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 |
Define database lock?
What is the use of CONSISTENT (Ver 7) option in EXP command ?
What is dbms function?
What are the two major subsystems of system r?
What is Schema in DBMS?
How is foreign key commands related to primary key?
What is data abstraction in dbms?
What do you understand by correlated subqueries in dbms?
what is the difference between two and three-tier architectures?
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
Difference between file system and relational database.
What is Database testing and What are ways of writing test cases for database testing?
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)