182 ) why we need OLAP when we can query with OLTP
Answer:
OLTP databases are built for fast, single-row inserts and updates
If the client runs heavy reports on their live OLTP systems (like the Oracle ,SSMS ), it will slow down or crash the daily operations if used for reporting by the customer service agents.
OLTP databases are built for fast, single-row inserts and updates (like entering one new policy at a time), not for scanning millions of rows to calculate monthly trends or agent performance. A Data Warehouse is needed because it is optimized for heavy, read-only analytical queries without impacting the live systems used by employees.
No comments:
Post a Comment