Gorman Database Management Systems

Understanding and Applying Database Technology
1. Auflage 2014
ISBN: 978-1-4832-7819-3
Verlag: Elsevier Science & Techn.
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 470 Seiten, Web PDF

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.

Autoren/Hrsg.

Gorman, Michael M.

Inhaltsverzeichnis

1;Front Cover;1
2;Database Management Systems: Understanding and Applying
Database Technology;4
3;Copyright Page;5
4;Table of Contents;8
5;PREFACE;14
6;CHAPTER 1. ANSI DATABASE STANDARDS;18
6.1;1.1 IN THE BEGINNING;18
6.2;1.2 REFERENCE MODELS;19
6.3;1.3 ANSI DATABASE COMMITTEES: X3H2 AND X3H4;28
6.4;1.4 THE BATTLE OVER DATA MODELS;28
6.5;1.5 DBMS STANDARDS;29
6.6;1.6 ANSI/NDL;32
6.7;1.7 ANSI/SQL;39
6.8;1.8 THE ANSI/IRDS;42
6.9;1.9 DATABASE STANDARDS SUMMARY;44
6.10;References;47
7;CHAPTER 2. DBMS APPLICATIONS AND COMPONENTS;48
7.1;2.1 APPLICATION CLASSIFICATIONS;48
7.2;2.2 STATIC AND DYNAMIC RELATIONSHIPS;49
7.3;2.3 THE NATURE OF A STATIC RELATIONSHIP APPLICATION;50
7.4;2.4 THE NATURE OF A DYNAMIC RELATIONSHIP APPLICATION;52
7.5;2.5 PROBLEMS AND BENEFITS OF STATIC RELATIONSHIP DBMSs;52
7.6;2.6 PROBLEMS AND BENEFITS OF DYNAMIC RELATIONSHIP DBMSs;53
7.7;2.7 IMPLEMENTING THE STATIC RELATIONSHIP APPLICATION;54
7.8;2.8 IMPLEMENTING THE DYNAMIC RELATIONSHIP APPLICATION;56
7.9;2.9 DBMS COMPONENTS AND SUBCOMPONENTS;58
7.10;2.10 THE DBMS;60
7.11;2.11 DBMS ISSUES;65
7.12;2.12 APPLICATION COMPONENTS AND DBMS COMPONENTS;67
7.13;2.13 DBMS REQUIREMENTS SUMMARY;68
7.14;References;68
8;CHAPTER 3. THE LOGICAL DATABASE;70
8.1;3.1 DEFINITION;70
8.2;3.2 LOGICAL DATABASE COMPONENTS;70
8.3;3.3 DATA MODELS;129
8.4;3.4 DATA DEFINITION LANGUAGE;151
8.5;3.5 LOGICAL DATABASE SUMMARY;154
9;CHAPTER 4. THE PHYSICAL DATABASE;158
9.1;4.1 PHYSICAL DATABASE COMPONENTS;158
9.2;4.2 STORAGE STRUCTURE;158
9.3;4.3 ACCESS STRATEGY;232
9.4;4.4 DATA LOADING;241
9.5;4.5 DATA UPDATE;245
9.6;4.6 DATABASE MAINTENANCE;250
9.7;4.7 PHYSICAL DATABASE SUMMARY;250
9.8;References;251
10;CHAPTER 5. INTERROGATION;252
10.1;5.1 INTERROGATION EVOLUTION;252
10.2;5.2 DBMSs AND LANGUAGE ORIENTATION;255
10.3;5.3 SUBSCHEMA FACILITY;257
10.4;5.4 View Facility;264
10.5;5.5 SCREEN DEVELOPMENT;271
10.6;5.6 RELATIONSHIP BETWEEN SCREENS AND VIEWS;274
10.7;5.7 SYSTEM CONTROL CAPABILITIES;274
10.8;5.8 HOST LANGUAGE INTERFACE;280
10.9;5.9 NATURAL LANGUAGES;298
10.10;5.10 PROCEDURE-ORIENTED LANGUAGE;301
10.11;5.11 REPORT WRITER;317
10.12;5.12 QUERY-UPDATE LANGUAGES;321
10.13;5.13 CHOOSING THE RIGHT INTERROGATION LANGUAGE;324
10.14;5.14 INTERROGATION SUMMARY;325
11;CHAPTER 6. SYSTEM CONTROL;328
11.1;6.1 SYSTEM CONTROL COMPONENTS;328
11.2;6.2 AUDIT TRAILS;331
11.3;6.3 MESSAGE PROCESSING;333
11.4;6.4 BACKUP and RECOVERY;340
11.5;6.5 REORGANIZATION;356
11.6;6.6 CONCURRENT OPERATIONS;363
11.7;6.7 MULTIPLE DATABASE PROCESSING;372
11.8;6.8 SECURITY and PRIVACY;382
11.9;6.9 INSTALLATION and MAINTENANCE;391
11.10;6.10 APPLICATION OPTIMIZATION;395
11.11;6.11 SYSTEM CONTROL STATIC AND DYNAMIC DIFFERENCES;417
11.12;6.12 SYSTEM CONTROL SUMMARY;418
12;Appendix A: Keys and BNF Notation Definition;420
13;Appendix B: Glossary;424
14;Index;468