An Indexing Learning Tool in Relational Databases

被引:0
|
作者
Vjestica, Marko [1 ]
Kordic, Slavica [1 ]
Dimitrieski, Vladimir [1 ]
Celikovic, Milan [1 ]
Lukovic, Ivan [1 ]
机构
[1] Univ Novi Sad, Fac Tech Sci, Dept Comp & Control Engn, Trg Dositeja Obradov 6, Novi Sad 21000, Serbia
关键词
Learning tool; Database optimization; Indexing techniques; Data warehouse; Relational database;
D O I
暂无
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
There are multiple ways to optimize a query execution time in database systems, but one of the most usual ways is to use indexing techniques. In database courses at University of Novi Sad, Faculty of Technical Sciences, we teach students about these techniques and we want to improve lab sessions by providing them with as much knowledge in short amount of time. We have created Indexing Learning Tool (ILT) to help our students learn about indices and their usage in database systems. With this tool students can make fast changes in data structures and try different indexing techniques on different use cases. ILT provides new insights into the usage of indexing techniques, their advantages and disadvantages.
引用
收藏
页码:59 / 66
页数:8
相关论文
共 50 条
  • [31] INDEXING IN TEMPORAL DATABASES
    NOVIKOV, BA
    PROGRAMMING AND COMPUTER SOFTWARE, 1995, 21 (02) : 78 - 81
  • [32] RELATIONAL DATABASES
    BAKER, HG
    COMMUNICATIONS OF THE ACM, 1992, 35 (04) : 16 - &
  • [33] Probabilistic relational indexing
    Chou, YY
    Shapiro, LG
    FOURTEENTH INTERNATIONAL CONFERENCE ON PATTERN RECOGNITION, VOLS 1 AND 2, 1998, : 1331 - 1335
  • [35] STRING INDEXING - RELATIONAL INDEXING - INTRODUCTION AND INDEXING - FARRADANE,J
    RICHMOND, PA
    COLLEGE & RESEARCH LIBRARIES, 1979, 40 (03): : 293 - 294
  • [36] Serving Deep Learning Models with Deduplication from Relational Databases
    Zhou, Lixi
    Chen, Jiaqing
    Das, Amitabh
    Min, Hong
    Yu, Lei
    Zhao, Ming
    Zou, Jia
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2022, 15 (10): : 2230 - 2243
  • [37] Learning from Skewed Class Multi-relational Databases
    Guo, Hongyu
    Viktor, Herna L.
    FUNDAMENTA INFORMATICAE, 2008, 89 (01) : 69 - 94
  • [38] Supporting Collaborative Work on Ontology Learning from Relational Databases
    El Idrissi, Bouchra
    Baina, Salah
    Baina, Karim
    2015 IEEE/ACS 12TH INTERNATIONAL CONFERENCE OF COMPUTER SYSTEMS AND APPLICATIONS (AICCSA), 2015,
  • [39] Rules Driven Object-Relational Databases Ontology Learning
    Chen, Jia
    Wu, Yue
    Li, Ming
    Li, Shuquan
    You, Jing
    I-ESA 2009: INTERNATIONAL CONFERENCE ON INTEROPERABILITY FOR ENTERPRISE SOFTWARE AND APPLICATIONS CHINA, PROCEEDINGS, 2009, : 169 - +
  • [40] Learning Probabilistic Relational Models with (partially structured) Graph Databases
    El Abri, Marwa
    Leray, Philippe
    Essoussi, Nadia
    2017 IEEE/ACS 14TH INTERNATIONAL CONFERENCE ON COMPUTER SYSTEMS AND APPLICATIONS (AICCSA), 2017, : 256 - 263