| |
| |
| |
| 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 | |