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 条
  • [31] A survey on indexing techniques for big data: taxonomy and performance evaluation
    Abdullah Gani
    Aisha Siddiqa
    Shahaboddin Shamshirband
    Fariza Hanum
    Knowledge and Information Systems, 2016, 46 : 241 - 284
  • [32] Data Warehouse Architect: Migrating legacy data into a data warehouse
    DBMS, 7 (14):
  • [33] Transforming an operational system model to a data warehouse model: A survey of techniques
    Dori, D
    Feldman, R
    Sturm, A
    IEEE INTERNATIONAL CONFERENCE ON SOFTWARE - SCIENCE, TECHNOLOGY AND ENGINEERING, PROCEEDINGS, 2005, : 47 - 56
  • [34] Data Warehouse Discovery Framework: The Case Study
    Apanowicz, Cas
    DATABASE THEORY AND APPLICATION, BIO-SCIENCE AND BIO-TECHNOLOGY, 2010, 118 : 155 - 166
  • [35] Case study of ROLAP Enterprise Data Warehouse
    GoPaul, K
    Chung, PT
    Ghriga, M
    IKE '04: PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON INFORMATION AND KNOWLEDGE ENGNINEERING, 2004, : 344 - 352
  • [36] A Study of Multidimensional Modeling Approaches for Data Warehouse
    Yusof, Sharmila Mat
    Sidi, Fatimah
    Ibrahim, Hamidah
    Affendey, Lilly Suriani
    PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON APPLIED SCIENCE AND TECHNOLOGY 2016 (ICAST '16), 2016, 1761
  • [37] Comprehensive Study and Comparison of Information Retrieval Indexing Techniques
    Malki, Zohair
    INTERNATIONAL JOURNAL OF ADVANCED COMPUTER SCIENCE AND APPLICATIONS, 2016, 7 (01) : 132 - 140
  • [38] A chronological study of paradigms for data warehouse design
    Cravero, A.
    Sepulveda, S.
    INGENIERIA E INVESTIGACION, 2012, 32 (02): : 58 - 62
  • [39] Study on lowclass granularity data division strategy in data warehouse
    School of Computer Science and Engineering, Shenyang Institute of Aeronautical Engineering, Shenyang 110034, China
    不详
    Jisuanji Gongcheng, 2006, 17 (138-140):
  • [40] Study on Data Warehouse Based Equipment Support Data Management
    Xie, Feng
    Sun, Jiangsheng
    Liang, Weijie
    Dai, Dongsheng
    PROGRESS IN MECHATRONICS AND INFORMATION TECHNOLOGY, PTS 1 AND 2, 2014, 462-463 : 1072 - +
12345