Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the Difference Between OLTP and OLAP Databases.
- 1 Answers
- 1949 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
Enlist ways to efficiently code transactions.
How many types of data are there?
What do you understand by data model?
What are procedures in database?
What do you mean by denormalization?
What does rdbms stand for?
How do I convert a spreadsheet to a database?
How can you perform pattern matching in sql?
what is normalization? types of normalization? example of each form? how do u implement normalization in ur project?
What is optimization in database?
what are the acid properties in dbms?
What is key dbms?
What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?
Explain the importance of partitioning.
how to solve cardinality in dbms...many to many ralationships
