 |
| Detailed information |
| Original study plan |
Bachelor's programme Computer Science 2025W |
| Learning Outcomes |
Competences |
| Students 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. They are able to reason about the potential benefit of the different data models and languages and apply their concepts for problem solving. Finally, they have expertise in physical database concepts most notably transaction management and performance tuning and are enabled to apply them in a problem adequate way.
|
|
| Skills |
Knowledge |
Students are able to
- apply advanced SQL language constructs, especially stored procedures and triggers (K3)
- develop appropriate DB schemata on basis of OR- and XML-based language constructs as well as analyze and evaluate their suitability (K4, K5, K6)
- apply transaction- and optimization mechanisms and evaluate their effectiveness (K3, K5)
|
- Advanced SQL-Concepts;
- Object-orientation and Databases;
- XML-technologies and Databases;
- Transaction Management;
- Performance tuning mechanisms
|
|
| 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 |
This lecture forms an inseparable unit together with its according practice course. Its learning outcome is achieved in combination with the practice course, only.
|
| Corresponding lecture |
(*)INBIPVOIFS2: VL Informationssysteme 2 (3 ECTS)
|
|
