期刊文献+
任意字段
题名或关键词
题名
关键词
文摘
作者
第一作者
机构
刊名
分类号
参考文献
作者简介
基金资助
栏目信息

物化视图作为汇总表在数据仓库中的应用(英文)

Application of Materialized View as Aggregate Table in Data Warehouse
下载PDF
导出
摘要 汇总表存储的是事先计算好的汇总数据,在数据仓库查询调优中是至关重要的。分析了汇总表数据生成的三种方法:即触发器、存储过程、物化视图;用实例阐述了物化视图的使用方法和优点,即灵活的数据刷新方式、减少繁重的编程工作、查询重写机制保证应用独立性等,指出了物化视图是实现汇总表的理想选择。 Aggregate tables store the pre--calculated summaries, and are critical in query performance tuning in a data warehouse. Analyzed the three methods of aggregates data building： triggers, stored procedures and materialized views. Stated the methods, usages and advantages of materialized views via examples, i. e. flexible refresh method, reduction of burdensome programming workload, query rewrite mechanism insuring application independence and so on. Indicated materialized views are ideal choice for aggregate tables.
作者 汪辉 李浪
机构地区 衡阳师范学院计算机科学系
出处 《衡阳师范学院学报》 2012年第6期59-62,共4页 Journal of Hengyang Normal University
基金 The Scientific Research Fund of Hunan Provincial Education Department(No:11B018) the Scientific Research fund of Hengyang Normal University(No 11B43)
关键词 物化视图 汇总表 数据仓库 materialized view aggregate table data warehouse
分类号 TP311 [自动化与计算机技术—计算机软件与理论]
  • 相关文献

参考文献8

  • 1INMON W. H. Building the Data Warehouse[M]. 4th ed Indiana, USA, Wiley Publication Inc. 2005.
  • 2KIMBALL R. ,ROSS M. The Data Warehouse Toolkit 2nd ed. : The Complete Guide to Dimensional Modeling [M]. New York USA, John Wiley and Sons, Inc. 2002.
  • 3PONNIAH P. Data Warehousing Fundamentals for IT Professionals[M]. 2nd ed. New Jersey USA John Wiley & Sons, Inc. 2010.
  • 4朱文,毛琴辉,薛燕,苏森,张柏礼.数据仓库中物化视图维护算法的分析和比较[J].现代计算机,2008,14(4):58-60. 被引量：2
  • 5CYRAN M, LANE P. Oracle Database Concepts 10g release[M]. California, USA, Oracle Corp. 2003.
  • 6CHEN Yi-xin, Ni Zi-wei. Application of materialized view in oracle large DB query[J]. Fujian Computer, 2011(10) : 147-148.
  • 7KIMBALl. R., CASERTA J. The Data Warehouse ETL Toolkit[M]. Indiana, USA, Wiley Publication Inc. 2004.
  • 8XIE Ren-dong, YANG Jun, Application of oracle mate rialized view in data warehouse[J]. Computer Knowl edge and Technology, 2008,2 (3): 421-423.

二级参考文献14

  • 1Inmon W H,王志海译.数据仓库.北京:机械工业出版社,2000
  • 2Gupta H. Selection of Views to Materialize in a Data Warehouse. In: Proc of the Sixth ICDT, 1997:98-112
  • 3Gupta A, Mumick I S. Maintenance of Materialized Views: Problems, Techniques, and Applications[C], IEEE Data Engineering Bulletin, Special Issue on Materialized Views and Data Warehousing, 1995:18(2):3-18
  • 4Lee K Y, S J H, Kim M H. Efficient Incremental View Maintenance in Data Warehouse. In: Proc of CIKM '01. GA: ACM Press, 2001:349-356
  • 5Agrawal D, Abbadi A, Singh A, et al. Efficient View Maintenance at Data Warehouses. In: Proc. of the ACM SIGMOD Intl. Conf. on Management of Data,New York: ACM Press, 1997:417-427
  • 6Quass D, Gupta A, Mumick I S, et al. Making Views Self-Maintainable for Data Warehousing. Technical report, Stanford University, 1996:158-169
  • 7Gupta A, Jagadis H, Mumick I S. Data Integration Using Self-Maintainable Views. In: Proc of the 5th Infl Conf on Extending Database Technology, Heidelberg. Springer, 1996: 140-144
  • 8Colby L S, Kawaguchi A, Lieuwen D F, et al. Supporting Multiple View Maintenance Policies. In: Proc. of the ACM SIGMOD Intl. Conf. on Management of Data, New York: ACM Press, 1997:405-416
  • 9Colby L S, Griffin T, Libkin L, et al. Algorithms for Deferred View Maintenance. In: Proc. of the ACM SIGMOD Intl. Conf. on Management of Data, New York: ACM Press, 1996:469-480
  • 10Blakeley J, Larson P, Tompa F. Efficienfly Updating Materialized Views In: Proc. of the ACM SIGMOD Intl. Conf. on Management of Data, New York: ACM Press, 1986: 61-71

共引文献1

衡阳师范学院学报
2012年 第6期

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部