Neuere Entwicklungen für Datenmodelle SS 2012

News

Date

Announcement

June 19, 2012

Exercise solutions available

You can find the solutions for the exercises below.

js

April 27, 2012

Exercise plan

The following exercises have been planned to be held on 23.April, 07.May, 21.May, 04.June, 18.June, 02.July and 16.July

April 23, 2012

Exercise room changed

The exercise room has been changed to 36-336

March 23, 2012

Start of the course

The course lectures will start on Wednesday, April 18, 2012.

Contents

Recent Developments for Data Models: pdf (1/1), pdf (2/1)

Chapter 0 - Overview: pdf (1/1), pdf (2/1)

Chapter 1 - User-defined Types and Typed Tables: pdf (1/1), pdf (2/1)

Chapter 2 - Object-Relational Views and Composite Types: pdf (1/1), pdf (2/1)

Chapter 3 - User-defined Routines and Object Behavior: pdf (1/1), pdf (2/1)

Chapter 4 - Application Programs and Object-Relational Capabilities: pdf (1/1), pdf (2/1)

Chapter 5 - Data Analysis in SQL: pdf (1/1), pdf (2/1)

Chapter 6 - Windowed Tables and Window Functions in SQL: pdf (1/1), pdf (2/1)

Chapter 7 - XML Data Modeling: pdf (1/1), pdf (2/1)

Chapter 8 - XQuery: pdf (1/1), pdf (2/1)

Chapter 9 - SQL/XML: pdf (1/1), pdf (2/1)

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

Exercise 5

pdf

Solution to Exercise 5

pdf

Sample XML , XSD, and XQuerys

zip

Exercise 6

pdf

Organizational matters

Course hours
Wednesday, 08:15 - 09:45, 48-462
Beginning at April 18, 2012

Exercise hours
Monday (bi-weekly), 15:30 - 17:00, 36-336
Beginning at April 23, 2012

 

Contact person

Stefan Deßloch, 36/329, 205-3275

Johannes Schildgen

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)