Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the Difference Between OLTP and OLAP Databases.
- 1 Answers
- 2212 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 is a clause in terms of sql?
Define checkpoint.
What are database modules?
Why not phenix, the zelinka/otwinoski libraries, etc?
Explain types of indexing in dbms?
How data are stored in database?
What is first normal form in dbms?
What is a join in the sql?
What is a concurrency problem in dbms?
Enlist various types of interactions created by dbms?
Explain the advantages of rdbms?
how Data is stored in a file so that Direct Searching can be performed
What are the disadvantage in file processing system?
Have you heard about sixth normal form?
What are the properties of a primary key in DBMS?
