Faster Result Retrieval from Health Care Product Sales Data Warehouse Using Materialized Queries

摘要

Existing approaches for result retrieval from a Data Warehouse, i.e., Data Cubes and Materialized Views, incur more processing, maintenance and storage cost. For faster retrieval of query results from Data Warehouse, authors suggest storing executed OLAP queries and their results along with metadata in a relational database referred here as Materialized Query Database (MQDB). For stored queries, processing incremental results using Data Marts is faster as compared to using Data Warehouse. Therefore, a significant reduction in query processing time is achieved using MQDB. Authors depict the working of proposed MQDB approach on the sales data of a health care product manufacturing organization by placing Data Warehouse on Centralized and on Cloud Server.