 |
| Detailed information |
| Original study plan |
Bachelor's programme Computer Science 2021W |
| Objectives |
Graduates understand extended SQL language constructs as well as the basic concepts and techniques of object-relational (OR) and semi-structured (XML and JSON) data models and according middleware approaches. They have in-depth knowledge about query (XQuery) and transformation (XSLT) languages based thereupon. Finally, they have expertise in physical database concepts most notably transaction management and performance tuning.
|
| Subject |
- Advanced SQL-Concepts (referential actions, materialized views, OLAP-queries, recursive queries, stored procedures and trigger);
- Object-orientation and Databases (modeling, object-relational database concepts and mapping-middleware, JDBC);
- XML-technologies and Databases (DTDs, XMLSchema, XPath, XMLAPIs, XSLT, XQuery, Storage of XML-documents, JSON);
- Transaction mechanisms (Serializability, Recoverability, optimistic / pessimistic methods, extended transaction models);
- Performance tuning mechanisms (Tuning principles, query optimization, algebraic optimization)
|
| Criteria for evaluation |
Exam
|
| Methods |
Slide-based Lecture
|
| Language |
German |
| Study material |
- Gunter Saake, Kai-Uwe Sattler, Andreas Heuer: Datenbanken - Konzepte und Sprachen, MITP Verlag, 6. Auflage (2018)
- Türker, C., Saake, G.: Objektrelationale Datenbanken, dpunkt.Verlag, 2005
- Elliotte Rusty Harold, W. Scott Means, XML in a Nutshell: A Desktop Quick Reference, 3rd Edition, O'Reilly & Associates, 2005
- Saake, G.; Heuer, A.; Sattler, K-U.: Datenbanken: Implementierungstechniken, MITP Verlag, 4. Auflage, 2019
|
| Changing subject? |
No |
| Further information |
http://www.cis.jku.at
|
| Corresponding lecture |
(*)INBIPVOIFS2: VL Informationssysteme 2 (3 ECTS)
|
|
