Thesis Details

Datové sklady a OLAP v prostředí MS SQL Serveru

Master's Thesis Student: Madron Lukáš Academic Year: 2007/2008 Supervisor: Bartík Vladimír, Ing., Ph.D.
English title
Data Warehouses and OLAP in MS SQL Server Environment
Language
Czech
Abstract

This paper deals with data warehouses and OLAP. These technologies are defined and described here. Then an introduction of the architecture of product MS SQL Server and its tools for work with data warehouses and OLAP folow. The knowledge gained is used for creation of sample application.

Keywords

Data warehouse, data mart, ETL (extract, transform, load), OLTP (online transaction processing), OLAP (online analytical processing), multidimensional database model, data cube, decision support systems, business intelligence, Microsoft SQL Server, SSIS (MS SQL Server Integration Services), SSAS (MS SQL Server Analysis Services), SSRS (MS SQL Server Reporting Services).

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
Stryka Lukáš, 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
MADRON, Lukáš. Datové sklady a OLAP v prostředí MS SQL Serveru. Brno, 2008. Master's Thesis. Brno University of Technology, Faculty of Information Technology. 2008-06-18. Supervised by Bartík Vladimír. Available from: https://www.fit.vut.cz/study/thesis/6624/
BibTeX 
@mastersthesis{FITMT6624,
    author = "Luk\'{a}\v{s} Madron",
    type = "Master's thesis",
    title = "Datov\'{e} sklady a OLAP v prost\v{r}ed\'{i} MS SQL Serveru",
    school = "Brno University of Technology, Faculty of Information Technology",
    year = 2008,
    location = "Brno, CZ",
    language = "czech",
    url = "https://www.fit.vut.cz/study/thesis/6624/"
}

Theses

Back to top