Database Management Systems (eBook)

Understanding and Applying Database Technology

Michael M. Gorman (Autor)

eBook Download: PDF

2014 | 1. Auflage
470 Seiten
Elsevier Science (Verlag)
978-1-4832-7819-3 (ISBN)

Infos

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.

Inhalt

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

Produkt-Details

• Erscheint lt. Verlag: 12.5.2014
• Sprache: englisch
• Themenwelt: Mathematik / Informatik ► Informatik ► Datenbanken
• Themenwelt: Mathematik / Informatik ► Informatik ► Theorie / Studium
• Themenwelt: Mathematik / Informatik ► Mathematik
• Themenwelt: Sozialwissenschaften ► Kommunikation / Medien ► Buchhandel / Bibliothekswesen
• ISBN-10: 1-4832-7819-0 / 1483278190
• ISBN-13: 978-1-4832-7819-3 / 9781483278193