Fundamentals of database systems /
Ramez Elmasri, Shamkant B. Navathe
- Sixth edition
- Boston : Addison-Wesley, 2014
- xxvii, 1,172 pages : illustrations ; 24 cm
Includes bibliographical references and index
Database and database users -- Database system concepts and architecture -- The relational data model and relational database constraints -- Basic SQL -- More SQL : complex queries, triggers, views, and schema modification -- The relational algebra and relational calculus -- Data modeling using the entity-relationship (ER) model -- The enhanced entity-relationship (EER) model -- Relational database design by ER-and EER-to-relational mapping -- Practical database design methodology and use of UML diagrams -- Object and object-related databases -- XML : extensible markup language -- Introduction to SQL programming techniques -- Web database programming using PHP -- Basics of functional dependencies and normalization for relational databases -- Relational database design algorithms and further dependencies -- Disk storage, basic file structures, and hashing -- indexing structures for files -- Query processing and optimization, and database tuning -- Physical database design and tuning -- Introduction to transaction processing concepts and theory -- Concurrency control techniques -- Database recovery techniques -- Database security -- Distributed databases -- Enhanced data models for advanced applications -- Introduction to information retrieval and web search -- Data mining concepts -- Overview of data warehousing and OLAP -- Appendix A : Alternative diagrammatic notations for ER models -- Appendix B : Parameters of disks -- Appendix C : Overview of the QBE language -- Appendix D : Overview of the hierarchical data model -- Appendix E : Overview of the network data model