Master of Eng. in Automation & IT
[ger]Deutsch
Englisch [eng]Englisch

Course 
People 

Automation & IT   Course   Modules   Integration

Integration of Technical and Business Information Systems


Qualification aims

This module covers relational database systems, manufacturing execution systems, enterprise resouce planning systems, and how they are integrated into company-wide IT architectures.

The student is to be enabled to

  • comprehend the theoretical principles of database systems and their application to modelling and implementing databases,
  • solve complex database queries, data definitions and data changes using SQL programming,
  • use transactions, multi-user synchronisation and procedures for fault recovery and ensuring data integrity,
  • comprehend MES architectures (Manufacturing Execution System),
  • understand the functionalities of central MES system components and their evaluation,
  • use interfaces to superior and inferior systems and their parameterisation,
  • comprehend basic technologies of industrial application systems (client/server, CORBA, web services communication in client/server and service oriented structures) and their pros and cons,
  • reflect complex application systems in reference models,
  • evaluate the technology of application systems,
  • comprehend various integration models, and
  • integrate sub-systems

Courses

The module consists of 3 courses:

Relational Databases

Tutor

Prof. Faeskorn-Woyke

Credit points

2 CP

Term

Fall

Contents

  • Basic terms and architectures of databases
  • Database system creation
  • Principles of the relational model (relational algebra, query optimisation, functional dependencies, data integrity and normalisation)
  • Data modelling (Entity Relationship Model)
  • Implementation using a relational database system as an example
  • Database language SQL: DDL, DML, DAL
  • Constraints of the current SQL standard (SQL 2003)
  • Transaction concepts
  • Multi-user synchronisation
  • Fault recovery and data security


Enterprise Resource Planning Systems (ERP)

Tutor

Prof. Westenberger

Credit points

4 CP

Term

Fall

Contents

  • Structure of an application system
  • Basic technologies (communication layers, RFC, CORBA, SOAP, client/server)
  • Middleware
  • Transaction term
  • Transaction monitor
  • Technical architecture
  • Integration models
  • EDI subsystems
  • Integration of server reference models
  • Analysis, design and development of company architectures
  • Workflow Management Systems (models and systems)


Manufacturing Execution Systems (MES)

Tutor

Prof. Scheuring

Credit points

2 CP

Term

Spring

Contents

  • Principles and terminology (ISA-95)
  • Architecture and structures of MES
  • Framework and library concept
  • PIMS (Process Information and Management Systems, Historian Database)
  • LIMS (Laboratory Information and Management Systems)
  • Production fine planning systems (Scheduling)
  • Materials management and warehousing administration systems
  • Quality management systems
  • Interfaces to subordinate automation systems (especially OPC)
  • Interfaces to and integration with superior ERP systems (especially SAP)
  • Industrial implementation examples


Bibliography

  • Current publications of major manufacturers such as ORACLE, SAP, SIEMENS, etc.
  • Conrad S. et al.: Enterprise Application Integration.
  • Grundlagen-Konzepte-Entwurfsmuster-Praxisbeispiele. 1st edition Elsevier Munich 2006.
  • Elmasri, R.; Navathe, S. B.: Grundlagen von Datenbanksystemen. Pearson-Studium. 2002
  • Faerber G., Kirchner J.: mySAP Technology. Galileo Press, Bonn 2002.
  • Heuer, A.; Saake, G.: Datenbanken Konzepte und Sprachen. mitp, 2000
  • Keller W.: Enterprise Application Integration.1st edition, dpunkt-Verlag, Heidelberg 2002.
  • Kemper, A.; Eickler, A.: Datenbanksysteme – Eine Einfuehrung. Oldenbourg-Verlag, 2004
  • Mende, U.: Workflow und ArchiveLink mit SAP, 1st edition, Dpunkt 2003.
  • Mueller, J.: Workflow Based Integration, 1st edition, Springer 2004.
  • Niemann K. D.: Von der Unternehmensarchitektur zur IT-Governance. 1st edition, Vieweg 2005
  • Rickayzen, A.: Workflow Management mit SAP, 1st edition, Galileo Press 2002.
  • Saake, G., Sattler, K.U. : Datenbanken und JAVA , dpunkt 2000
  • Stewart, J.: SAP EDI, 1st edition, Equity Press 2006.
  • Tanenbaum A., van Stehen A.: Verteilte Systeme, Grundlagen und Paradigmen.
  • van der Aalst, W.: Workflow Management, MIT Press 2004.
  • Vossen, G.: Datenmodelle, Datenbanksprachen, Datenbank-Managementsysteme, Oldenbourg-Verlag, 1994