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
相关论文
共 50 条
  • [1] Comparative Study on Data Warehouse Evolution Techniques
    Thakur, Garima
    Gosain, Anjana
    ADVANCES IN COMPUTING AND COMMUNICATIONS, PT I, 2011, 190 : 691 - 703
  • [2] Indexing Spatial Objects in Stream Data Warehouse
    Gorawski, Marcin
    Malczok, Rafal
    ADVANCES IN INTELLIGENT INFORMATION AND DATABASE SYSTEMS, 2010, 283 : 53 - 65
  • [3] Comparative Study of Indexing Techniques for Data Dissemination in Wireless Environment
    Narvekar, Meera
    Lopes, Selifa
    Mantha, S. S.
    INTERNATIONAL CONFERENCE ON ADVANCED COMPUTING TECHNOLOGIES AND APPLICATIONS (ICACTA), 2015, 45 : 671 - 680
  • [4] The data warehouse toolkit: Practical techniques for building dimension data warehouse - Kimball,R
    Gillespie, T
    LIBRARY JOURNAL, 1996, 121 (13) : 102 - 102
  • [5] Data Warehouse Performance: Selected Techniques and Data Structures
    Wrembel, Robert
    BUSINESS INTELLIGENCE, 2012, 96 : 27 - 62
  • [6] Adapting data modeling techniques for data warehouse design
    Raisinghani, MS
    JOURNAL OF COMPUTER INFORMATION SYSTEMS, 2000, 40 (03) : 73 - 77
  • [7] A survey of image data indexing techniques
    Sharma, Saurabh
    Gupta, Vishal
    Juneja, Mamta
    ARTIFICIAL INTELLIGENCE REVIEW, 2019, 52 (02) : 1189 - 1266
  • [8] A survey of image data indexing techniques
    Saurabh Sharma
    Vishal Gupta
    Mamta Juneja
    Artificial Intelligence Review, 2019, 52 : 1189 - 1266
  • [9] Application of web and data warehouse techniques in DSS
    Lin, YZ
    Wang, K
    Shi, B
    DCABES 2002, PROCEEDING, 2002, : 369 - 371
  • [10] Data warehouse efficiency techniques with the SAS® system
    Brown, T
    PROCEEDINGS OF THE TWENTY-THIRD ANNUAL SAS USERS GROUP INTERNATIONAL CONFERENCE, 1998, : 484 - 493
12345