Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the Difference Between OLTP and OLAP Databases.
- 1 Answers
- 2086 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
What are reports in a database?
What does clipper stand for?
What are cursors give different types of cursors?
What is metadata in dbms?
What are service-specific middleware?
What is vacuum in database?
What is the purpose of a model?
Explain all codd's rules for relational database system?
What is a stretch database?
What is index and also explain types of indexing in dbms?
Mention the differences between the clustered and non-clustered index
What is the easiest database to learn?
When does checkpoint occur in dbms?
What is database transaction?
What is the license for clipper?
