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.

Students can

  • design and write object oriented program code using the Python language
  • use relational databases
  • evaluate technologies of Industrial Internet of Things and Manufacturing Execution Systems
  • understand Enterprise Ressource Planning Systems

by

  • understanding and using abstract classes, composition and data analysis functions
  • comprehending the theoretical principles of database systems and their application to modelling and implementing databases,
  • creating complex database queries, data definitions and data changes using SQL programming
  • using transactions, multi-user synchronisation and procedures for fault recovery and ensuring data integrity
  • understanding active database concepts and applying them with Oracle PL/SQL
  • understanding and evaluating Internet of Things (IoT) technologies
  • understanding protocols of IoT
  • evaluating architectures of industrial IoT applications and environments
  • handling data within IoT systems
  • comprehending MES architectures (Manufacturing Execution System)
  • understanding the functionalities of central MES components and their evaluation
  • using and parameterizing MES interfaces to superior and inferior systems
  • comprehending basic technologies of information systems (client/server, web services, communication in client/server and service oriented structures) and their pros and cons
  • modeling business processes and implementing small examples of business functions in an enterprise resource planning environment
  • analyzing complex application systems in reference models
  • evaluating the technology of application systems
  • comprehending various integration models and integrating sub-systems
  • summarizing results in reports
  • presenting results in oral presentations

to

  • be able to solve data science problems by developing fast and reliable object-oriented software
  • be able to integrate automation systems, technical information systems and business information systems
  • be qualified for a professional career as automation engineer



Courses

The module consists of 4 courses:

Object oriented Programming for Data Science

Tutor

Prof. Wolf

Credit points

3 CP

Term

Fall

Contents

  • Abstract data types, classes, objects, messages, instance variables, methods, encapsulation, private and public access, class variables, constructors, class interface, class implementation
  • Classes and objects, private and public class members, constructors, initialization list, static data members, overloading, inline, separation of interface and implementation
  • Data structures, iterators and containers
  • Design, code and test a series of object-oriented programs to reenforce lecture content
  • Exception handling
  • Function overloading, operator overloading
  • Generic types, static and dynamic binding, polymorphism, overloading
  • Inheritance: types of inheritance, construction, destruction, multiple inheritance


Relational Databases

Tutor

D. Gawenda, M.A.

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
  • Active database concepts and fundamentals of Oracle PL/SQL


Industrial IoT and Manufacturing Execution Systems

Tutor

Prof. Hackeloeer

Credit points

3 CP

Term

Spring

Contents

  • Introduction into Industrial IoT and Industrie 4.0
  • Architecture of IIoT Applications
  • IoT Plattforms and cloud based systems
  • Designating factors of industrial IoT applications
  • IoT Connectivity
  • Protocols of Industrial IoT
  • Semantics
  • Digital twins
  • Handling of data
  • Principles and terminology of MES (ISA-95)
  • Architecture and structures of MES
  • Framework and library concept
  • Specific MES (PIMS, LIMS, QS, Scheduling, etc.)
  • Interfaces to subordinate automation systems (especially OPC)
  • Interfaces to and integration with superior ERP systems (especially SAP)
  • Industrial implementation examples


Enterprise Resource Planning Systems (ERP)

Tutor

Prof. Westenberger

Credit points

3 CP

Term

Fall

Contents

  • Structure of ERP systems, ERP paradigms
  • Basic technologies (client/server, SOAP) and technical architecture
  • Business transaction and transaction monitor
  • Process modelling
  • Programming and implementation of business functions
  • Middleware and integration models
  • Web service based integration


Bibliography

  • Lutz, M.: Programming Python Powerful Object-Oriented Programming (ISBN: 0596158106)
  • Gamma, E., Helm, R.: Design Patterns Elements of Reusable Object-Oriented Software (ISBN: 0201633612)
  • VanderPlas, J.: Python Data Science Handbook Essential Tools for Working with Data (ISBN: 9781491912058)
  • Geron, A.: Hands-On Machine Learning with Scikit-Learn and TensorFlow Concepts, Tools, and Techniques to Build Intelligent Systems (ISBN: 1491962291)
  • Chappell D. A.: Enterprise Service Bus. O'Reilly, 2004.
  • Current publications of major manufacturers such as ORACLE, SAP, SIEMENS, etc.
  • Elmasri, R, Navathe, R.: Fundamentals of Database Systems.Prentice Hall International, 6th edition, Global Edition, 2010.
  • Garcia-Molina, Jeffrey D. Ullman Jennifer Widom, Database Systems: The Complete Book, Prentice Hall International, 2008.
  • Josuttis N., M.: Soa in Practise. O'Reilly Media, 2007.
  • Meyer, H., Fuchs, F., Thiel, K.: Manufacturing Execution Systems: Optimal Design, Planning, and Deployment. Mcgraw Hill Book Co, 2009.
  • Kletti, H.(Editor): Manufacturing Execution System MES. Springer Berlin Heidelberg, 2010.
  • Schleipen: Praxishandbuch OPC UA, ISBN 978-3-8343-3413-8
  • [Lea: Internet of Things for Architects, ISBN 978-1-78847-059-9]
  • http://mqtt.org/
  • https://www.amqp.org/
  • Van der Hoven H.: ERP and Business Processes. Llumina Press, 2009.