OLAP and OLTP data integration for operational level decision making
Muhammad Azhar Chohan, Muhammad Younus Javed · 2010
Data warehousing is being used by many organizations to make decisions at top level. These analysis-based decisions are more helpful for top management for setting their market trends to compete their market rivals. However some decisions have to be taken at operational level in an organization such that management should be able to compare current and targeted performance values so they can take proper steps according to the situation. For these decisions to be quicker and accurate, operational data is needed. Such data cannot be gathered from the current warehouse solutions alone, as the ETL process of data warehouse is generally done periodically like once every 24 hours. We have proposed an architecture that will integrate OLTP data and OLAP data to support operational level decisions.