首页    期刊浏览 2024年12月01日 星期日
登录注册

文章基本信息

  • 标题:A Novel Algorithm with IM-LSI Index for Incremental Maintenance of Materialized View
  • 本地全文:下载
  • 作者:T. Nalini ; A. Kumaravel ; K. Rangarajan
  • 期刊名称:Journal of Computer Science and Technology
  • 印刷版ISSN:1666-6046
  • 电子版ISSN:1666-6038
  • 出版年度:2012
  • 卷号:12
  • 期号:1
  • 出版社:Iberoamerican Science & Technology Education Consortium
  • 摘要:The ability to afford decision makers with both accurate and timely consolidated information as well as rapid query response times is the fundamental requirement for the success of a Data Warehouse. To provide fast access, a data warehouse stores materialized views of the sources of its data. As a result, a data warehouse needs to be maintained to keep its contents consistent with the contents of its data sources. Incremental maintenance is generally regarded as a more efficient way to maintain materialized views in a data warehouse The view has to be maintained to reflect the updates done against the base relations stored at the various distributed data sources. The proposed approach contains two modules namely, (1) materialized view selection(MVS) and (2) maintenance of materialized view. (MMV). In recent times, several algorithms have been proposed for keeping the views up-to-date in response to the changes in the source data. Therefore, we present an improved algorithm for MVS and MMV using IM-LSI(Itemset Mining using Latent Semantic Index) algorithm. selection of views to materialize using the IM(Itemset Mining) algorithm method to overcome the problem resulting from conventional view selection algorithms and then we consider the maintenance of materialized views using LSI. For the justification of the proposed algorithm, we reveal the experimental results in which both time and space costs better than conventional algorithms.4
  • 关键词:materialization view; data warehousing; selection;cost; I-mine item set index; FP growth ; LSI index
国家哲学社会科学文献中心版权所有