"Babes-Bolyai" University of Cluj-Napoca
Faculty of Mathematics and Computer Science

Object oriented databases
Code
Semes-
ter
Hours: C+S+L
Credits
Type
Section
MI088
8
2+0+2
10
optional
Informatică
MI088
8
2+0+2
7
optional
Matematică-Informatică
Teaching Staff in Charge
Lect. VARGA Viorica, Ph.D., ivarga@cs.ubbcluj.ro
Aims
Theoretical knowledges about Object Databases. Implementing one aplication in Oracle 8i, an object-relational database management system.
Content
1.The development of object-database systems in two distinct paths: object-oriented database systems and object-relational database systems.
2. The design of object-database systems, the Object Definition Language (ODL).
2.1 Declaring interfaces in ODL, relations in ODL, inverse relations in ODL.
2.2 Subclasses in ODL, multiple inheritance in ODL.
2.3 Integrity contraints in ODL.
3.Query languages for object-database systems
3.1 Declaring methods in ODL.
3.2 Language OQL
3.2.1 Types in OQL
3.2.2 Select - from - where expresions in ODL
3.2.3 Complex expresions in ODL: grouping, operations on sets.
3.2.4 Object creation in ODL, collections, accessing elements of one collection.
3.3 Language SQL3
3.3.1 Type ROW in SQL3, creating tables with type ROW.
3.3.2 Abstract datatypes in SQL3
3.3.3 Methods of abstract datatypes in SQL3.
4. Object-relational programming in Oracle 8i.
4.1 Complex objects (Object Type)
4.1.1 Methods for one Object Type, constructor, MAP si ORDER.
4.1.2 Tabels of Object Type.
4.1.3 Select - from - where expresions using methods of objects, attributes of complex objetcts.
4.2 Application developing using complex objects in Oracle 8i
4.2.1 Possibilities in C++, Object Type Translator.
4.2.2 Using objects OraDatabase, OraObject in Visual Basic.
5. One object-oriented database system: O2.
5.1 One object-oriented data model: O2.
5.2 Persistent objects, methods in O2, queries in O2, CO2 language.
6. One object-relational database system: Ilustra.
6.1 Creating objects, methods, queries.
6.2 Query optimization in object-relational database systems: extensions of the relational database systems‘ query optimization.
References
1. S. Abiteboul, R. Hull, V. Vianu: Foundations of Databases, Addison-Wesley Publishing Company, 1995.
2. E. Bertino, P. Foscoli: Index Organizations for Object-Oriented Database Systems, IEEE Trans.on Knowledge and Data Engin. Vol.7 No.2, pp. 193-209, 1995.
3. E. Bertino, W. Kim: Indexing Techniques for Queries on Nested Objects, IEEE Trans.on Knowledge and Data Engin. Vol.1 No.2, pp. 196-213, 1989.
4. E. Bertino, L. Martino: Object-Oriented Database Systems, Concept and Arhitectures, Addison-Wesley, 1993.
5. D. N. Chorafas, H. Steinmann: Object-Oriented Databases, PTR Prentice-Hall, 1993.
6. R. Ramakrishnan: Database Management Systems, WCB McGraw-Hill, Boston, 1998.
7. M. Stonebraker: Object-Relational DBMSs, Morgan Kaufmann Publishers, San Fransisco, 1996.
8. J. D. Ullman, J. Widom: A First Course in Database Systems, Prentice Hall Upper Saddle River, New Jersey, 1997.
Assessment
Students has two develop one object-relational database application: design the database using complex objects, implement it in Oracle 8i, the interface in a visual programming language.
60% from the final mark is the mark from the laboratory
40% from the final mark is the mark from a written test.