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)
Dr. Arnim Franzmann
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