Database Systems, 4th Edition

This book places a strong emphasis on good design practice, allowing readers to master design methodology in an accessible, step-by-step fashion. In this book, database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodology working in practice. Extensive treatment of the Web as an emerging platform for database applications is covered alongside many code samples for accessing databases from the Web including JDBC, SQLJ, ASP, ISP, and Oracle’s PSP. A thorough update of later chapters covering object-oriented databases, Web databases, XML, data warehousing, data mining is included in this new edition. A clear introduction to design implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable, complete reference for database professionals.

Table of Contents

Part 1 Background
Chapter 1 Introduction to Databases
Chapter 2 Database Environment

Part 2 The Relational Model and Languages
Chapter 3 The Relational Model
Chapter 4 Relational Algebra and Relational Calculus
Chapter 5 SQL: Data Manipulation
Chapter 6 SQL: Data Definition
Chapter 7 Query-By-Example
Chapter 8 Commercial RDBMSs: Office Access and Oracle

Part 3 Database Analysis and Design Techniques
Chapter 9 Database Planning, Design, and Administration
Chapter 10 Fact-Finding Techniques
Chapter 11 Entity–Relationship Modeling
Chapter 12 Enhanced Entity–Relationship Modeling
Chapter 13 Normalization
Chapter 14 Advanced Normalization

Part 4 Methodology
Chapter 15 Methodology – Conceptual Database Design
Chapter 16 Methodology – Logical Database Design for the Relational Model
Chapter 17 Methodology – Physical Database Design for Relational Databases
Chapter 18 Methodology – Monitoring and Tuning the Operational System

Part 5 Selected Database Issues
Chapter 19 Security
Chapter 20 Transaction Management
Chapter 21 Query Processing

Part 6 Distributed DBMSs and Replication
Chapter 22 Distributed DBMSs – Concepts and Design
Chapter 23 Distributed DBMSs – Advanced Concepts
Chapter 24 Replication and Mobile Databases

Part 7 Object DBMSs
Chapter 25 Introduction to Object DBMSs
Chapter 26 Object-Oriented DBMSs – Concepts
Chapter 27 Object-Oriented DBMSs – Standards and Systems
Chapter 28 Object-Relational DBMSs

Part 8 Web and DBMSs
Chapter 29 Web Technology and DBMSs
Chapter 30 Semistructured Data and XML

Part 9 Business Intelligence
Chapter 31 Data Warehousing Concepts
Chapter 32 Data Warehousing Design
Chapter 33 OLAP
Chapter 34 Data Mining