Dynamic Optimization Algorithm of Static Materialized Views

Baili Zhang,
Yuhang Wu,
Linmu Wang,
Jie Wang,
Jianhua Lu,


In this paper an algorithm DCO (dynamic cache optimization) is proposed for the static materialized views that lack better response performance to dynamic queries. Based on the optimal static materialized views, DCO combines cache mechanism to obtain dynamic materialized views with dynamic adaptability and quick response. Meanwhile, a novel method of allocating free space is presented to implement the dynamic cache, and thus the free space of system can be used efficiently to store more materialized views for improving the query response. Experimental results indicate the efficiency and feasibility of DCO, and also show that DCO can overcome the SPSE (space-performance saturation effect) of materialized views in some degree.

Citation Format:
Baili Zhang, Yuhang Wu, Linmu Wang, Jie Wang, Jianhua Lu, "Dynamic Optimization Algorithm of Static Materialized Views," Journal of Internet Technology, vol. 20, no. 5 , pp. 1453-1461, Sep. 2019.

Full Text:



  • There are currently no refbacks.

Published by Executive Committee, Taiwan Academic Network, Ministry of Education, Taipei, Taiwan, R.O.C
JIT Editorial Office, Office of Library and Information Services, National Dong Hwa University
No. 1, Sec. 2, Da Hsueh Rd., Shoufeng, Hualien 974301, Taiwan, R.O.C.
Tel: +886-3-931-7314  E-mail: jit.editorial@gmail.com