Explain the Difference Between OLTP and OLAP Databases.
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 is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
How to monitor firebird server activity?
What is db context?
how to retrive a data From database into the grid view..?
What are the components of a database management system?
Explain the difference between dbms and rdbms?
What do you know about Master Data & Transaction Info Package?
0 Answers ITC Indian Tobacco Company,
what is the difference between unique and primary key
What is cold backup, hot backup, warm backup recovery?
What is rdbms and its features?
What are the advantages of database system?
What do you understand by index hunting?
Oracle (3259)
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)