| Description |
1 online resource (xxiv, 870 pages) : illustrations |
| Contents |
Front Cover; Database: Principles Programming Performance; Copyright Page; Table of Contents; Preface; Chapter 1. Introduction; 1.1 Fundamental Database Concepts; 1.2 Database Users; 1.3 Overview of a Relational DBMS; 1.4 Putting It All Together; Chapter 2. The Relational Model; 2.1 The CAP Database; 2.2 Naming the Parts of a Database; 2.3 Relational RULES; 2.4 Keys, Superkeys, and Null Values; 2.5 Relational Algebra; 2.6 Set-Theoretic Operations; 2.7 Native Relational Operations; 2.8 The Interdependence of Operations; 2.9 Illustrative Examples; 2.10 Other Relational Operations |
|
Suggestions for Further ReadingExercises; Chapter 3. Query Language SQL; 3.1 Introduction; 3.2 Setting Up the Database; 3.3 Simple Select Statements; 3.4 Subselects; 3.5 SQL Union and ""FOR ALL . . ."" Conditions; 3.6 Set Functions in SQL; 3.7 Groups of Rows in SQL; 3.8 A Complete Description of SQL Select; 3.9Insert, Update, and Delete Statements; 3.10 The Power of the Select Statement; 3.11 Object-Orientation in Database Systems; Suggestions for Further Reading; Exercises; Chapter 4. Programs to Access a Database; 4.1 Introduction to Embedded SQL in C; 4.2 Error Handling |
|
4.3 Some Common Embedded SQL Statements4.4 Programming for Transactions; 4.5 The Power of Procedural SQL Programs; 4.6 Dynamic SQL; 4.7 Some Advanced Programming Concepts; Suggestions for Further Reading; Exercises; Chapter 5. Database Design; 5.1 Introduction to E-R Concepts; 5.2 Further Details of E-R Modeling; 5.3Additional E-R Concepts; 5.4 Case Study; 5.5 Normalization: Preliminaries; 5.6 Functional Dependencies; 5.7 Lossless Decompositions; 5.8 Normal Forms; 5.9Additional Design Considerations; Suggestions for Further Reading; Exercises |
|
Chapter 6. Integrity, Views, Security, and Catalogs6.1 Integrity Constraints; 6.2 Creating Views; 6.3 Security: The Grant Statement in SQL; 6.4 System Catalogs; Suggestions for Further Reading; Exercises; Chapter 7. Indexing; 7.1 The Concept of Indexing; 7.2 Disk Storage; 7.3 The B-Tree Index; 7.4 Clustered and Non-Clustered Indexes; 7.5 A Hash Primary Index; 7.6 Throwing Darts at Random Slots; Suggestions for Further Reading; Exercises; Chapter 8. Query Processing; 8.1 Introductory Concepts; 8.2 Table Space Scans and I/O; 8.3 Simple Indexed Access in DB2; 8.4 Filter Factors and Statistics |
|
8.5 Matching Index Scans, Composite Indexes8.6 Multiple Index Access; 8.7 Methods for Joining Tables; 8.8 Disk Sorts; 8.9 Query Performance Benchmarks: A Case Study; 8.10 Query Performance Measurements; 8.11 Cost-Performance Assessment; Suggestions for Further Reading; Exercises; Chapter 9. Update Transactions; 9.1 Transactional Histories; 9.2 Interleaved Read/Write Operations; 9.3 Serializability and the Precedence Graph; 9.4 Locking to Ensure Serializability; 9.5 Levels of Isolation; 9.6Transactional Recovery; 9.7 Recovery in Detail: Log Formats; 9.8 Checkpoints; 9.9 Media Recovery |
| Summary |
Database |
| Notes |
Previous edition 1994 |
| Bibliography |
Includes bibliographical references and index |
| Notes |
Print version record |
| Subject |
Database management.
|
|
COMPUTERS -- Data Processing.
|
|
COMPUTERS -- Document Management.
|
|
Database management
|
| Form |
Electronic book
|
| Author |
O'Neil, Elizabeth
|
| ISBN |
9781483184043 |
|
1483184048 |
|
