Middleware for heterogeneous and distributed information systems

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