Introduction to Database Systems

Introduction to Database Systems
(Einführung in Datenbanken)
summer term 2007

Contact Hours

Prof. Dr. Matthias Jarke jarke@informatik.rwth-aachen.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. Dominik Lübbers luebbers@informatik.rwth-aachen.de Tel.: 0241/80-21512 Room: 6235 Office Hours: when the door is open...

News

The second exam has been corrected. See the results below.

Dates

Lecture

	Tuesday, 08.15-09.45, AH V (start: April 10)
	Thursday, 11:30-13:00, AH V

Tutorial

Monday, 11.45-13.15, AH VI (start: April 23)

Exam

Wednesday, July 18, 2007, 14.00, Aula 2

General Information

	Announcement in CAMPUS
	Structure and organization of lecture and tutorial sessions

Lecture

Course material (use the password announced in the lecture to access the files)

Chapter 1 (Introduction)

Chapter 2 (Conceptual Modelling)

Chapter 3 (Relational Databases)

Oracle Introduction

	Slides
	Travel scenario
	Queries and Commands

Chapter 4 (Object-Oriented Database Model)

Chapter 5 (Semistructured Data Models and XML)

Tutorials

Tutorial Session "0"

Assignment 1

Assignment 2

Solution sketches for task 2.1 and task 2.2

Assignment 3

Short summary of alternatives for mapping IS-A relationships to the rel. DB model

Assignment 4

Assignment 5

	Solution sketch to task 5.1b)
	Solution sketch to SQL part of 5.2
	Solution sketch to part 5.2.d)

Assignment 6

Solution sketch to task 6.1b)

Assignment 7

Assignment 8

Assignment 9

Solution sketch to task 9.4a)

Assignment 10

	Solution sketch to task 10.1a)
	Solution sketch to task 10.3a) and 10.3b)

Assignment 11

This assignment is only intended for students who want to receive 8 ETCS points for the course, for the other students the 10th assignment is the last one.

Criteria for getting 8 ETCS points

	50% of points in assignments 1-10
	active participation
	50% of points in assignment 11
	50% of points in exam

Resources:

	Lectures1.xml
	Lectures2.xml
	Lectures.xsd
	ShopData.xml

Exam

The exam will take place on July 18. During the next week we will provide a simple web interface to register for the exam.

Last year's exam sheets

	first exam
	second exam

Results

	Students' results
	Overview

Second Exam

	Results
	You can take a look at our correction on Tuesday, October 23, at the office of Dominik Lübbers (room 6235).

Links

Relational Data Model

SQL-introduction (Uni Gießen):

	Lexical Syntax, Tuple Variables, Conditions, Null Values
	Aggregation, Subqueries, UNION, Outer Joins
	Data Types, CREATE TABLE, Updates

MySQL (free SQL database system, frequently used for small (web-) applications, does only support a limited set of SQL statements)

PostgreSQL (free SQL database system, very close to the SQL standard)

Oracle Technology Network

Object-Oriented Data Model

	ODMG
	Enterprise Java Beans
	Java Data Objects
	Object-Relational Features of Oracle (Material of a course at Stanford Univ.)
	LINQ Project of Microsoft (Webcast shown in lecture)
	UML Reference Card (by Allen I. Holub, short overview of the concepts of the UML structure diagram)

XML

General

XML page of W3C (information about the XML standard)

XML Tutorial (by Anders Møller & Michael I. Schwartzbach)

Managing XML and Semistructured Data (course by Dan Suciu)

Java Web Services Tutorial, look at chapter 9!

Altova XMLSpy (look for the freely available Home Edition)

XQuery

XML Query (information about the XML Query standard)

XML Query Use Cases

eXist, an open-source XML DBMS with an frontend to execute XQueries online.

XSLT

XSLT at W3C

XML Bible, chapter on XSL-T

Altova XMLSpy

ConceptBase's home page (Metadata Manager developed by Informatik 5)

Databases & Logic Programming bibliography server

ACM SIGMOD (Special Interest Group Management of Data): Links to many online resources related to research in databases

Updated: 29.01.08
www

Disclaimer

document.write(document.title);