IMIT 31022

>< Title : Advanced Databases
>< Type/Status : Elective Course
>< Teaching and learning objectives:
The aim of this course is to introduce the different techniques that can be used to optimize database applications. This course will also introduce the design and development of different non-relational data models for an organization
On successful completion of the course students will be able to describe and explain the concepts of transaction processing in database management systems and mechanisms for dealing with security of database systems. They will also be able to appreciate techniques in designing distributed and parallel data base systems and familiar with the role of data warehousing and data mining on modern information systems
>< Course Content:

Query optimization (different approaches of building query, query trees, query graphs, etc.), database security, Concurrency & Recovery (transaction, types of transaction, problems with uncontrolled concurrency, immediate update, differed update, check point, time stamping, locking, OS functions) Object Oriented Databases, Distributed Databases, Parallel Databases, Temporal Databases, Deductive Databases, Data warehouse and data mining, Geographic Databases & GIS systems.

>< Methodology:
The course will be delivered in a combination of lectures, supervised hands on practical and group work.
>< Scheme of Evaluation:
End-of- semester examination and continuous assessment.
>< Recommended Reading:
1. Elmasri R. and Navathe S. B., “Fundamentals of Database Systems”, 4rd Edition, 2003, Addison Wesley.
2. Kimble R., “Data Warehouse Toolkit”, 2rd Edition, 2002, John Wiley & Sons.

Back