DBMS Systems and Services Administration

General

• Course Code: 1944
• Semester: 9th
• Course Type: Specialization (SP)
• Course Category: Optional (OP)
• Scientific Field: Data Management - Artifial Inteligence (DMAI)
• Lectures: 4 hours/week
• ECTS units: 6
• Teching and exams language: Greek, English
• The course is offered to Erasmus students
• Recommended prerequisite courses: (1401) Database Management Systems
• Coordinator: Sidiropoulos Antonis

Educational goals

The course fills a gap in the knowledge and skills of the typical new IT Engineer graduate in relation to the needs of the respective labor market. More specifically, the topic of the course focuses on the management of a modern DBMS environment and the services that it supports. Includes theoretical and practical training in technologies and practices that represent general knowledge and skills, independent of the DBMS software (commercial or free) used. Upon successful completion of the course, students are able to:

• Identifies, describes and explains the role and responsibilities of the DBMS Administrator in relation to the management of the system and the services it supports, as well as in the development of application development and management policies by the developers
• Implements in practice all the sub-processes of installation, parameterization and configuration of a DBMS, specifying and implementing the sub-instances of the environment
• Distinguishes and interprets the components of DBMS architecture and technology related to the management of the system cache and the records of the file with the history of the execution of the transactions (transaction log file)
• Understands the ARIES algorithm and explains the sub-process of restoring the DBMS to full operation after a failure
• It contrasts the various backup management strategies to restore the system content information to a specific past time point (recovery to point-in-time).
• Integrates management strategies for individual DBMS functions, incorporating them into the automation provided by the latest
• Evaluates system performance under specific operating conditions and calculates the impact of different data indexing strategies

General Skills

• Assist the decision-making process of managing critical business data
• Adaptation of collaborative application development processes to the capabilities provided by the modern relational data management system (DBMS)
• Acquisition of know-how in improving the performance and operational reliability of DBMS through its indexing, and / or data sharing/distribution
• Autonomous work
• Teamwork

Course Contents

• The role of the DBMS administrator
• The architecture and instances of the DBMS server
• Install/create a DBMS and configure its snapshots
• Management of DBMS users and resources
• The SQL standard in system management
• Metadata and views on the functional content of the DBMS
• Buffer: control, data, history (logging), transaction log file
• Manage transaction history records
• Continuous (online) action history rescue, data recovery in case of local (soft) failure
• System restore after generalized crash (hard crash). The ARIES algorithm
• Backup management, ROLLBACK and ROLL-FORWARD actions. Restore point-to-time DBMS information content
• Directory design, loading / exporting / data transfer policies, reorganization of DBMS information content
• Monitor and optimize DBMS performance
• The architecture of the distributed DBMS environment
• Data partitioning and distribution in the distributed DBMS

Teaching Methods - Evaluation

Teaching Method

• Face to face theoretical teaching
• Demonstration of practical issues and techniques
• Practical training in the laboratory

Use of ICT means

• Use of ICT in teaching
• Use of a virtual machine for practicing on the computer
• Availability of educational material via CMS on the internet
• Communication with students during office hours, and via the internet (Email, announcements in CMS)

Teaching Organization

Students evaluation

Language of instruction and assessment: Greek and English
Two tasks: one individual and one group.
Final written examination with the use of multiple-choice questions and with the solution of problems related to the curriculum/examiners of the course

Recommended Bibliography

Recommended Bibliography through "Eudoxus"

1. J. Hoffer, V. Ramesh, H. Topi, Βάσεις Δεδομένων - Σύγχρονη Διαχείριση, Α. Τζίόλα & Υιοί Α.Ε., Έκδοση 11η, 2017, ISBN: 978-960-418-502-3, Κωδ. Ευδόξου: 50656016
2. R. Ramakrishnan, J. Gehrke, "Συστήματα Διαχείρισης Βάσεων Δεδομένων", Εκδόσεις Α. Τζιόλα & Υιοί Α.Ε., 3η Έκδοση, 2012, ISBN: 978-960-418-411-8, Κωδ. Ευδόξου: 22694245

Complementary greek bibliography

1. J.D. Ullman, J. Widom, Βασικές Αρχές για τα Συστήματα Βάσεων Δεδομένων, Εκδόσεις 'Κλειδάριθμος', Αθήνα 2008
2. R. Elmasri, S.B. Navathe, "Θεμελιώδεις Αρχές Συστημάτων Βάσεων Δεδομένων", Εκδόσεις Δίαυλος Α.Ε., 7η Έκδοση, 2016

Complementary international bibliography

1. W. Lemahieu, S. Van Den Broucke, B. Baesens, Principles of Database Management: The Practical Guide to Storing, Managing, and Analyzing Big and Small Data, Cambridge University Press, 2018
2. T. Connolly, C. Begg, Database Systems: A Practical Approach to design, Implementation, and Management, 5th Edition, Addison Wesley, 2010
3. J.D. Ullman, J. Widom, A First Course in Database Systems, Prentice-Hall, 2007
4. M. Laiho, M. Kurki, DBTechNet Database Administration Labs, http://www.dbtechnet.org/labs/dba_lab/DBALabs.pdf
5. M. Laiho, F. Laux, and K. Silpiö, DBTechEXT Backup and Recovery Labs, http://www.dbtechnet.org/labs/ccr_lab/RCLabs.pdf
6. M. Laiho, F. Laux, and K. Silpiö, J. Rantanen, DBTech EXT Index Design and Performance Labs, http://www.dbtechnet.org/labs/idp_lab/IDPLabs.pdf