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's the best database software for mac?
Explain the concepts of a primary key and foreign key.
What are good databases?
What is father dbms?
what do u mean by canvases and alerts?
What is considered a database?
Can you explain insert, update and delete query?
How to monitor firebird server activity?
What is field in database give an example?
What are reports in a database?
How is the pattern matching done in the sql?
What are the differences between drop, truncate and delete commands?
What is the purpose of a model?
Is file system a database?
what are database files, control files and log files. How many of these files should a database have at least? Why?