Course Outline :

1. A case study to bring out paradigms useful in developing complex/collaborative information systems

2. Extended ER model : a quick review

3. Object-orientation, modeling, methodologies (briefly); using UML, OMT etc.

4. Relational model review; new features of SQL2 standard

5. Objcet-oriented data models and database systems; persistence in OOPLs; ODMG standard for OODBs

6. Object-relational database systems; SQL-3 features

7. Database connectivity standards and using them for architecting database applications

8. Temporal database models; study of TSQL proposal

9. Semi-structured database models; XML in database applications; LOREL as a case study for semi-structured data models

10. Directory services; directory data models : LDAP

11. Data warehousing : multidimensional models, star schemas

12. Metadata and emerging standards like OIM

13. Workflow technologies

14. Distributed databases : design and application development strategies

These will be followed by seminars (given as reading asignments !) on selected topics

We will use Oracle8i/9i as a case study whenever possible.

Oracle8i documentation is available on-line