Database Management Systems - 1st Edition - ISBN: 9780750601351, 9781483278193

Database Management Systems

1st Edition

Understanding and Applying Database Technology

Authors: Michael M. Gorman
eBook ISBN: 9781483278193
Imprint: Butterworth-Heinemann
Published Date: 1st March 1991
Page Count: 470
Tax/VAT will be calculated at check-out Price includes VAT (GST)
30% off
30% off
30% off
30% off
30% off
20% off
20% off
30% off
30% off
30% off
30% off
30% off
20% off
20% off
30% off
30% off
30% off
30% off
30% off
20% off
20% off
72.95
51.06
51.06
51.06
51.06
51.06
58.36
58.36
43.99
30.79
30.79
30.79
30.79
30.79
35.19
35.19
54.95
38.47
38.47
38.47
38.47
38.47
43.96
43.96
Unavailable
Price includes VAT (GST)
× DRM-Free

Easy - Download and start reading immediately. There’s no activation process to access eBooks; all eBooks are fully searchable, and enabled for copying, pasting, and printing.

Flexible - Read on multiple operating systems and devices. Easily read eBooks on smart phones, computers, or any eBook readers, including Kindle.

Open - Buy once, receive and download all available eBook formats, including PDF, EPUB, and Mobi (for Kindle).

Institutional Access

Secure Checkout

Personal information is secured with SSL technology.

Free Shipping

Free global shipping
No minimum order.

Description

Database Management Systems: Understanding and Applying Database Technology focuses on the processes, methodologies, techniques, and approaches involved in database management systems (DBMSs).

The book first takes a look at ANSI database standards and DBMS applications and components. Discussion focus on application components and DBMS components, implementing the dynamic relationship application, problems and benefits of dynamic relationship DBMSs, nature of a dynamic relationship application, ANSI/NDL, and DBMS standards. The manuscript then ponders on logical database, interrogation, and physical database. Topics include choosing the right interrogation language, procedure-oriented language, system control capabilities, DBMSs and language orientation, logical database components, and data definition language. The publication examines system control, including system control components, audit trails, reorganization, concurrent operations, multiple database processing, security and privacy, system control static and dynamic differences, and installation and maintenance.

The text is a valuable source of information for computer engineers and researchers interested in exploring the applications of database technology.

Table of Contents


Preface

1. 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 Summary

3. 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 Summary

4. 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 Summary

5. 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.8 DBMS and Database Invocation

5.8.9 System Control Capabilities

5.8.10 Static and Dynamic Differences

5.9 Natural Languages

5.9.1 Natural Language Types

5.9.2 Natural Language Execution Alternatives

5.9.3 Run-Unit Development

5.10 Procedure-Oriented Language

5.10.1 Basic Capabilities

5.10.2 View Access

5.10.3 Schema Record Access

5.10.4 Screen Development and Utilization

5.10.5 Updating

5.10.6 Reporting

5.10.7 Batch Job Execution

5.10.8 System Control

5.10.9 Reorganization

5.10.10 Pol Summary

5.11 Report Writer

5.11.1 Basic Capabilities

5.11.2 View Access

5.11.3 Reporting

5.11.4 System Control

5.11.5 Report Writer Summary

5.12 Query-Update Languages

5.12.1 Basic Capabilities

5.12.2 View Access

5.12.3 Updating

5.12.4 Reporting

5.12.5 System Control

5.13 Choosing The Right Interrogation Language

5.14 Interrogation Summary

6. System Control

6.1 System Control Components

6.2 Audit Trails

6.3 Message Processing

6.4 Backup and Recovery

6.4.1 Database Backup

6.4.2 Database Recovery

6.4.3 Checkpoint and Restart

6.4.4 Database Lockout

6.4.5 Differences Between Static and Dynamic Relationship DBMSs

6.4.6 Disabling the Journal File

6.4.7 Backup and Recovery Summary

6.5 Reorganization

6.5.1 Logical Database Reorganization

6.5.2 Physical Database Reorganization

6.5.3 Impact of Reorganization

6.5.4 Reorganization Locking

6.5.5 Static and Dynamic Differences

6.5.6 Reorganization Summary

6.6 Concurrent Operations

6.6.1 Single or Multiple User DBMS

6.6.2 Single or Multiple Database

6.6.3 Single and Multiple Threaded DBMS

6.6.4 Commonly Existing DBMS Combinations

6.6.5 Complex Storage Structure Effects on Concurrent Operations

6.6.6 System Control Operation Conflicts

6.6.7 Concurrent Operations Locks

6.6.8 Deadly Embrace

6.6.9 Static and Dynamic Differences

6.7 Multiple Database Processing

6.7.1 Types of Multiple Databases

6.7.2 Rationale for Multiple Databases

6.7.3 Critical Issues

6.7.4 Logical Database Impact

6.7.5 Physical Database Impact

6.7.6 Interrogation Impact

6.7.7 System Control Impact

6.7.8 Static and Dynamic Differences

6.7.9 Multiple Database Summary

6.8 Security and Privacy

6.8.1 Rationale

6.8.2 Areas of Concern

6.8.3 Definition Alternatives

6.8.4 Trapping and Reporting Security Violations

6.8.5 Static and Dynamic Differences

6.8.6 Security and Privacy Summary

6.9 Installation and Maintenance

6.9.1 Initial Installation and Testing

6.9.2 Special Versions

6.9.3 Operating Environment Interfaces

6.9.4 DBMS Versions and Upgrades

6.9.5 TP Monitor Restrictions

6.9.6 Managing DBMS Bugs

6.9.7 Installation and Maintenance Summary

6.10 Application Optimization

6.10.1 Logical Database Analysis

6.10.2 Physical Database Analysis

6.10.3 Interrogation

6.10.4 System Control

6.10.5 Static and Dynamic Differences

6.10.6 Application Optimization Summary

6.11 System Control Static and Dynamic Differences

6.12 System Control Summary

Appendix A Keys And Bnf Notation Definition

Appendix B: Glossary

Details

No. of pages:
470
Language:
English
Copyright:
© Butterworth-Heinemann 1991
Published:
Imprint:
Butterworth-Heinemann
eBook ISBN:
9781483278193

About the Author

Michael M. Gorman