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