Give some difference between OLTP and OLAP.
devquora
Posted On: Feb 22, 2018
Difference between OLTP and OLAP
| OLTP | OLAP |
|---|---|
| The transaction system that collects the business data is called as OLTP. | OLAP tends to report and analyze the system on that data. |
| OLTP systems are usually optimized for INSERT and UPDATE operations, hence they are highly normalized in general. | When it comes to OLAP, systems are made denormalized for faster data retrieval through the operation of SELECT. |
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Data Warehousing Interview Questions
What are the different types of data warehouses?
There are three major types of data warehouses as-..
Data Warehousing Interview Questions
What are the fundamental elements of the data warehouse?
A data warehouse consists of data which is obtained from data sources or in other words, external sources...
Data Warehousing Interview Questions
What is Data Analytics in simple terms?
Data analytics or simply DA is the science used for examining raw data with the purpose of concluding that information. This is mostly built to enable the Data Analytics..