Online Transaction Processing Systems | Online Analytical Processing Systems |
Operational Data and original source of data. | The Data (integrated) comes from various OLTP systems |
Application specific, Detailed and most currrent/recent data. | Historical data collected from various systems to support Business decision, planning and reporting |
Performance is predicted as per application architecture and design. | Performance is not predicted or mandated. |
Most recent data with several Insert/Update operations. | Read only data. |
Highly Normalized for performance. | Minimal normalization with restructuring of data. |
Not (least) used for reporting and analysis. | High analysis for business decisions. |
Many transactions. | low (none) transactions. |
Low to moderate space is required. | Very large space is required to support volumes of data. |
Backup and recovery is critical to organization. | Backup is not very critical. Reloading the OLTP data is a recovery practice. |
Tuesday, March 19, 2013
Difference between OLTP and OLAP systems
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment