Middleware for heterogeneous and distributed information systems WS 2009/10

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

February 2, 2010

Last exercise rescheduled

The last exercise is rescheduled to Monday, February 22nd, 15:00 - 16:30, room 48-379.

tj

February 2, 2010

Lecture canceld

There will be no lecture on Tuesday, February 9th.

tj

October 27, 2009

First exercise rescheduled!

The first exercise is rescheduled to Friday, November 6th, 15:30-17:00, room 48-379.

tj

October 26, 2009

Start of the course

The course lectures will start on Tuesday, October 27, 2009.

tj

Contents

Part I - Middleware for Information Systems

 

Chapter 0: Course Information and Outline

pdf

Chapter 1: Motivation

pdf

Chapter 2: Distributed Information Systems Architecture

pdf

Chapter 3: DB Gateways

pdf

Chapter 4: Remote Procedure Calls and Distributed Transactions

pdf

Chapter 5: Application Server Middleware

pdf

Chapter 6: Object Persistence, Relationships, and Queries

pdf

Chapter 7: XML

pdf

Chapter 8: Foundations of Web Services

pdf

Chapter 9: Web Services Coordination and Transactions

pdf

Chapter 10: Web-based Information Systems

pdf

Part II - Enterprise Information Systems

 

Chapter 1: Motivation

pdf

Chapter 2: Virtual Data Integration

pdf

Chapter 3: Data Replication and Materialized Integration

pdf

Chapter 4: Information Integration

pdf

Chapter 5: Message-oriented Middleware

pdf

Chapter 6: Business Process Modeling and Workflow Management

pdf

Chapter 7: Web Services Composition and E-Business Collaboration

pdf

Exercises

Exercise 1

 

pdf

Exercise 2

 

pdf

Exercise 2 - Handout

 

pdf

Exercise 3

 

pdf

Exercise 4

 

pdf

Exercise 5

 

pdf

Exercise 5 - Sample DTD

 

dtd

Exercise 5 - Sample XSD

 

xsd

Exercise 6

 

pdf

Exercise 7

 

pdf

Exercise 7 - Sequence Diagrams

 

pdf

Web Services Coordination (WS-Coordination) Version 1.1
(includes the sample Coordination Context presented in class)

 

html

Exercise 8

 

pdf

Exercise 8 - Garlic Query Plans

 

pdf

Exercise 9

 

pdf

Exercise 9 - FIRA view definitions

 

pdf

Exercise 10

 

pdf

Exercise 10 - Cupid Schema Matching

 

pdf

Exercise 11

 

pdf

Exercise 12

 

pdf

Exercise 13

 

pdf

Exercise 14

 

pdf

Exercise 14 - Explanation of BPEL's pick activity

 

html

Exercise 14 - A Hands-on Introduction to BPEL

 

html

 

Organizational matters

Course hours
Tuesday, 10:00 - 11:30, 48-462
Thursday, 10:00 - 11:30, 48-462
Beginning at October 27, 2009

Exercise hours
Wednesday, 10:00 - 11:30, 48-379
Beginning at November 6, 2009

Contact person

Stefan Deßloch, 36/329, 205-3275
Thomas Jörg, 36/308, 205-2644

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