OLAP and OLTP

What is the difference between OLAP and OLTP?

Questions by harshaece

Showing Answers 1 - 3 of 3 Answers

Pardeep Kaur

  • Jan 31st, 2008
 

OLAP stands for online analytical processing . In this we have access to live data. This process contain historical information to analyze. Data needs to be integrated.We can create reports that are multi-dimensional, supported by time-based analysis and ideal for applications with unpredictable, ad hoc query requirments.

OLTP stands for online transaction processing. OLTP databases are fully normalized and are designed to consistently store operational data, one transaction at a time.It performs day-to -day operations and not support historical data.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions