Integration betrieblicher Informationssysteme 1 (IBIS 1)

Name in diploma supplementIntegration of Business Information Systems 1 (IBIS 1)
Organisational Unit Forschungsgruppe Wirtschaftsinformatik und Unternehmensmodellierung (http://www.wi-inf.uni-duisburg-essen.de/FGFrank/)
LecturersProf. Dr. Ulrich Frank
Cyclesummer semesterParticipants at mostno limit

Preliminary knowledge



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.


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


  • 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.


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