Event
Exercises Applied Informatics - Database Systems [SS222511201]
Lecturers
Organisation
- Institut für Angewandte Informatik und Formale Beschreibungsverfahren
Part of
Literature
Schlageter / Stucky: Datenbanksysteme: Konzepte und Modelle, 2. Auflage, Teubner, Stuttgart, 1983 P. C. Lockemann / J. W. Schmidt (Hrsg.): Datenbank-Handbuch, Springer-Verlag, 1987 S. Cannan / G. Otten: SQL - The Standard Handbook, McGraw-Hill, 1993 Jim Gray / Andreas Reuter: Transaction Processing: Concepts and Techniques, Morgan Kaufmann, 1993 S. M. Lang / P. C. Lockemann: Datenbankeinsatz, Springer-Verlag, 1995 Ramez Elmasri / Shamkant B. Navathe: Fundamentals of Database Systems, Addison-Wesley, 1994 und 2000
Appointments
- 19.04.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 26.04.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 03.05.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 10.05.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 17.05.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 24.05.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 31.05.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 14.06.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 21.06.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 28.06.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 05.07.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 12.07.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 19.07.2022 11:30 - 13:00 - Room: 05.20 1C-03
- 26.07.2022 11:30 - 13:00 - Room: 05.20 1C-03
Note
Database systems (DBS) play an enormously important role in today's companies. The 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, teaches 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 the correctness of data (operational, semantic integrity), the recovery of a consistent database state, and the synchronization of parallel transactions.