Informations about the modules

zurück

Module (6 Credits)

Integration betrieblicher Informationssysteme 1 (IBIS 1)

Name in diploma supplement
Integration of Business Information Systems 1 (IBIS 1)
Responsible
Admission criteria
See exam regulations.
Workload
180 hours of student workload, in detail:
  • Attendance: 45 hours
  • Preparation, follow up: 90 hours
  • Exam preparation: 45 hours
Duration
The module takes 1 semester(s).
Qualification Targets

The students

  • understand essential approaches to integrate business information systems and are able to explain the key concepts underlying these approaches
  • are able to explain and critically discuss the relevance of integration as well as problems and challenges associated with integration
  • are familiar with a differentiated concept of integration, are able to describe the demand for integration of business information systems, and can assess traditional approaches (e.g., CIM systems or ERP systems) with respect to meeting this demand
  • are able to classify and assess integration approaches that are based on data exchange formats and have the ability to implement these approaches using corresponding tools and technologies
  • know different database technologies, are able to assess these technologies as a means of integration, and have the ability to apply these technologies using selected tools
  • understand the structure of data warehouse systems, can describe a method for developing data warehouse systems, and are able to practically apply this method using selected tools 
  • know different forms of decision supporting information systems including knowledge-based expert systems, and are able to assess both prerequisites for applying these systems and prospective bene-fits of these systems
Module Exam

Zum Modul erfolgt eine modulbezogene Prüfung in der Gestalt einer Klausur (in der Regel: 90-120 Minuten).

Vom Dozierenden wird zu Beginn der Veranstaltung festgelegt, ob durch freiwillige Testate in Form von technischen Miniprojekten bereits im Vorfeld Punkte für die Klausur erworben werden können. Für die Möglichkeit der Anrechnung der Testate muss die Klausur unabhängig vom Ergebnis der Testate mindestens bestanden sein. Ist dies der Fall, so bildet sich die Endnote aus dem Ergebnis der mindestens bestandenen Abschlussprüfung zuzüglich der bereits über die Testate erworbenen Punkte. Die Möglichkeit der Anrechnung der Testate auf die abschließende Prüfungsleistung ist auf maximal 15% der in der abschließenden Prüfung maximal erwerbbaren Punkte beschränkt. Bestandene Testate haben nur Gültigkeit für die Prüfungen, die zu der Veranstaltung im jeweiligen Semester gehören. Es ist unabhängig von der Bearbeitung der freiwilligen Testate möglich, die volle Punktzahl für die modulbezogene Prüfung ausschließlich im Rahmen der abschließenden Klausur zu erreichen.

Usage in different degree programs
  • BWL-EaF-Ma-2015 Wahlpflichtbereich 1st-3rd Sem, Elective
  • MuU-Ma-2013 Wahlpflichtbereich III Wahlpflichtbereich III B.: Informationssysteme für Märkte und Unternehmen 1st-3rd Sem, Elective
  • VWL-Ma-2009-V2013 Wahlpflichtbereich II 1st-3rd Sem, Elective
  • WiInf-Ma-2010 Wahlpflichtbereich Wahlpflichtbereich I: Wirtschaftsinformatik 1st-3rd Sem, Elective
Elements
Name in diploma supplement
Integration of Business Information Systems 1 (IBIS 1)
Organisational Unit
Lecturers
SPW
2
Language
English
Cycle
summer semester
Participants at most
no limit
Preliminary knowledge

keines

Abstract

Designing and implementing corporate information systems are pivotal topics of ‘Wirtschaftsinformatik’. While the modules ‘Enterprise Modelling I’ and ‘Enterprise Modelling II’ mainly focus on analysis and conceptual design, this lecture emphasizes a bottom-up perspective on implementation level artefacts, such as applications, technologies, and standards. Methods and technologies to develop integration systems as well as to foster the integration of existing systems are at the core of the lecture. The lecture starts by motivating the need for integration and reusability. Since integration is a vastly overloaded term, the students will be provided with a concept of integration that accounts for the peculiarities of information systems and can be applied to organizational integration – IT business alignment – as well. To further illustrate the need for integration in current IT landscapes, the participants will get an overview of functions covered by traditional business applications such as systems for accounting, human resource management, or production planning. Against this background, key approaches to promote the integration of corporate information systems will be presented and evaluated. This will include data exchange formats for loosely coupled systems and corresponding standards, database technologies as well as persistence in general. These approaches will be discussed and evaluated from both software-engineering and managerial perspectives. The presentation of decision support systems will provide further insights into the need for integrated information systems. For this purpose, their conceptual foundation and the need to integrate them with operational level systems will be analysed. Having gained an appropriate understanding of the concepts and technologies presented in the lecture, students are given the opportunity to practice their use in the accompanying tutorial.

Contents
  1. Motivation and Foundational Concepts
  2. Terminological Foundation
  3. Integration through Data Exchange Formats
  4. Integration through Database Technologies
  5. Decision Support Systems
Literature
  • Brachman, R. J.; Levesque, H. J.: Knowledge Representation and Reasoning. Morgan Kaufmann: San Francisco 2004
  • Frank, U.: Anwendungsnahe Standards für E-Business: Überblick über aktuelle Initiativen. In: Wirtschaftsinformatik, 43 Jg., Heft 3, 2001, S. 283-293
  • Frank, U.: Integration - Reflections on a Pivotal Concept for Designing and Evaluating Information Systems. In: Kaschek, R.; Kop, C.; Steinberger, C.; Fliedl, G.: Uniscon 2008 Proceedings. Lecture Notes in Business Information Processing, Vol. 6, Springer: Berlin, Heidelberg 2008, S. 11-22
  • Frank, U.; Strecker, S.: Beyond ERP Systems: An Outline of Self-Referential Enterprise Systems. ICB-Research Report, Institut für Informatik und Wirtschaftsinformatik (ICB), Universität Duisburg-Essen, No. 31, Universität Duisburg-Essen 2009
  • Goldfarb, C.; Rubinsky, Y.: The SGML Handbook. Oxford: Clarendon Press 1990
  • Golfarelli, M., Maio, D., Rizzi, S.: Conceptual Design of Data Warehouses from E/R Schemes. In Proceedings of the Hawaii International Conference on System Sciences; Kona, Hawaii, January 6-9, 1998
  • Hichert, R.; Moritz, M.: Management-Informationssysteme. Praktische Anwendungen. 2. Aufl., Springer: Berlin u.a.: Springer 1995
  • Inmon, W.H.: Building the Data Warehouse. 3rd ed., John Wiley & Sons; New York et al., 2002
  • Klettke, M. ; Meyer, H.: XML & Datenbanken. 1. Aufl. dpunkt: Heidelberg, 2003.
  • Turban, E.: Decision Support and Expert Systems. Management Support Systems. 4th ed., Englewood Cliffs, NJ: Prentice Hall 1995 (neueres Werk)
  • Witten, I.H., Frank, E.: Data Mining: Practical Machine Learning Tools and Techniques. 2nd ed., Elsevier,: Amsterdam et al., 2005
Teaching concept

Classic lecture with extensive discussions.

Participants
  • BWL-EaF-Ma-2015 Wahlpflichtbereich Modul "Integration betrieblicher Informationssysteme 1 (IBIS 1)" 1st-3rd Sem, Elective
  • MuU-Ma-2013 Wahlpflichtbereich III Wahlpflichtbereich III B.: Informationssysteme für Märkte und Unternehmen Modul "Integration betrieblicher Informationssysteme 1 (IBIS 1)" 1st-3rd Sem, Elective
  • VWL-Ma-2009-V2013 Wahlpflichtbereich II Modul "Integration betrieblicher Informationssysteme 1 (IBIS 1)" 1st-3rd Sem, Elective
  • WiInf-Ma-2010 Wahlpflichtbereich Wahlpflichtbereich I: Wirtschaftsinformatik Modul "Integration betrieblicher Informationssysteme 1 (IBIS 1)" 1st-3rd Sem, Elective
Lecture: Integration betrieblicher Informationssysteme 1 (IBIS 1) (WIWI‑C0532)
Name in diploma supplement
Integration of Business Information Systems 1 (IBIS 1)
Organisational Unit
Lecturers
SPW
2
Language
English
Cycle
summer semester
Participants at most
no limit
Preliminary knowledge

keines

Abstract

The tutorial extends and deepens the foundational concepts and challenges discussed in the lecture by examining, applying, and critically assessing various technologies and standards for integrating business information systems. In the first block, the tutorial starts with a consideration of XML and related technologies (e.g., DTD, XML Schema, Java and XML APIs, XPath, XQuery, XSLT, and XML application standards). This allows for a critical assessment of the integration of business information systems based on document exchange formats. In the second block, the tutorial covers integration through database technologies. This includes a treatment of relational databases, object persistence, and data warehouses. The part on object persistence is concerned with object persistence by means of RDBMS, the use of object-relational persistence frameworks (including JPA and corresponding example frameworks), as well as dedicated object-oriented databases. The part on data warehouses discusses (1) practical motivations, challenges, and procedures of establishing data warehouses, (2) prototypical architectures, components, and processes related to data warehouse systems, (3) data models used in the context of data warehouse systems (in particular, multi-dimensional data models), as well as (4) the practical implementation and assessment of an example data warehouse system. The considered end user components include static reporting, on-line analytical reporting (OLAP), and data mining tools. Finally, in the third block, the tutorial concludes with a discussion of decision support and expert systems (knowledge-based systems) and an application of corresponding example tools.

Qualification Targets

Siehe Qualifikationsziele des Moduls.

Contents

1. Integration through Data Exchange Formats

  • a. XML, DTD, and XML Schema
  • b. Java and XML APIs
  • c. XPath, XQuery, XSLT
  • d. XML Application Standards

2. Integration through Database Technologies

  • a. Relational DBMS
  • b. Object Persistence
  • c. Data Warehouses

3. Decision Support Systems and Expert Systems

Literature
  • Bauer, C.; King, G.; Gregory, G. (2015): Java Persistence with Hibernate. Manning, Greenwich.
  • Birbeck, M. (2001): Professional XML. Wrox Press, Birmingham.
  • Frank, U. (1988): Expertensysteme. Neue Automatisierungspotentiale im Büro- und Verwaltungsbereich? Gabler, Wiesbaden.
  • Frank, U. (2001): Standardisierungsvorhaben zur Unterstützung des elektronischen Handels. WIRTSCHAFTSINFORMATIK 43(3), pp. 283–293.
  • Gluchowski, P.; Kurze, C.; Schieder, C. (2009): A Modeling Tool for Multidimensional Data using the ADAPT Notation. In: Proceedings of the 42nd Hawaii International Conference on System Sciences (HICSS '09). Big Island, Hawaii.
  • Goldfarb, C. F.; Prescod, P. (2002): XML Handbook. 4th ed. Prentice Hall, Upper Saddle River.
  • Golfarelli, M.; Rizzi, S. (2009): Data Warehouse Design. Modern Principles and Methodologies. McGraw-Hill, New York.
  • Inmon, W. H. (2005): Building the Data Warehouse. 4th ed. Wiley, Indianapolis.
  • Ireland, C.; Bowers, D.; Newton, M.; Waugh, K. (2009): A Classification of Object-Relational Impedance Mismatch. In: Proceedings of the 2009 First International Conference on Advances in Databases, Knowledge, and Data Applications. IEEE Computer Society, Los Alamitos, pp. 36-43.
  • Kay, M. (2004): XPath 2.0. Wiley, Indianapolis. 
  • Lehner, W. (2003): Datenbanktechnologie für Data-Warehouse-Systeme. dpunkt, Heidelberg.
  • McLaughin, B. (2001): Java & XML. O’Reilly, Sebastapol.
  • Negnevitsky M (2005): Artificial Intelligence. A Guide to Intelligent Systems. 2nd Edition. Pearson, Essex.
  • Paterson, J; Edlich, S.; Hörning, H; Hörning, R. (2006): The Definitive Guide to db4o. Apress, Berkeley.
  • Van der Vlist, E. (2002): XML Schema. O’Reilly, Sebastapol.

The listed literature references are examples. Further references will be provided during the tutorial.

Teaching concept

The tutorial is designed as a combination of presentations, in-class exercises, group discussions, home assignments, and teamwork mini-projects. Active participation is encouraged. Participants will access server-based software and development environments to get familiar with example tools for the discussed technologies.

Participants
  • BWL-EaF-Ma-2015 Wahlpflichtbereich Modul "Integration betrieblicher Informationssysteme 1 (IBIS 1)" 1st-3rd Sem, Elective
  • MuU-Ma-2013 Wahlpflichtbereich III Wahlpflichtbereich III B.: Informationssysteme für Märkte und Unternehmen Modul "Integration betrieblicher Informationssysteme 1 (IBIS 1)" 1st-3rd Sem, Elective
  • VWL-Ma-2009-V2013 Wahlpflichtbereich II Modul "Integration betrieblicher Informationssysteme 1 (IBIS 1)" 1st-3rd Sem, Elective
  • WiInf-Ma-2010 Wahlpflichtbereich Wahlpflichtbereich I: Wirtschaftsinformatik Modul "Integration betrieblicher Informationssysteme 1 (IBIS 1)" 1st-3rd Sem, Elective
Exercise: Integration betrieblicher Informationssysteme 1 (IBIS 1) (WIWI‑C0533)
Module: Integration betrieblicher Informationssysteme 1 (IBIS 1) (WIWI‑M0365)