Data Warehousing, Data Mining, OLAP and OLTP Technologies Are Essential Elements to Support Decision-Making Process in Industries
S.Saagari1, P. Devi Anusha2, Ch. Lakshmi Priyanka3, V.S.S.N.Sailaja4
1S.Saagari, Department of Computer Science and Engineering, KL University, (Andhra Pradesh), India.
2P.Devi Anusha, Department of Computer Science and Engineering, KL University, (Andhra Pradesh), India.
3Ch.Lakshmi Priyanka, Department of Computer Science and Engineering, KL University, (Andhra Pradesh), India.
4V.S.S.N.Sailaja, Department of Computer Science and Engineering, KL University, (Andhra Pradesh), India.
Manuscript received on 10 May 2013 | Revised Manuscript received on 18 May 2013 | Manuscript Published on 30 May 2013 | PP: 88-93 | Volume-2 Issue-6, May 2013 | Retrieval Number: F0801052613/13©BEIESP
Open Access | Editorial and Publishing Policies | Cite | Mendeley | Indexing and Abstracting
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC-BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: This paper provides an overview of Data warehousing, Data Mining, OLAP, OLTP technologies, exploring the features, applications and the architecture of Data Warehousing. The data warehouse supports on-line analytical processing (OLAP), the functional and performance requirements of which are quite different from those of the on-line transaction processing (OLTP) applications traditionally supported by the operational databases. Data warehouses provide on-line analytical processing (OLAP) tools for the interactive analysis of multidimensional data of varied granularities, which facilitates effective data mining. Data warehousing and on-line analytical processing (OLAP) are essential elements of decision support, which has increasingly become a focus of the database industry. OLTP is customer-oriented and is used for transaction and query processing by clerks, clients and information technology professionals. An OLAP system is market-oriented and is used for data analysis by knowledge workers, including managers, executives and analysts. Data warehousing and OLAP have emerged as leading technologies that facilitate data storage, organization and then, significant retrieval. Decision support places some rather different requirements on database technology compared to traditional on-line transaction processing applications.
Keywords: Data Warehousing, OLAP, OLTP, Data Mining, Decision Making and Decision Support.
Scope of the Article: Data Mining