htw saar
Back to Main Page

Choose Module Version:

flag

Databases and Information Systems

Module name (EN): Databases and Information Systems
Degree programme: Applied Informatics, Master, ASPO 01.10.2011
Module code: PIM-DBI
Hours per semester week / Teaching method: 3V+1U (4 hours per week)
ECTS credits: 6
Semester: 1
Mandatory course: yes
Language of instruction:
German
Assessment:
Written examination; attendance at problem-solving classes
Curricular relevance:
PIM-DBI Applied Informatics, Master, ASPO 01.10.2011, semester 1, mandatory course
Workload:
60 class hours (= 45 clock hours) over a 15-week period.
The total student study time is 180 hours (equivalent to 6 ECTS credits).
There are therefore 135 hours available for class preparation and follow-up work and exam preparation.
Recommended prerequisites (modules):
None.
Recommended as prerequisite for:
Module coordinator:
Prof. Dr. Klaus Berberich
Lecturer:
Prof. Dr. Klaus Huckert
Dipl.-Math. Wolfgang Braun (exercise)


[updated 23.06.2010]
Learning outcomes:
This course of lectures aims to provide students with a deeper understanding of the methods and techniques used in the design, implementation and application of complex databases.
 
The deployment of databases in larger information systems is explained and possible extensions are discussed.


[updated 08.05.2008]
Module content:
1. Architectural models of database systems
  a. Physical architecture design
  b. Server architectures for database systems
  c. Transactions
  d. Error handling in database systems
  e. Distributed database systems
  f. Homogeneous distribution
  g. Heterogeneous distribution
  h. Parallel database systems
 
2. Database design and quality assurance
  a. Initial considerations when designing a quality compliant database
  b. The database life cycle
  c. Design phases
  d. Data modelling concepts
  e. Conceptual and logical design
  f. Implementation design
  g. Physical design
  h. Mapping object-oriented design in relational databases
  i. Reverse engineering
 
3. Data integration and analysis in creating information systems
  a. Data integration
  b. Data warehouses
  c. Principles of online analytical processing
  d. Data mining
 
4. Database applications in information systems
  a. Databases in the world wide web
  b. Multimedia databases
  c. Mobile databases
  d. XML and databases


[updated 08.05.2008]
Recommended or required reading:
LAUSEN, Georg: Datenbanken. Grundlagen und XML. Elsevier, 2005
DATE, Chris: Introduction to database systems, Addison Wesley 8th Ed. 2003
ELMASRI, Ramez; NAVATHE, Shamkant: Grundlagen von Datenbanksystemen, Addison Wesley 3. Auflage 2005
JAROSCH, Helmut: Datenbankentwurf. Vieweg 2002
VOSSEN, Gottfried: Datenmodelle, Datenbanksprachen und Datenbankmanagementsysteme. Oldenbourg 2000
 
Additional print and web-based references will be provi


[updated 08.05.2008]
Module offered in:
WS 2016/17, WS 2015/16, WS 2014/15, WS 2013/14, WS 2012/13, ...
[Sun May 31 06:42:08 CEST 2020, CKEY=pdui, BKEY=pim, CID=PIM-DBI, LANGUAGE=en, DATE=31.05.2020]