DATA MANAGEMENT
INBGA0423-17
Semester: 4
Type: Lecture / Laboratory
Number of Classes: 2+0+2
Credit: 6
Status: Obligatory
Assessment: Practical mark
Prerequisites: INBGA0318-17 (Database systems)
Responsible: Dr. Marianna Zichar, Bodroginé

Topics:
Becoming familiar with the structure of database management system
selected to study in the current semester. Metadata management (planning
and implementation of easy access to integrated metadata of high quality).
Data-centered activities in software development life cycle (SDLC): analysis
and planning of data requirement, maintaining the database, solution
components related to data). Database accessibility, levels of service.
Database administration, tasks of database administrators. The role of indexes,
indexing. Data quality management. Database monitoring, technologies of
backup, recovery, and tuning. Log management. Current industrial trends and
their impacts.


Weekly schedule:
1.,  Introduction into database management system.

2.,  Structure of database management system.

3.,  Metadata management (planning and implementation of easy access to integrated metadata of high quality). +++

4.,  Data-centered activities in software development life cycle (SDLC): analysis and planning of data requirement, maintaining the database, solution components related to data). +++

5.,  Database accessibility, levels of service.

6.,  Exam 1

7.,  Database administration, tasks of database administrators. +++

8.,  The role of indexes, indexing.

9.,  Data quality management. +++ 

10., Database technologies of monitoring, and tuning. 

11., Database technologies of backup, and recovery.

12., Log management. Current industrial trends and their impacts.

13., Exam 2

14., Retake Exam

Compulsory/Recommended Readings:
- Mullins: Database Administration, Addison-Wesley, 2013, ISBN 978-0201741292
- Keith Gordon: Principles of Data Management, BCS, The Chartered Institute for IT, 2013, ISBN 9781780171845


Requirements:
The aim of the course is to develop theoretical and practical skills on data management.

There will be four obligatory classroom tests during the education period:

- Two practical classroom test (to be solved using the classroom computers).

- Two theory classroom test (held on the penultimate lecture).

- Each classroom test has to be passed in order to successfully complete the course.

- Both the theory and the practical classroom tests can be re-taken once on the last week of the education period.

The final course mark is calculated as follows:

- theory classroom test: 25% - 25% weight
- practical classroom tests: 25% - 25% weights

Those students who got mark 1 (failed) during the education period will have the opportunity to take a written test during the first week of the exam period covering the topics of both the lectures and the practical course.

Exams/Tests
At the time and place announced on the lecture and the practical course.

Consultations
According to e-mail negotiation in the study period.