Database systems: concepts, languages, architectures

Summary of contents

• Part 1: relational databases
• the model and its languages
• the relational model
• the structure of the relational model
• integrity constraints
• discussion
• relational algebra and calculus
• relational algebra
• relational calculus
• datalog
• SQL
• data definition in SQL
• queries in SQL
• data manipulation in SQL
• additional data definition features
• access privileges
• SQL and programming languages
• Part 2: database design
• design methodologies and models
• the database design process
• the entity-relationship model
• documentation of E-R schemes
• conceptual design
• requirements collection and analysis
• general representation criteria
• design strategies
• qualities of a conceptual schema
• a general methodology for database design
• a design example
• the conceptual phase
• CASE tools for database design
• logical design
• performance analysis on conceptual schemes
• restructuring E-R schemes
• translation towards the relational model
• a design example
• the logical phase
• logical design with database design tools
• normalization
• redundancies and anomalies
• functional dependencies
• Boyce-Codd normal form
• qualities of decompositions
• third normal form
• normalization and the design process
• Part 3: Database technology
• technology of a database server
• transactions
• concurrency control
• buffer management
• reliability control
• physical structures
• query processing and optimization
• physical design
• distributed architectures
• client-server architecture
• distributed databases
• distributed database technology
• two-phase commit protocol
• interoperability
• parallelism
• replication management
• Part 4: evolution of databases
• object databases
• object-oriented database systems (OODBMS)
• OMG standard languages
• ODL and OQL
• object-relational database systems (ORDBMS)
• multimedia database systems
• technology extensions for object databases
• active databases
• triggers in relational systems
• definitions and use of triggers in DB
• advanced features of active rules
• properties of active rules
• active database applications
• data warehouses
• architecture
• multi-dimensional model and language
• data mining
• databases in the World Wide web
• CGI and gateways
• database tools for Web applications
• design of Web sites
• DB ORACLE
• ACCESS