Babes-Bolyai University of Cluj-Napoca
Faculty of Mathematics and Computer Science
Study Cycle: Graduate
SUBJECT

Code	Subject	
MIH0012	Object Oriented Databases	

Section	Semester	Hours: C+S+L	Category	Type	
Information engineering - in Romanian	8	2+0+2		optional	

Teaching Staff in Charge	Assoc.Prof. VARGA Viorica, Ph.D., ivarga@cs.ubbcluj.ro
Lect. SABAU Andreea, Ph.D., deiush@cs.ubbcluj.ro	
Aims	Theoretical knowledges about Object Databases. Implementing one aplication in Oracle 9i, 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 9i.
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 9i
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 and query optimization.
	
Bibliography	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. A. Silberschatz, H. Korth, S. Sudarshan: Database System Concepts, McGraw-Hill, New York, 2006.
8. M. Stonebraker: Object-Relational DBMSs, Morgan Kaufmann Publishers, San Fransisco, 1996.
9. 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.
50% from the final mark is the mark from the laboratory
50% from the final mark is the mark from a written test.