含有SPREADSHEET子句的实化视图匹配  

Materialized View Matching with SPREADSHEET Clause

作　　者：颜文跃[1] 王元珍[1] 张晨静[1] 冯剑琳[1] 

机构地区：[1]华中科技大学计算机科学与技术学院,湖北武汉430074

出　　处：《小型微型计算机系统》2006年第3期507-511,共5页Journal of Chinese Computer Systems

基　　金：国家自然科学基金项目(60303030)资助;高等学校博士学科点专项科技基金课题(20030487032)资助.

摘　　要：含有SPREADSHEET子句的SQL语句,增强了传统SQL语句的多维计算能力.本文研究含有SPREADSHEET子句的实化视图匹配,利用实化数据加快spreadsheet查询的响应速度.文中提出了含有SPREADSHEET子句的视图匹配算法.实验结果表明,含有SPREADSHEET子句的视图匹配方法,具有良好的查询响应能力和良好的可扩展性.The capability of multi-dimensional computation of traditional SQL can be strengthened by the extended SPREADSHEET clause. Further, we combine the extended SQL clause with materialized-view to improve the response time of spreadsheet-queries. This paper gave the algorithm of materialized view matching with SPREADSHEET clause. Experimental results showed that materialized view matching with SPREADSHEET clause can speed up queries effectively and had outstanding scaly ability.

关 键 词：实化视图匹配 SPREADSHEET子句 spreadsheet查询 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]