Database Management Systems

Database Management Systems (dbms) Is A Must For Any Course In Database Systems Or File Organization. Dbms Provides A Hands-on Approach To Relational Database Systems, With An Emphasis On Practical Topics Such As Indexing Methods, Sql, And Database Design. New To This Edition Are The Early Coverage Of The Er Model, New Chapters On Internet Databases, Data Mining, And Spatial Databases, And A New Supplement On Practical Sql Assignments (with Solutions For Instructors' Use). Many Other Chapters Have Been Reorganized Or Expanded To Provide Up-to-date Coverage. Pt. I. Basics. 1. Introduction To Database Systems. 2. The Entity-relationship Model. 3. The Relational Model -- Pt. Ii. Relational Queries. 4. Relational Algebra And Calculus. 5. Sql: Queries, Programming, Triggers. 6. Query-by-example (qbe) -- Pt. Iii. Data Storage And Indexing. 7. Storing Data: Disks And Files. 8. File Organizations And Indexes. 9. Tree-structured Indexing. 10. Hash-based Indexing -- Pt. Iv. Query Evaluation. 11. External Sorting. 12. Evaluation Of Relational Operators. 13. Introduction To Query Optimization. 14. A Typical Relational Query Optimizer -- Pt. V. Database Design. 15. Schema Refinement And Normal Forms. 16. Physical Database Design And Tuning. 17. Security -- Pt. Vi. Transaction Management. 18. Transaction Management Overview. 19. Concurrency Control. 20. Crash Recovery -- Pt. Vii. Advanced Topics. 21. Parallel And Distributed Databases. 22. Internet Databases. 23. Decision Support. 24. Data Mining. 25. Object-database Systems. 26. Spatial Data Management. 27. Deductive Databases. 28. Additional Topics -- A. Database Design Case Study: The Internet Shop -- B. The Minibase Software. Raghu Ramakrishnan, Johannes Gehrke.