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

Code	Subject	
MIH0005	Semistructured Data	

Section	Semester	Hours: C+S+L	Category	Type	
Computer Science - in Hungarian	5	2+0+2	speciality	optional	
Mathematics-Computer Science - in Hungarian	5	2+0+2	speciality	optional	

Teaching Staff in Charge	Assoc.Prof. VARGA Viorica, Ph.D., ivarga@cs.ubbcluj.ro	
Aims	Theoretical knowledges about object databases and semistructured data. Implementing one 
aplication in Oracle 9i, an object-relational database management system, using XML too.
	
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).
3.Query languages for object-database systems
3.1 Declaring methods in ODL.
3.2 Language OQL
3.3 Language SQL3
4. Object-relational programming in Oracle 8i.
4.1 Complex objects (Object Type)
4.2 Select - from - where expresions using methods of objects, attributes of complex 
objetcts.
4.3 Query optimization in object-relational database systems: extensions of the relational database systems and query optimization.
4.4 Application developing using complex objects in Oracle 8i (Using objects OraDatabase, 
OraObject in Visual Basic).
5. Semistructured data model.
6. XML
6.1 Basic syntax
6.2 XML and semistructured data
6.3 Document Type Definition
6.4 Stylesheets
6.5 The Document Object Model
7. Quering semistructured data
7.1 Un-SQL query language
7.2 XQuery query language	
Bibliography	1. S. ABITEBOUL, R. HULL, V. VIANU: Foundations of Databases, Addison-Wesley Publishing Company, 1995.
2. S. ABITEBOUL, P. BUNEMAN, D. SUCIU: Data on the Web, Morgan Kaufmann, San Fracisco, 2000.
3. E. BERTINO, L. MARTINO: Object-Oriented Database Systems, Concept and Arhitectures, Addison-Wesley, 1993.
4. D. N. CHORAFAS, H. STEINMANN: Object-Oriented Databases, PTR Prentice-Hall, 1993.
5. C. J. DATE: Baze de date, Editia a opta, Editura Plus, 2005.
6. C. FUNG, K. KARLAPALEM, Q. LI: Complex Object Retrieval via Structural Join Index Hierarchy Mechanisms: Evaluation and Selection Approaches", Proceedings of the Ninth International Conference on Information Knowledge Management CIKM 2000. 
7. R. RAMAKRISHNAN: Database Management Systems, WCB McGraw-Hill, Boston, 1998.
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, using XML features, 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.