This text is a complete guide to designing databases to utilize database structures, using examples from the Oracle database. More than a reworking of logical database design, it combines theory with technique to cover all aspects of the topic.
This text is a complete guide to designing databases to utilize database structures, using examples from the Oracle database. More than a reworking of logical database design, it combines theory with technique to cover all aspects of the topic.
INTRODUCTION TO LOGICAL DATABASE DESIGN
Understanding a Database
Database Architectures
Relational Databases
Creating the Database
System Development Life Cycle (SDLC)
Systems Planning: Assessment and Feasibility
System Analysis: Requirements
System Analysis: Requirements Checklist
Models Tracking and Schedules
Design Modeling
Functional Decomposition Diagram
Data Flow Diagrams
Data Dictionary
Logical Structures and Decision Trees
System Design: Logical
SYSTEM DESIGN AND IMPLEMENTATION
The ER Approach
Entities and Entity Types
Attribute Domains
Attributes
Set-Valued Attributes
Weak Entities
Constraints
Lookup Tables and Consistency
Modeling Approaches
Relationships
Cardinality
Schemas
Implementation: Converting the ERD
Specifications and Documentation
CONVERTING THE LOGICAL DATA MODEL
Database Architecture
SQL
DDL Commands
Data Retrieval
DML Statements and Implicit Cursors
SELECT Statements
Cartesian Product
DML: INSERT Commands
DML: UPDATE Command
DML: DELETE Statements
Transaction Commands
DCL Commands
FORMAL DATA NORMALIZATION
Definitions of Normal Forms
Introduction to Relational Algebra
Comparison Operations and Logical Operators
Summary
DATA DENORMALIZATION
Historical Perspective on Disk Costs
The Importance of Database Performance to the Logical Model
Introducing Data Redundancy: Size versus Volatility
The Theory of Dr. Ralph Kimball
Pre-Joining Entities Together
Pre-Aggregating Summary Information
Non-First Normal Form Entities
Horizontal and Vertical Partitioning for Performance
Summary
OBJECT-ORIENTED DESIGN
Object-Oriented Terminology
Object-Oriented Design
Creating the Object Model
Methods and Database Objects
Summary
OBJECT-RELATIONAL DESIGN
Advantages of Object-Relational Databases
Object 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 Database
Replication Using Triggers
Replication Using Views
One-Way Replication
Writeable Replication
Updateable Replication
What Are Conflicts?
Which Form of Replication is Right for You?
Planning Your Replication Schema
Summary
DESIGN OF THE OLTP DATABASE
Designing for Online Transaction Processing
Normalization
Data Storage
SQL Reuse
Database Locking and Waiting
Deadlocks
Rollbacks
Indexing
Summary
DESIGN OF DATA WAREHOUSES AND DECISION
SUPPORT SYSTEM DATABASES
What Is a Data Warehouse?
Gathering Data
Staging and Processing Data
Loading and Unloading Data
Data Marts
Designing the Data Warehouse
Summary
Overview