Experimental Comparison of Relational and NoSQL Document Systems: The Case of Decision Support

Experimental Comparison of Relational and NoSQL Document Systems: The Case of Decision Support

연구 분야: Databases

학회: Technology Conference on Performance Evaluation and Benchmarking

We design and implement an experimental analysis comparing a relational system (PostgreSQL) and two document-based NoSQL systems (MongoDB and Couchbase) 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 formulations in order to investigate the effect of physical design and query optimization in document-based stores. Our results show that design is very important for document stores performance, and that query optimization over documents is less sophisticated than in relational systems and needs to improve. Our results offer some guidance in this area.