Data Engineering for ERP Systems (E)
Niveau
Master
Learning outcomes of the courses/module
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 for the course
not applicable
Course content
* 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 specialist literature
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
English
Number of ECTS credits awarded
5
Share of e-learning in %
15
Semester hours per week
3.0
Planned teaching and learning method
Lecture, individual work with software, group work, presentation and discussion of tasks
Semester/trimester in which the course/module is offered
2
Name of lecturer
Dr. Arnim Franzmann
Academic year
1.year of studies
Key figure of the course/module
DAT.1
Type of course/module
integrated lecture
Type of course
Compulsory
Internship(s)
not applicable