| |
GeekInterview.com > Interview Questions > Data Warehousing
| Print | |
Question: OLAP and OLTP
Answer: What is the difference between OLAP and OLTP? |
| January 01, 2008 11:03:42 |
#1 |
| Pardeep Kaur |
Oracle Expert Member Since: January 2008 Total Comments: 1 |
RE: OLAP and OLTP
|
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. |
| |
Back To Question | |
