Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the Difference Between OLTP and OLAP Databases.
- 1 Answers
- 2013 Views
- I also Faced
- E-Mail Answers
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
Why do I need netlib?
What is a concurrency problem in dbms?
What is a database management system and give examples?
Define dbms.
Define sub-query.
What you mean by Object Relational DBMS?
What is 3nf in dbms?
Suppose database is running slow, what will you do?
What is bcnf in the dbms?
What is foreign key in database?
What are the advantages of a database?
How do I delete a database in phpmyadmin?
Describe reporting lifecycle?
What is the quickest sorting method to use?
Define the relationship between ‘view’ and ‘data independence’.
