Ships from: acton, MA
Usually ships in 1-2 business days
This book places a strong emphasis on good design practice, allowing readers to master design methodology in an accessible, step-by-step fashion.
In this book, database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodology working in practice. Extensive treatment of the Web as an emerging platform for database applications is covered alongside many code samples for accessing databases from the Web including JDBC, SQLJ, ASP, ISP, and Oracle's PSP. A thorough update of later chapters covering object-oriented databases, Web databases,
A clear introduction to design implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable, complete reference for database professionals.
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 DBMSs: Access and Oracle.
III. DATABASE ANALYSIS AND DESIGN TECHNIQUES.
9. Database planning, design and administration.
10. Fact-finding techniques.
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.
20. Transaction management.
21. Query processing.
22. Programming SQL.
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. Introduction to Object DBMSs.
27. Object-oriented DBMSs - concepts and design.
28. Object-oriented DBMSs - standards and languages.
29. Object-relational DBMSs.
VIII. WEB AND DBMSs.
30. Web technology and DBMSs.
31. Semistructureddata and
IX. BUSINESS INTELLIGENCE (OR DECISION SUPPORT).
32. Data warehousing concepts.
33. Data warehousing design.
34. OLAP.
35. Data mining.
APPENDICES.
A. Users' requirements specification for Dreamhome case study.
B. Other case studies.
C. File organization and storage structures.
D. When is a DBMS relational?
E. Programmatic SQL.
F. Alternative data modeling notations.
G. Summary of the database design methodology for relational databases.
H. Estimating disk space requirements.
I. Example web scripts.
Overview
This book places a strong emphasis on good design practice, allowing readers to master design methodology in an accessible, step-by-step fashion.
In this book, database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodology working in practice. Extensive treatment of the Web as an emerging platform for database applications is covered alongside many code ...