Data warehouses Field of study: Computer Science
Programme code: 08-S2INIA15.2019

Module name: Data warehouses
Module code: 08-IN-ISI-S2-HD
Programme code: 08-S2INIA15.2019
Semester: summer semester 2020/2021
Language of instruction: English
Form of verification: course work
ECTS credits: 2
Description:
The goal of the module is to teach the student to design and implement a data warehouse that holds different types of data. The challenge is to create systems that use different platforms and programming standards. Emphasis will be placed on the use of tools according to the type of data - structural, semistructural and nonstructural. Student will prototype the application.
Prerequisites:
(no information given)
Key reading:
(no information given)
Learning outcome of the module Codes of the learning outcomes of the programme to which the learning outcome of the module is related [level of competence: scale 1-5]
Can work over a problem solution individually and in a team. Can present results of his work. [HD _K5]
 K_U02 [1/5] K_K01 [1/5]
Can develop and implement an IT system (data warehouse) using technology according to type and volume of data necessary to store in the base. [HD _U4]
 K_U12 [2/5] K_U13 [2/5] K_U14 [2/5] K_U19 [1/5]
Has knowledge in the field of data warehouses architecture, advanced SQL commands used in data warehouses implementation. [HD _W1]
 K_W06 [1/5] K_W09 [2/5] K_W10 [2/5] K_W14 [1/5]
Has knowledge in the field of chips modelling and semi-structural data according to XML language. [HD _W2]
 K_W06 [1/5] K_W09 [1/5] K_W10 [1/5] K_W14 [1/5]
Has knowledge of development and implementation of other than relational data models (NoSQL) ensuring gathering unstructured data. [HD _W3]
 K_W06 [1/5] K_W09 [1/5] K_W10 [1/5] K_W14 [1/5]
Type Description Codes of the learning outcomes of the module to which assessment is related
Reports (documentation of the performed tasks) [HD _w_1]
Students will be required to complete documentation including a description of the exercises they are doing in the lab. Programming tasks in SQL, PL / SQL, Java (other languages are also possible).
 HD _K5 HD _U4 HD _W1 HD _W2 HD _W3
Discussion [HD _w_2]
In order to select and work out the best solutions accepted by the group in the classes will be conducted discussions in the form of so. brainstorming during which the facilitator will have the opportunity to observe and evaluate the knowledge and involvement of students.
 HD _K5 HD _U4 HD _W1 HD _W2 HD _W3
Form of teaching Student's own work Assessment of the learning outcomes
Type Description (including teaching methods) Number of hours Description Number of hours
lecture [HD _fs_1]
Presenting module content in verbal form, discussing modelling principles, presentation of typical problems and solutions, discussing possible solution variant. Explaining the most important trends and solutions suggested all over the world.
 10
Deepening of the verbally presented content with analysis of additional materials available on module website and other indicated portals.
 10 Reports (documentation of the performed tasks) [HD _w_1] Discussion [HD _w_2]
laboratory classes [HD _fs_2]
Systematic development of skills and competences in the field of modleing under supervision and with support of the teachers basing on the knowledge acquired. Discussing the executed projects.
 20
Realization of projects developing skills and competences in the field of programming and teamwork. Participation in the group, discussion on the module forum.
20 Reports (documentation of the performed tasks) [HD _w_1] Discussion [HD _w_2]
Attachments
Module description (PDF)
Information concerning module syllabuses might be changed during studies.
Syllabuses (USOSweb)
Semester Module Language of instruction
(no information given)