Saved Bookmarks
| 1. |
Is Oltp Database Is Design Optimal For Data Warehouse? |
|
Answer» No. OLTP database tables are normalized and it will add additional time to queries to return results. Additionally OLTP database is smaller and it does not CONTAIN LONGER period (many years) data, which needs to be analyzed. A OLTP system is basically ER model and not Dimensional Model. If a complex query is executed on a OLTP system, it may CAUSE a heavy OVERHEAD on the OLTP SERVER that will affect the normal business processes. No. OLTP database tables are normalized and it will add additional time to queries to return results. Additionally OLTP database is smaller and it does not contain longer period (many years) data, which needs to be analyzed. A OLTP system is basically ER model and not Dimensional Model. If a complex query is executed on a OLTP system, it may cause a heavy overhead on the OLTP server that will affect the normal business processes. |
|