Transcript Data Warehousing – CG124

Advanced Databases – CM036
Dr. Akhtar Ali
School of Computing, Engineering and
Information Sciences
The module aims to:



Extend the concepts and practical implementation of the
relational model.
Introduce the concepts of Object Oriented and ObjectRelational Databases.
Provide essentials of Query Optimization.
1
Learning Outcomes
On completion, the student should be able to:





Critically assess the limitations of relational databases;
Assess different ways of extending the relational model and
SQL (e.g object-relational extensions, PL/SQL);
Explain, discuss, and evaluate Object-Oriented databases;
Compare and contrast the relational data model with objectrelational and object-oriented data models;
Critically evaluate query optimisation techniques and
compare alternative ways of storing data in order to improve
the performance of a database system;
2
Main Topics

Relational Algebra
– (1 Week)

Programming Extensions to SQL (PLSQL & Triggers)
– (2-3 Weeks)

Extensions to Relational Databases (e.g. object-relational
databases)
– (2 Weeks)

Object-Oriented Databases (ODMG standard, ODL, OQL)
– (3 Weeks)

Query Optimization (query processing and evaluation)
– (3 Weeks)
3
Prerequisite Knowledge & Skills

CM503 - Data Structures, Algorithms & Database Programming or
equivalent at level 5.
– Data structures and algorithms analysis using Java
– Database programming using Java/PLSQL

OR Prior
knowledge of Relational Databases
– For Example:
»
»
»
»
»
»
Relations
Keys
Constraints
Relational algebra
SQL (structured query language)
Relational database design – ER / Normalization
4
Assessment

Open Book/Notes Exam
– Worth 100%
– 3 hours duration
– In weeks 13 to 15 (January 2005)

Open-book means that you can take with you into the
examination room:
– Lecture notes,
– Seminar handouts and solutions, and
– Text books
5
Books and Learning Resources

Text Books
– Connolly/Begg, 'Database Systems: A Practical Approach to Design,
Implementation, and Management', Addison-Wesley, Latest Edition, 2004/5
– Elmasri/Navathe, ‘Fundamentals of Database Systems’, Addison-Wesley,
Latest Edition, 20004.

Supplementary Material
– Douglas K. Barry. ‘Object Database Standard: ODMG 3.0’. Morgan
Kaufmann Publishers, Inc. 2000.
– Ramakrishnan/Gehrke, ‘Database Management Systems’, McGraw Hill, 2nd
Edition, 2000.

Online Resources
– Blackboard (all the lecture notes, seminar handouts)
– Oracle Concepts, Oracle Corporation.
– Oracle Application Developer's Guide – Object-Relational Features
6