ERP Systems & Business Process Management PT
Apply Icon

Data Engineering for ERP Systems (E)

level of course unit


Learning outcomes of course unit

* 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

prerequisites and co-requisites

not applicable

course contents

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

recommended or required reading

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

assessment methods and criteria

Written exam

language of instruction


number of ECTS credits allocated


eLearning quota in percent


course-hours-per-week (chw)


planned learning activities and teaching methods

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

semester/trimester when the course unit is delivered


name of lecturer(s)

Dr. Arnim Franzmann

year of study

1.year of studies

recommended optional program components

not applicable

course unit code


type of course unit

integrated lecture

mode of delivery


work placement(s)

not applicable