Database systems (DBS) play an enormously important role in today's companies. Internal and external data is stored and processed in the database of the respective company. The correct management and organization of this data helps to solve numerous problems, enables simultaneous queries by several users and is the organizational and operational basis for the entire workflows and processes of the company. The lecture introduces the field of database theory, covers the basics of database languages and database systems, looks at basic concepts of object-oriented and XML databases, conveys the principles of multi-user database control and physical data organization. In addition, it provides an overview of database problems often encountered in business practice, such as

• Correctness of data (operational, semantic integrity),
• Restoration of a consistent database state,
• synchronization of parallel transactions (phantom problem).

Learning objectives:

Students

• explain the terms and principles of database models, languages and systems and their possible applications,
• design relational databases based on sound theoretical principles,
• create queries for relational database systems,
• overview advanced database problems in business practice.

Workload:

The total workload for this course unit is approx. 135 hours (4.5 credit points).

• Lecture 30h
• Exercise 15h
• Preparation and follow-up of the lecture 24h
• Preparation and follow-up of the exercise 25h
• Exam preparation 40h
• Exam 1h
  
  

• Schlageter, Stucky. Database systems: concepts and models. Teubner 1983.
• S. M. Lang, P. C. Lockemann. Database application. Springer-Verlag 1995.
• Jim Gray, Andreas Reuter. Transaction Processing: Concepts and Techniques. Morgan Kaufmann 1993.

Further literature will be announced in the lecture.