Middleware for heterogeneous and distributed information systems

News

 

Date

Announcement

2018-01-23

Lecture Survey / Vorlesungsumfrage (VLU)
Here is the link to participate in the lecture survey of the current semester: VLU

wq

2018-01-12

Dates for oral exams


There will be oral exams for this lecture. Possible exam dates are March 1., 2., 15., 16., 22., 23., 26., and 27. There will be no exams offered in February or April. Starting Monday, January 15th, 9:00 o’clock, please contact our secretary Heike Neu (with link to http://wwwlgis.informatik.uni-kl.de/cms/?id=541) to make an appointment for your exam and then register with the examination office. The duration of the exam will be approx. 45 minutes. It will take place in room 36-329.


wq

2017-10-24

Cancelling of lecture on Oct. 30, 2017

The middleware lecture given next Monday (Oct. 30) at 11:45 is cancelled.
wq

2017-10-09

First Exercise Session
Due to the holiday on 31.10., the first exercise session will take place on Friday, 03.11.2017 15:30 in room 48-208. All other exercises will be weekly on Tuesdays 13:45 in room 13-222, beginning at 07.11.2017
wq

Contents

 


Chapters


Literature

Chapter 0: Organization and Outline

pdf

Chapter 1: Motivation

pdf

Chapter 2: Distributed Information Systems

pdf

[1] (chapters 1, 2.2, 3.1, 3.2, 8.1, 8.2, 8.3); [2] (chapter 1)

Chapter 3: DB Gateways

pdf

[3] (chapter 12), [4], [5]

Chapter 4: Remote Procedure Calls and Distributed Transactions

pdf

[1] (chapters 2.4, 8, 10.8)

Chapter 5: Application Server Middleware

pdf

[1] (chapters 2, 3 and 10); [6] (chapters 4 and 10)

Chapter 6: Object Persistence Services

pdf

[6] (chapters 6, 9)

Chapter 7: Message-oriented Middleware

pdf

[1] (chapter 4); [7] (chapter 7.6.3)

Chapter 8: Foundations of Web Services

pdf

[1] (chapters 1 & 10), [2] (chapters 5 & 6)

Chapter 9: Web Services Coordination and Transactions

pdf

[2] (chapter 7), [1] (chaper 8.4)

Chapter 10: Business Process Modeling and Workflow Management

pdf

[1](chapter 5), [2](chapter 8), [7]

Chapter 11: Web-based Information Systems

pdf

[1](chapter 3.3), [2](chapter 4)

Chapter 12: Information Systems Integration

pdf


Chapter 13: Virtual Data Integration

pdf

[8] [9] [10] [11]

Chapter 14: Data Replication and Materialized Integration

pdf*

[12] [1](chapter 9) [13]

Chapter 15: Information Integration

pdf


*recently updated since 25.Jan 2018

Exercises

Exercise 1

pdf

solution

Exercise 2

pdf

solution


Exercise 3

pdf

solution


Exercise 4

pdf

solution

extras

Exercise 5

pdf

solution

extras

Exercise 6

pdf

solution

Exercise 7

pdf

solution

Exercise 8

pdf

solution


Exercise 9

pdf

solution

extras

Exercise 10

pdf

solution

Exercise 11

pdf

solution


Exercise 12

pdf

solution

Exercise 13


pdf

solution

 

Organizational matters

Course hours
Monday, 11:45 - 13:15, 46-260
Friday, 13:45 - 15:15, 48-453
Beginning at October 23, 2017

Exercise hours
First Exercise: Friday, 03.11.2017 15:30 - 17:00, 48-208
Exercises 2-13: Tuesday, 13:45 - 15:15, 13-222, beginning at November 7, 2017

Literature

Course literature:

[1] Philip A. Bernstein, Eric Newcomer: Principles of Transaction Processing (2nd Edition), Morgan Kaufmann Publ., 2009; available online at http://www.sciencedirect.com/science/book/9781558606234

[2] Gustavo Alonso, Fabio Casati, Harumi Kuno, Vijay Machiraju: Web Services - Concepts, Architectures and Applications, Springer, 2004; available in our university library and CS library.

[3] Ramez Elmasri, Shamkrant Navathe: Database Systems: Models, Languages, Design, and Application Programming (6th edition), Pearson, 2011; available in the CS library.

[4] MSDN - Introduction to ODBC, https://msdn.microsoft.com/en-us/library/ms715408(v=vs.85).aspx

[5] Andrew Eisenberg, Jim Melton. SQLJ Part 0, Now Known as SQL/OLB (Object-Language Bindings). SIGMOD Record 27(4): 94-100 (1998) GZipped PDF (Download first "Save link as..." -file may not open in your browser)

[6] Rima Patel Sriganesh, Gerald Brose, Micah Silverman: Mastering Enterpris JavaBeans 3.0, Wiley Publishing, 2006, available at
http://media.techtarget.com/tss/static/books/wiley/masteringEJB3/downloads/MasteringEJB4thEd.pdf

[7] Frank Leymann, Dieter Roller: Production Workflow: Concepts and Techniques, Prentice Hall, 2000, available in our university library and CS library.

[8] 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

[9] 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

[10] M. T. Roth, P. Schwarz. Don’t Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources. VLDB’97 PDF

[11] Catharine M. Wyss, Edward L. Robertson. Relational languages for metadata integration. ACM Trans. Database Syst. 30(2), 2005, 624-660 PDF

[12] Jim Gray, Pat Helland, Patrick E. O'Neil, Dennis Shasha. The Dangers of Replication and a Solution. SIGMOD Conference 1996: 173-182 PDF

[13] Chaudhuri, Surajit, and Umeshwar Dayal. "An overview of data warehousing and OLAP technology." ACM Sigmod record 26.1 (1997): 65-74.
http://dl.acm.org/citation.cfm?id=248616

Literature for prerequisites:

Any good database textbook, like the ones listed for the course "Database Systems".

 

Contact person

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

Weiping Qu, 36/331, 205-3264