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