Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the Difference Between OLTP and OLAP Databases.
- 1 Answers
- 1950 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 |
Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?
Define and explain about progress?
What is variable dbms?
Define the relationship between ‘view’ and ‘data independence’.
How to determine who is and change the owner of database?
What is a database in business?
Why is it better to use an Integrity Constraint to validate data ?
What are the Different Types of Joins and How do They Work?
What is a system concept?
Why are databases so important?
What is tabular form?
When does checkpoint occur in dbms?
-
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)
