Middleware for heterogeneous and distributed information systems

News

 

Date

Announcement

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)

Exercises

Exercise 1

pdf

solution

Exercise 2

pdf

solution


Exercise 3

pdf

solution


Exercise 4

pdf

solution

extras

Exercise 5

pdf

solution


Exercise 6

pdf

solution

Exercise 7

pdf

solution

Exercise 8

pdf

solution


Exercise 9

pdf

solution


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