Selection Of Materialized View Using Query Optimization In Database Management : An Efficient Methodology

P.P Karde, V.M Thakare
<span title="2010-11-30">2010</span> <i title="Academy and Industry Research Collaboration Center (AIRCC)"> <a target="_blank" rel="noopener" href="" style="color: black;">International Journal of Database Management Systems</a> </i> &nbsp;
Multiple Views can be formed and materialized from a data warehouses per the user requirements specified in the queries being generated against the information contained in the warehouse. Selecting Views to be materialized is one of the most important decisions in designing a warehouse. Due to change in user requirements and constraints over time View definitions stored in a data warehouse are dynamic in nature. This paper focus on the issues of materialized views in Data warehousing to enable
more &raquo; ... fficient Information Management. The issues include selection, maintenance and updating of Materialized views and how these issues create an impact in Business scenarios.
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="">doi:10.5121/ijdms.2010.2410</a> <a target="_blank" rel="external noopener" href="">fatcat:mcuymhuy3rh43bimyaoucexzli</a> </span>
<a target="_blank" rel="noopener" href="" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href=""> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="unlock alternate icon" style="background-color: #fb971f;"></i> Publisher / </button> </a>