ScholarLens Back to search
2013•Unpublished venueRequires access

A Comparative Study of OLTP and OLAP Technologies

Jatinderpal Singh, Anshul Sood

Open publisher page 0 citations

Abstract

This paper provides an overview of Data warehousing and comparative study of OLAP, OLTP technologies. The data warehouse supports On-Line Analytical Processing (OLAP) who’s functional and performance requirements are different from those of the On-Line Transaction Processing (OLTP) applications supported by the operational databases. Data warehousing and On-Line Analytical Processing (OLAP) are essential elements of decision support. OLTP is a class of program that facilitates and manages transaction-oriented applications. An OLAP system is used for data analysis by knowledge workers, including managers, business executives and market analysts. Data warehousing and OLAP have emerged as leading technologies that facilitate data storage, organization and retrieval.

About this research paper

What this paper is about

This paper provides an overview of Data warehousing and comparative study of OLAP, OLTP technologies. The data warehouse supports On-Line Analytical Processing (OLAP) who’s functional and performance requirements are different from those of the On-Line Transaction Processing (OLTP) applications supported by the operational databases. Data warehousing and On-Line Analytical Processing (OLAP) are essential elements of decision support. OLTP is a class of program that facilitates and manages transaction-oriented applications. An OLAP system is used for data analysis by knowledge workers, including managers, business executives and market analysts. Data warehousing and OLAP have emerged as leading technologies that facilitate data storage, organization and retrieval.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

This paper provides an overview of Data warehousing and comparative study of OLAP, OLTP technologies. The data warehouse supports On-Line Analytical Processing (OLAP) who’s functional and performance requirements are different from those of the On-Line Transaction Processing (OLTP) applications supported by the operational databases. Data warehousing and On-Line Analytical Processing (OLAP) are essential elements of decision support. OLTP is a class of program that facilitates and manages transaction-oriented applications. An OLAP system is used for data analysis by knowledge workers, including managers, business executives and market analysts. Data warehousing and OLAP have emerged as leading technologies that facilitate data storage, organization and retrieval.

Key concepts: Online analytical processing, Online transaction processing, Data warehouse, Transaction processing, Database, Database transaction, Computer science, Business intelligence

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
A Comparative Study of OLTP and OLAP Technologies — Research Paper | ScholarLens