Fundamentals of database systems
Clasificación: QA 79.6 .D3 E48 2016 | Agregado: 07/10/2020
Ramez Elmasri, Shamkant B. Navathe. -- 7a. ed. -- Hoboken, N.J. : Pearson, 2016.
xxx, 1242 p.; 24 cm.
ISBN 978-0-13-397077-7.
Incluye referencias bibliográficas e índice.
Contenido: Preface -- Introduction to databases -- Databases and database users -- Database system concepts and architecture -- Conceptual data modeling and database design -- Data modeling using the entity-relationship (ER) model -- The enhanced entity-relationship (EER) model -- The relational data model and SQL -- 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 -- Relational database design by ER- and EER-to-relational mapping -- Database programming techniques -- Introduction to SQL programming techniques -- Web database programming using PHP -- Object, object-relational, and XML: concepts, models, lenguages, and standards -- Object and object-relational databases -- XML: extensible markup lenguage -- Database design theory and normalization -- Basics of functional dependencies and normalization for relational databases -- Relational database design algorithms and further dependencies -- File structures, hashing, indexing, and physical database design -- Disk storage, basic file structures, hashing, and modern storage architectures -- Indexing structures for files and physical database design -- Query processing and optimization -- Strategies for query processing -- Query optimization -- Transaction processing, concurrency control, and recovery -- Introduction to transaction processing concepts and theory -- Concurrency control techniques -- Database recovery techniques -- Distributed databases, NOSQL systems, and big data -- Distributed database concepts -- NOSQL databases and big data storage systems -- Big data technologies based on MapReduce and Hadoop -- Advanced database models, systems, and applications -- Enhanced data models: introduction to active, temporal, spatial, multimedia, and deductive databases -- Introduction to information retrieval and web search -- Data mining concepts -- Overview of data warehousing and OLAP -- Additional database topics: security -- Database security -- 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.