Introduction to Databases

Compact Course, V12, Ü6 

Fraunhofer Institut FIT, Bonn,
Raum 318 2.3.-26. 3. 2004 

Prof. Dr. Matthias Jarke
jarke@informatik.rwth-aachen.de

Dr. Thomas Rose
thomas.rose@fit.fraunhofer.de

Dr. Lemonia Ragia
ragia@informatik.rwth-aachen.de
Tel.: 0241/80-215116

Dipl.-Math. Thomas List
list@informatik.rwth-aachen.de
Tel.: 0241/80-21510

Dates

	Lecture Wednesdays, Thursdays and Fridays from 9.00 to 12.30 including a break from 10.30 to 11.00
	Exercise Class Wednesdays, Thursdays and Fridays, from 14.00 to 15.30

Results of the Exam

For any questions about the examn please contact Lemonia Ragia.

Exercises

	Solutions for exercise 6
	Some solutions for exercise 9
	Some solutions for the XML exercise

Links

	some more detailed information about B- and B*-trees (in german, Universität Kaiserslautern) Slides1, Slides2, Slides3
	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
	TogetherSoft (provides an UML modelling tool used in the lecture, evaluation version available)
	XML XML page of W3C (information about the XML standard) XML Query (information about the XML Query standard) XML Query Use Cases X-Hive/DB query demo XQuery Demo (provided by Microsoft, read also the Announcement on DBWorld) XML Tutorial (by Anders Møller & Michael I. Schwartzbach) Managing XML and Semistructured Data (course by Dan Suciu) XML Bible, chapter on XSL-T Java Web Services Tutorial, look at chapter 9! The Saxon XQuery Processor The simple Saxon editor used in the exercises (jar-file, 1.13MB) Altova XMLSpy (look for the free 30 day evaluation version)
	UML Reference Card (by Allen I. Holub, short overview of the concepts of the UML structure diagram)
	ConceptBase's home page (Metadata Manager developed Informatik V)
	Databases & Logic Programming bibliography server
	ACM SIGMOD (Special Interest Group Management of Data): Links to many online resources related to research in databases
	GOM: A Strongly Typed Persistent Object Model With Polymorphism (1991) A. Kemper, G. Moerkotte, H-D Walter, A. Zachmann Datenbanksysteme in Buro, Technik und Wissenschaft