期刊文献+

基于时间段查询的物化视图策略

Strategy of materializing views based on queries of time period
下载PDF
导出
摘要 物化视图是减少数据仓库中查询响应时间的有效方法。现有的物化视图选择策略主要考虑物化视图的初始选择方法以及动态更新方法。针对某时间段内查询进行物化视图更新的情况考虑不足,在贪心算法以及动态更新算法的基础上,提出了基于时间段内查询的物化视图更新策略。基于时间段查询的物化视图更新策略可充分适应用户需求,提高查询效率。 An effective method to reduce the response time to query is to materialize views in data warehouse. The current strategies mainly consider the methods of the primary selection of materialized views and the methods of dynamic updating. Concerning the situation that the updating of views based on queries of time period did not get enough attention, based on greedy algorithm and dynamic refreshment algorithm, the authors proposed a method of materializing views based on queries of time period. The method of materializing views based on queries of time period can meet the needs of clients, and enhance the efficiency of queries.
作者 于翔 印桂生
出处 《计算机应用》 CSCD 北大核心 2009年第10期2772-2773,2777,共3页 journal of Computer Applications
基金 国家863计划项目(2007AA01Z401) 国家重点实验室基金项目
关键词 数据仓库 物化视图 查询 更新 data warehouse materialized view query refreshment
  • 相关文献

参考文献9

  • 1HARINARAYAN V, RAJARAMAN A, ULLMAN J D. Implementing data cubes efficiently[ J]. ACM SIGMOD Record, 1996, 25(2) : 205 - 216.
  • 2AGRAWAL R, GUPTA A, SARAWAGI S. Modeling multidimensional databases[ C]// ICDE' 97: Proceedings of the 13 th International Conference on Data Engineering. Birmingham: IEEE Computer Society Press, 1997:232 - 243.
  • 3BARALIS E, PARABOSCHI S, TENIENTE E. Materialized view selection in a multidimensional database[ C]//VLDB' 97: Proceedings of the 23 rd International Conference on Very Large Data Bases. Athens: Morgan Kaufmann Publishers, 1997:156 - 165.
  • 4SHUKLA A, DESHPANDE P, NAUGHTON J F. Materialized view selection for multidimensional datasets[ C]//VLDB' 98: Proceedings of the 24th International Conference on Very Large Data Bases. New York: Morgan Kaufmann Publishers, 1998:488-499.
  • 5GUPTA H, HARINARAYAN V, RAJARAMAN A, et al. Index selection for OLAP[ C]// ICDE' 97: Proceedings of the 13 th International Conference on Data Engineering. Birmingham: IEEE Computer Society Press, 1997:208 - 219.
  • 6谭红星,周龙骧.多维数据实视图的动态选择[J].软件学报,2002,13(6):1090-1096. 被引量:35
  • 7杨少军,范金存,李庆忠.数据仓库中物化视图的选择[J].计算机应用,2003,23(9):58-60. 被引量:11
  • 8严勇 袁晴晴 周皓峰 等.物化视图选择方法的研究.计算机科学,2003,30(10):251-254.
  • 9祁文文,徐彬,谭红星.数据方体中实视图的选择[J].河南大学学报(自然科学版),2001,31(1):20-24. 被引量:3

二级参考文献21

  • 1谭红星 祁文文 等.多维数据模型的比较与分析[J].兰州大学学报:自然科学版,1999,35:162-166.
  • 2Molina HG 杨冬青 唐世渭 徐其钧 等译.数据库系统实现[M].北京:机械工业出版社,Prentice Hall,2001..
  • 3InmonWH 王志海 等译.数据仓库[M].北京:机械工业出版社,2002..
  • 4Han J, Kambr M. Data Mining - Concepts and Techniques[M].Morgan Kaufmann Publishers; Higher Education Press, 2001.
  • 5Harinarayan V, Rajaraman A, Ullman JD. Implementing Data Cubes Efficiently[A]. Proc ACM SIGMOD'96[C], 1996.205 -216.
  • 6Yang J, Karlapalem K, Li Q. A Framework for Designing Materialized Views in Data Warehousing Environment[R]. Technical Report from Hong Kong University of Science and Technology, 1996.
  • 7Cheung DW, Zhou B, Kao B. Requirement-Based Data Cube Schema Design[A]. ACM CIIGM'99[C], 1999.
  • 8Mistry H, Roy P, Sudarshan S, et al. Materialized View Selection and Maintenance Using Multi-Query Optimization[A]. ACM SIGMOD[C], 2001.
  • 9Ross KA, Sirvastava D, Sudarshan S. Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time[A]. ACM SIGMOD'96[C]. 1996. 447 - 458.
  • 10谭红星,兰州大学学报,1999年,35卷,增刊,162页

共引文献42

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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