Sales System for Golf Course products using Data warehouse and OLAP Technology

Abstract

Many in top managements extremely need high quality information for various time periods. Most organizations are facing some problems concerning data information gap. Decision support data usually needs to be collected from a variety of operational system and kept in a data store of its own on a separate platform. Data warehouse is constructed by integrating multiple heterogeneous sources and stores historical data, both summarized and detailed information. Online Analytical processing is used to describe the analysis of complex data from the data warehouse. OLAP service has a number of powerful tools that make it the best solution for designing OLAP system. This presents a system that uses multidimensional Online Analytical processing technology for extracting necessary information and knowledge. In this system,, the data warehouse using OLAP query for sale analysis of golf course product data has been developed. The aim of this system is accurate, effective, and efficient access for users by using OLAP query.