Data warehousing OLTP system and OLAP system

Data warehousing - What is an OLTP system and OLAP system? - August 07, 2008 at 17:10 pm by Rajmeet Ghai

What is an OLTP system and OLAP system?

OLTP: Online Transaction and Processing helps and manages applications based on transactions involving high volume of data. Typical example of a transaction is commonly observed in Banks, Air tickets etc. Because OLTP uses client server architecture, it supports transactions to run cross a network.

OLAP: Online analytical processing performs analysis of business data and provides the ability to perform complex calculations on usually low volumes of data. OLAP helps the user gain an insight on the data coming from different sources (multi dimensional).

Data warehousing - What is an OLTP system and OLAP system? - May 11, 2009 at 14:40 pm by Vidya Sagar

What is an OLTP system and OLAP system?

OLTP stands for OnLine Transaction Processing. Applications that supports and manges transactions which involve high volumes of data are supported by OLTP system. OLTP is based on client-server architecture and supports transactions across networks.

OLAP stands for OnLine Analytical Processing. Business data analysis and complex calculations on low volumes of data are performed by OLAP. An insight of data coming from various resources can be gained by a user with the support of OLAP.


Write your comment - Share Knowledge and Experience

More Related Links
What is snow flake scheme design in database?

Answer - A snowflake Schema in its simplest form is an arrangement of fact tables.........

Explain the difference between Data warehousing and Business Intelligence.

Answer - Data Warehousing helps you store the data while business intelligence.....

What is Dimensional Modeling?

Answer - Dimensional modeling is often used in Data warehousing.......

What are fundamental stages of Data Warehousing?

Answer - Stages of a data warehouse helps to find and understand.......


Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us