Explain the Difference Between OLTP and OLAP Databases.
- 1 Answers
- 255 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 |
How many records can a database hold?
Why is normalisation used?
How can I create database in excel?
What is difference between sql and rdbms?
What is the best database for big data?
Which database is good for large data?
What is an advantage of a database?
i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........
how Data is stored in a file so that Direct Searching can be performed
What is built_in Subprogram ?
0 Answers BBAU Babasaheb Bhimrao Ambedkar University, HCL, TCS,
How do I add a file to a database?
Are Constraints exported through Export command?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
