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
鄂公网安备 42010302001612号 