| |
| |
| |
Background | |
| |
| |
| |
Introduction to Databases | |
| |
| |
| |
Database Environment | |
| |
| |
| |
Database Architectures and the Web | |
| |
| |
| |
The Relational Model and Languages | |
| |
| |
| |
The Relational model | |
| |
| |
| |
Relational Algebra and Relational Calculus | |
| |
| |
| |
SQL: Data Manipulation | |
| |
| |
| |
SQL: Data Definition | |
| |
| |
| |
Query-By-Example (QBE) | |
| |
| |
| |
Database Analysis and Design | |
| |
| |
| |
Database System Lifecycle | |
| |
| |
| |
Database Analysis and the DreamHome: Case Study | |
| |
| |
| |
Entity-Relationship Modeling | |
| |
| |
| |
Enhanced Entity-Relationship Modeling | |
| |
| |
| |
Normalization | |
| |
| |
| |
Advanced Normalization | |
| |
| |
| |
Methodology | |
| |
| |
| |
Methodology-Conceptual Database Design | |
| |
| |
| |
Methodology-Logical Database Design for Relational Model | |
| |
| |
| |
Methodology-Physical Database Design for Relational Databases | |
| |
| |
| |
Methodology-Monitoring and Tuning the Operational System | |
| |
| |
| |
Selected Database Issues | |
| |
| |
| |
Security and Administration | |
| |
| |
| |
Professional, Legal, and Ethical Issues | |
| |
| |
| |
Transaction Management | |
| |
| |
| |
Query Processing | |
| |
| |
| |
Distributed DBMSs and Replication | |
| |
| |
| |
Distributed DBMSs-Concepts and Design | |
| |
| |
| |
Distributed DBMSs-Advanced Concepts | |
| |
| |
| |
Replication and Mobile Databases | |
| |
| |
| |
Object DBMSs | |
| |
| |
| |
Object-Oriented DBMSs-Concepts and Design | |
| |
| |
| |
Object-Oriented DBMSs-Standards and Languages | |
| |
| |
| |
Object-Relational DBMSs | |
| |
| |
| |
Web and DBMSs | |
| |
| |
| |
Web Technology and DBMSs | |
| |
| |
| |
Semistructured Data and XML | |
| |
| |
| |
Business Intelligence Technologies | |
| |
| |
| |
Data Warehousing Concepts | |
| |
| |
| |
Data Warehousing Design | |
| |
| |
| |
OLAP | |
| |
| |
| |
Data Mining | |
| |
| |
Appendices | |
| |
| |
| |
Users' | |
| |
| |
| |
Other Case Studies | |
| |
| |
| |
Alternative Data Modeling Notations | |
| |
| |
| |
Summary of the Database Design Methodology for Relational Databases | |
| |
| |
| |
Introduction to Pyrrho-A Liteweight RDBMS | |
| |
| |
Web Appendices | |
| |
| |
| |
File Organization and Storage Structures | |
| |
| |
| |
When Is a DBMS Relational? | |
| |
| |
| |
Commercial DBMSs: Access and Oracle | |
| |
| |
| |
Programmatic SQL | |
| |
| |
| |
Estimating Disk Space Requirements | |
| |
| |
| |
Introduction to Object-Orientation | |
| |
| |
| |
Example Web Scripts | |