Logical Database Design Principles

Nearly all books on logical database design focus exclusively on relational design. However, modern database management systems have added powerful features that have driven a movement away from truly normalized database design. Logical Database Design Principles reflects these recent changes. The book begins by covering traditional logical design principles, followed by an analysis of the normalizing and modeling of data. It examines designing for specific purposes, such as object-oriented databases, online transaction processing (OLTP), and data warehouses. As the text progresses, it moves from the purely logical into physical design, as determined by how the features of modern databases are implemented.

Until now, almost all books on logical database design focused exclusively on relational design. However, modern database management systems have added powerful features that have driven a movement away from truly normalized database design. Logical Database Design Principles reflects these recent changes. The book begins by covering traditional logical design principles, followed by an analysis of the normalizing and modeling of data. It then examines designing for specific purposes, such as object-oriented databases, online transaction processing (OLTP), and data warehouses. As the text progresses, it moves from the purely logical into some physical design, as determined by how the features of modern databases are implemented.Because this is a logical-design book, the authors attempt to make the examples database-neutral. Because various vendors implement features in different ways, this volume sometimes offers examples from a specific database management system. When necessary, it highlights a specific application, clearly demonstrating the concept being discussed.

INTRODUCTION TO LOGICAL DATABASE DESIGNUnderstanding a Database Database Architectures Relational Databases Creating the Database System Development Life Cycle (SDLC)Systems Planning: Assessment and Feasibility System Analysis: RequirementsSystem Analysis: Requirements Checklist Models Tracking and Schedules Design Modeling Functional Decomposition DiagramData Flow Diagrams Data Dictionary Logical Structures and Decision Trees System Design: LogicalSYSTEM DESIGN AND IMPLEMENTATION The ER ApproachEntities and Entity Types Attribute Domains AttributesSet-Valued AttributesWeak Entities Constraints Lookup Tables and ConsistencyModeling ApproachesRelationshipsCardinalitySchemas Implementation: Converting the ERD Specifications and Documentation CONVERTING THE LOGICAL DATA MODEL Database ArchitectureSQLDDL CommandsData Retrieval DML Statements and Implicit Cursors SELECT StatementsCartesian Product DML: INSERT CommandsDML: UPDATE Command DML: DELETE StatementsTransaction Commands DCL Commands FORMAL DATA NORMALIZATIONDefinitions of Normal Forms Introduction to Relational Algebra Comparison Operations and Logical Operators Summary DATA DENORMALIZATIONHistorical Perspective on Disk CostsThe Importance of Database Performance to the Logical Model Introducing Data Redundancy: Size versus Volatility The Theory of Dr. Ralph Kimball Pre-Joining Entities TogetherPre-Aggregating Summary InformationNon-First Normal Form EntitiesHorizontal and Vertical Partitioning for PerformanceSummary OBJECT-ORIENTED DESIGNObject-Oriented Terminology Object-Oriented DesignCreating the Object ModelMethods and Database Objects Summary OBJECT-RELATIONAL DESIGNAdvantages of Object-Relational DatabasesObject Types Object Views Using Logical Pointers Comparison of Object-Oriented and Object-Relational Databases Creating the Object-Relational Design Summary DESIGNING REPLICATED DATABASES Manual Replication Techniques Standby DatabaseReplication Using Triggers Replication Using ViewsOne-Way Replication Writeable Replication Updateable ReplicationWhat Are Conflicts?Which Form of Replication is Right for You? Planning Your Replication Schema Summary DESIGN OF THE OLTP DATABASEDesigning for Online Transaction Processing Normalization Data Storage SQL Reuse Database Locking and Waiting Deadlocks RollbacksIndexingSummary DESIGN OF DATA WAREHOUSES AND DECISION SUPPORT SYSTEM DATABASESWhat Is a Data Warehouse? Gathering Data Staging and Processing DataLoading and Unloading DataData Marts Designing the Data Warehouse Summary

Until now, almost all books on logical database design focused exclusively on relation design. However, modern database management systems have added powerful features that have driven a movement away from truly normalized database design. this book reflects these recent changes.