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

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)

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)

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