Database Systems, 4th Edition

Part 1 Background 1
Chapter 1 Introduction to Databases 3
Chapter 2 Database Environment 33
Part 2 The Relational Model and Languages 67
Chapter 3 The Relational Model 69
Chapter 4 Relational Algebra and Relational Calculus 88
Chapter 5 SQL: Data Manipulation 112
Chapter 6 SQL: Data Definition 157
Chapter 7 Query-By-Example 198
Chapter 8 Commercial RDBMSs: Office Access and Oracle 225
Part 3 Database Analysis and Design Techniques 279
Chapter 9 Database Planning, Design, and Administration 281
Chapter 10 Fact-Finding Techniques 314
Chapter 11 Entity–Relationship Modeling 342
Chapter 12 Enhanced Entity–Relationship Modeling 371
Chapter 13 Normalization 387
Chapter 14 Advanced Normalization 415
viii | Brief Contents
Part 4 Methodology 435
Chapter 15 Methodology – Conceptual Database Design 437
Chapter 16 Methodology – Logical Database Design for the
Relational Model 461
Chapter 17 Methodology – Physical Database Design for
Relational Databases 494
Chapter 18 Methodology – Monitoring and Tuning the
Operational System 519
Part 5 Selected Database Issues 539
Chapter 19 Security 541
Chapter 20 Transaction Management 572
Chapter 21 Query Processing 630
Part 6 Distributed DBMSs and Replication 685
Chapter 22 Distributed DBMSs – Concepts and Design 687
Chapter 23 Distributed DBMSs – Advanced Concepts 734
Chapter 24 Replication and Mobile Databases 780
Part 7 Object DBMSs 801
Chapter 25 Introduction to Object DBMSs 803
Chapter 26 Object-Oriented DBMSs – Concepts 847
Chapter 27 Object-Oriented DBMSs – Standards and Systems 888
Chapter 28 Object-Relational DBMSs 935
Part 8 Web and DBMSs 991
Chapter 29 Web Technology and DBMSs 993
Chapter 30 Semistructured Data and XML 1065
Brief Contents | ix
Part 9 Business Intelligence 1147
Chapter 31 Data Warehousing Concepts 1149
Chapter 32 Data Warehousing Design 1181
Chapter 33 OLAP 1204
Chapter 34 Data Mining 1232
Appendices 1247
A Users’ Requirements Specification for DreamHome
Case Study 1249
B Other Case Studies 1255
C File Organizations and Indexes
(extended version on Web site) 1268
D When is a DBMS Relational? 1293
E Programmatic SQL
(extended version on Web site) 1298
F Alternative ER Modeling Notations 1320
G Summary of the Database Design Methodology for
Relational Databases 1326
H Estimating Disk Space Requirements On Web site
I Example Web Scripts On Web site
References 1332
Further Reading 1345
Index 1356