Both OLTP and OLAP are types of IT systems.OLTP (Online transaction processing system) deals with transactions ( insert, update , delete and simple search ) while OLAP (Online analytical processing) deals with analyzing historical data, forecasting etc.
Below is a simple table which chalks out the differences.
| OLTP | OLAP | |
| Design | Normalized. (1st normal form, second normal form and third normal form). | Denormalized (Dimension and Fact design). |
| Source | Daily transactions. | OLTP. |
| Motive | Faster insert, updates, deletes and improve data quality by reducing redundancy. | Faster analysis and search by combining tables. |
| SQL complexity | Simple and Medium. | Highly complex due to analysis and forecasting. |
No comments:
Post a Comment