The Study on Indexing Techniques in Data Warehouse

被引：0

作者：

Chen Li ^{[1
]}

机构：

[1] Hunan Vocat Coll Sci & Technol, Changsha, Hunan, Peoples R China

来源：

ADVANCED MEASUREMENT AND TEST, PARTS 1 AND 2 | 2010年 / 439-440卷

关键词：

Data Warehousing; Bitmap Index; Hash Index; Cluster Index;

D O I：

10.4028/www.scientific.net/KEM.439-440.1505

中图分类号：

TM [电工技术]; TN [电子技术、通信技术];

学科分类号：

0808 ; 0809 ;

摘要：

Nowadays, data warehouse has already become the hot spot in database studies. Indexes can potentially speed up a variety of operations in a data warehouse. In this paper, we present several relatively mature index techniques in data warehouse. Then, we give a comparison between them on performance evaluations. This paper focuses on the performance evaluation of three data warehouse queries with three different indexing techniques and to observe the impact of variable size data with respect to time and space complexity.

引用

页码：1505 / 1510

页数：6