Neuere Entwicklungen für Datenmodelle SS 2010

News

Date

Announcement

July 7, 2010

The last exercise

The 6th exercise sheet will be distributed in the upcoming lecture. Let's meet at Wednesday 21st, 10:00 in room 48-379 (the usual one). (Note that this date is different from the one porposed in the exercise class!) This way all students should be able to attend - including those that attended conflicting lectures during the semester. If this date does not work for you, please send me a mail.

tj

May 4, 2010

Exercise class will NOT be rescheduled!
Unfortunately, none of the proposed (17!) timeslots seems to work for all participants. Rescheduling the class would thus mean to exclude other students from it and we do not want this to happen. We therefore stick to Wednesday 10:00 – 11:30, as initially announced.

tj

April 23, 2010

Exercise class to be rescheduled!

Several students asked for the exercise class to be rescheduled, because it conflicts with a lecture on "Verification of Reactive Systems". Please indicate ALL dates that will work for you using the doodle poll at
www.doodle.com/5q3trkcvrad9697d

Note that the first exercise class will take place as planned (on April 28, 10:00 - 11:30, 48-379)!

tj

April 19, 2010

Lecture will NOT be rescheduled!

Since none of the proposed dates seems feasible for the majority of the current participants, the lecture will not be rescheduled.

tj

April 14, 2010

Attention - lecture to be rescheduled!

Due to conflicting schedules we are looking for a new data for the lecture. Please indicate which dates will be feasible for you using the doodle poll at http://www.doodle.com/ckuzi8ay8aahhmya. Thank you!

tj

March 15, 2010

Start of the course

The course lectures will start on Wednesday, April 14, 2010.

tj

Contents

Chapter 0: Overview

pdf

Chapter 1: User-defined Types and Typed Tables

pdf

Chapter 2: Object-Relational Views and Composite Types

pdf

Chapter 3: User-defined Routines and Object Behavior

pdf

Chapter 4: Application Programs and Object-Relational Capabilities

pdf

Chapter 5: Data Analysis in SQL

pdf

Chapter 6: Windowed Tables and Window Functions in SQL

pdf

Chapter 7: XML Data Modeling

pdf

Chapter 8: XQuery

pdf

Chapter 9: SQL/XML

pdf

Exercises

Exercise 1

pdf

Solution to Exercise 1

pdf

Exercise 2

pdf

Solution to Exercise 2

pdf

Exercise 3

pdf

Solution to Exercise 3

pdf

Exercise 4

pdf

Solution to Exercise 4

pdf

Schema definitions and sample data

zip

Exercise 5

pdf

Solution to Exercise 5

pdf

Sample XML , XSD, and XQuerys

zip

Exercise 6

pdf

Solution to Exercise 6

pdf

 

Organizational matters

Course hours
Wednesday, 11:45 - 13:15, 48-379
Beginning at April 14, 2010

Exercise hours
Wednesday (bi-weekly), 10:00 - 11:30, 48-379
Beginning at April 28, 2010

 

Contact person

Stefan Deßloch, 36/329, 205-3275
Thomas Jörg, 36/308, 205-2644

References

Textbooks

  • Jim Melton: Advanced SQL:1999 – Understanding Object-Relational and Other Advanced Features, Morgan Kaufmann, 2003.
  • Andreas Geppert: Objektrelationale und objektorientierte Datenbankkonzepte und –systeme, dpunkt Verlag, 2002.
  • Jim Melton, Andrew Eisenberg: Understanding SQL and Java Together - A Guide to SQLJ, JDBC, and Related Technologies, Morgan Kaufmann, 05/2000.
  • Wolfgang Lehner, Harald Schöning: n"XQuery – Ein Lehrbuch", dpunkt Verlag, 2004.
  • nHoward Katz, Don Chamberlin, Denise Draper, Mary Fernandez, Michael Kay, Jonathan Robie, Michael Rys, Jerome Simeon, Jim Tivy, Philip Wadler: XQuery from the Experts: A Guide to the W3C XML Query Language, Addison Wesley, 2003.

Papers (internally available only)

  • Malcolm P. Atkinson, François Bancilhon, David J. DeWitt, Klaus R. Dittrich, David Maier, Stanley B. Zdonik: TheObject-Oriented Database System Manifesto. SIGMOD Conference 1990: 395 (PDF)
  • Donald D. Chamberlin: XQuery: An XML query language. IBM Systems Journal 41(4): 597-615 (2002) (PDF)
  • Surajit Chaudhuri, Umeshwar Dayal: An Overview of Data Warehousing and OLAP Technology. SIGMOD Record 26(1): 65-74 (1997) (PDF)
  • Stefan Deßloch: SQL-Norm und Java. Datenbank-Spektrum 1: 25-32 (2001) (PDF)
  • Andrew Eisenberg, Jim Melton: SQL/XML is Making Good Progress. SIGMOD Record 31(2): 101-108 (2002) (PDF)
  • Andrew Eisenberg, Jim Melton: Advancements in SQL/XML. SIGMOD Record 33(3): 79-86 (2004) (PDF)
  • Fatma Özcan, Donald D. Chamberlin, Krishna G. Kulkarni, Jan-Eike Michels: Integration of SQL and XQuery in IBM DB2. IBM Systems Journal 45(2): 245-270 (2006) (PDF)

Papers (publicly available)