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
Februar 02, 2012	Extra exericse for Sheet 13   The exercise will take place on Wednesday, Februar 08th 2012 at 11:45 in Room 11-222 au
November 08, 2011	Lecture at November 10, 2011 canceled   Because of a business trip, the lecture at November 10 is canceled. The lecture will be catched up as needed. au

Contents

Part I - Middleware for Information Systems
Chapter 0: Course Information and Outline		pdf (2/1)
Chapter 1: Motivation	pdf (1/1)	pdf (2/1)
Chapter 2: Distributed Information Systems	pdf (1/1)	pdf (2/1)
Chapter 3: DB Gateways	pdf (1/1)	pdf (2/1)
Chapter 4: RPC and DTP	pdf (1/1)	pdf (2/1)
Chapter 5: Application Server Middleware	pdf (1/1)	pdf (2/1)
Chapter 6: Persistence-Relationships-Query	pdf (1/1)	pdf (2/1)
Chapter 7: XML	pdf (1/1)	pdf (2/1)
Chapter 8: Foundations of Web Services	pdf (1/1)	pdf (2/1)
Chapter 9: Web Services Coordination and Transactions	pdf (1/1)	pdf (2/1)
Chapter 10: Web-based Information Systems	pdf (1/1)	pdf (2/1)
Part II - Enterprise Information Systems
Chapter 1: Motivation	pdf (1/1)	pdf (2/1)
Chapter 2: Virtual Data Integration	pdf (1/1)	pdf (2/1)
Chapter 3: Web Services Coordination and Transactions	pdf (1/1)	pdf (2/1)
Chapter 4: Information Integration	pdf (1/1)	pdf (2/1)
Chapter 5: Message Oriented Middleware	pdf (1/1)	pdf(2/1)
Chapter 6: Business Process Modeling and Workflow Management	pdf (1/1)	pdf (2/1)
Chapter 6: Web Services Composition	pdf (1/1)	pdf (2/1)

Exercises

Exercise 1		pdf
Exercise 2		pdf
Exercise 3		pdf
Exercise 4		pdf
Exercise 5		pdf
Exercise 6		pdf
Exercise 7		pdf
Exercise 8		pdf
Exercise 9		pdf	Handout pdf
Exercise 10		pdf	Handout pdf
Exercise 11		pdf	Handout pdf
Exercise 12		pdf
Exercise 13		pdf

 

Organizational matters

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

Exercise hours
Wednesday, 11:45 - 13:15, 44-465
Beginning at October 26, 2011

Contact person

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

Alexandra Unkelbach, 36/333, 205-3278

Yong Hu, 36/307, 205-3414

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