i5 Logo - Home

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


Up
Introduction to Database Systems
Advanced Data Models
Accenture Campus Challenge 2008
Gaming Communities
Software-Entwicklung mit .NET
SAP HR Praktikum
Working Group MCIS
Working Group Model Management
Diploma/Master Theses

Advanced Data Models

Teaching staff

Dr. Christoph Quix
quix@cs.rwth-aachen.de
Tel: 0241/80-21511
Office hours: Appointment needed

Prof. Dr. M. Jarke
jarke@cs.rwth-aachen.de
Tel: 0241/80-21501
Office hours: Appointment needed

M.Sc. Xiang Li
lixiang@cs.rwth-aachen.de
Tel: 0241/80-21512

News

bulletThe preliminary results of the exam are now available. You can see the corrected version of the exam on Wednesday, July 30, 2008, from 10am to 11am in the seminar room of Informatik 5.

Schedule

Lecture: Wednesday, 15.15 - 16.45, AH VI (starting: April 9, 2008)

Tutorials: Tuesday, 10.00 - 11.30, 5055 (bi-weekly, starting: April 22, 2008)

Contents

This lecture presents advanced concepts in data modeling. In particular, we will discuss formal methods for the representation and management of data models.

In addition, methods for data integration, which are based on these formalizations, will be discussed. The tutorials will present practical examples for the presented concepts.

The lecture follows up on the topics of the lecture "Introduction to Databases" in which basic methods for data models (e.g. relational model, entity-relationship model, UML, XML Schema) have been discussed. Knowledge about these topics is therefore a prerequisite for this course. Furthermore, knowledge about logic and knowledge representation is helpful.

bulletSemi structured data models (e.g. XML)
bulletObject oriented data models (e.g. UML) and object relational models
bulletSemantic data models and ontologies (e.g. OWL)
bulletMappings between data models
bulletData integration
bulletModel Management
bulletSchema Evolution

Course Material

bulletCh. 0: Organization and Contents
bulletCh. 1: Introduction
bulletCh. 2: Repitition and Comparison
bulletCh. 3: XML Schema
bulletCh. 4: Object-Relational Models and Mappings
bulletCh. 5: OWL & Ontologies
bulletCh. 6: Multidimensional Data Model
bulletCh. 7: Data Integration (Introduction)
bulletCh. 8: Mappings & Data Exchange
bulletCh. 9: Schema Matching
bulletCh. 10: Schema Integration
bulletCh. 11: Quality of Data Models and Generic Metamodels
bulletCh. 12: Model Management, Dataspaces and Summary

Exercises

Nr.TopicsDueMisc.
1Data models and data modeling22. AprilEx1 Slides, One Possible XML Schema,
2XML Schema, XQuery, and OWL 14. MayEx2 Slides, Lectures.xsd, Lectures1.xml, Lectures2.xml
3Multidimensional data model 28. May Ex3 Slides
4Data Integration and Answering Queries Using Views 11. JuneTableau Containment ,Ex4 Slides
5Maximally Contained Rewriting and Data Exchange 25. June Ex5 Slides
6Similarity Flooding and Schema Merging 9. JulySimilarity Flooding Ex6 Slides, propagation.py

Resources

bulletData Models
bullet What goes around comes around by Stonebraker and Hellerstein in Readings in Database Systems, MIT Press, 2005.
bulletOf Objects and Databases: A Decade of Turmoil by Carey and DeWitt in VLDB'96.

bulletXML
bulletData on the web by Abiteboul, Buneman, and Suciu
bulletAltova XML Spy and Stylus Studio are two popular editors
bulletTutorial at W3Schools
bulletAn XQuery Introduction
bulletW3C XML Primer
bullet Essential XML, a freely available book covering Schema, DTD, XPath, and etc.
bullet XML Schema, a free chapter from a book.
bulletXQuery: A Guided Tour, an exerpt from XQuery From the Experts
bullet XML: Model, Schemas, Types, Logics, and Queries by Klarlund et al. In "Logics for Emerging Applications of Databases", 2003, Springer.
bulletOWL
bulletThe Semantic Web by Tim Berners-Lee et al.
bulletRDF Primer by Manola, F., Miller, E. (eds.)
bulletTutorial on OWL
bulletProtege, an academic ontology project at Stanford.
bulletSPARQL, a W3C query language for RDF.
bulletRDF Validator
bulletData Warehousing
bulletAn overview of data warehousing and olap technology by Chaudhuri and Dayal in SIGMOD Record 26(1), 1997.
bulletData Cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-totals by Jim Gray et al. in J. Data Mining and Knowledge Discovery, 1(1), 1997.
bulletAggregate View Management in Data Warehouses by Yannis Kotidis in Handbook of Massive Data Set, Kluwer 2002.
bulletMaintenance of materialized views: Problems, techniques and applications by Gupta and Mumick in IEEE Bulletin on Data Engineering, 18(2), 1995.
bulletMaterialized Views: Techniques, Implementations, and Applications by Gupta and Mumick(ed.), the MIT Press, 1998.
bulletData Integration
bullet Data Integration: A Theoretical Perspective by M. Lenzerini in PODS'02. Slides
bullet Answering Queries Using Views: A Survey by A. Halevy in VLDB Journal 10(4), 2001.
bullet Information Integration Using Logical Views by Jeffrey D. Ullman in ICDT 1997: 19-40.
bullet Mediators in the Architecture of Future Information Systems by G. Wiederhold in IEEE Computer 25(3), 1992.
bulletData Exchange
bulletSchema mappings, data exchange, and metadata management by P. Kolaitis in PODS'05. Slides

Links

bulletWorking Group Model Management
bulletCourse Introduction to Database Systems

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