MPŠ
MPŠ MP&Scaron MP&Scaron MP&Scaron Avtorji

Jožef Stefan
International
Postgraduate School

Jamova 39
SI-1000 Ljubljana
Slovenia

Phone: +386 1 477 31 00
Fax: +386 1 477 31 10
Email: info@mps.si

Search

Course Description

Data Warehouses

Program

Information and Communication Technologies, second-level study programme

Lecturers:

prof. dr. Bojan Cestnik

Goals:

Students gain basic theoretical and practical knowledge in the field of Data warehousing. The emphasis is on OLAP and OLTP technologies and their practical application in the context of Decision Support Systems.

The goal is to educate students for understanding the most recent solutions in the field of Data warehousing.

Obtained knowledge will enable the use of Data warehousing technology to support decisions in various situations. In the context of business decision- making the expected gain of using the Data warehousing technology is the revitalization, modernization and growth of production.

Content:

From databases to data warehouses

Models for data warehouses management

Data view on data warehouses

Process view on data warehouses
.
Data security and protection in data warehouses

OLAP and OLTP

Application areas
DSS, CRM, e-business, risk assessment and management.

Course literature:

• Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd Edition, Wiley, 2002.
• Anahory, S., Murray, D.: Data warehouses in the real world, Addison Wesley, 1998.

Significant publications and references:

• PEROVŠEK, Matic, VAVPETIČ, Anže, KRANJC, Janez, CESTNIK, Bojan, LAVRAČ, Nada. Wordification : propositionalization by unfolding relational data into bags of words. Expert systems with applications, ISSN 0957-4174. [Print ed.], 2015, vol. 42, no. 17/18, str. 6442-6456, doi: 10.1016/j.eswa.2015.04.017.
• PEROVŠEK, Matic, CESTNIK, Bojan, URBANČIČ, Tanja, COLTON, Simon, LAVRAČ, Nada. Towards narrative ideation via cross-context link discovery using banded matrices. V: TUCKER, Allan (ur.). Advances in intelligent data analysis XII : IDA 2013 : 12th International Symposium, London, UK, October 17-19, 2013 : proceedings, (Lecture notes in computer science, ISSN 0302-9743, 8207). Berlin; Heidelberg: Springer, 2013, vol. 8207, str. 333-344.
• PEROVŠEK, Matic, VAVPETIČ, Anže, CESTNIK, Bojan, LAVRAČ, Nada. A wordification approach to relational data mining. V: FÜRNKRANZ, Johannes (ur.), et al. Discovery science : 16th International Conference, DS 2013, Singapore, October 6-9, 2013. proceedings, (Lecture notes in computer science, ISSN 0302-9743, Lecture notes in artificial intelligence, 8140). Berlin, Heidelberg: Springer, 2013, vol. 8140, str. 141-154.
• JURŠIČ, Matjaž, CESTNIK, Bojan, URBANČIČ, Tanja, LAVRAČ, Nada. HCI empowered literature mining for cross-domain knowledge discovery. V: HOLZINGER, Andreas (ur.), PASI, Gabriella (ur.). Human-computer interaction and knowledge discovery in complex, unstructured, big data : proceedings, Third International Workshop, HCI-KDD 2013, Held at SouthCHI 2013, Maribor, Slovenia, July 1-3, 2013, (Lecture notes in computer science, ISSN 0302-9743, Lecture notes in artificial intelligence, vol. 7947). Berlin; Heidelberg: Springer, 2013, vol. 7947, str. 124-135.
• PETRIČ, Ingrid, CESTNIK, Bojan, LAVRAČ, Nada, URBANČIČ, Tanja. Outlier detection in cross-context link discovery for creative literature mining. The Computer journal, ISSN 0010-4620, 2012, vol. 55, no. 1, str. 47-61, doi: 10.1093/comjnl/bxq074.

Examination:

Seminar and oral exam (100%)

Students obligations:

Seminar and oral exam

Links: