书籍详情
数据库处理：基础、设计与实现（第十版）
作者：（美）克罗恩克（Kroenke，D.M.）著
出版社：电子工业出版社
出版时间：2006-06-01
ISBN：9787121026065
定价：¥68.00
购买这本书可以去
内容简介
经典数据库教材！这一版本包括了最新的数据库实用技术和技能。本书是第十版，此次修订对全书的结构和内容做了很多重大改变。其中最重要的改变就是突破了传统数据库教材“从数据模型讲述数据库设计”的陈规，强调学习过程中的乐趣，让读者从一开始就能把所学的知识用于解决具体的应用实例。本书添加了大量专业的参考文献，并以完整的章节讲述了SQL Server，Oracle，Microsoft Access以及MySQL的应用。本书为英文版。 本书从基础、设计和实现三个层面介绍数据库处理技术，内容全面详实，既包括数据库设计、数据库实现、多用户数据处理、数据访问标准等经典理论，也包括商务智能、XML和.NET等最新技术。本书在内容编排和写作风格新颖，强调学习过程中的乐趣，围绕两个贯串全书的项目练习，让读者从一开始就能把所学的知识用于解决具体的应用实例。本书每章都有丰富的习题，可作为高校本科生或研究生的数据库课程的双语教材，同时也是一本很好的专业参考书。
作者简介
DavidM.Kroenke是一位多产的计算机畅销书作家。他撰写或与人合著的图书专业性强，涉及面广。注重专业理论与实践运用的结合，精通数据库处理、数据库概念、商用计算机系统和管理信息系统等。
目录
Preface
Part 1: Getting Started 1
Chapter 1: Introduction 3
The Characteristics of Databases 4
Database Examples 5
Components of a Database System 8
The Database 11
Database Design 13
What You Need to Learn 17
A Brief History of Database Processing 18
Chapter 2: Introduction to Structured
Query Language 27
SQL Background 28
Cape Codcl Outdoor Sports 28
The SQL SELECT/FROM/WHERE Framework 31
Continuation of SQL for Querying a Single Table 40
Performing Calculations in SQL Queries 45
Grouping 50
Looking for Patterns in NASDAQ Trading 52
Querying Two or More Tables with SQL 55
Part 2: Database Design 67
Chapter 3: The Relational Model
and Normalization 69
Relational Model Terminology 71
Normal Forms 81
Chapter 4: Database Design
Using Normalization 101
Assess Table Structure 102
Designing Updatable Databases 103
Designing Read-Only Databases 106
Common Design Problems 109
Chapter 5: Data Modeling with the Entity-Relationship
Model 119
The Purpose of a Data Model 120
The Entity-Relationship Model 120
Patterns in Forms, Reports, and
Entity-Relationship Models 135
The Data Modeling Process 153
Chapter 6: Transforming Data Models
into Database Designs 171
Create a Table for Each Entity 172
Create Relationships 177
Design for Minimum Cardinality 194
The View Ridge Gallery Database 204
Part 3: Database Implementation 217
Chapter 7: SQL for Database Construction
and Application Processing 219
SQL DDL, DML, and Joins 220
SQL DML 232
New Forms of Join 234
Using SQL Views 239
Embedding SQL in Program Code 247
Use Triggers 248
Using Stored Procedures 254
Chapter 8: Database Redesign 265
The Need for Database Redesign 266
Additional SCIL Statements 266
Analyzing the Existing Database 271
Changing Table Names and Table Columns 275
Changing Relationship Cardinalities
and Properties 279
Adding and Deleting Tables and Relationships 283
Forward Engineering (?) 284
Part 4: Multiuser Database Processing 291
Chapter 9: Managing Multiuser Databases 293
Database Administration 294
Concurrency Control 296
Database Security 309
Database Recovery 314
Managing the DMBS 317
Chapter 10: Managing Databases with Oracle 325
Installing Oracle 326
Creating an Oracle Database 326
Data Dictionary 354
Concurrency Control 356
Oracle Security 358
Oracle Backup and Recovery 363
Topics Not Discussed in This Chapter 365
Chapter 11 : Managing Databases with SQL Server 2000 371
Installing SQLServer 2000 372
Creating a SQL Server 2000 Database 372
Application Logic 382
Concurrency Control 393
SQL Server Security 397
SQL Server Backup and Recovery 40o
Topics Not Discussed in This Chapter 404
Part 5: Database Access Standards 409
Chapter 12: ODBC, aLE DB, ADO, and ASP 411
The Web Server Data Environment 412
Open Database Connectivity (ODBC) Standard 414
OLE DB 418
Active Data Objects (ADO) 422
ADO Examples 428
Chapter 13: XML and ADO.NET 449
The Importance of XML 450
XML as a Markup Language 451
XML Schema 456
ADO.NET 474
Additional XML Standards 488
Chapter 14: JDBC, Java Server Pages, and MySQL 497
JDBC 498
Java Server Pages 5o7
MySOL 519
Part 6: Conclusion 529
Chapter 15: Database Processing for Business
Intelligence Systems 531
Repasting and Data Mining Applications 532
Data Warehouses and Data Marts 533
Reporting Systems 537
Data Mining 549
Appendix A Introduction to Microsoft Access 561
Appendix B The IDEF1XStandard 575
Appendix G UML-Style Entity-Relationship Diagrams 583
Appendix D Data Structures for Database Processing 589
Appendix E The Semantic Object Model 609
Bibliography 643
Glossary 645
Index 663
Part 1: Getting Started 1
Chapter 1: Introduction 3
The Characteristics of Databases 4
Database Examples 5
Components of a Database System 8
The Database 11
Database Design 13
What You Need to Learn 17
A Brief History of Database Processing 18
Chapter 2: Introduction to Structured
Query Language 27
SQL Background 28
Cape Codcl Outdoor Sports 28
The SQL SELECT/FROM/WHERE Framework 31
Continuation of SQL for Querying a Single Table 40
Performing Calculations in SQL Queries 45
Grouping 50
Looking for Patterns in NASDAQ Trading 52
Querying Two or More Tables with SQL 55
Part 2: Database Design 67
Chapter 3: The Relational Model
and Normalization 69
Relational Model Terminology 71
Normal Forms 81
Chapter 4: Database Design
Using Normalization 101
Assess Table Structure 102
Designing Updatable Databases 103
Designing Read-Only Databases 106
Common Design Problems 109
Chapter 5: Data Modeling with the Entity-Relationship
Model 119
The Purpose of a Data Model 120
The Entity-Relationship Model 120
Patterns in Forms, Reports, and
Entity-Relationship Models 135
The Data Modeling Process 153
Chapter 6: Transforming Data Models
into Database Designs 171
Create a Table for Each Entity 172
Create Relationships 177
Design for Minimum Cardinality 194
The View Ridge Gallery Database 204
Part 3: Database Implementation 217
Chapter 7: SQL for Database Construction
and Application Processing 219
SQL DDL, DML, and Joins 220
SQL DML 232
New Forms of Join 234
Using SQL Views 239
Embedding SQL in Program Code 247
Use Triggers 248
Using Stored Procedures 254
Chapter 8: Database Redesign 265
The Need for Database Redesign 266
Additional SCIL Statements 266
Analyzing the Existing Database 271
Changing Table Names and Table Columns 275
Changing Relationship Cardinalities
and Properties 279
Adding and Deleting Tables and Relationships 283
Forward Engineering (?) 284
Part 4: Multiuser Database Processing 291
Chapter 9: Managing Multiuser Databases 293
Database Administration 294
Concurrency Control 296
Database Security 309
Database Recovery 314
Managing the DMBS 317
Chapter 10: Managing Databases with Oracle 325
Installing Oracle 326
Creating an Oracle Database 326
Data Dictionary 354
Concurrency Control 356
Oracle Security 358
Oracle Backup and Recovery 363
Topics Not Discussed in This Chapter 365
Chapter 11 : Managing Databases with SQL Server 2000 371
Installing SQLServer 2000 372
Creating a SQL Server 2000 Database 372
Application Logic 382
Concurrency Control 393
SQL Server Security 397
SQL Server Backup and Recovery 40o
Topics Not Discussed in This Chapter 404
Part 5: Database Access Standards 409
Chapter 12: ODBC, aLE DB, ADO, and ASP 411
The Web Server Data Environment 412
Open Database Connectivity (ODBC) Standard 414
OLE DB 418
Active Data Objects (ADO) 422
ADO Examples 428
Chapter 13: XML and ADO.NET 449
The Importance of XML 450
XML as a Markup Language 451
XML Schema 456
ADO.NET 474
Additional XML Standards 488
Chapter 14: JDBC, Java Server Pages, and MySQL 497
JDBC 498
Java Server Pages 5o7
MySOL 519
Part 6: Conclusion 529
Chapter 15: Database Processing for Business
Intelligence Systems 531
Repasting and Data Mining Applications 532
Data Warehouses and Data Marts 533
Reporting Systems 537
Data Mining 549
Appendix A Introduction to Microsoft Access 561
Appendix B The IDEF1XStandard 575
Appendix G UML-Style Entity-Relationship Diagrams 583
Appendix D Data Structures for Database Processing 589
Appendix E The Semantic Object Model 609
Bibliography 643
Glossary 645
Index 663
猜您喜欢
