International Journal of Innovative Research In Advanced Engineering (IJIRAE)
A data warehouse is an integrated set of data, derived basically from operational data to use in decision making strategy and business intelligence using OLAP techniques. The words On-Line Analytical Processing (OLAP) bring together a set of tools that use multidimensional modelling in the extraction of information from the data warehouse. The multi-dimensional data model is an integral part of on-line analytical processing, or OLAP. Because OLAP is on-line, it must provide answers quickly; analysts pose iterative queries during interactive sessions, not in batch jobs that run overnight.