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
Jan. 30, 2013	Due to Prof. Deßloch's illness, there will be no lecture on Thursay, 31.01.
Dec. 03, 2012	All the courses of the first part (Middleware for Information Systems) will be finished tomorrow Dec. 04. After that, Professor Dessloch will iteract with you about the tips for learning and preparation for the exam.

Contents

 

 

Part I - Middleware for Information Systems
Chapter 0: Course Information and Outline	pdf (1/1)	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 System	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: Data Replication and Materialized Integration	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 7: Web Services Composition	pdf (1/1)	pdf (2/1)

Exercises

Exercise 1		pdf
Exercise 2		pdf	diagram
Exercise 3		pdf
Exercise 4		pdf
Exercise 5		pdf
Exercise 6		pdf
Exercise 7		pdf
Exercise 8		pdf
Exercise 9		pdf
Exercise 10		pdf	pdf (2/1)	Solution for exercise 1.5
Exercise 11		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 16, 2012

Exercise hours
Tuesday, 13:45 - 15:15, 48-462
Beginning at October 23, 2012

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
  • 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