This book provides improved and extensive coverage of concepts, database system internals and new tools and techniques. It is intended for a first course in databases at the junior or senior undergraduate, or first-year graduate level, and offers a complete background in the basics of database design, languages and system implementations. Concepts are presented using intuitive descriptions, and important theoretical results are covered, but formal proofs are omitted. The concepts and algorithms covered are based on those used in existing commercial or experimental database systems, and are presented in a general setting that is not tied to one particular database system.
Part 1. Introduction. 1. Data Models. 2. Entity-Relationship Model. 3. Relational Model. Part 2. Relational Databases. 4. SQL. 5. Other Relational Languages. 6. Integrity and Security. 7. Relational-Database Design. Part 3. Object-Based Databases and XML. 8. Object-Oriented Databases. 9. Object-Relational Databases. 10. XML. Part 4. Data Storage and Querying. 11. Storage and File Structure. 12. Indexing and Hashing. 13. Query Processing. 14. Query Optimization. Part 5. Transaction Management. 15. Transactions. 16. Concurrency Control. 17. Recovery System. Part 6. Database System Architecture. 18. Database System Architectures. 19. Distributed Databases. 20. Parallel Databases. Part 7. Other Topics. 21. Application Development and Administration. 22. Advanced Querying and Information Retrieval. 23. Advanced Data Types and New Applications. 24. Advanced Transaction Processing. Part 8. Case Studies. 25. Oracle. 26. IBM DB2 Universal Database. 27. Microsoft SQL Server. Appendices. A. Network Model (contents online). B. Hierarchical Model (contents online). C. Advanced Relational Design (contents online).
Number Of Pages: 1079
Published: 16th January 2001
Dimensions (cm): 23.2 x 18.7
Weight (kg): 1.594