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
来源：
2020 IEEE INTERNATIONAL CONFERENCE ON BIG DATA (BIG DATA) | 2020年
关键词：
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 条
  • [41] Influence Diagrams: Predictive Approach in Decision Support Systems
    Hosseinian-Far, Amin
    Pimenidis, Elias
    Jahankhani, Hamid
    [J]. STRATEGIC MANAGEMENT, 2012, 17 (04): : 16 - 22
  • [42] The scientific approach to problem solving and decision support systems
    Ho, JKK
    Sculli, D
    [J]. INTERNATIONAL JOURNAL OF PRODUCTION ECONOMICS, 1997, 48 (03) : 249 - 257
  • [43] Developing intelligent decision support systems: A bipartite approach
    Gachet, A
    Haettenschwiler, P
    [J]. KNOWLEDGE-BASED INTELLIGNET INFORMATION AND ENGINEERING SYSTEMS, PT 2, PROCEEDINGS, 2003, 2774 : 87 - 93
  • [44] Decision support systems based on CLP approach in SMEs
    Tomczuk-Pirog, Izabela
    Wojcik, Robert
    Banaszak, Zbigniew
    [J]. 2006 IEEE CONFERENCE ON EMERGING TECHNOLOGIES & FACTORY AUTOMATION, VOLS 1 -3, 2006, : 1078 - +
  • [45] An associative memory approach to medical decision support systems
    Aldape-Perez, Mario
    Yanez-Marquez, Cornelio
    Camacho-Nieto, Oscar
    Argueelles-Cruz, Amadeo J.
    [J]. COMPUTER METHODS AND PROGRAMS IN BIOMEDICINE, 2012, 106 (03) : 287 - 307
  • [46] A RESTful Approach for Developing Medical Decision Support Systems
    Weller, Tobias
    Maleshkova, Maria
    Maerz, Keno
    Maier-Hein, Lena
    [J]. SEMANTIC WEB: ESWC 2015 SATELLITE EVENTS, 2015, 9341 : 376 - 384
  • [47] An Options Approach for Decision Support of Systems With Prognostic Capabilities
    Haddad, Gilbert
    Sandborn, Peter A.
    Pecht, Michael G.
    [J]. IEEE TRANSACTIONS ON RELIABILITY, 2012, 61 (04) : 872 - 883
  • [48] A critical systems approach to decision support for process engineering
    Basson, Lauren
    Petrie, Jim
    [J]. COMPUTERS & CHEMICAL ENGINEERING, 2007, 31 (08) : 876 - 888
  • [49] Hycones: A hybrid approach to designing decision support systems
    Leao, BD
    Reategui, EB
    Guazzelli, A
    Mendonca, EA
    [J]. M D COMPUTING, 1996, 13 (02): : 160 - 164
  • [50] An object relational approach for the design of decision support systems
    Srinivasan, A
    Sundaram, D
    [J]. EUROPEAN JOURNAL OF OPERATIONAL RESEARCH, 2000, 127 (03) : 594 - 610
12345