ERP Systems & Business Process Management PT
Apply Icon
Apply
now

Data Engineering for ERP Systems (E)

level of course unit

Master

Learning outcomes of course unit

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

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

English

number of ECTS credits allocated

5

eLearning quota in percent

15

course-hours-per-week (chw)

3

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

2

name of lecturer(s)

Prof. (FH) DI Dr. Martin Adam

year of study

1.year of studies

recommended optional program components

not applicable

course unit code

DAT.1

type of course unit

integrated lecture

mode of delivery

Compulsory

work placement(s)

not applicable