Polyteknisk Boghandel

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. 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 Lifecyc= Database Analysis and the DreamHomeCase 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'Requirements Specification for DreamHomeCase Study; 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 Orac= Programmatic SQL; Estimating Disk Space Requirements; Introduction to Object-Orientation; Example Web Scripts. This book is ideal for readers interested in database management or database design.

I. Background
1. Introduction to Databases
2. Database Environment
3. Database Architectures and the Web
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. Query-By-Example (QBE)
III. Database Analysis and Design
9. Database System Lifecycle
10. Database Analysis and the DreamHome Case Study
11. Entity Relationship Modeling
12. Enhanced Entity Relationship Modeling
13. Normalization
14. Advanced Normalization
IV. Methodology
15. Methodology Conceptual Database Design
16. Methodology Logical Database Design for Relational Model
17. Methodology Physical Database Design for Relational Databases
18. Methodology Monitoring and Tuning the Operational System
V. Selected Database Issues
19. Security and Administration
20. Professional, Legal, and Ethical Issues
21. Transaction Management
22. Query Processing
VI. Distributed DBMSs and Replication
23. Distributed DBMSs Concepts and Design
24. Distributed DBMSs Advanced Concepts
25. Replication and Mobile Databases
VII. Object DBMSs
26. Object-Oriented DBMSs Concepts and Design
27. Object-Oriented DBMSs Standards and Languages
28. Object-Relational DBMSs
VIII. Web and DBMSs
29. Web Technology and DBMSs
30. Semistructured Data and XML
IX. Business Intelligence Technologies
31. Data Warehousing Concepts
32. Data Warehousing Design
33. OLAP
34. Data Mining Appendices A. Users' Requirements Specification for DreamHome Case Study B. Other Case Studies C. Alternative Data Modeling Notations D. Summary of the Database Design Methodology for Relational Databases E. Introduction to Pyrrho A Liteweight RDBMS Web Appendices F. File Organization and Storage Structures G. When Is a DBMS Relational? H. Commercial DBMSs: Access and Oracle
I. Programmatic SQL J. Estimating Disk Space Requirements K. Introduction to Object-Orientation L. Example Web Scripts