Solving Scheduling Problem in Data Ware House Using OLAP and OLAP

Abstract

Data in the warehouse and data marts is stored and managed by one or more warehouse servers, which present multidimensional views of data to a variety of front end tools: query tools, report writers, analysis tools, and data mining tools. Finally, there is a repository for storing and managing metadata, and tools for monitoring and administering the warehousing system.  An operational database undergoes frequent changes on a daily basis on account of transactions that taken area. Think a business management wants to analyze previous feedback on any data such as a product, a supplier, or any consumer data, then executive will had no data available to analyze because  previous data has been updated due to transactions. A data warehouse helps business executives to organize, analyze, & use their data for decision making. A data warehouse serves as a sole part of a plan-execute-assess "closed-loop" feedback system for  enterprise management. Data warehouses are widely used in  following fields: Financial services. Banking services. Consumer goods. Retail sectors. Controlled manufacturing.