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 条
  • [41] A Framework for Improving Data Quality in Data Warehouse: A Case Study
    Ali, Taghrid Z.
    Abdelaziz, Tawfig M.
    Maatuk, Abdelsalam M.
    Elakeili, Salwa M.
    2020 21ST INTERNATIONAL ARAB CONFERENCE ON INFORMATION TECHNOLOGY (ACIT), 2020,
  • [42] A temporal study of data sources to load a corporate data warehouse
    Martín, C
    Abelló, A
    DATA WAREHOUSING AND KNOWLEDGE DISCOVERY, PROCEEDINGS, 2003, 2737 : 109 - 118
  • [43] The data warehouse
    Donaldson, WR
    AM/FM INTERNATIONAL CONFERENCE XX, PROCEEDINGS - ENTERING THE MAINSTREAM, 1997, : 21 - 29
  • [44] Techniques for video indexing
    Chen, CYR
    Meliksetian, DS
    Liu, LJ
    Chang, MCS
    MULTIMEDIA: FULL-SERVICE IMPACT ON BUSINESS, EDUCATION, AND THE HOME, 1996, 2617 : 70 - 80
  • [45] TECHNIQUES OF INDEXING PERIODICALS
    JONES, GC
    ASLIB PROCEEDINGS, 1961, 13 (04): : 103 - 106
  • [46] Data Warehouse
    Peter Gluchowski
    Informatik-Spektrum, 1997, 20 (1) : 48 - 49
  • [47] From Traditional Data Warehouse To Real Time Data Warehouse
    Bouaziz, Senda
    Nabli, Ahlem
    Gargouri, Faiez
    INTELLIGENT SYSTEMS DESIGN AND APPLICATIONS (ISDA 2016), 2017, 557 : 467 - 477
  • [48] Indexing techniques for power management in multi-attribute data broadcast
    Hu, QL
    Lee, WC
    Lee, DL
    MOBILE NETWORKS & APPLICATIONS, 2001, 6 (02): : 185 - 197
  • [49] Big IoT Data Indexing: Architecture, Techniques and Open Research Challenges
    Ferrag, Mohamed Amine
    Kouahla, Zineddine
    Seridi, Hamid
    Kurulay, Muhammet
    2019 4TH INTERNATIONAL CONFERENCE ON NETWORKING AND ADVANCED SYSTEMS (ICNAS 2019), 2019, : 140 - 145
  • [50] Indexing Techniques for Power Management in Multi-Attribute Data Broadcast
    Qinglong Hu
    Wang-Chien Lee
    Dik Lun Lee
    Mobile Networks and Applications, 2001, 6 : 185 - 197
12345