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.,  ivargacs.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
References
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.
Links: Syllabus for all subjects
Romanian version for this subject
Rtf format for this subject