[ 521ANWEDI2V21 ] VL Databases and Information Systems 2

(*) Unfortunately this information is not available in english.
Workload Education level Study areas Responsible person Hours per week Coordinating university
3 ECTS B2 - Bachelor's programme 2. year Computer Science Werner Retschitzegger 2 hpw Johannes Kepler University Linz
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.
  1. Advanced SQL-Concepts (referential actions, materialized views, OLAP-queries, recursive queries, stored procedures and trigger);
  2. Object-orientation and Databases (modeling, object-relational database concepts and mapping-middleware, JDBC);
  3. XML-technologies and Databases (DTDs, XMLSchema, XPath, XMLAPIs, XSLT, XQuery, Storage of XML-documents, JSON);
  4. Transaction mechanisms (Serializability, Recoverability, optimistic / pessimistic methods, extended transaction models);
  5. 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
Corresponding lecture (*)INBIPVOIFS2: VL Informationssysteme 2 (3 ECTS)
On-site course
Maximum number of participants -
Assignment procedure Direct assignment