Apply
now
now
Data Engineering for ERP Systems (E)
level of course unit
MasterLearning 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
* 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.
* 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
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
Englishnumber of ECTS credits allocated
5eLearning quota in percent
15course-hours-per-week (chw)
3planned learning activities and teaching methods
Lecture, individual work with software, group work, presentation and discussion of tasks
