Middleware for heterogeneous and distributed information systems WS 2013/14

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

2014-10-06

Results for the second exam

Here are the results and an overview of grades of the written exam from 29.09.2014. A post-exam review will be on 28.10.2014 11:00 - 11:45 in room 36-336.

js

2014-04-01

Second exam

The next date for a written exam is Monday, 29.09.2014 at 9:00 in room 52-207. By registering in the examination office, you can choose between an exam in Middleware for Information Systems (= part 1, 4 ETCS), Enterprise Information Systems (=part 2, 4 ETCS) or the full course Middleware for heterogeneous and distributed information systems (part 1 and 2, 8 ETCS). If you do the full exam, you will have two hours time and you will get one grade for both parts together, otherwise it lasts one hour. If you already participated in the exam in March, you can use this exam examine the other part or to repeat the exam in case of a failure.

js

2014-03-31

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, 29.04.2014 in room 336. 10:00 - 10:40 (One part, 4 ETCS), 10:45 - 11:30 (Both parts, 8 ETCS).

js

2014-03-11

Another room for the written exam

Depending on the exam, this will be your room:

- 52-206: 4 ETCS (only part 1 or part 2, 60 Minutes)
- 52-207: 8 ETCS (both parts, 120 Minutes)

js

2014-01-14

Exam for erasmus students

If you are an erasmus student who doesn't need to register for the exam, you can register via email. On the first page on the exam there will be a checkbox "[x] I need a certificate" which you then have to check.

js

2013-12-10

Exercise 8 on 19.12. instead of 17.12.2013

Exercise sheet 8 will be the first sheet on the second half of the course (Enterprise Information Systems). The exercise lesson in the week before christmas will be on Thursday, 19.12.2013 at 10:00 in room 44-465. So, there is no exercise lesson on Tuesday, 17.12. In January and Feburary, the exercises take place again as usual (every Tuesday).

js

2013-11-27

No lecture on 05.12.2013

There will be no lecture on Thursday, 05.12.2013.

js

2013-11-19

Exam
The written exam will be on Tuesday, 25.03.2014 at 8:30 in room 52-207. By registering in the examination office, you can choose between an exam in Middleware for Information Systems (= part 1, 4 ETCS), Enterprise Information Systems (=part 2, 4 ETCS) or the full course Middleware for heterogeneous and distributed information systems (part 1 and 2, 8 ETCS). If you do the full exam, you will have two hours time and you will get one grade for both parts together, otherwise it lasts one hour. There will be antother exam date in autumn 2014. This can be used to examine the other part or to repeat the exam you do in March in case of a failure.

js

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: XML 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: Message-Oriented Middleware pdf (1/1)
Chapter 6: Business Process Modeling and Workflow Management pdf (1/1)
Chapter 7: Web Services Composition pdf (1/1)

Exercises

Exercise 1

pdf

solution

Exercise 2

pdf

solution_1

solution_2

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

Exercise 13

pdf

solution

extras

 

Organizational matters

Course hours
Tuesday, 10:00 - 11:30, 48-462
Thursday, 15:30 - 17:00, 46-260
Beginning at October 22, 2013

Exercise hours
Tuesday, 13:45 - 15:15, 48-462
Beginning at October 29, 2013

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