Diese Seite auf DE

Event

Exercises Applied Informatics - Database Systems [SS232511201]

Type

exercise (Ü)
Präsenz

Term

SS 2023

SWS

Language

Deutsch

Appointments

Links

ILIAS

Lecturers

Dr. Daniel Sommer

Organisation

Institut für Angewandte Informatik und Formale Beschreibungsverfahren

Part of

Brick Applied Informatics – Database Systems | Industrial Engineering and Management (B.Sc.)
Brick Applied Informatics – Database Systems | Economics Engineering (B.Sc.)
Brick Applied Informatics – Database Systems | Digital Economics (B.Sc.)

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

17.04.2023 09:45 - 11:15 - Room: 05.20 1C-04
19.04.2023 09:45 - 11:15 - Room: 05.20 1C-04
24.04.2023 09:45 - 11:15 - Room: 05.20 1C-04
26.04.2023 09:45 - 11:15 - Room: 05.20 1C-04
03.05.2023 09:45 - 11:15 - Room: 05.20 1C-04
08.05.2023 09:45 - 11:15 - Room: 05.20 1C-04
10.05.2023 09:45 - 11:15 - Room: 05.20 1C-04
15.05.2023 09:45 - 11:15 - Room: 05.20 1C-04
17.05.2023 09:45 - 11:15 - Room: 05.20 1C-04
22.05.2023 09:45 - 11:15 - Room: 05.20 1C-04
24.05.2023 09:45 - 11:15 - Room: 05.20 1C-04
05.06.2023 09:45 - 11:15 - Room: 05.20 1C-04
07.06.2023 09:45 - 11:15 - Room: 05.20 1C-04
12.06.2023 09:45 - 11:15 - Room: 05.20 1C-04
14.06.2023 09:45 - 11:15 - Room: 05.20 1C-04
19.06.2023 09:45 - 11:15 - Room: 05.20 1C-04
21.06.2023 09:45 - 11:15 - Room: 05.20 1C-04
26.06.2023 09:45 - 11:15 - Room: 05.20 1C-04
28.06.2023 09:45 - 11:15 - Room: 05.20 1C-04
03.07.2023 09:45 - 11:15 - Room: 05.20 1C-04
05.07.2023 09:45 - 11:15 - Room: 05.20 1C-04
10.07.2023 09:45 - 11:15 - Room: 05.20 1C-04
12.07.2023 09:45 - 11:15 - Room: 05.20 1C-04
17.07.2023 09:45 - 11:15 - Room: 05.20 1C-04
19.07.2023 09:45 - 11:15 - Room: 05.20 1C-04
24.07.2023 09:45 - 11:15 - Room: 05.20 1C-04
26.07.2023 09:45 - 11:15 - Room: 05.20 1C-04

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.