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
鄂公网安备 42010302001612号 