Database Systems

This book's practical, hands-on approach makes it uniquely suited to providing a strong foundation in good database design practice. It allows the reader to master a methodology for conceptual, logical and physical database design in an accessible, step-by-step fashion. A running case study employed throughout the book enables complex subjects to be explained in the context of one accessible example, while a second case study allows readers to work through an entire example by themselves. The new edition of this successful book has been brought up to date with recent developments in the field, including: new chapters overviewing Oracle and Access; fact-finding techniques; structured and semi-structured data using XML and DBMS, and DMBS applications like multimedia and mobile databases; updated material on databases and the Web and data warehousing and data mining; and a move to the standard UML notation where relevant. It also provides coverage of distributed and object-oriented databases. A clear introduction to implementation and management issues as well as an extensive treatment of database languages and standards make this book an indispensable complete guide and reference for both novice and practicing database designers.

Contents

• Preface.

I. BACKGROUND.

• 1. Introduction to Databases.
• 2. Database Environment.

II. THE RELATIONAL MODEL AND LANGUAGES.

• 3. The Relational Model.
• 4. Relational Algebra and Relational Calculus.
• 5. SQL: Data Manipulation.
• 6. SQL: Data Definition.
• 7. Query-By-Example (QBE).
• 8. Commercial RDBMSs: Access and Oracle.

III. DATABASE ANALYSIS AND DESIGN TECHNIQUES.

• 9. Database Planning and Design.
• 10. Fact-Finding Techniques.
• 11. Entity-Relationship Modeling.
• 12. Enhanced Entity-Relationship Modeling.
• 13. Normalization.

IV. METHODOLOGY.

• 14. Methodology - Conceptual Database Design.
• 15. Methodology - Logical Database Design for the Relational Model.
• 16. Methodology - Physical Database Design for Relational Databases.
• 17. Methodology - Monitoring and Tuning the Operational System.

V. SELECTED DATABASE ISSUES.

• 18. Security.
• 19. Transaction Management.
• 20. Query Processing.
• 21. Programmatic SQL.

VI. CURRENT TRENDS.

• 22. Distributed DBMSs - Concepts and Design.
• 23. Distributed DBMSs -Advanced Concepts.
• 24. Introduction to Object DBMSs.
• 25. Object-Oriented DBMSs - Concepts and Design.
• 26. Object-Oriented DBMSs - Standards and Systems.
• 27. Object-Relational DBMSs.

VII. EMERGING TRENDS.

• 28. Web Technology and DBMSs.
• 29. Semistructured Data and XML.
• 30. Data Warehousing Concepts.
• 31. Data Warehousing Design.
• 32. OLAP and Data Mining.

APPENDICES.

• A. Users' Requirements Specification for DreamHome Case Study.
• B. Other Case Studies.
• C. File Organization and Storage Structures.
• D. When is DBMS Relational?
• E. Alternative ER Modeling Notations.
• F. Summary of the Database Design Methodology for Relational Databases.
• G. Estimating Disk Space Requirements.
• H. Example Web Scripts.
• References.
• Further Reading.
• Index.