The Study on Indexing Techniques in Data Warehouse

被引:0
|
作者
Chen Li [1 ]
机构
[1] Hunan Vocat Coll Sci & Technol, Changsha, Hunan, Peoples R China
来源
关键词
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 条
  • [21] Study and application of data warehouse technology
    Gao, Y
    Li, P
    98 INTERNATIONAL CONFERENCE ON MANAGEMENT SCIENCE & ENGINEERING, PROCEEDINGS, 1998, : 13 - 17
  • [22] Research of Decision Support System Based on Data Warehouse Techniques
    Han, Qingtian
    Gao, Xiaoyan
    WKDD: 2009 SECOND INTERNATIONAL WORKSHOP ON KNOWLEDGE DISCOVERY AND DATA MINING, PROCEEDINGS, 2009, : 215 - +
  • [23] The study of indexing techniques on object oriented databases
    Huang, YF
    Chen, JM
    INFORMATION SCIENCES, 2000, 130 (1-4) : 109 - 131
  • [24] Application of Data Warehouse Techniques in Enterprise Decision Support System
    Han, Qingtian
    Gao, Xiaoyan
    9TH INTERNATIONAL CONFERENCE ON COMPUTER-AIDED INDUSTRIAL DESIGN & CONCEPTUAL DESIGN, VOLS 1 AND 2: MULTICULTURAL CREATION AND DESIGN - CAID& CD 2008, 2008, : 1116 - +
  • [25] Design of A Data Warehouse for Medical Information System Using Data Mining Techniques
    Farooqui, Nafees Akhter
    Mehra, Ritika
    2018 FIFTH INTERNATIONAL CONFERENCE ON PARALLEL, DISTRIBUTED AND GRID COMPUTING (IEEE PDGC), 2018, : 199 - 203
  • [26] TECHNIQUES FOR DATA WAREHOUSE MODELING IN CONTEXT OF AGILE BUSINESS INTELLIGENCE
    Nemec, Radek
    SOFTWARE DEVELOPMENT 2012, 2012, : 77 - 83
  • [27] The study and application of data mining and data warehouse in CIMS
    Zhou, LJ
    Liu, C
    Liu, DX
    DATA MINING AND KNOWLEDGE DISCOVERY: TOOLS AND TECHNOLOGY V, 2003, 5098 : 272 - 278
  • [28] Study of MIS based on data warehouse & data mining
    Zhao, JH
    PROCEEDINGS OF THE SEVENTH INTERNATIONAL CONFERENCE ON INDUSTRIAL ENGINEERING AND ENGINEERING MANAGEMENT, 2000, : 328 - 330
  • [29] Data Extraction of XML Files using Searching and Indexing Techniques
    Satpute, Sushma
    Katkar, Vaishali
    Sahare, Nilesh
    PROCEEDINGS OF WORLD ACADEMY OF SCIENCE, ENGINEERING AND TECHNOLOGY, VOL 29, 2008, 29 : 408 - 414
  • [30] A survey on indexing techniques for big data: taxonomy and performance evaluation
    Gani, Abdullah
    Siddiqa, Aisha
    Shamshirband, Shahaboddin
    Hanum, Fariza
    KNOWLEDGE AND INFORMATION SYSTEMS, 2016, 46 (02) : 241 - 284