1 / 7

Advanced Database Technologies

This module aims to review relational databases and introduce and review object-oriented, object-relational, and other emerging database technologies. It provides an evaluation of query optimization, distribution, and parallelism in database systems.

squires
Download Presentation

Advanced Database Technologies

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advanced Database TechnologiesCG096 Dr. Akhtar Ali School of Computing, Engineering and Information Systems Jan 2007

  2. Module Aims The module aims: • To review relational databases. • To introduce and review object-oriented, object relational and other emerging database technologies. • To provide and evaluate essentials of query optimization, distribution and parallelism in database systems.

  3. Learning Outcomes On completion, the student should be able to: • Assess the limitations of relational databases; • Assess different ways of extending the relational databases; • Have mastered programming language extensions to SQL and the integration of SQL with programming languages; • Explain, discuss and evaluate object-oriented databases; • Compare and contrast the relational with object -relational and object-oriented databases; • Have understanding of the principles, methods, techniques and tools that underpin query processing/optimization; • Comprehend and practically assess the concepts of distributed and parallel databases; • Assess the implications of new developments in database technology.

  4. Main Topics • Relational Algebra • Programming Extensions to SQL (PLSQL & Triggers) • Extensions to Relational Databases (e.g. object-relational databases) • Object-Oriented Databases (ODMG standard, ODL, OQL) • Query Optimization (query processing and evaluation) • Distributed and Parallel Databases

  5. Prerequisite Knowledge & Skills • Working experience of a relational database management system. • For example, if you have previously attended CG065 – Databases. • OR you should be able to: • Understand and apply the principles of relational DBMS to a substantial real-world data analysis. • Use effectively an SQL-based DBMS to create, maintain, query and update a relational database. • Design relational database conceptual models using Entity Relationship Modelling. • Design relational database conceptual schemes using normalisation. • Critically evaluate principles and methods of relational database design.

  6. Assessment • Assignment • Worth 40% • Issued in week 7 and due in week 12. • Open Book/Notes Exam • Worth 60% • 2 hours duration • In weeks 13 to 15 (January 2005) • Open-book/open-notes means that you can take with you into the examination room: • lecture notes, • handouts and • text books

  7. Books and Learning Resources • Text Books • Elmasri/Navathe, ‘Fundamentals of Database Systems’, Addison-Wesley, 5th Edition, 2007. • Supplementary Material • 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

More Related