Data Warehouses Field of study: Computer Science
Programme code: 08-S2INIA15.2016

Module name: Data Warehouses
Module code: 08-IN-S2-HD
Programme code: 08-S2INIA15.2016
Semester:
  • summer semester 2017/2018
  • winter semester 2017/2018
Language of instruction: English
Form of verification: course work
ECTS credits: 3
Description:
Aim of the module is teaching the student to develop and implement a data warehouse storing various types of data. A special challenge is developing systems using various platforms and programming standards. Emphasis will be put on using tools according to types of data – structured, semi-structured and unstructured. The student will develop an application prototype.
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_2_A_I_K01 [2/5] K_2_A_I_K03 [1/5] K_2_A_I_K06 [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_2_A_I_U13 [2/5] K_2_A_I_U14 [2/5] K_2_A_I_U15 [2/5] K_2_A_I_U20 [1/5]
Has knowledge in the field of data warehouses architecture, advanced SQL commands used in data warehouses implementation. [HD _W1]
 K_2_A_I_W06 [1/5] K_2_A_I_W09 [2/5] K_2_A_I_W10 [2/5] K_2_A_I_W14 [1/5]
Has knowledge in the field of chips modelling and semi-structural data according to XML language. [HD _W2]
 K_2_A_I_W06 [1/5] K_2_A_I_W09 [1/5] K_2_A_I_W10 [1/5] K_2_A_I_W14 [1/5]
Has knowledge of development and implementation of other than relational data models (NoSQL) ensuring gathering unstructured data. [HD _W3]
 K_2_A_I_W06 [1/5] K_2_A_I_W09 [1/5] K_2_A_I_W10 [1/5] K_2_A_I_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]
The tasks of students will be executing documentation containing description of the tasks executed during laboratory classes. Programming tasks in SQL, PL/SQL, Java (other languages are also possible).
 HD _K5 HD _U4 HD _W1 HD _W2 HD _W3
Brainstorming [HD _w_2]
In order to choose and work out the best solutions accepted by the group during classes, discussions will be held in the form of brainstorming, during which, the teacher will be able to observe and evaluate knowledge and students’ engagement.
 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.
 15
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] Brainstorming [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.
 30
Realization of projects developing skills and competences in the field of programming and teamwork. Participation in the group, discussion on the module forum.
35 Reports (documentation of the performed tasks) [HD _w_1] Brainstorming [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)