Original title:
Návrh datového skladu
Translated title:
Design of Data Warehouse
Authors:
Szkuta, David ; Neuwirth, Bernard (referee) ; Dydowicz, Petr (advisor) Document type: Master’s theses
Year:
2018
Language:
cze Publisher:
Vysoké učení technické v Brně. Fakulta podnikatelská Abstract:
[cze][eng]
Tato diplomova prace se zabyva navrhem datoveho skladu pro ukladani udalosti z mobilni aplikace. Cilem bylo navrzeni datoveho skaldu, jenz poslouzi jako alternativa k soucasne pouzivanemu systemu. V praci jsou vysvetleny pojmy, jez se v ramci cele prace vyskytuji, ty jsou zamereny predevsim na problematiku datovych skladu. Dale je provedena analyza pro posouzeni soucasne pouzivaneho systemu a take dostupnych reseni v oblasti datovych skladu a ETL sluzeb. V zavislosti na vysledcich analyzy je vybrano vhodne reseni, ktere je naimplementovano a odzkouseno.
This diploma thesis deals with the design of a data warehouse that stores events created in the mobile app. The goal was to design an alternative to the current solution. The thesis explains concepts, mainly data warehouse terminology, which are used in subsequent chapters. An analysis of the current solution is conducted, and as well as research of available data warehouse and ETL services. Based on the results of the analysis, a suitable new solution is chosen, implemented, and tested.
Keywords:
Data Warehouse; ETL process; mobile application; Python; SQL; Datovy sklad; ETL proces; mobilni aplikace; Python; SQL
Institution: Brno University of Technology
(web)
Document availability information: Fulltext is available in the Brno University of Technology Digital Library. Original record: http://hdl.handle.net/11012/82241