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
  • The J2EE™ Tutorial
• 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)
  • Offizielle Webseite zu JDO
  • Java Specification Request zu 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
  • XQuery 1.0: An XML Query Language W3C-Webseite

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