i5 Logo - Home

RWTH Aachen University 
Homepage o Projects o Teaching o Staff o Publications o Service o o
o


Introduction to Database Systems 
(Einführung in Datenbanken)
winter term 2004/2005

Contact Hours

Prof. Dr. Matthias Jarke
jarke@informatik.rwth-aachen.de
Office Hours: by appointment after the lecture
Prof. Dr. Thomas Rose
thomas.rose@fit.fraunhofer.de
Office Hours: by appointment after the lecture
Dr. Christoph Quix
quix@cs.rwth-aachen.de
Tel: 0241/80-21510
Office hours: every Monday 13.00 - 14.00
Dipl.-Inform. Carla Valle
carla.valle@fit.fraunhofer.de
Tel: 02241/14-2416
Office Hours: 10:30 - 12:00, room 4, B-IT building
Dipl.-Inform. Dominik Lübbers
luebbers@informatik.rwth-aachen.de
Tel.: 0241/80-21512
Room: 6235
Office Hours: when the door is open...
Dipl.-Ing. Michail Miatidis
miatidis@informatik.rwth-aachen.de
Tel.: 0241/80-21516
Room: 6239
Office Hours: every Monday 11.30 - 13.00

News

bulletThe results of the second exam are available.
You can take a look at our correction on Friday, April 8, 2005 from 10.00-11.00.
bulletThe final results of the written examination are now available
bulletThe last year's exam is available for download
bulletInformation about the Accenture Campus Challenge

Dates

bulletLecture
bulletTuesday, 08.15-09.45, AH VI
bulletThursday, 12:30-14:00, AH VI
bulletTutorial
bulletRWTH Aachen: Monday, 10.00-11.30, AH I
B-IT: Thursday
bulletPreliminary Schedules
bulletRWTH Aachen
bulletB-IT
bulletWritten Examination: February 16, 2005, 9.30 am

 General Information

bulletCourse and Tutorial announcement in CAMPUS
bulletOrganization of lecture and tutorials, literature (slides from the first lecture)

Lecture

bulletMaterial from the brief introduction to Oracle Database Management System:
bulletSlides
bulletSQL-Scripts: Table creation, data insertion, queries, trigger definition, views and indexes

Tutorials

bulletIntroduction to B- and B*-Trees
bulletAssignment 1
bulletSolution sketch to Exercise 1.3
bulletAssignment 2
bulletAssignment 3
bulletisA mapping options
bulletAssignment 4
bulletAssignment 5
bulletThe first Oracle SQL command hint is slightly wrong: The correct semantic of the given command is:
SELECT TABLE_NAME FROM USER_TABLES lists the names of all tables that are in the user's schema.
bulletThe data dictionary view that contains information about the tables that are accessible to the user, is named ALL_TABLES.
bulletAssignment 6
bulletAssignment 7
bulletAssignment 8
bulletSome words on Oracle's implementation of object relational features
bulletSolution sketch to Assignment 8
bulletAssignment 9 (including two Christmas tasks with extra points!)
bulletSolution sketch to Assignment 9
bulletAssignment 10
bulletSolution sketch to Assignment 10
bulletAssignment 11 (please notice that we moved the hand in date for the RWTH students to January 27 after the lecture)
bulletXML document for task 11.3
bulletSolution of 11.1a)
bulletSolution of 11.1b)

Exam

bulletFinal results of this year's exam:
bulletStudents' results
bulletOverview and point distribution
bulletFor those who did not have to register at the ZPA: 
The certificates are available at our chair's office.
bulletSecond exam:
bulletStudents' results
bulletYou can take a look at our corrections on Friday, April 8, 2005 from 10.00-11.00.
bulletThe last year's exam can be downloaded for preparation.
This year's exam will be comparable to this.
Some more information will be given in the tutorial session on January 31.
English version, German version

Links

bulletSQL-introduction (Uni Gießen): 
bulletLexical Syntax, Tuple Variables, Conditions, Null Values
bulletAggregation, Subqueries, UNION, Outer Joins
bulletData Types, CREATE TABLE, Updates
bulletMySQL (free SQL database system, frequently used for small (web-) applications, does only support a limited set of SQL statements)
bulletPostgreSQL (free SQL database system, very close to the SQL standard)
bulletOracle Technology Network
bulletGOM: A Strongly Typed Persistent Object Model With Polymorphism (1991) A. Kemper, G. Moerkotte, H-D Walter, A. Zachmann
Datenbanksysteme in Buro, Technik und Wissenschaft
bulletUML Reference Card (by Allen I. Holub, short overview of the concepts of the UML structure diagram)
bulletRDF home page at W3C
bulletXML

General
bulletXML page of W3C (information about the XML standard)
bulletXML Tutorial (by Anders Møller & Michael I. Schwartzbach)
bulletManaging XML and Semistructured Data (course by Dan Suciu)
bulletJava Web Services Tutorial, look at chapter 9!
bulletAltova XMLSpy (look for the freely available Home Edition)

XQuery
bulletXML Query (information about the XML Query standard)
bulletXML Query Use Cases
bulletQizx/open: an open-source Java implementation of the latest XML Query specifications
bulletX-Hive/DB query demo (alternative demo to run XQuery queries)
bulletThe Saxon XQuery Processor

XSLT
bulletXSLT at W3C
bulletXML Bible, chapter on XSL-T
bulletAltova XMLSpy (look for the freely available Home Edition)

bullet ConceptBase's home page (Metadata Manager developed Informatik V)
bullet Databases & Logic Programming bibliography server
bulletACM SIGMOD (Special Interest Group Management of Data): Links to many online resources related to research in databases

 

 
Updated: 29.01.08
www
Disclaimer       Webmaster  |  i5 Home  |  Projects  |  Teaching  |  Staff  | Publications | Service
 BSCW Server | Lehr- und Forschungsgebiet Informatik 5  |  Fachgruppe Informatik  |  RWTH Aachen