AdvancedDataBasesSystems

This course is composed of two parts:

1. Advanced Concepts of Relational Database Systems, we study:

• Concurrency Control (Transactions)
• Coping With System Failures (Undo, Redo, Undo-Redo Log)
• Active Database Systems(Triggers)
• Procedural extension of SQL (Oracle PL/SQL)
• Java Database Connectivity (JDBC)

1. Beyond Relational Databases, we study :

• Object Oriented Databases Systems
• Object Relational Databases Systems
• Mapping Object Relational

My Lectures Notes and Slides

• Transactions
• System Failure (Undo, Redo, Unod-Redo Log)
• Triggers
• JDBC
• Oracle PL/SQL
• Object-Oriented Database Systems (Old)
• Beyond Relational Database Systems (OO,OR,Mapping)
• Oracle Object relational

Links

• Document of Oracle OR
• mon ancienne page(Merise,normaisation,..
• Lectures Slides of others(R. Grin)
• J. Ullman (good site for Courses and Exercises)
• Oracle Toplink (object/relational persistence)
• http://www.hibernate.org
• SQL commandes
• Oracle 10g Online Documents

TD/TP

• Transactions 1ère partie
• Transactions 2ème partie
• Trigger Δ
• TP JDBC
• Object-Oriented Database Systems Δ
• Object-Relational Database Systems Δ
• Object-Relational Mapping Δ

Examen

• Examen Juin 2006
• Examen mai 2007
• Examen mai 2008