Database Management Systems
Understanding and Applying Database Technology
- 1st Edition - May 12, 2014
- Imprint: Butterworth-Heinemann
- Author: Michael M. Gorman
- Language: English
- eBook ISBN:9 7 8 - 1 - 4 8 3 2 - 7 8 1 9 - 3
Database Management Systems: Understanding and Applying Database Technology focuses on the processes, methodologies, techniques, and approaches involved in database management… Read more
Purchase options
Institutional subscription on ScienceDirect
Request a sales quoteDatabase 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.
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.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 Summary6. 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 SummaryAppendix A Keys And Bnf Notation DefinitionAppendix B: Glossary
- Edition: 1
- Published: May 12, 2014
- Imprint: Butterworth-Heinemann
- Language: English
- eBook ISBN: 9781483278193
Read Database Management Systems on ScienceDirect