Master of Eng. in Automation & IT

Deutsch Englisch

Future Students  Course  People  Contact

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
• 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
• 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 three courses:

Object oriented Programming for Data Science

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

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

Enterprise Resource Planning Systems (ERP)

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
• Van der Hoven H.: ERP and Business Processes. Llumina Press, 2009

© 2024 TH Köln    Contact