Data Engineering for ERP Systems (E)

Master

Graduates/students: * Knows ERP-specific requirements of content and organizational nature * Can design databases (normalization, specific content) * Can implement databases (indexing, filegroups, partitioning, indexed views, etc.) * Knows the components and design options of the physical environment of databases (hardware) * Can implement defined processes in databases * Knows ways to back up data * Can log data access and implement a access strategy * Knows ways to ensure the availability of data (monitoring, logging, clustering, RAID, etc.) * Knows performance-relevant criteria * Knows the most important database manufacturers and their products * Knows Life Cycle of Data * Knows interfaces and their problems

not applicable

* Distributed databases * distributed database management system (DDBMS) * transaction management in DDBMS * synchronization and recovery in DDBMS * database management in ERP-systems.

Ramez E., Shamkant N.; Fundamentals of database systems, Prentice Hall, 2016 Connolly Th. et al.; Database Systems; Addison-Wesley; 4. Auflage 2004 Dyche J.; e-Data; Addison-Wesley; 2000 Bauer A., Günzel, H.; Data Warehouse Systeme; dpunkt; 2013 Clausen N.; OLAP; Addison-Wesley; 1998 Messerschmidt H., Schweinsberg K.; OLAP mit dem SQL Server; dpunkt; 2003

Written exam

English

5

15

3.0

Lecture, individual work with software, group work, presentation and discussion of tasks

2

Dr. Arnim Franzmann

1.year of studies

DAT.1

integrated lecture

Compulsory

not applicable