Abstract
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.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
