doi: 10.4304/jsw.6.5.857-865
An Efficient Method for Improving Query Efficiency in Data Warehouse
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.
Index Terms—Aggregation Table, Inverted Index, Bitmap Index, B-Tree Index
Cite: Zhiwei Ni, Junfeng Guo, Li Wang, Yazhuo Gao, "An Efficient Method for Improving Query Efficiency in Data Warehouse," Journal of Software vol. 6, no. 5, pp. 857-865, 2011.
General Information
ISSN: 1796-217X (Online)
Abbreviated Title: J. Softw.
Frequency: Biannually
APC: 500USD
DOI: 10.17706/JSW
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Cecilia Xie
Abstracting/ Indexing: DBLP, EBSCO,
CNKI, Google Scholar, ProQuest,
INSPEC(IET), ULRICH's Periodicals
Directory, WorldCat, etcE-mail: jsweditorialoffice@gmail.com
-
Mar 07, 2025 News!
Vol 19, No 4 has been published with online version [Click]
-
Mar 07, 2025 News!
JSW had implemented online submission system [Click]
-
Apr 01, 2024 News!
Vol 14, No 4- Vol 14, No 12 has been indexed by IET-(Inspec) [Click]
-
Apr 01, 2024 News!
Papers published in JSW Vol 18, No 1- Vol 18, No 6 have been indexed by DBLP [Click]
-
Oct 22, 2024 News!
Vol 19, No 3 has been published with online version [Click]