Thesis Details

Implementace OLAP analýzy nad daty knihoven VUT

Master's Thesis Student: Mahdalíček Josef Academic Year: 2007/2008 Supervisor: Šárfy Martin, Mgr.
English title
Implementation of OLAP Analysis for BUT Libraries
Language
Czech
Abstract

The aim of this project is to create tool for OLAP analysis over operational data of BUT libraries. This OLAP tool answers ie. query how long were users having loaned books. These queries could be specified by time period (year, month), library (ie. FIT library) and other dimensions. Only some, for this application interesting, tables from source database are used. Tables were exported into text files in csv format. According to project specification, system for OLAP analysis should be open source. Tool Mondrian accomplishes this requirement and was  used in this work. Data warehouse is represented by relational database MySQL. ETL tool feeds data warehouse by data from exported files. User interface is used from internet browser and is implemented by component JPivot. Query results are displayed in tables and graphs.

Keywords

OLAP analysis, Mondrian, Aleph VUT, ETL

Department
Department of Information Systems FIT BUT
Degree Programme
Information Technology, Field of Study Information Systems
Files
Status
defended, grade C
Date
18 June 2008
Reviewer
Ruttkay Ladislav, Ing.
Committee
Hruška Tomáš, prof. Ing., CSc. (DIFS FIT BUT), předseda
Češka Milan, prof. RNDr., CSc. (DITS FIT BUT), člen
Kršek Přemysl, doc. Ing., Ph.D. (DCGM FIT BUT), člen
Švéda Miroslav, prof. Ing., CSc. (DIFS FIT BUT), člen
Vondrák Ivo, prof. Ing., CSc. (FEI VSB), člen
Zbořil František, doc. Ing., Ph.D. (DITS FIT BUT), člen
Citation
MAHDALÍČEK, Josef. Implementace OLAP analýzy nad daty knihoven VUT. Brno, 2008. Master's Thesis. Brno University of Technology, Faculty of Information Technology. 2008-06-18. Supervised by Šárfy Martin. Available from: https://www.fit.vut.cz/study/thesis/6695/
BibTeX 
@mastersthesis{FITMT6695,
    author = "Josef Mahdal\'{i}\v{c}ek",
    type = "Master's thesis",
    title = "Implementace OLAP anal\'{y}zy nad daty knihoven VUT",
    school = "Brno University of Technology, Faculty of Information Technology",
    year = 2008,
    location = "Brno, CZ",
    language = "czech",
    url = "https://www.fit.vut.cz/study/thesis/6695/"
}

Theses

Back to top