Datové modely a struktury databází

The aim of this thesis is to compare several models (Dimensional model, Data Vault model and NF3 model), and to determine their usability in BI with the data from DHL s.r.o. company. The aim is going to be reached by gathering necessary information from the printed scientific literature and from the online sources. Thereafter, the gathered information is going to be used during the construction and testing of the individual models with the DHL s.r.o. data. The results of the testing of the three models are going to be saved and compared.This thesis’ contribution is the comparison itself. In BI, there is a long tradition of the Dimensional model’s usage. The comparison of the three models might help to understand the reason for using the Dimensional model in most cases. However, it might provide information for improving the effectivity of BI in DHL s.r.o. by using a different model. The result alone might be reflected in the HR database of DHL s.r.o. company and cause the BI processes to be more efficient.The thesis itself begins with introductory summary of basic information about BI. Thereafter, there is a passage with detailed information about the individual models (their history, use, specification, and example). Furthermore, there is the practical part in which the models are going to be created in databases, compared based on demandingness, speed and other factors. The results of the individual models are going to be compared and the comparison is going to establish the most appropriate model.