htw saar Piktogramm
Back to Main Page Choose Module Version:
XML-Code

flag

Database Management

Module name (EN):
Name of module in study programme. It should be precise and clear.
Database Management
Degree programme:
Study Programme with validity of corresponding study regulations containing this module.
Applied Informatics, Bachelor, ASPO 01.10.2011
Module code: PIBWI45
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.
2V (2 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.
2
Semester: 5
Mandatory course: no
Language of instruction:
German
Assessment:


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

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
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).
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
Lecturer:
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 Dec 10 06:12:35 CET 2022, CKEY=dbadmin, BKEY=pi, CID=PIBWI45, LANGUAGE=en, DATE=10.12.2022]