Database systems: a practical approach to design, implementation, and management

Description

Part I. Background -- Part II. The Relational Model and Languages -- Part III. Database Analysis and Design -- Part IV. Methodology -- Part V. Selected Database Issues -- Part VI. Distributed DBMSs and Replication -- Part VII. Object DBMSs -- Part VIII. Web and DBMSs -- Part IX. Business Intelligence.;"This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases-conceptual, logical, and physical database design."--Publisher's website. Part I. Background -- Part II. The Relational Model and Languages -- Part III. Database Analysis and Design -- Part IV. Methodology -- Part V. Selected Database Issues -- Part VI. Distributed DBMSs and Replication -- Part VII. Object DBMSs -- Part VIII. Web and DBMSs -- Part IX. Business Intelligence. Part I. Background -- 1. Introduction to Databases -- 2. Database Environment -- 3. Database Architectures and the Web -- Part II. The Relational Model and Languages -- 4. The Relational model -- 5. Relational Algebra and Relational Calculus -- 6. SQL: Data Manipulation -- 7. SQL: Data Definition -- 8. Advanced SQL -- 9. Object Relational DBMSs -- Part III. Database Analysis and Design -- 10. Database System Development Lifecycle -- 11. Database Analysis and the DreamHome Case Study -- 12. Entity-Relationship Modeling -- 13. Enhanced Entity-Relationship Modeling -- 14. Normalization -- 15. Advanced Normalization -- Part IV. Methodology -- 16. Methodology-Conceptual Database Design -- 17. Methodology-Logical Database Design for Relational Model -- 18. Methodology-Physical Database Design for Relational Databases -- 19. Methodology-Monitoring and Tuning the Operational System -- Part V. Selected Database Issues -- 20. Security and Administration -- 21. Professional, Legal, and Ethical Issues in Data Management -- 22. Transaction Management -- 23. Query Processing -- Part VI. Distributed DBMSs and Replication -- 24. Distributed DBMSs-Concepts and Design -- 25. Distributed DBMSs-Advanced Concepts -- 26. Replication and Mobile Databases -- Part VII. Object DBMSs -- 27. Object-Oriented DBMSs-Concepts and Design -- 28. Object-Oriented DBMSs-Standards and Languages -- Part VIII. Web and DBMSs -- 29. Web Technology and DBMSs -- 30. Semistructured Data and XML -- Part IX. Business Intelligence -- 31. Data Warehousing Concepts -- 32. Data Warehousing Design -- 33. OLAP -- 34. Data Mining -- Appendix A. Users' Requirements Specification for DreamHome Case Study -- Appendix B. Other Case Studies -- Appendix C. Alternative ER Modeling Notations -- Appendix D. Summary of the Database Design Methodology for Relational Databases -- Appendix E. Introduction to Pyrrho-A Liteweight RDBMS -- Appendix F. File Organization and Indexes (Online) -- Appendix G. When Is a DBMS Relational? (Online) -- Appendix H. Commercial DBMS Appendix s. Access and Oracle (Online) -- Appendix I. Programmatic SQL (Online) -- Appendix J. Estimating Disk Space Requirements (Online) -- Appendix K. Introduction to Object-Orientated Concepts (Online) -- Appendix L. Example Web Scripts (Online) -- Appendix M. Query-by-Example (QBE) (Online) -- Appendix N. Third generation manifestos (Online) -- Appendix O. Postgres -- An Early ORDBNS (Online).