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