OLTP vs OLAP
OLTP (On-line Transaction Processing) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF).
OLAP (On-line Analytical Processing) is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations. For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema).
In Simple term:
OLTP databases are meant to be used to do many small transactions, and usually serve as a "single source of truth".
OLAP databases on the other hand are more suited for analytics, data mining, less queries but they are usually bigger (they operate on more data).
#Shyamb4u
OLTP (On-line Transaction Processing) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF).
OLAP (On-line Analytical Processing) is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations. For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema).
In Simple term:
OLTP databases are meant to be used to do many small transactions, and usually serve as a "single source of truth".
OLAP databases on the other hand are more suited for analytics, data mining, less queries but they are usually bigger (they operate on more data).
 |
| OLTP vs OLAP - shyam.mb |
#Shyamb4u
No comments:
Post a Comment