Middleware for heterogeneous and distributed information systems WS 2015/16
News
Date | Announcement |
|---|---|
2016-09-27 | Results of the Second Exam |
2016-06-20 | Second Exam The second exam takes place on Monday, 26.09.2016, 9:00 - 11:00 in room 52-207. |
2016-04-18 | Exam Results |
2016-03-30 | The exam results will be published here on 18.04.2016. The post-exam review will take place on Monday, 25.04.2016, 14:00 - 15:30 in room 36-336. |
2016-02-25 | Exam |
2016-02-23 | Q&A Session |
2016-01-13 | No lecture on 21.01. |
2015-11-04 |
As of this semester, students taking their first exams for this course can only take a written exam for the complete course content (8 ECTS). If you have already passed or attempted exams for one of the two submodules in a previous semester, please see the information on our course website for WS2014/15. |
Contents
|
| ||
Chapter 0: Course Information and Outline | |||
| Chapter 1: Motivation | pdf | ||
| Chapter 2: Distributed Information Systems | [1] (chapters 1, 2.2, 3.1, 3.2); [2] (chapter 1) | ||
| Chapter 3: DB-Gateways | [3] (chapter 12), [4], [5] | ||
| Chapter 4: Remote Procedure Calls and Distributed Transactions | [1] (chapters 2.4, 8, 10.8) | ||
| Chapter 5: Application Server Middleware | [1] (chapters 2, 3 and 10); [6] (chapters 4 and 10) | ||
| Chapter 6: Object Persistence Services | [6] (chapters 6, 9) | ||
| Chapter 7: Message-Oriented Middleware | [1] (chapter 4); [7] (chapter 7.6.3) | ||
| Chapter 8: Introduction to Web Services | [1] (chapters 1 & 10), [2] (chapters 5 & 6) | ||
| Chapter 9: Web Services Coordination and Transactions | [2] (chapter 7), [1] (chaper 8.4) | ||
| Chapter 10: Business Process Modeling and Workflow Management | [1](chapter 5), [2](chapter 8), [7] | ||
| Chapter 11: Web-based Information Systems | [1](chapter 3.3), [2](chapter 4) | ||
| Chapter 12: Information System Integration | |||
| Chapter 13: Virtual Integration, Wrappers and External Data | [8] [9] [10] [11] | ||
| Chapter 14: Data Replication and Materialized Integration | [12] [1](chapter 9) [13] | ||
| Chapter 15: Information Integration |
Exercises
Exercise 1 | ||||
Exercise 2 | ||||
Exercise 3 | ||||
Exercise 4 | ||||
Exercise 5 | ||||
Exercise 6 | ||||
Exercise 7 | ||||
Exercise 8 | ||||
Exercise 9 | ||||
Exercise 10 | ||||
Exercise 11 | ||||
Exercise 12 | ||||
Exercise 13 |
Exam
The written exam takes place on Tuesday, 29.03.2016, 14:00 in room 01-106 and 01-019. The exam lasts two hours. Only non-red permantent pens and a non-prgrammable calculator are allowed. No pencils, no Tipp-ex, no books, no notes.
Organizational matters
Course hours
Monday, 11:45 - 13:15, 46-260
Thursday, 15:30 - 17:00, 46-260
Beginning at October 26, 2015
Exercise hours
Tuesday, 13:45 - 15:15, 13-222
Part 1 (MID) exercises (sheets 1-7) begin at November 03, 2015
Part 2 (EIS) exercises (sheets 8-13) begin at January 12, 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