Evaluating NoSQL Systems for Decision Support: An Experimental Approach

被引:0
|
作者
Llano-Rios, Tomas F. [1 ]
Khalefa, Mohamed [2 ]
Badia, Antonio [1 ]
机构
[1] Univ Louisville, Louisville, KY 40208 USA
[2] SUNY Coll Old Westbury, Old Westbury, NY 11568 USA
关键词
D O I
10.1109/BigData50022.2020.9377881
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
We design and implement an experimental analysis comparing two relational systems (PostgreSQL and MariaDB) and two document-based NoSQL systems (MongoDB and CouchBase). We compare their performance on a single server, Decision Support (DSS) scenario. We argue that DSS is becoming an important case study for NoSQL. We experiment with several database designs and several query translations in order to investigate the effect of physical design and query optimization in documentbased stores. Our results show that design is very important for MongoDB's performance, and that query optimization over documents is much less sophisticated on documentbased stores than in relational data bases and needs to improve. Our results also offer some ideas to guide further development in this area.
引用
收藏
页码:2802 / 2811
页数:10
相关论文
共 50 条
  • [1] Experimental Comparison of Relational and NoSQL Document Systems: The Case of Decision Support
    Llano-Rios, Tomas F.
    Khalefa, Mohamed
    Badia, Antonio
    [J]. PERFORMANCE EVALUATION AND BENCHMARKING (TPCTC 2020), 2021, 12752 : 58 - 74
  • [2] Evaluating Decision Support Systems
    Boukhayma, Khaoula
    ElManouar, Abdellah
    [J]. 2015 15TH INTERNATIONAL CONFERENCE ON INTELLIGENT SYSTEMS DESIGN AND APPLICATIONS (ISDA), 2015, : 404 - 408
  • [3] THE ROLE OF AN EXPERIMENTAL APPROACH IN THE DESIGN OF DECISION SUPPORT SYSTEMS
    GUITIERREZ, O
    [J]. KNOWLEDGE-BASED MANAGEMENT SUPPORT SYSTEMS, 1989, : 183 - 197
  • [4] FROM NOSQL DATABASES TO DECISION SUPPORT SYSTEMS: DEVELOPING A BUSINESS INTELLIGENCE SOLUTION
    Pereira, Jose Luis
    Costa, Marco
    [J]. INTERNATIONAL JOURNAL FOR QUALITY RESEARCH, 2019, 13 (04) : 769 - 781
  • [5] A group decision support approach to evaluating journals
    Turban, E
    Zhou, DN
    Ma, H
    [J]. INFORMATION & MANAGEMENT, 2004, 42 (01) : 31 - 44
  • [6] USING AND EVALUATING ADMINISTRATIVE DECISION SUPPORT SYSTEMS
    KING, WR
    [J]. NEW DIRECTIONS FOR HIGHER EDUCATION, 1981, (35) : 63 - 71
  • [7] Decision Support Systems for evaluating urban regeneration
    Bottero, Marta
    Mondini, Giulio
    Oppio, Alessandra
    [J]. 2ND INTERNATIONAL SYMPOSIUM NEW METROPOLITAN PERSPECTIVES - STRATEGIC PLANNING, SPATIAL PLANNING, ECONOMIC PROGRAMS AND DECISION SUPPORT TOOLS, THROUGH THE IMPLEMENTATION OF HORIZON/EUROPE2020, (ISTH2020), 2016, 223 : 923 - 928
  • [8] A Multicriteria Analysis Approach for Evaluating the Performance of Agriculture Decision Support Systems for Sustainable Agribusiness
    Duan, Sophia Xiaoxia
    Wibowo, Santoso
    Chong, Josephine
    [J]. MATHEMATICS, 2021, 9 (08)
  • [9] Can clinical decision support systems be an asset in medical education? An experimental approach
    Kafke, Sean D. D.
    Kuhlmey, Adelheid
    Schuster, Johanna
    Blueher, Stefan
    Czimmeck, Constanze
    Zoellick, Jan C. C.
    Grosse, Pascal
    [J]. BMC MEDICAL EDUCATION, 2023, 23 (01)
  • [10] A psychological approach to decision support systems
    Hoch, SJ
    Schkade, DA
    [J]. MANAGEMENT SCIENCE, 1996, 42 (01) : 51 - 64