Recent Developments for Data Models SS 2014

News

Date

Announcement

October 22, 2014

Oral exams during the winter semester
Here are possible dates for an oral exam: 21.11., 19.12. 23.01. 13.02. Plase contact Heike Neu for an appointment.

js

September 25, 2014

Additional date for an oral exam
If you want to take your oral exam on October, 27, register here.
js

August, 18, 2014

Oral exams

The oral exams take place in Prof. Deßloch's office (36-329).

js

July, 10, 2014

Online-Exam-Registration closed

If you did not receive a confirmation mail for your oral exam or if you want to register, cancel or move your exam, please write me an email or come to my office.

js

July, 04, 2014

Got your date for an oral exam?

E-Mails were sent to every student who has sucessfully registered for the oral exam. If you didn't receive a mail, or if you didn't register yet, there will be an consultation-hour on Thu,10.07. 17:00 - 18:00 in room 36-340 36-336. There you can ask questions and cancel, move, register or re-register your exam.

js

June 05, 2014

Oral exams

The oral-exam registration opens on Tuesday, 01.07.2014 at 8:00 am. THIS LINK will be redirected to a Doodle poll where you can write your e-mail address and choose one exam slot of the following dates:

- 25., 27. August

- 15., 17., 19. September

- 20., 21., 22. October

js

March 06, 2014

Course in KIS / KIS Office

You can find this lecture in KIS and KIS Office by using the search function with the German lecture title "Neuere Entwicklungen". The lecture will be held in English. You can do the oral exam in English or German.

js

March 06, 2014

Start of the course

The course lectures will start on Wednesday, April 23, 2014.

js

Contents

Recent Developments for Data Models:

Course Information

pdf

Chapter 0 - Overview:

pdf

Chapter 1 - UDTs 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 and Databases

pdf

Chapter 8 - XQuery

pdf

Chapter 9 - SQL/XML

pdf

Chapter 10 - Temporal Data Models

pdf

 

 

Exercises

Exercise 1

pdf

solution

test data

Exercise 2

pdf

solution

Exercise 3

pdf

solution

Exercise 4

pdf

solution

test data

Exercise 5

pdf

solution

test data

Exercise 6

pdf

solution

 

Organizational matters

Course hours
Wednesday, 08:15 - 09:45, 48-462
Beginning at April 23, 2014

Exercise hours
Tuesday (bi-weekly), 17:15 - 18:45, 11-243
Exercise plan: 06.05., 20.05., 10.06., 24.06., 08.07., 22.07.

 

Contact person

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

Johannes Schildgen, 36/340, 205-3281

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)
  • Krishna Kulkarni, Jan-Eike Michels: Temporal features in SQL:2011, SIGMOD Record 41(3):34-43 (2012)  (PDF)
  • Dušan Petković: Was lange währt, wird endlich gut: Temporale Daten im SQL-Standard, Datenbank-Spektrum, July 2013, Volume 13, Issue 2, pp 131-138 (PDF)

Papers (publicly available)