adbm.pdf - Advanced Database Models Dr-Ing Eike Schallehn...

Advanced Database Models
Dr.-Ing. Eike Schallehn
OvG Universität Magdeburg
Fakultät für Informatik
Institut für Technische und Betriebliche Informationssysteme
2018

Organization
Weekly lecture
I
Weekly exercises (3 alternative slots, currently)
I
Starting April 23rd
Exams
I
Written exams of 120 minutes at the end of lecture period
Schallehn (FIN/ITI) Advanced Database Models 2018 2 / 358

History of this Lecture
Previous titles
I
Object-oriented Database Systems
I
Object-relational Database Systems
Latest addition: semi-structured data models
Previously held and refined by
I
Gunter Saake
I
Can Türker
I
Ingo Schmitt
I
Kai-Uwe Sattler
Schallehn (FIN/ITI) Advanced Database Models 2018 3 / 358

Overview of the Lecture
Data and design models
I
Recapitulation: the relational model
I
NF
2
and eNF
2
I
Object-oriented models
I
Object-relational models
I
Models for semi-structured data (XML)
For these models we discuss
I
Theoretical foundations
I
Query Languages
I
Application
I
Standards and systems
Schallehn (FIN/ITI) Advanced Database Models 2018 4 / 358

English Literature /1
Stonebraker, M.; Moore, D.: Object-Relational DBMSs: The Next
Great Wave , Morgan Kaufmann Publishers, 1999
Date, C. J.; Darwen, H.: Foundation for Object / Relational
Databases: The Third Manifesto , Addison-Wesley, 1998
Melton, J.: Advanced SQL: 1999 - Understanding
Object-Relational and Other Advanced Features ,Morgan
Kaufmann, 2002
Schallehn (FIN/ITI) Advanced Database Models 2018 5 / 358

English Literature /2
Russel, C. et al.: The Object Data Standard: ODMG 3.0 , Morgan
Kaufmann, 2000
Chaudhri, A. B., Rashid, A.; Zicari, R.: XML Data Management:
Native XML and XML-Enabled Database
Systems ,Addison-Wesley, 2003
Elmasri, R.; Navathe, S.: Fundamentals of Database Systems ,
Addison Wesley, 2003
Schallehn (FIN/ITI) Advanced Database Models 2018 6 / 358

German Literature
Türker, C.; Saake, G.: Objektrelationale Datenbanken ,
dpunkt.verlag, Heidelberg 2006
Türker, C.: SQL:1999 & SQL:2003 , dpunkt.verlag, Heidelberg,
2003
Klettke, M.; Meyer, H.: XML und Datenbanken , dpunkt.verlag,
Heidelberg, 2003
Saake, G.; Türker, C.; Schmitt, I.: Objektdatenbanken , Int.
Thomson Publishing, 1997
Elmasri, R.; Navathe, S.: Grundlagen von Datenbanksystemen ,
Pearson Studium, 2002
Schallehn (FIN/ITI) Advanced Database Models 2018 7 / 358

Teil I
Introduction

Overview
Some Basic Terms
History of Database Models
Problems with RDBMS
Aspects of Advanced Data Models
Schallehn (FIN/ITI) Advanced Database Models 2018 9 / 358

Some Basic Terms
Data Model
Database Model
Database
Database System
Database Management System
Conceptual Model
Database Schema(s)
Schallehn (FIN/ITI) Advanced Database Models 2018 10 / 358

Data Model
A data model is a model that describes in an abstract way how data
is represented in an information system or a database management
system.
Generic term includes models of
I
Programming languages
I
Database systems
I
Conceptual design methods
Often (but not here) ambiguously used for schemata
Schallehn (FIN/ITI) Advanced Database Models 2018 11 / 358

Data Model /2
A data model
I
is a system of concepts and their interrelations
I
is the “‘language” used to describe data
I