Elmasri, Ramez.

Database systems : models, languages, design and application programming / Ramez Elmasri, Shamkant B. Navathe. - 6th ed. - New Delhi : Pearson, 2014 - xxv, 1214 p. : ill. ; 24 cm.

overview of database languages an architectures;
the basic relational model;
SQL: data definition, constraints and basic queries and updates;
SQL: advanced queries, assertions, triggers and views;
formal relational languages: the algebra and calculus;
conceptual data modeling using entities and relationships;
mapping a conceptual design into a logical design;
UML for database application design;
object and object-relational databases: concepts, models, languages and standards;
XML: concepts, languages and standards;
SQL application programming using C and Java;
SQL web programming using C PHP;
database design theory: introduction to normalization using functional and multivalued dependencies;
database design theory: normalization algorithms;
database file organizations: unordered, ordered and hashed files of records;
database file indexing techniques, b-trees and B+ trees;
introduction to query processing and query optimization techniques;
introduction to data base tuning and physical design issued;
foundations of databases transaction processing;
introduction to protocols for concurrency control in databases;
introduction to database recovery protocols;
emerging database technologies and applications;
advanced database models and applications;
introduction to database security;
introduction to distributed databases;
introduction to information retrieval;
data mining concepts;
overview of data warehousing and OLAP


9788131792476


Database management.

005.74 / E482