| |
| |
| Preface | |
| |
| |
| |
| The Context of Database Management | |
| |
| |
| Part I Overview | |
| |
| |
| |
| The Database Environment | |
| |
| |
| Learning Objectives | |
| |
| |
| Data Matters! | |
| |
| |
| Introduction | |
| |
| |
| Basic Concepts and Definitions | |
| |
| |
| Traditional File Processing Systems | |
| |
| |
| File Processing Systems at Pine Valley Furniture Company | |
| |
| |
| The Database Approach | |
| |
| |
| Advantages of The Database Approach | |
| |
| |
| Cautions About Database Benefits | |
| |
| |
| Costs and Risks of The Database Approach | |
| |
| |
| Components of the Database Environment | |
| |
| |
| The Range of Database Applications | |
| |
| |
| Evolution of Database Systems | |
| |
| |
| Summary | |
| |
| |
| Chapter Review | |
| |
| |
| Case: Mountain View Community Hospital | |
| |
| |
| |
| The Database Development Process | |
| |
| |
| Learning Objectives | |
| |
| |
| Introduction | |
| |
| |
| Database Development Within Information Systems Development | |
| |
| |
| Database Development Process | |
| |
| |
| Managing the People Involved in Database Development | |
| |
| |
| Three-Schema Architecture for Database Development | |
| |
| |
| Three-Tiered Database Location Architecture | |
| |
| |
| Developing a Database Application for Pine Valley Furniture Company | |
| |
| |
| Summary | |
| |
| |
| Chapter Review | |
| |
| |
| Case: Mountain View Community Hospital | |
| |
| |
| |
| Database Analysis | |
| |
| |
| Part II Overview | |
| |
| |
| |
| Modeling Data in the Organization | |
| |
| |
| Learning Objectives | |
| |
| |
| Introduction | |
| |
| |
| Modeling the Rules of the Organization | |
| |
| |
| The E-R Model: An Overview | |
| |
| |
| Modeling Entities and Attributes | |
| |
| |
| Modeling Relationships | |
| |
| |
| E-R Modeling Example: Pine Valley Furniture Company | |
| |
| |
| Database Processing at Pine Valley Furniture | |
| |
| |
| Summary | |
| |
| |
| Chapter Review | |
| |
| |
| Case: Mountain View Community Hospital | |
| |
| |
| |
| The Enhanced E-R Model and Business Rules | |
| |
| |
| Learning Objectives | |
| |
| |
| Introduction | |
| |
| |
| Representing Supertypes and Subtypes | |
| |
| |
| Specifying Constraints in Supertype/Subtype Relationships | |
| |
| |
| EER Modeling Example: Pine Valley Furniture | |
| |
| |
| Entity Clustering | |
| |
| |
| Packaged Data Models | |
| |
| |
| Business Rules Revisited | |
| |
| |
| Summary | |
| |
| |
| Chapter Review | |
| |
| |
| Case: Mountain View Community Hospital | |
| |
| |
| |
| Database Design | |
| |
| |
| Part III Overview | |
| |
| |
| |
| Logical Database Design and the Relational Model | |
| |
| |
| Learning Objectives | |
| |
| |
| Introduction | |
| |
| |
| The Relational Data Model | |
| |
| |
| Integrity Constraints | |
| |
| |
| Transforming EER Diagrams into Relations | |
| |
| |
| Introduction to Normalization | |
| |
| |
| Normalization Example: Pine Valley Furniture Company | |
| |
| |
| Merging Relations | |
| |
| |
| A Final Step for Defining Relational Keys | |
| |
| |
| Summary | |
| |
| |
| Chapter Review | |
| |
| |
| Case: Mountain View Community Hospital | |
| |
| |
| |
| Physical Database Design and Performance | |
| |
| |
| Learning Objectives | |
| |
| |
| Introduction | |
| |
| |
| Physical Database Design Process | |
| |
| |
| Designing Fields | |
| |
| |
| Designing Physical Records and Denormalization | |
| |
| |
| Designing Physical Files | |
| |
| |
| Using and Selecting Indexes | |
| |
| |
| RAID: Improving File Access Performance by Parallel Processing | |
| |
| |
| Designing Databases | |
| |
| |
| Optimizing for Query Performance | |
| |
| |
| Summary | |
| |
| |
| Chapter Review | |
| |
| |
| Case: Mountain View Community Hospital | |
| |
| |
| |
| Implementation | |
| |
| |
| Part IV Overview | |
| |
| |
| |
| Introduction to SQL | |
| |
| |
| Learning Objectives | |
| |
| |
| Introduction | |
| |
| |
| History of the SQL Standard | |
| |
| |
| The Role of SQL in a Database Architecture | |
| |
| |
| The SQL Environment | |
| |
| |
| Defining a Database in SQL | |
| |
| |
| Inserting, Updating, and Deleting Data | |
| |
| |
| Internal Schema Definition in RDBMSs | |
| |
| |
| Processing Single Tables | |
| |
| |
| Summary | |
| |
| |
| Chapter Review | |
| |
| |
| Case: Mountain View Community Hospital | |
| |
| |
| |
| Advanced SQL | |
| |
| |
| Learning Objectives | |
| |
| |
| Introduction | |
| |
| |
| Processing Multiple Tables | |
| |
| |
| Ensuring Transaction Integrity | |
| |
| |
| Data Dictionary Facilities | |
| |
| |
| SQL:2003 Enhancements and Extensions to SQL | |
| |
| |
| Triggers and Routines | |
| |
| |
| Embedded SQL and Dynamic SQL | |
| |
| |
| Summary | |
| |
| |
| Chapter Review | |
| |
| |
| Case: Mountain View Community Hospital | |
| |
| |
| |
| The Client/Server Database Environment | |
| |
| |
| Learning Objectives | |
| |
| |
| Location, Location, Location! | |
| |
| |
| Introduction | |
| |
| |
| Client/Server Architectures | |
| |
| |
| Three-Tier Architectures | |
| |
| |
| Partitioning an Application | |
| |
| |
| Role of the Mainframe | |
| |
| |
| Using Middleware | |
| |
| |
| Client/Server Issues | |
| |
| |
| Using ODBC to Link External Tables Stored on a Database Server | |
| |
| |
| Using JDBC to Link External Tables Stored on a Database Server | |
| |
| |
| Looking Forward with Client/Server in Mind | |
| |
| |
| Summary | |
| |
| |
| Chapter Review | |
| |
| |
| Case: Mountain View Community Hospital | |
| |
| |
| |
| The Internet Database Environment | |
| |
| |
| Learning Objectives | |
| |
| |
| Introduction | |
| |
| |
| The Internet and Database Connection | |
| |
| |
| The Internet Environment | |
| |
| |
| Common Internet Architecture Components | |
| |
| |
| Web-to-Database Tools | |
| |
| |
| Summary | |
| |
| |
| Chapter Review | |
| |
| |
| Case: Mountain View Community Hospital | |
| |
| |
| |
| Data Warehousing | |
| |
| |
| Learning Objectives | |
| |
| |
| Introduction | |
| |
| |
| Basic Concepts of Data Warehousing | |
| |
| |
| Data Warehouse Architectures | |
| |
| |
| Some Characteristics of Data Warehouse Data | |
| |
| |
| The Reconciled Data Layer | |
| |
| |
| Data Transformation | |
| |
| |
| The Derived Data Layer | |
| |
| |
| The User Interface | |
| |
| |
| Summary | |
| |
| |
| Chapter Review | |
| |
| |
| Case: Mountain View Community Hospital | |
| |
| |
| |
| Advanced Database Topics | |
| |
| |
| Part V Overview | |
| |
| |
| |
| Data and Database Administration | |
| |
| |
| Learning Objectives | |
| |
| |
| Introduction | |
| |
| |
| The Roles of Data and Database Administrators | |
| |
| |
| The Open-Source Movement | |
| |
| |
| Modeling Enterprise Data | |
| |
| |
| Managing Data Security | |
| |
| |
| Database Backup and Recovery | |
| |
| |
| Controlling Concurrent Access | |
| |
| |
| Managing Data Quality | |
| |
| |
| Data Dictionaries and Repositories | |
| |
| |
| Overview of Tuning the Database for Performance | |
| |
| |
| Data Availability | |
| |
| |
| Summary | |
| |
| |
| Chapter Review | |
| |
| |
| Case: Mountain View Community Hospital | |
| |
| |
| |
| Overview: Distributed Databases | |
| |
| |
| Learning Objectives | |
| |
| |
| Overview | |
| |
| |
| Chapter Review | |
| |
| |
| |
| Overview: Object-Oriented Data Modeling | |
| |
| |
| Learning Objectives | |
| |
| |
| Overview | |
| |
| |
| Chapter Review | |
| |
| |
| |
| Overview: Object-Oriented Database Development | |
| |
| |
| Learning Objectives | |
| |
| |
| Overview | |
| |
| |
| Chapter Review | |
| |
| |
| |
| Data Modeling Tools and Notation | |
| |
| |
| Comparing E-R Modeling Conventions | |
| |
| |
| Visio Professional 2003 Notation | |
| |
| |
| AllFusion ERwin Data Modeler 4.1 SPI Notation | |
| |
| |
| Sybase Power Designer 11.1 Notation | |
| |
| |
| Oracle Designer Notation | |
| |
| |
| Comparison of Tool Interfaces and E-R Diagrams | |
| |
| |
| |
| Advanced Normal Forms | |
| |
| |
| Boyce-Codd Normal Form | |
| |
| |
| Anomalies in STUDENT_ADVISOR | |
| |
| |
| Definition of Boyce-Codd Normal Form (BCNF) | |
| |
| |
| Converting a Relation to BCNF | |
| |
| |
| Fourth Normal Form | |
| |
| |
| Multivalued Dependencies | |
| |
| |
| Higher Normal Forms | |
| |
| |
| Appendix Review | |
| |
| |
| Key Terms | |
| |
| |
| References | |
| |
| |
| Web Resources | |
| |
| |
| |
| Data Structures | |
| |
| |
| Pointers | |
| |
| |
| Data Structure Building Blocks | |
| |
| |
| Linear Data Structures | |
| |
| |
| Stacks | |
| |
| |
| Queues | |
| |
| |
| Sorted Lists | |
| |
| |
| Multilists | |
| |
| |
| Hazards of Chain Structures | |
| |
| |
| Trees | |
| |
| |
| Balanced Trees | |
| |
| |
| References | |
| |
| |
| |
| Object-Relational Databases | |
| |
| |
| Basic Concepts and Definitions | |
| |
| |
| Features of an ORDBMS | |
| |
| |
| Complex Data Types | |
| |
| |
| Enhanced SQL | |
| |
| |
| A Simple Example | |
| |
| |
| Content Addressing | |
| |
| |
| Advantages of the Object-Relational Approach | |
| |
| |
| ORDBMS Vendors and Products | |
| |
| |
| Appendix Review | |
| |
| |
| Key Terms | |
| |
| |
| References | |
| |
| |
| Web Resources | |
| |
| |
| Glossary of Acronyms | |
| |
| |
| Glossary of Terms | |
| |
| |
| Index | |