<?xml version="1.0" encoding="ISO-8859-1" standalone="yes" ?>
<document>
<title>Database Management</title>
<cid>PIBWI45</cid>
<bkey>pi</bkey>
<ctypes>
<hours>2</hours>
<type>V</type>
</ctypes>
<cp>2</cp>
<semester>5</semester>
<mandatory>no</mandatory>
<language>German</language>
<exam>
</exam>
<curriculum>
<curriculum_entry>
<cid>KI642</cid>
<branch>Computer Science and Communication Systems</branch>
<semester>5</semester>
<mandatory_tag>optional course</mandatory_tag>
</curriculum_entry>
<curriculum_entry>
<cid>PIBWI45</cid>
<branch>Applied Informatics</branch>
<semester>5</semester>
<mandatory_tag>optional course</mandatory_tag>
</curriculum_entry>
</curriculum>
<workload>
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.</workload>
<prerequisites>
<prerequisite>
<pfcid>PIB325</pfcid>
<pftitle>Computer Architecture</pftitle>
</prerequisite>
<prerequisite>
<pfcid>PIB330</pfcid>
<pftitle>Databases</pftitle>
</prerequisite>
<prerequisite>
<pfcid>PIB420</pfcid>
<pftitle>Computer Networks</pftitle>
</prerequisite>
</prerequisites>
<knowledge>[?]</knowledge>
<prerequisitesfor>
</prerequisitesfor>
<convenor>Dipl.-Ing. Achim Pick</convenor>
<convenor-person-key>api</convenor-person-key>
<lecturers>
<lecturer>Dipl.-Ing. Achim Pick</lecturer>
<lecturer-person-key>api</lecturer-person-key>
</lecturers>
<objectives>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.</objectives>
<content>-	The function of a database administrator
-	Architecture
-	Operating modes
-	Memory structures
-	Instances
-	User management
-	Backup and recovery
-	Network database mode
</content>
<media>[?]</media>
<literature>ORACLE ADMINISTRATORS GUIDE, Oracle Corporation, December 2003
ORACLE CONCEPTS, Oracle Corporation, December 2003
Loney, Kevin:  ORACLE 10G DBA HANDBOOK, Oracle Press, 2005
</literature>
<offered>
</offered>
<moduldb-query>Mon Oct  5 14:10:09 CEST 2026, CKEY=dbadmin, BKEY=pi, CID=[?], LANGUAGE=en, DATE=05.10.2026</moduldb-query>
</document>
