Middleware for heterogeneous and distributed information systems WS 2014/15

The lecture Middleware for heterogeneous and distributed information systems (4V + 2Ü) is subdivided into two consecutive parts: Middleware for Information Systems (2V + 1Ü) is given in the first half of semester and Enterprise Information Systems (2V + 1Ü) in the second half of semester. Students may take the examination for the first and second part individually or in combination.

News

 

 

Date

Announcement

04.11.2015

If you have already started with separate exams for a/the submodule(s) of this course (i.e., "Middleware for Information Systems" or "Enterprise Information Systems") before WS 2015/16 and you would like to register for another submodule exam because
* you have passed the exam for one submodule and you want to take an exam for the remaining submodule, or
* you have failed the exam for one of the submodules and need a repeat exam,
then you can schedule an oral exam for the remaining submodule. We offer oral exam dates at least once per month. Please contact our secretary, Heike Neu, to schedule an examination date.

07.10.2015

Exam results

Here are the results and an overview of grades of the second exam. You can find the results on the blackboard in building 36-3xx as well. A Post-exam review will be on Wednesday, 28.10.2015 11:00 - 12:00 in room 36-336.

js

29.04.2015

Another Post-Exam Review for the Middleware exam will take place on 12.05. 15:00 - 15:30 in room 36-336.
js

15.04.2015

Exam results

Here are the results and an overview of grades of the written exam. You can find the results on the blackboard in building 36-3xx as well. A Post-exam review will be on Tuesday, 28.04.2015 in room 336. 10:00 - 10:40 (One part, 4 ETCS), 10:45 - 11:30 (Both parts, 8 ETCS).

js

03.02.2015

Next week (09th to 13th February), there will be no Middleware lectures and no exercise.

js

29.01.2015

There will be no lecture today (29.01.2015).
js

11.12.2014

The second part of the lecture (Enterprise Information Systems) will start on Monday, 15.12.2014
js

10.12.2014

We added some information about the written exam below on this website.
js

05.11.2014

The room for exercise is changed to 13-222.
hu

Contents

 

 

Part I - Middleware for Information Systems

Chapter 0: Course Information and Outline

pdf (1/1)
Chapter 1: Motivation pdf (1/1)
Chapter 2: Distributed Information Systems pdf (1/1)
Chapter 3: DB Gateways pdf (1/1)
Chapter 4: RPC and DTP pdf (1/1)
Chapter 5: Application Server Middleware pdf (1/1)
Chapter 6: Persistence-Relationships-Query pdf (1/1)
Chapter 7: Message-oriented Middleware pdf (1/1)
Chapter 8: Foundations of Web Services pdf (1/1)

Chapter 9: Web Services Coordination and Transactions

 pdf (1/1)

Chapter 10: Web based Information System

 pdf (1/1)

Part II - Enterprise Information Systems
Chapter 1: Motivation pdf (1/1)
Chapter 2: Virtual Data Integration pdf (1/1)
Chapter 3: Data Replication and Materialized Integration pdf (1/1)
Chapter 4: Information Integration pdf (1/1)
Chapter 5: Business Process Modeling and Workflow Management pdf (1/1)
Chapter 6: Web Services Composition pdf (1/1)

Exercises

Exercise 1

pdf

solution

Exercise 2

pdf

solution

solution

Exercise 3

pdf

solution

Exercise 4

pdf

solution

Exercise 5

pdf

solution

Exercise 6

pdf

solution

Exercise 7

pdf

solution

Exercise 8

pdf

solution

Exercise 9

pdf

solution

Exercise 10

pdf

solution

Exercise 11

pdf

solution

Exercise 12

pdf

solution

 

Exam

The written exam takes place on Tuesday, 31.03.2015, 14:00 in room 01-106 (8 ECTS, i.e. both parts of the lecture) and 01-019 (4 ECTS, only first or only second part). The full exam lasts two hours, the half exam one hour. Only non-red permantent pens are allowed. No calculators, no pencils, no Tipp-ex, no books, no notes.

The second exam takes place on Monday, 28.09.2015, 9:00 in room 52-207.

Organizational matters

Course hours
Monday, 11:45 - 13:15, 46-260
Thursday, 15:30 - 17:00, 46-260
Beginning at October 28, 2014

Exercise hours
Tuesday, 13:45 - 15:15, 13-222
Part 1 (MID) exercises begin at November 04, 2014
Part 2 (EIS) exercises begin at January 06, 2015

Contact person

Stefan Deßloch, 36/329, 205-3275

Yong Hu, 36/333, 205-3278

Johannes Schildgen, 36/340, 205-3281

References

Textbooks

  • Alonso, G.; Casati, F.; Kuno, H.; Machiraju, V.: Web Services, Springer Verlag, Heidelberg, 2003
  • Allamaraju, S. et. al.: Professional Java Server Programming - J2EE Edition, Wrox Press, Birmingham, UK, 2000
  • Blakeley, B., Harris, H., Lewis, R.: Messaging & Queuing Using the MQI, McGraw-Hill, New York, 1995
  • Bradley, N.: The XML companion, Addison-Wesley, Harlow, UK, 1998
  • Geiger, K.: Inside ODBC - Der Entwicklerleitfaden zum Industriestandard für Datenbankschnittstellen, Microsoft Press, Washington, 1995
  • Gray, J., Reuter, A.: Transaction Processing: Concepts und Techniques, Morgan Kaufmann, San Mateo, Kalifornien, 1993
  • Harold, E.R.: The XML Bible (2nd ed.), Hungry Minds, Inc., 2001
  • Leymann, F., Roller, D.: Production Workflow, Prentice Hall, 2000
  • Melton, J., Eisenberg, A.: Understanding SQL and Java Together - A Guide to SQLJ, JDBC, and Related Technologies, Morgan Kaufmann, San Francisco, 2000
  • Monson-Haefel, R.: Enterprise JavaBeans (4th ed.), O'Reilly, 2004
  • Orfali, R., Harkey, D.: Client/Server Programming with JAVA and CORBA, Wiley Computer Publishing Group (John Wiley & Sons, Inc.), New York, 1997
  • Siegel, J.: CORBA - Fundmentals and Programming, Wiley Computer Publishing Group (John Wiley & Sons, Inc.), New York, 1996
  • Stonebraker, M., Brown, P., Moore, D.: Object-Relational DBMSs - The Next Great Wave, 2nd Edition, Morgan Kaufmann, San Mateo, Kalifornien, 1998

Further readings

  • J2EE
  • SQL/OLB (SQLJ)
    • Andrew Eisenberg, Jim Melton
      SQLJ Part 0, Now Known as SQL/OLB (Object-Language Bindings). SIGMOD Record 27(4): 94-100 (1998) GZipped PDF
  • CORBA
    • CORBA services specifications HTML
  • Java Data Objects (JDO)
  • Web-based Information Systems
    • Loeser, H.
      Techniken für Web-basierte Datenbankanwendungen - Anforderungen, Ansätze, Architekturen
      in: Informatik - Forschung und Entwicklung 13(4), Springer, 1998, pp. 196-216.
      Publikationsseite der AG DBIS
  • SQL/MED
    • Jim Melton, Jan-Eike Michels, Vanja Josifovski, Krishna G. Kulkarni, Peter M. Schwarz
      SQL/MED - A Status Report.
      SIGMOD Record 31(3): 81-89 (2002)
      PDF
    • Jim Melton, Jan-Eike Michels, Vanja Josifovski, Krishna G. Kulkarni, Peter M. Schwarz, Kathy Zeidenstein
      SQL and Management of External Data.
      SIGMOD Record 30(1): 70-77 (2001)
      PDF
  • SQL/XML
    • Andrew Eisenberg, Jim Melton
      Advancements in SQL/XML
      SIGMOD Record 33(3): 79-86 (2004)
      PDF
    • Andrew Eisenberg, Jim Melton
      SQL/XML is Making Good Progress
      SIGMOD Record 31(2): 101-108 (2002)
      PDF
    • Andrew Eisenberg, Jim Melton
      SQL/XML and the SQLX Informal Group of Companies
      SIGMOD Record 30(3): 105-108 (2001)
      PDF
  • XQuery

Further readings (internally available only)

  • Middleware allgemein
    • S. Doraiswamy, M. Altinel, L. Shrinivas, S.L. Palmer, F.N. Parr, B. Reinwald, C. Mohan
      Reweaving the Tapestry: Integrating Database and Messaging Systems in the Wake of New Middleware Technologies
      in T. Härder, W. Lehner (Eds.): Data Management in a Connected World, LNCS 3551, Springer 2005: 91-110
      PDF
  • Wrappers
    • M. T. Roth, P. Schwarz
      Don’t Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources
      VLDB’97
      PDF
  • Data Replication Middleware
    • Jim Gray, Pat Helland, Patrick E. O'Neil, Dennis Shasha
      The Dangers of Replication and a Solution
      SIGMOD Conference 1996: 173-182
      PDF
  • Information Integration
    • Catharine M. Wyss, Edward L. Robertson
      Relational languages for metadata integration
      ACM Trans. Database Syst. 30(2), 2005, 624-660
      PDF
    • Jayant Madhavan, Philip A. Bernstein, Erhard Rahm
      Generic Schema Matching with Cupid
      VLDB'01
      PDF
    • Rachel A. Pottinger, Philip A. Bernstein
      Merging models based on given correspondences
      VLDB'03
      PDF
  • XQuery
    • Don Chamberlin
      XQuery: An XML Query Language
      IBM Systems Journal, vol. 41, no. 4, 2002
      PDF