Explain the Difference Between OLTP and OLAP Databases.
Answer Posted / hr@tgksolutions.com
Databases made for handling transaction-oriented applications are known as OLTP (Online Transaction Processing) databases. They are designed to handle a lot of brief online transactions (update, remove, insert). Retail sales systems are one example.
Databases created for querying and reporting are known as OLAP (Online Analytical Processing) databases, and they are frequently used for corporate intelligence and data analysis. They are best suited for processes involving a lot of reading on big data sets. Data warehousing is one example.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you understand by index hunting?
Explain a database server?
How do I create a database?
What is raid controller technology?
What is normalization in dbms?
How to repair a corrupt firebird database?
Why do we need database normalization?
What is database management definition?
What is a Federated Query ?
What is a checkpoint in dbms?
What is difference between sql and rdbms?
Explain the use of assign statement in progress database?
Explain the components of rdbms?
Why is foreign key used?
What is rdbms and its features?