Chapter 1 Introduction 1.1 Database-System Applications 1.2 Purpose of Database Systems 1.3 View of Data 1.4 Database Languages 1.5 Relational Databases 1.6 Database Design 1.7 Data Storage and Querying 1.8 Transaction Management 1.9 Database Architecture 1.1 0 Data Mining and Information Retrieval 1.1 1 Specialty Databases 1.1 2 Database Users and Administrators 1.1 3 History of Database Systems 1.1 4 Summary Exercises Bibliographical Notes PART ONE RELATIONAL DATABASES Chapter 2 Introduction to the Relational Model 2.1 Structure of Relational Databases 2.2 Database Schema 42 2.3 Keys 2.4 Schema Diagrams 2.5 Relational Query Languages 2.6 Relational Operations 2.7 Summary Exercises Bibliographical Notes Chapter 3 Introduction to SQL 3.1 Overview of the SQL Query Language 3.2 SQL Data Definition 3.3 Basic Structure of SQL Queries 3.4 Additional Basic Operations 3.5 Set Operations 3.6 Null Values 3.7 Aggregate Functions 3.8 Nested Subqueries 3.9 Modification of the Database 3.10 Summary Exercises Bibliographical Notes Chapter 4Intermediate SQL 4.1 Join Expressions 4.2 Views 4.3 Transactions 4.4 Integrity Constraints 4.5 SQL Data Types and Schemas 4.6 Authorization 4.7 Summary Exercises Bibliographical Notes Chapter 5 Advanced SQL 5.1 Accessing SQL From a Programming Language 5.2 Functions and Procedures 5.3 Triggers 5.4 Recursive Queries** 5.5 Advanced Aggregation Features** 5.6 OLAP** 5.7 Summary Exercises Bibliographical Notes Chapter 6 Formal Relational Query Languages 6.1 The Relational Algebra 6.2 The Tuple Relational Calculus 6.3 The Domain Relational Calculus 6.4 Summary Exercises Bibliographical Notes PART TWO DATABASE DESIGN Chapter 7 Database Design and the E-R Model 7.1 Overview of the Design Process 7.2 The Entity-Relationship Model 7.3 Constraints 7.4 Removing Redundant Attributes in Entity Sets 7.5 Entity-Relationship Diagrams 7.6 Reduction to Relational Schemas 7.7 Entity-Relationship Design Issues 7.8 Extended E-R Features 7.9 Alternative Notations for Modeling Data 7.10 0ther Aspects of Database Design 7.11 Summary Exercises Bibliographical Notes …… PART THREE DATA STORAGE AND QUERYING PART FOUR TRANSACTION MANAGEMENT PART FIVE SYSTEM ARCHITECTURE PART SIX DATA WAREHOUSING, DATA MINING AND INFORMATION RETRIEVAL PART SEVEN SPECIALTY DATABASES PART EIGHT ADVANCED TOPICS PART NINE CASE STUDIES PART TEN APPENDICES
鄂公網(wǎng)安備 42010302001612號 