经典数据库教材！这一版本包括了最新的数据库实用技术和技能。本书是第十版，此次修订对全书的结构和内容做了很多重大改变。其中最重要的改变就是突破了传统数据库教材“从数据模型讲述数据库设计”的陈规，强调学习过程中的乐趣，让读者从一开始就能把所学的知识用于解决具体的应用实例。本书添加了大量专业的参考文献，并以完整的章节讲述了SQL Server，Oracle，Microsoft Access以及MySQL的应用。本书为英文版。

本书从基础、设计和实现三个层面介绍数据库处理技术，内容全面详实，既包括数据库设计、数据库实现、多用户数据处理、数据访问标准等经典理论，也包括商务智能、XML和.NET等最新技术。

本书在内容编排和写作风格新颖，强调学习过程中的乐趣，围绕两个贯串全书的项目练习，让读者从一开始就能把所学的知识用于解决具体的应用实例。

本书每章都有丰富的习题，可作为高校本科生或研究生的数据库课程的双语教材，同时也是一本很好的专业参考书。

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