Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the Difference Between OLTP and OLAP Databases.
- 1 Answers
- 2229 Views
- I also Faced
- E-Mail Answers
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 |
What are the steps in creating a database?
State some commands of ddl in dbms?
Enlist the advantages of normalizing database.
What are the advantages of database?
How to create a database from my program?
What is the use of drop command and what are the differences between drop, truncate and delete commands?
What is the purpose of a database table?
What is the full meaning of dbms?
Explain types of indexing in dbms?
What is a database in healthcare?
What is netlib for clipper?
What is the use of ROWS option in IMP command ?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
