Study programmes / C-SE System engineering and informatics / Database Systems II
Course code:DBS2
Course title in language of instruction:Databázové systémy II
Course title in Czech:Databázové systémy II
Course title in English:Database Systems II
Mode of completion and number of credits:Exam (6 credits)
(1 ECTS credit = 28 hours of workload)
Mode of delivery/Timetabled classes:full-time, 2/3
(full-time, hours of lectures per week / hours of seminars per week)
Language of instruction:Czech
Level of course:master continuing
Semester:WS 2018/2019 - FBE
Name of lecturer:Ing. Jan Přichystal, Ph.D. (supervisor)
Prerequisites:Final Bachelor Exam
 
Aims of the course:The goal of this course is to provide students with advanced database methods and technology, particularly hierarchical databases, object databases, especially on Oracle based database system. Course also includes themes related with large data warehouses.
Course contents:
1.Hierarchical databases (allowance 6/6)
 
a.The theoretical model, XML representation, query languages (XQL, XPath)
b.Used in combination with relational databases

2.Object databases (allowance 4/6)
 
a.The concept of the object, implementation of OO principles in a purely object-oriented database
b.The representation of OO principles in a relational database

3.Advanced techniques in RDBMS Oracle (allowance 10/8)
 
a.Oracle working model, optimization and recommendations
b.Installing and running Oracle, storage management, backup and archiving
c.High availability database, redundancy and clustering technologies

4.Data Warehousing (allowance 8/10)
 
a.Data warehouse, Data mining, Large Data storage
b.Data mining in data warehouse, Full text, OLAP technology

5.Preparation and presentation of working project (allowance 0/12)
 
a.Application of knowledge gained in the practical implementation

Learning outcomes and competences:
Generic competences:
 
-ability to apply knowledge
-ability to communicate with professionals in different field of study
-ability to create new ideas (creativity)
-science and research skills
-skilled at utilizing and processing information

Specific competences:
 
-Student is able desgin and implement ETL process used for the data loding into a Datawarehouse.
-Student is able to define and explain data analysis results applied on the reporting level.
-Student is able to desgin a Datawarehouse model.
-Student is able to implement intermediate BI project on a random data set together with interpretations of achieved results.
-Student is capable to explicate executions principles of database queries on a database system together with their optimisation strategies.
-Student is capable to understand the applicability of data warehouse model and use case on a real-world example and to optimize Datawarehouse model.

Type of course unit:optional
Year of study:Not applicable - the subject could be chosen at anytime during the course of the programme.
Work placement:There is no compulsory work placement in the course unit.
Recommended study modules:none
Assessment methods:Condition of credit is implementation the project and oral examination of the principles presented on lectures and seminars in this course.
 
Learning activities and study load (hours of study load)
Type of teaching methodDaily attendance
Direct teaching
     lecture28 h
     practice42 h
Self-study
     preparation for exam38 h
     preparation for regular assessment20 h
     elaboration and execution of projects40 h
Total168 h

Basic reading list
  • BERRY, M J A. -- LINOFF, G. Data mining techniques: for marketing, sales, and customer relationship management. 2nd ed. Indianapolis, Ind.: Wiley Pub., 643 p. ISBN 0-471-47064-3.
  • KIMBALL, R. -- ROSS, M. The data warehouse toolkit : the complete guide to dimensional modeling. 2nd ed. New York: Wiley, 2002. 436 p. ISBN 978-0-471-20024-6.
Recommended reading list
  • Data mining: concepts and techniques. 2nd ed. Amsterdam ;: Elsevier ;, 770 p. ISBN 1-55860-901-6.
  • Col. The data warehouse lifecycle toolkit. 2nd ed. Indianapolis, IN: Wiley Pub., 636 p. Kimball Group. ISBN 978-0-470-14977-5.
  • KIMBALL, R. -- CASERTA, J. The data warehouse ETL toolkit : practical techniques for extracting, cleaning, conforming, and delivering data. Indianapolis, IN: Wiley, 2004. 491 p. ISBN 978-0-7645-6757-5.
  • LACKO, Ľ. Databáze: datové sklady, OLAP a dolování dat s příklady v Microsoft SQL Serveru a Oracle. 1st ed. Brno: Computer Press, 2003. 486 p. ISBN 80-7226-969-0.
  • The Microsoft data warehouse toolkit: with SQL server 2008 R2 and the Microsoft Business intelligence toolset. 2nd ed. Indianapolis, IN: Wiley Pub., 648 p. Kimball Group. ISBN 978-0-47064038-8.