Volume 6 Number 5 (May 2011)
Home > Archive > 2011 > Volume 6 Number 5 (May 2011) >
JSW 2011 Vol.6(5): 857-865 ISSN: 1796-217X
doi: 10.4304/jsw.6.5.857-865

An Efficient Method for Improving Query Efficiency in Data Warehouse

Zhiwei Ni, Junfeng Guo, Li Wang, Yazhuo Gao
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.

Index Terms—Aggregation Table, Inverted Index, Bitmap Index, B-Tree Index

[PDF]

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
Frequency: Monthly
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, ProQuest, INSPEC, ULRICH's Periodicals Directory, WorldCat, CNKI,etc
E-mail: jsw@iap.org
  • Jan 11, 2019 News!

    Papers published in JSW Vol. 13, No. 1- Vol. 13 No. 12 have been indexed by DBLP.    [Click]

  • Aug 24, 2018 News!

    Vol.12, No.8- Vol.13, No.5 has been indexed by EI (Inspec).   [Click]

  • Aug 01, 2018 News!

    [CFP] 2019 the annual meeting of JSW Editorial Board, ICCSM 2019, will be held in Barcelona, Spain, July 14-16, 2019.   [Click]

  • Jan 15, 2019 News!

    Welcome Prof. Timothy J Arndt from USA to join the Editorial board of JSW   [Click]

  • Apr 03, 2019 News!

    Vol 14, No. 4 has been published with online version 4 original aritcles from 4 countries are published in this issue.    [Click]