Camera Shopping Data Analysis using OLAP Model

Abstract

Nowadays, many commercil products and services are available, and all of the principal database management system vendors now have offering in business areas. Readity available high-quality information is very important and valuable in today’s business environment. The rapidly changing environment in which business operates demands ever more immediate access to data. Most organizations are having a lot of data but facing poor information with data information gap. However, this situation can be handled by developing a data warehousing system. So, this system used data warehouse and on-line analytical processing (OLAP) to analyze the camera shopping data. The data in the data warehouse are analyzed by using on-line analytical processsing (OLAP) query processing –roll up, drill down, slice and dice to provide a variety of analysis reports and information in time with accuraately fast response and optimize for decision making.