htw saar Piktogramm
Back to Main Page

Choose Module Version:


Database Management

Module name (EN): Database Management
Degree programme: Applied Informatics, Bachelor, ASPO 01.10.2011
Module code: PIBWI45
Hours per semester week / Teaching method: 2V (2 hours per week)
ECTS credits: 2
Semester: 5
Mandatory course: no
Language of instruction:

[updated 08.05.2008]
Applicability / Curricular relevance:
KI642 Computer Science and Communication Systems, Bachelor, ASPO 01.10.2014, semester 6, optional course, course inactive since 30.09.2009
PIBWI45 Applied Informatics, Bachelor, ASPO 01.10.2011, semester 5, optional course, course inactive since 30.09.2009
30 class hours (= 22.5 clock hours) over a 15-week period.
The total student study time is 60 hours (equivalent to 2 ECTS credits).
There are therefore 37.5 hours available for class preparation and follow-up work and exam preparation.
Recommended prerequisites (modules):
PIB325 Computer Architecture
PIB330 Databases
PIB420 Computer Networks

[updated 01.04.2006]
Recommended as prerequisite for:
Module coordinator:
Dipl.-Ing. Achim Pick
Dipl.-Ing. Achim Pick

[updated 01.10.2005]
Learning outcomes:
This module will introduce students to the relational database system Oracle and to the broad range of activities performed by a database administrator. Students will become acquainted with internal memory and process architectures. The course also covers the theoretical foundations of instance management, memory management and user management, and backup and recovery procedures. Students will have the opportunity to implement these database management techniques using a student-created database.

[updated 08.05.2008]
Module content:
-        The function of a database administrator
-        Architecture
-        Operating modes
-        Memory structures
-        Instances
-        User management
-        Backup and recovery
-        Network database mode

[updated 08.05.2008]
Recommended or required reading:
ORACLE ADMINISTRATORS GUIDE, Oracle Corporation, December 2003
ORACLE CONCEPTS, Oracle Corporation, December 2003
Loney, Kevin:  ORACLE 10G DBA HANDBOOK, Oracle Press, 2005

[updated 08.05.2008]
[Sat May 21 01:24:50 CEST 2022, CKEY=dbadmin, BKEY=pi, CID=PIBWI45, LANGUAGE=en, DATE=21.05.2022]