quotSTUDIES ON METHODOLOGY FOR INCREMENTAL MAINTENANCE OF MATERIALIZED VIEW IN A DATA WAREHOUSE ENVIRONMENTquot

Abstract

quotThe ability to afford decision makers with both accurate and timely newlineconsolidated information as well as rapid query response times is the fundamental newlinerequirement for the success of a Data Warehouse. To provide fast access, a data newlinewarehouse stores materialized views of the sources of its data. As a result, a data newlinewarehouse needs to be maintained to keep its contents consistent with the contents newlineof its data sources. Incremental maintenance is generally regarded as a more newlineefficient way to maintain materialized views in a data warehouse. The view has to newlinebe maintained to reflect the updates done against the base relations stored at the newlinevarious distributed data sources. The proposed approach contains two modules newlinenamely, (1) materialized view selection(MVS) and (2) maintenance of materialized newlineview. (MMV). Selecting views to materialize for the purpose of supporting the newlinedecision making efficiently is one of the most significant decisions in designing newlineData Warehouse. Selecting a set of derived views to materialize which minimizes newlinethe sum of total query response time and maintenance of the selected views is newlinedefined as view selection problem. Therefore, to select an appropriate set of a view newlineis the major target that diminishes the entire query response time and also newlinemaintains the selected views. In the literature, the view selection problem has newlineacknowledged with significant consideration. View Maintenance is the process of newlineupdating a materialized view in response to the modifications in the base relation newlinethat acquires a View Maintenance Cost . Maintenance of a view can be attained newlineeither by complete re-computation of the view definition or by calculating the newlinemodifications to the view incrementally. The new view is computed from the newlineexisting view and the modifications to the base relations are termed as Incremental newlineComputation. In recent times, several algorithms have been proposed for keeping newlinethe views up-to-date in response to the changes in the source data.quot newline newline