Fundamentals of database systems / Ramez Elmasri, Shamkant B. Navathe.
By: Elmasri, Ramez
Contributor(s): Navathe, Shamkant B.Call number: 005.74 E48F 2017 Material type: BookPublisher: Boston, Mass. : Pearson, c2017. Edition: 7th ed., Global ed.Description: 1272 p. : charts.ISBN: 9781292097619 (pbk.).Subject(s): Database management
Part 1. Introduction to databases. 1, Databases and database users. 2, Database system concepts and architecture -- Part 2. Conceptual data modeling and database design. 3, Data modeling using the entity-relationship (ER) model. 4, The enhanced entity-relationship (EER) model -- Part 3. The relational data model and SQL. 5, The relational data model and relational database constraints. 6, Basic SQL. 7, More SQL: complex queries, triggers, views, and schema modification. 8, The relational algebra and relational calculus. 9, Relational database design by ER- and EER-to-relational mapping -- Part 4. Database programming techniques. 10, Introduction to SQL programming techniques. 11, Web database programming using PHP -- Part 5. Object, object-relational, and XML: concepts, models, languages, and standards. 12, Object and object-relational databases. 13, XML: extensible markup language -- Part 6. Database design theory and normalization. 14, Basics of functional dependencies and normalization for relational databases. 15, Relational database design algorithms and further dependencies -- Part 7. File structures, hashing, indexing, and physical database design. 16, Disc storage, basic file structures, hashing, and modern storage architectures. 17, Indexing structures for files and physical database design -- Part 8. Query processing and optimization. 18, Strategies for query processing. 19, Query optimization -- Part 9. Transaction processing, concurrency control, and recovering. 20, Introduction to transaction processing concepts and theory. 21, Concurrency control techniques. 22, Database recovery techniques -- Part 10. Distributed databases, NOSQL systems, and big data. 23, Distributed database concepts. 24, NOSQL databases and big data storage systems. 25, Big data technologies based on mapreduce and hadoop -- Part 11. Advanced database models, systems, and applications. 26, Enhanced data models: introduction to active, temporal, spatial, multimedia, and deductive databases. 27, Introduction to information retrieval and web search. 28, Data mining concepts. 29, Overview of data warehousing and OLAP -- Part 12. Additional database topics: security. 30, Database security.