Database Management Systems
- 3rd ed.
- Boston McGraw hill 2003
- xxxii, 1065 pages : illustrations ; 25 cm
Part I: Foundations. Overview of database systems ; Introduction to database design ; The relational model ; Relational algebra and calculus ; SQL : queries, constraints, triggers -- Part II: Application development. Database application development ; Internet applications -- Part II: Storage and indexing. Overview of storage and indexing ; Storing data : disks and files ; Tree-structured indexing ; Hash-based indexing -- Part IV: Query evaluation. Overview of query evaluation ; External sorting ; Evaluating relational operators ; A typical relational query optimizer -- Part V: Transaction management. Overview of transaction management ; Concurrency control ; Crash recovery -- Part VI: Database design and tuning. Schema refinement and normal forms ; Physical database design and tuning ; Security and authorization -- Part VII: Additional topics. Parallel and distributed databases ; Object-database systems ; Deductive databases ; Data warehousing and decision support ; Data mining ; Information retrieval and XML data ; Spatial data management ; Further reading ; The minibase software.
Designed for an introductory database course, this new text emphasizes conceptual and physical database design and tuning. Database Management Systems also covers advanced topics that can be used for a second course in database. These topics include parallel and distributed database systems, transaction processing, decision support, object-relational systems, and active and deductive database systems.