News

 

Date	Announcement
2017-01-12	Lecture Survey / Vorlesungsumfrage (VLU) Here is the link to participate in the lecture survey of the current semester: VLU. js
2016-12-13	Second time slots for ex5 extended doodle.com/poll/s7gkk47inkwhs4ec   The second slot:Friday, Jan 13, 2017 wq
2016-12-13	No lecture on 22.12.2016 There will be no lecture on 22.12.2016 js
2016-11-29	Time slots for ex5 extended doodle.com/poll/tmsiwc258yzrhn6c   The first slot: Dec 1st. 10:00-11:00 in 36/336 wq
2016-11-28	Oral-Exams The oral exams take place on 20.02., 21.02., 23.02, 20.03., 21.03., 23.03.2017 in room 36-329. You can register for the exams in the exercise lesson on 20.12.2016. Alternatively, you can register at Heike Neu's office (room 36-325) on 21.12.2016 or in the new year. js
2016-10-11	First Exercise Session Due to the holiday on 01.11., the first exercise session will take place on Wednesday, 02.11.2016 13:45 in room 11-241. All other exercises will be weekly on Tuesdays 13:45 in room 13-222, beginning at 08.11.2016 js

Contents

 

Chapters		Literature
Chapter 0: Course Information and Outline	pdf
Chapter 1: Motivation	pdf
Chapter 2: Distributed Information Systems	pdf	[1] (chapters 1, 2.2, 3.1, 3.2); [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 System Integration	pdf
Chapter 13: Virtual Integration, Wrappers and External Data	pdf	[8] [9] [10] [11]
Chapter 14: Data Replication and Materialized Integration	pdf	[12] [1](chapter 9) [13]
Chapter 15: Information Integration	pdf

Exercises

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

 

Organizational matters

Course hours
Monday, 11:45 - 13:15, 46-260
Thursday, 15:30 - 17:00, 46-260
Beginning at October 24, 2016

Exercise hours
First Exercise: Wednesday, 02.11.2016 13:45 - 15:15, 11-241
Exercises 2-13: Tuesday, 13:45 - 15:15, 13-222, beginning at November 8, 2016

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

Johannes Schildgen, 36/340, 205-3281