doi: 10.4304/jsw.6.5.857-865
An Efficient Method for Improving Query Efficiency in Data Warehouse
- School of Management, Hefei University of Technology, Hefei , Anhui, China; Key Lab. of Process Optimization and Intelligent Decision-making, Ministry of Education, Hefei , Anhui, China
Abstract
There are lots of performance bottlenecks for real-time queries in mass data. Many methods can only improve the efficiency for frequently used queries, but it is not advisable to neglect the non-frequently used queries. This paper proposes a new integrated index model called BBI and illustrates the application of this model. Based on the feature of data warehouse and OLAP queries, this index model is built with inverted index, aggregation table, bitmap index and b-tree. It greatly promotes not only the efficiency of frequently used queries, but also the performance of other queries. The analytical and experimental results demonstrate the utility of BBI.
Keywords
- Aggregation Table
- Inverted Index
- Bitma
How to Cite
Zhiwei Ni, Junfeng Guo, Li Wang, and Yazhuo Gao, "An Efficient Method for Improving Query Efficiency in Data Warehouse," Journal of Software, vol. 6, no. 5, pp. 857-865, 2011. https://doi.org/ 10.4304/jsw.6.5.857-865
Copyright & License
Copyright © 2011 by the authors. This is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited (CC BY 4.0).