Implementation of Multidimensional Data Models using Data Warehouse and OLAP Technology

Abstract

Data warehousing and online analytical processing (OLAP) are essential elements of decision support system, which has increasingly become a focus of the database industry. A data warehouse is an integrated and time-varying collection of data derived from operational data and primarily used in strategic decision making by means of OLAP techniques. OLAP technology can use data from operational database to be executed data analysis queries. We describe back end tools for extracting, cleaning and loading data into a data warehouse multidimensional data model. In this system, we also implement multidimensional data models typical of OLAP. This proposed system intends to develop the data warehouse for the main crops of Pathein District in Ayeyarwaddy Division. And then develop relational online analytical processing (ROLAP) to retrieve information from the data warehouse via graphical user interface.