数据库处理：基础、设计与实现（第十版）

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