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 条
  • [11] A psychological approach to decision support systems
    Hoch, SJ
    Schkade, DA
    [J]. MANAGEMENT SCIENCE, 1996, 42 (01) : 51 - 64
  • [12] 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)
  • [13] Can clinical decision support systems be an asset in medical education? An experimental approach
    Sean D. Kafke
    Adelheid Kuhlmey
    Johanna Schuster
    Stefan Blüher
    Constanze Czimmeck
    Jan C. Zoellick
    Pascal Grosse
    [J]. BMC Medical Education, 23
  • [14] EVALUATING DECISION SUPPORT AND EXPERT SYSTEMS - ADELMAN,L
    PICK, RA
    [J]. INTERFACES, 1993, 23 (01) : 135 - 136
  • [15] Clinical decision-support systems: Evaluating the evaluation
    Hornberger, J
    Goldstein, MK
    [J]. MEDICAL DECISION MAKING, 2000, 20 (01) : 130 - 131
  • [16] On proposing and evaluating a NoSQL document database logical approach
    Lima, Claudio
    Mello, Ronaldo Santos
    [J]. INTERNATIONAL JOURNAL OF WEB INFORMATION SYSTEMS, 2016, 12 (04) : 398 - 417
  • [17] A Novel Approach to Make Decision in Intelligent Decision Support systems
    Han, Yehong
    [J]. PROCEEDINGS OF THE 2017 2ND INTERNATIONAL CONFERENCE ON AUTOMATION, MECHANICAL CONTROL AND COMPUTATIONAL ENGINEERING (AMCCE 2017), 2017, 118 : 814 - 817
  • [18] EXPERT SYSTEMS-APPROACH TO DECISION SUPPORT
    LIGEZA, A
    [J]. EUROPEAN JOURNAL OF OPERATIONAL RESEARCH, 1988, 37 (01) : 100 - 110
  • [19] Service Oriented Approach for Decision Support Systems
    Nada, Ayman
    Nasr, Mona
    Salah, Marwa
    [J]. 2014 IEEE 7TH JOINT INTERNATIONAL INFORMATION TECHNOLOGY AND ARTIFICIAL INTELLIGENCE CONFERENCE (ITAIC), 2014, : 409 - 413
  • [20] A cooperative approach for intelligent decision support systems
    Zarate, P
    Rosenthal-Sabroux, C
    [J]. PROCEEDINGS OF THE THIRTY-FIRST HAWAII INTERNATIONAL CONFERENCE ON SYSTEM SCIENCES, VOL V: MODELING TECHNOLOGIES AND INTELLIGENT SYSTEMS TRACK, 1998, : 72 - 81