htw saar Piktogramm QR-encoded URL
Back to Main Page Choose Module Version:
emphasize objectives XML-Code

flag

Databases and Information Systems

Module name (EN):
Name of module in study programme. It should be precise and clear.
Databases and Information Systems
Degree programme:
Study Programme with validity of corresponding study regulations containing this module.
Applied Informatics, Master, ASPO 01.10.2011
Module code: PIM-DBI
SAP-Submodule-No.:
The exam administration creates a SAP-Submodule-No for every exam type in every module. The SAP-Submodule-No is equal for the same module in different study programs.
P221-0052
Hours per semester week / Teaching method:
The count of hours per week is a combination of lecture (V for German Vorlesung), exercise (U for Übung), practice (P) oder project (PA). For example a course of the form 2V+2U has 2 hours of lecture and 2 hours of exercise per week.
3V+1U (4 hours per week)
ECTS credits:
European Credit Transfer System. Points for successful completion of a course. Each ECTS point represents a workload of 30 hours.
6
Semester: 1
Mandatory course: yes
Language of instruction:
German
Assessment:
Written examination; attendance at problem-solving classes

[updated 08.05.2008]
Applicability / Curricular relevance:
All study programs (with year of the version of study regulations) containing the course.

PIM-DBI (P221-0052) Applied Informatics, Master, ASPO 01.10.2011 , semester 1, mandatory course
Workload:
Workload of student for successfully completing the course. Each ECTS credit represents 30 working hours. These are the combined effort of face-to-face time, post-processing the subject of the lecture, exercises and preparation for the exam.

The total workload is distributed on the semester (01.04.-30.09. during the summer term, 01.10.-31.03. during the winter term).
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, ... 
[Wed Apr 24 06:14:32 CEST 2024, CKEY=pdui, BKEY=pim, CID=PIM-DBI, LANGUAGE=en, DATE=24.04.2024]