Database System Concepts

De facto text book for DatabasesWho need this book?DBMS developer or admins, who want to brush up concepts.Students who are learning Computer science at university, this book is must have for them.Book is divided in following main sections1. Introduction.This section just gives brief introduction about DBMS (database management system).2. Relational databases.This section is divided in five difference chapters, which are* Introduction to the Relational Model* Introduction to SQL* Intermediate SQL* Advanced SQL* Formal Relational Query Languages3. Database design.This section is divided in three difference chapters, which are* Database Design and the E-R Model* Relational Database Design* Application Design and Development4. Data storage and querying.This section is divided in four difference chapters, which are* Storage and File Structure* Indexing and Hashing* Query Processing* Query Optimization5. Transaction managementThis section is divided in three difference chapters, which are* Transactions* Concurrency Control* Recovery System6. System architecture.This section is divided in three difference chapters, which are* Database-System Architectures* Parallel Databases* Distributed Databases7. Data warehousing, data mining and data retrieval.This section is divided in two difference chapters, which are* Data Warehousing and Mining* Information Retrieval8. Specialty databases.This section is divided in two difference chapters, which are* Object-Based Databases* XML9. Advance topics.This section is divided in three difference chapters, which are* Advanced Application Development* Spatial and Temporal Data and Mobility* Advanced Transaction Processing10. Case studies.This section is divided in four difference chapters, which are* PostgreSQL* Oracle* IBM DB2 Universal Database* Microsoft SQL Server11. AppendicesPoints about book are as followBook is well written and very concise.Explains each and every DBMS concepts in very details.Each chapter has exercises at end.The exercises are divided into two sets: practice exercises and exercises. The solutions for the practice exercises are publicly available at book's website.SQL syntaxes used in this book are standard SQL language and do not follow any specific DBMS such as oracle or Microsoft SQL Server.There are lots of diagrams, tables and real life examples in book for better explanation.Case studies are good way to explain some real life problems.Case studies section is missing MySQL database system, which is surprised for me.