Update of materialized WebView

Abstract

WebView materialization is an important technology in improving the performance of database-backed Web server in terms of response time. However, it brings the WebView update problem since WebView should be updated online to maintain the freshness of queries. The online update would increase the system workload, and may severely degrade system performance if the update approach is not efficient enough. Currently, there is only few literatures addressing this problem. In this paper, a new framework for the materialized WebView update named OUDA (opportunity & deferred update approach) is proposed, which combines the asynchronous opportunity update and the deferred update methods together. The asynchronous opportunity update is adopted to make the best of the idle time of CPU to refresh the outdated WebViews as much as possible, and the deferred update is employed to refresh those requested WebViews which have not yet been updated by the opportunity update. OUDA not only guarantees the freshness of queries, but also greatly lessens the contest between update tasks and query service process. Our experiments indicate that OUDA is a more scalable and more efficient solution