Databases and Information Systems

This lecture introduces database systems as a core technology for an important class of information processing tasks.The major principles and components of relational, object-oriented and other database models are presented. Moreover, the virtues and limitations of these models for particular data modeling tasks are analyzed. Students will also gain an understanding of the major issues that arise in the implementation of a database system. In addition to an understanding of concepts of databases and information systems, students will also acquire practical skills in the use of modern database system.

• Programmiermethodik, Informatik für Ingenieure I+II
  

• Pflichtveranstaltung 5. Semester Informatik-Ingenieurwesen
• Wahlveranstaltung für Allgemeine Ingenieurwissenschaften, Elektrotechnik und Information and Communication Sciences

1. Overview and current trends in research and development
2. Information- and Database Systems
3. Basic Data Modeling Concepts
4. The Relational Data Model and SQL - 3
5. Object-Oriented Data Models and ODMG 2.0
6. Other Data Models (Network, Hierarchical, Object-Relational)
7. Comparison of Data Models
8. Database Architectures and Database Interfaces
9. Transactions and their Implementation

• F. Matthes, J.W. Schmidt. Datenbankmodelle und Datenbanksprachen, 1998. Buchvorabdruck als Postscript [3,8 MB]; gepacktes Postscript [890 KB]; PDF [1,2 MB].
• A. Kemper, A. Eickler, A.: Datenbanksysteme - Eine Einführung, Oldenbourg Verlag, München, Wien, 1997.. Elmasri, S. Navathe, S.: Fundamentals of Database Systems, Benjamin-Cummings, 1989.

• M. Stonebraker.: Object-Relational DBMSs - The Next Great Wave, Morgan Kaufman, 1996.
• J. Gray, A. Reuter: Transaction Processing - Concepts and Techniques, The Morgan Kaufmann Series in Data Management Systems, Morgan Kaufman, 1993.
• J. Melton, A.R. Simon: Understanding the New SQL: A Complete Guide. Morgan Kaufman, 1993.
• M. Stonebraker, J.M. Hellerstein.: Readings in Database Systems, Third Edition, Morgan Kaufman, 1998.
• R.G.G. Catell: The Object Database Standard: ODMG-93 (Version 2.0), Morgan Kaufman, 1997.
• R.G.G. Catell: Object Data Management, 2nd Edition, Addison-Wesley, 1994.
• C.J. Date: An Introduction to Database Systems, Addison-Wesley, 1990.
• P. O'Neil: Database Principles, Programming, Performance, Morgan Kaufman, 1994.
• D. Pietrzyk, D.M. Radic.: ODBC in der Praxis, IT-Verlag, Höhenkirchen, Deutschland, 1994.
• S.B. Zdonik, D. Maier: Readings in Object Oriented Database Management Systems},Morgan Kaufman, 1989.
• H. Balzert: Lehrbuch der Software-Technik, Band 1, Spektrum Akademischer Verlag, 1996.

As an optional service for the preparation for the exam, every week optional exercises are handed out to the students. Students may return their solutions within two weeks to receive a feedback from the lecturer on their solution.

All participants have to pass the written exam at the end of the semester. Date: 09-mar-1999, Time: 10:00 - 13:00, Room: ES40-0007