The Study on Indexing Techniques in Data Warehouse

Li Chen

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

Paper Titles

A Improved Topics Search Algorithm Based on PSO Strategy for Web Mining
p.1481

The Scheduling Algorithm of Grid Task Based on PSO and Cloud Model
p.1487

A Novel Binary Differential Evolution for Discrete Optimization
p.1493

A Supporting Framework for Real-Time Data Mining
p.1499

The Study on Indexing Techniques in Data Warehouse
p.1505

Digital Generation ──The Diversified Impact of Digital on Architecture
p.1511

Measurement of Two-Phase Flow Parameters and Image Reconstruction Based on Weighted SVD Truncated Conjugate Gradient Algorithm
p.1516

Research on Physical Network Education Teaching Resources Construction and Knowledge Management Technology
p.1522

Discussion about Desulfurization Technology and Management
p.1528

HomeKey Engineering MaterialsKey Engineering Materials Vols. 439-440The Study on Indexing Techniques in Data Warehouse

The Study on Indexing Techniques in Data Warehouse

Abstract:

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.

You might also be interested in these eBooks

View Preview

Info:

Periodical:

Key Engineering Materials (Volumes 439-440)

Pages:

1505-1510

DOI:

https://doi.org/10.4028/www.scientific.net/KEM.439-440.1505

Citation:

Cite this paper

Online since:

June 2010

Authors:

Li Chen

Keywords:

Bitmap Index, Cluster Index, Data Warehouse (DW), Hash Index

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] S. Vanichayobon, Le Gruenwald, Indexing techniques for data warehouses' queries, Business Intelligence Community Academic Articles, December (2004).

Google Scholar

[2] M. A. Poolet, Indexing the data warehouse, SQL server magazine August (2008).

Google Scholar

[3] A. Abdullah, A brief introduction to data mining, August (2008).

Google Scholar

[4] http: /download-east. oracle. com/docs/html/A76994_01/indexes. htm.

Google Scholar

[5] S. B. Davidson, Indexing, Sorting and Hashing, October 23, 2008, www. seas. upenn. edu/~cse330/docs/14-Indexing. ppt (visited date: may 6, 2009).

Google Scholar

[6] A. Aizawa, A method of cluster-based indexing of textual data, In Proceedings of the 19thinternational conference on Computational linguistics - Volume 1, International Conference On Computational Linguistics, Taipei, Taiwan, pp.1-7, (2002).

DOI: 10.3115/1072228.1072273

Google Scholar