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.
