1 publication

• Published Subscription 14 Jan 2021

  Overview of Query Materialization

  By Priyanka M. Yalagach, Kavitha G., Mohammad Rafi

  Abstract: AbstractA materialized view (MV) is the pre-calculated (materialized) result of a query. Unlike a simple view, the result of a materialized view is stored somewhere, generally in a table. Materialized views are used when immediate response is needed and the query where the materialized view bases on would take too long to produce a result. Materialized views have to be refreshed once in a while. It depends on the requirements …

  Published in E-Commerce for Future & Trends · Vol. 7, Issue 3, 2020 · pp. 35–45 Read article →