Topics Covered in Databases II Lectures
(Chris Clack only)
Selected Database Issues
1. Security: scope, countermeasures-BRAVE.
2. Security: Microsoft Access DBMS, Oracle DBMS, DBMS on the web.
3. Transaction Management: concurrency, serializability, protocols to prevent
4. Transaction Management: recovery, advanced transaction models, Oracle.
5. Query Processing: overview, decomposition, heuristic approach
6. Query Processing: cost estimation approach, pipelining, Oracle.
7. Programmatic SQL : static embedded SQL.
8. Programmatic SQL : dynamic embedded SQL, ODBC.
III. Current Trends
9. Distributed DBMSs: Concepts, extended functionality, distributed relational
database design, Transparency.
10. Distributed DBMSs: advanced concepts, protocols for distributed deadlock
control, X/Open Distributed Transaction Processing Model, Oracle.
11. Object-Oriented DBMSs: Introduction, approaches to developing OODBMSs,
storage models, issues
12. Object-Oriented DBMSs: framework, pointer swizzling, persistence,
development strategies, issues
13. Object-Relational DBMSs: background to ORDBMS, third manifesto, Postgres-
An Early ORDBMS, Query Processing and Optimazation.
IV. Emerging Trends
14. Web Technology and DBMSs: overview of internet and Web as a database
application platform, approaches to integrating databases.
15. Semistructured Data and XML: introduction, OEM, Lore and Lorel, XML
emerging standard, XML-related technologies, XML query languages.
16. Data Warehousing Concepts: outline, architecture, important processes,
associated tools, data marts, Oracle.
17. Data Warehousing Design: major issues, basic concepts in dimensionality
modeling, step-by-step methodology, dimensionality assessment criteria, Oracle
18. OLAP and Data Mining: discussion of OLAP: applications, rules, tools,
MOLAP, ROLAP, MQE. Data mining concepts, techniques, tools.