Database Management Systems

Preface1. Ansi Database Standards 1.1 In the Beginning 1.2 Reference Models 1.2.1 The 1975 Ansi Reference Model 1.2.2 The ISO Reference Model 1.3 Ansi Database Committees: X3H2 and X3H4 1.4 The Battle over Data Models 1.5 DBMS Standards 1.6 ANSI/NDL 1.7 ANSI/SQL 1.8 The ANSI/IRDS 1.9 Database Standards Summary 2. DBMS Applications and Components 2.1 Application Classifications 2.2 Static and Dynamic Relationships 2.3 The Nature of a Static Relationship Application 2.4 The Nature of a Dynamic Relationship Application 2.5 Problems and Benefits of Static Relationship DBMSs 2.6 Problems and Benefits of Dynamic Relationship DBMSs 2.7 Implementing the Static Relationship Application 2.7.1 The Logical Database 2.7.2 The Physical Database 2.7.3 Interrogation 2.7.4 System Control 2.7.5 Static Relationship Application Summary 2.8 Implementing the Dynamic Relationship Application 2.8.1 The Logical Database 2.8.2 The Physical Database 2.8.3 Interrogation 2.8.4 System Control 2.8.5 Dynamic Relationship Application Summary 2.9 DBMS Components And Subcomponents 2.10 The DBMS 2.10.1 The Logical Database 2.10.2 The Physical Database 2.10.3 Interrogation 2.10.4 System Control 2.11 DBMS Issues 2.12 Application Components and DBMS Components 2.13 Dbms Requirements Summary3. The Logical Database 3.1 Definition 3.2 Logical Database Components 3.2.1 Domains 3.2.2 Data Elements 3.2.3 Data Record Types 3.2.4 Relationships 3.2.5 Operations 3.2.6 Logical Database Components Summary 3.3 Data Models 3.3.1 Data Models and DBMS 3.3.2 Static Data Models 3.3.3 Dynamic Data Models 3.3.4 Data Model Summary 3.4 Data Definition Language 3.5 Logical Database Summary4. The Physical Database 4.1 Physical Database Components 4.2 Storage Structure 4.2.1 Dictionary Component 4.2.2 Index Component 4.2.3 Relationship Component 4.2.4 Data Component 4.2.5 Data Storage Definition Language 4.2.6 Storage Structure Summary 4.3 Access Strategy 4.3.1 Static Access Strategy 4.3.2 Dynamic Access Strategy 4.3.3 Comparing Access Strategies 4.3.4 Buffer Management 4.3.5 Access Strategy Summary 4.4 Data Loading 4.4.1 Static Data Loading 4.4.2 Dynamic Data Loading 4.4.3 Load Engineering 4.5 Data Update 4.5.1 Data Record Type Changes 4.5.2 Data Record Element Changes 4.5.3 Relationship Changes 4.6 Database Maintenance 4.7 Physical Database Summary5. Interrogation 5.1 Interrogation Evolution 5.2 DBMS and Language Orientation 5.2.1 Static Relationship DBMS and HLIs 5.2.2 Dynamic Relationship DBMSs and Natural Languages 5.2.3 Types of Interrogation Languages 5.3 Subschema Facility 5.3.1 Language-Independent Specifications 5.3.2 Language-Dependent Specifications 5.3.3 Data Interface Specifications 5.3.4 Where Clause Facilities 5.4 View Facility 5.5 Screen Development 5.6 Relationship Between Screens and Views 5.7 System Control Capabilities 5.7.1 Audit Trails 5.7.2 Message Processing 5.7.3 Backup and Recovery 5.7.4 Concurrent Operations 5.7.5 Multiple Database Processing 5.7.6 Security and Privacy 5.7.7 Reorganization 5.8 Host Language Interface 5.8.1 HLI-DBMS Interaction Protocol 5.8.2 Access Language Form 5.8.3 View Access 5.8.4 Subschema Access 5.8.5 Screen Development and Utilization 5.8.6 HLI Cursors 5.8.7 Updating 5.8.