首页    期刊浏览 2024年11月06日 星期三
登录注册

文章基本信息

  • 标题:A Comprehensive Analysis of Materialized Views in a Data Warehouse Environment
  • 本地全文:下载
  • 作者:Garima Thakur ; Anjana Gosain
  • 期刊名称:International Journal of Advanced Computer Science and Applications(IJACSA)
  • 印刷版ISSN:2158-107X
  • 电子版ISSN:2156-5570
  • 出版年度:2011
  • 卷号:2
  • 期号:5
  • DOI:10.14569/IJACSA.2011.020513
  • 出版社:Science and Information Society (SAI)
  • 摘要:Data in a warehouse can be perceived as a collection of materialized views that are generated as per the user requirements specified in the queries being generated against the information contained in the warehouse. User requirements and constraints frequently change over time, which may evolve data and view definitions stored in a data warehouse dynamically. The current requirements are modified and some novel and innovative requirements are added in order to deal with the latest business scenarios. In fact, data preserved in a warehouse along with these materialized views must also be updated and maintained so that they can deal with the changes in data sources as well as the requirements stated by the users. Selection and maintenance of these views is one of the vital tasks in a data warehousing environment in order to provide optimal efficiency by reducing the query response time, query processing and maintenance costs as well. Another major issue related to materialized views is that whether these views should be recomputed for every change in the definition or base relations, or they should be adapted incrementally from existing views. In this paper, we have examined several ways o performing changes in materialized views their selection and maintenance in data warehousing environments. We have also provided a comprehensive study on research works of different authors on various parameters and presented the same in a tabular manner.
  • 关键词:thesai; IJACSA; thesai.org; journal; IJACSA papers; Materialized views; view maintenance; view selection; view adaptation; view synchronization.
国家哲学社会科学文献中心版权所有