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

✍ Scribed by Beg, Carolyn E.;Connolly, Thomas M

• Publisher: Pearson
• Year: 2015
• Tongue: English
• Leaves: 1442
• Edition: Sixth edition
• Category: Library

✦ Synopsis

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.

✦ Table of Contents

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

✦ Subjects

Database design;Database management