456-0555/01 – Administration of Database System (SD)

Gurantor departmentDepartment of Computer ScienceCredits4
Subject guarantordoc. Ing. Radim Bača, Ph.D.Subject version guarantordoc. Ing. Radim Bača, Ph.D.
Study levelundergraduate or graduateRequirementOptional
Year3Semestersummer
Study languageCzech
Year of introduction2009/2010Year of cancellation2009/2010
Intended for the facultiesFEIIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
BAC027 doc. Ing. Radim Bača, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 2+2
Part-time Graded credit 8+0

Subject aims expressed by acquired skills and competences

The student who pass this course will be able to work with the three most widespread database systems (DB2, Oracle, MS SQL Server) and efectively utilize their features. The database system start, configuration and common administration is explained and tried practicaly on an accessible hardware. Students will be able to tune the performance of databases running on a database system and detect possible problems. - DB2, Oracle, MS SQL Server intorduction. - Database enviroment, Load balancing. - Initialization and configuration of one instance of an database system. - Database tuning. - Physical database design. - Special database types. OLAP, data warehouse. - Tools for an automatic database design.

Teaching methods

Lectures
Tutorials

Summary

The main topic of this course is the administration of the most widespread database system (DB2, Oracle, MS SQL Server). The course is focused on general aspects of these products and also on their specified features. The first part will focus on a database startup and settings. The second part will focus on a database tuning.

Compulsory literature:

M. Krátký, R. Bača: Databázové systémy. http://db.cs.vsb.cz/edu/dbsys.pdf. leden, 2009. Dokumentace k SŘBD Oracle, SQL Server a DB2. Oracle database administration's guide, http://download.oracle.com/docs/cd/E11882_01/server.112/e10595.pdf

Recommended literature:

D.K.Burleson. Physical database design using Oracle, Auerbach, ISBN 0-8493-1817-3 S.Lightstone, T.Teorey, T.Nadeau. Physical database design, Morgan Kaufmann, ISBN-10: 0-12-369389-6

Way of continuous check of knowledge in the course of semester

Students will have to solve problems during the exercises and show the understanding of the DBMS administration. The problems will be available before the exercise.

E-learning

Other requirements

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Syllabus of lectures DB2, Oracle, MS SQL Server intorduction. Database enviroment, Load balancing. Initialization and configuration of one instance of an database system. Database tuning. Physical database design. Special database types. OLAP, data warehouse. Tools for an automatic database design. Syllabus of computer exercises: Introduction to the DB2, Oracle and MS SQL Server. Database system start-up. Database system administration. Problem detection in a DBMS. DBMS tunning. Tools for an automatic database design.

Conditions for subject completion

Part-time form (validity from: 2009/2010 Summer semester, validity until: 2010/2011 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)		Min. number of pointsMax. počet pokusů
Graded exercises evaluation Graded credit 100 (100) 51 3
        DBMS instalation and settings Laboratory work 30  10
        Oracle database tunning Laboratory work 35  15
        SQL server database tunning Laboratory work 35  15
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2009/2010 (B2647) Information and Communication Technology (1103R031) Computational Mathematics P Czech Ostrava 3 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology P Czech Ostrava 3 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 3 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2612R059) Mobile Technology P Czech Ostrava 3 Optional study plan
2009/2010 (B2647) Information and Communication Technology (1103R031) Computational Mathematics K Czech Ostrava 3 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2601R013) Telecommunication Technology K Czech Ostrava 3 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 3 Optional study plan
2009/2010 (B2647) Information and Communication Technology (2612R059) Mobile Technology K Czech Ostrava 3 Optional study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2009/2010 Summer