Babes-Bolyai University of Cluj-Napoca
Faculty of Mathematics and Computer Science
Study Cycle: Graduate
SUBJECT
| MI113 | Semi-Structured Data |
| 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 |
| 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 |