INDUSTRIAL SIGNIFICANCE OF DATA WAREHOUSING. (original) (raw)

This paper provides an overview of Data warehousing and OLAP-OLTP technology exploring the significance of Industrial work like decision support. Data warehousing and OLAP (On-line Analytical Processing) tools are essential for decision-making and has the ability to focus on databases of industry. Today we can easily see the difference between the requirements of database technology compared to OLTP (On-line Transaction Processing) application. OLAP is market oriented where OLTP is customers transaction oriented. Moreover, we have some of the descriptions of back end tools for extracting and cleaning of data, multidimensional data models, front-end client tools, database query and analysis, metadata management of warehouse, industrial database management and some research about data warehousing and mining with OLAP and OLTP. In addition, here will be consideration of basic need of OLAP and OLTP in industry or business management and OLAP-OLTPs advantages and disadvantages.