Database systems

Elmasri, Ramez.

Database systems - 6th ed. - New Delhi : Dorling Kindersley, c2013. - xxv, 1214 p. :

Includes Index.

1. Introduction to databases --
2. Overview of database languages and architectures --
3. The basic (flat) relational model --
4. SQL: data definition, constraints, and basic queries and updates --
5. SQL: advanced queries, assertions, triggers, and views --
6. Formal relational languages: the algebra and calculus --
7. Conceptual data modeling using entities and relationships --
8. Mapping a conceptual design into a logical design --
9. UML for database application design --
10. Object and object-relational databases: concepts, models, languages and standards --
11. XML: concepts, languages and standards --
12. SQL application programming using C and Java --
13. SQL web programming using C PHP --
14. Database design theory: introduction to normalization using functional and multivalued dependencies --
15. Database design theory: normalization algorithms --
16. Database file organizations: unordered, ordered, and hashed files of records --
17. Database file indexing techniques, B-Trees, and B+-Trees --
18. Introduction to query processing and query optimization techniques --
19. Introduction to database tuning and physical design issues --
20. Foundation of database transaction processing --
21. Introduction to protocols for concurrency control in databases --
22. Introduction to database recovery protocols --
23. Emerging database technologies and applications --
24. Advanced database models and applications --
25. Introduction to database security --
26. Introduction to distributed databases --
27. Introduction to information retrieval --
Appendix A. Alternative diagrammatic notations for ER models --
Appendix B. Paramaters for disks --
Appendix C. Overview of the QBE language --
Appendix D. Overview of the hierarchical data model --
Appendix E. Overview of the network data model --
Selected bibliography --



Clear explanations of theory and design, broad coverage of models and real systems, and an up-to-date introduction to modern database technologies result in a leading introduction to database systems. Intended for computer science majors, this text emphasizes math models, design issues, relational algebra, and relational calculus.

9788131792476


Database management.

005.74 / ELM

© University of Vavuniya

---