NSYS Cloud Warehouse

Bc. Tomáš Hrdlička

Master's thesis

Abstract:

The trend of the last years is in area of cloud computing based on various services which are related to one or more particular fields such as Software as a Service (SaaS), Infrastructure as a Service (IaaS) and Platform as a Service (PaaS). The cloud services are operated by different providers which are usually oriented in specific field such as storage or computing. The common requirement from the users of cloud services is to have an option for getting reports and analyses tasks helping them to get the over-view about cloud services usage. The challenge in the terms of reporting and analyses is in ap-proach of collecting data from the various systems, store them somewhere and generate reports with some results. The ideal scenario would be in use of a traditional data warehouse which is capable to collect data from the operational systems and pass the data through an operational data store for additional operations before they are used in the warehouse for reporting. Unfor-tunately the traditional data warehouse implementations are too complex for flexible and easy way how to extend their functionality and mostly oriented for some particular solutions of the 3rd parties. There is missing a way how to do a simple integration with other systems. This thesis presents another view on data warehouse focused on data of the cloud ser-vices. The cloud warehouse is a database used for reporting, analyses and data synchronization. The data stored in the cloud warehouse are collected from the external/operational systems pro-vided as cloud services. The data may pass through an operational data store (ODS) for addi-tional operations before it is used in the cloud warehouse for reporting. The cloud warehouse maintains its function on three layers: collecting, integration, and access. Collecting is used to store raw data from external/operational systems. The integration layer is used to integrate data and to have a level of abstraction from users. The access layer is for getting data out for users. This is definition of the cloud warehouse focused on data storage of cloud services. Prototype implementation of the cloud warehouse is developed and described in this the-sis.

Abstract:

The trend of the last years is in area of cloud computing based on various services which are related to one or more particular fields such as Software as a Service (SaaS), Infrastructure as a Service (IaaS) and Platform as a Service (PaaS). The cloud services are operated by different providers which are usually oriented in specific field such as storage or computing. The common requirement from the users of cloud services is to have an option for getting reports and analyses tasks helping them to get the over-view about cloud services usage. The challenge in the terms of reporting and analyses is in ap-proach of collecting data from the various systems, store them somewhere and generate reports with some results. The ideal scenario would be in use of a traditional data warehouse which is capable to collect data from the operational systems and pass the data through an operational data store for additional operations before they are used in the warehouse for reporting. Unfor-tunately the traditional data warehouse implementations are too complex for flexible and easy way how to extend their functionality and mostly oriented for some particular solutions of the 3rd parties. There is missing a way how to do a simple integration with other systems. This thesis presents another view on data warehouse focused on data of the cloud ser-vices. The cloud warehouse is a database used for reporting, analyses and data synchronization. The data stored in the cloud warehouse are collected from the external/operational systems pro-vided as cloud services. The data may pass through an operational data store (ODS) for addi-tional operations before it is used in the cloud warehouse for reporting. The cloud warehouse maintains its function on three layers: collecting, integration, and access. Collecting is used to store raw data from external/operational systems. The integration layer is used to integrate data and to have a level of abstraction from users. The access layer is for getting data out for users. This is definition of the cloud warehouse focused on data storage of cloud services. Prototype implementation of the cloud warehouse is developed and described in this the-sis.

Keywords

Cloud, warehouse, reporting, analyses, provider, saas, iaas, paas

Language used: English

Date on which the thesis was submitted / produced: 28. 5. 2012

Thesis defence

• Date of defence: 25. 6. 2012
• Supervisor: doc. RNDr. Eva Hladká, Ph.D.
• Reader: doc. RNDr. Tomáš Pitner, Ph.D.

Masaryk University

Faculty of Informatics

Master programme / field:
Applied Informatics / Service Science, Management and Engineering