Improving Resource Management and Solving Scheduling Problem In Data Ware House Using OLAP and OLTP
M.tech Computer Engineering OITM Hissar, GJU Univesity Hissar, Sheenu Kohar, Surender Punia · International Journal Of Mechanical Engineering And Information Technology · 2016
A data warehouses provides us generalized and consolidated data in multidimensional view.Along with generalized and consolidated view of data, a data warehouses also provides us Online Analytical Processing (OLAP) tools.These tools help us in interactive and effective analysis of data in a multidimensional space.This analysis results in data generalization and data mining.Data mining functions such as association, clustering, classification, prediction can be integrated with OLAP operations to enhance the interactive mining of knowledge at multiple level of abstraction.That's why data warehouse has now become an important platform for data analysis and online analytical processing.Data warehousing is the process of constructing and using a data warehouse.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.