A data warehouse is constructed by integrating data from multiple heterogeneous sources that support analytical reporting, structured and/or ad hoc queries, and decision making. Data warehousing involves data cleaning, data integration, and data consolidations....
Sr.No.Data Warehouse (OLAP)Operational Database (OLTP) 1 Involves historical processing of information. Involves day-to-day processing. 2 OLAP systems are used by knowledge workers such as executives, managers and analysts. OLTP systems are used by clerks, DBAs, or database professionals. 3 ...
Access Financial Information during Data Mining− The simplest way to frame decisions in financial terms is to augment the raw information that is generally mined to also contain financial data. Some organizations are investing and developing data warehouses, and data marts. The design of a wareh...
It consistently provides information and makes the data accurate, verified, and adaptive in nature. A large amount of historical data is provided to perform the analysis. Also, data warehouse helps in recovering from database failure and are a feature of the data mining process. Difficulties in ...