期刊文献+

Parallel Data Cube Storage Structure for Range Sum Queries and Dynamic Updates

Parallel Data Cube Storage Structure for Range Sum Queries and DynamicUpdates
原文传递
导出
摘要 I/O parallelism is considered to be a promising approach to achieving highperformance in parallel data warehousing systems where huge amounts of data and complex analyticalqueries have to be processed. This paper proposes a parallel secondary data cube storage structure(PHC for short) to efficiently support the processing of range sum queries and dynamic updates ondata cube using parallel computing systems. Based on PHC, two parallel algorithms for processingrange sum queries and updates are proposed also. Both the algorithms have the same time complexity,O(log^d n/P). The analytical and experimental results show that PHC and the parallel algorithms havehigh performance and achieve optimum speedup. I/O parallelism is considered to be a promising approach to achieving highperformance in parallel data warehousing systems where huge amounts of data and complex analyticalqueries have to be processed. This paper proposes a parallel secondary data cube storage structure(PHC for short) to efficiently support the processing of range sum queries and dynamic updates ondata cube using parallel computing systems. Based on PHC, two parallel algorithms for processingrange sum queries and updates are proposed also. Both the algorithms have the same time complexity,O(log^d n/P). The analytical and experimental results show that PHC and the parallel algorithms havehigh performance and achieve optimum speedup.
出处 《Journal of Computer Science & Technology》 SCIE EI CSCD 2005年第3期345-356,共12页 计算机科学技术学报(英文版)
基金 国家自然科学基金,黑龙江省自然科学基金
关键词 data warehouse parallel processing CUBE range query processing data warehouse parallel processing cube range query processing
  • 相关文献

参考文献1

二级参考文献8

  • 1Gray J, Bosworth A, Layman A, Pirahesh H. Data cube: A relational aggregation operator generating groupby, cross-tab and sub-total. In: Marek R, ed. Proceedings of the 12th ICDE. IEEE Press, 1996. 152-159.
  • 2Oeffner S, Agrawal D, Abbadi A, Smith T. Relative prefix sums: an efficient approach for querying dynamic OLAP data cubesIn:Alberto O, ed. Proceedings of the 15th International Conference on Data Engineering IEEE Press, 1999. 328~335.
  • 3Liang W, Wang H, Orlowska ME. Range queries in dynamic OLAP data cubes. Data and Knowledge Engineering,2000,34(1):21~38.
  • 4Ho CT, Agrawal R, Megiddo R, Srikant R. Range queries in OLAP data cubes In: Joan P, ed. Proceedings of the International ACM SIGMOD Conference. ACM Press, 1997.73~88.
  • 5Li HG, Ling TW, Lee SY, Loh ZX. Range sum queries in dynamic OLAP data Cubes. In: Lu HJ, Stefano Seds. Proceedings of the 3th International Symposium on Cooperative Database Systems for Advanced Applications (CODAS2001). IEEE Computer Society Press, 2001.74~81.
  • 6Chan CY, Ioannidis YE. Hierarchical cubes for range-sum queries In: Bassiouni A, ed. Proceedings of the 25th VLDB Conference.IEEE Press, 1999. 675-686.
  • 7Geffner S, Agrawal D, Abbadi AE The dynamic data cube. In: Zaniolo C, Lockemann PC, Scholl NH, Grust T, eds. Proceedingsof the EDBT. LNCS 1777, Heidelberg: Springe-Verlag, 2000. 55~77.
  • 8Chun S J, Chung C W, Lee J H, Lee S L. Dynamic update Cube for rangesum queries In: Peter MG, ed. Proceedings of the 27th VLDB Conference. IEEE Press, 2001. 521~530.

共引文献13

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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