Efficiency has been a pivotal aspect of the software industry since its inception, as a system that serves the end-user fast, and the service provider cost-efficiently benefits all parties. A database management system (DBMS) is an integral part of effectively all software systems, and therefore it is logical that different studies have compared the performance of different DBMSs in hopes of finding the most efficient one. This study systematically synthesizes the results and approaches of studies that compare DBMS performance and provides recommendations for industry and research. The results show that performance is usually tested in a way that does not reflect real-world use cases, and that tests are typically reported in insufficient detail for replication or for drawing conclusions from the stated results.
翻译:自软件产业诞生以来,效率一直是其关键方面,因为一个既能快速响应用户需求又能为服务提供商带来成本效益的系统能使所有相关方获益。数据库管理系统(DBMS)是几乎所有软件系统中不可或缺的组成部分,因此,不同研究对各类数据库管理系统的性能进行比较,以期找到最高效的方案,这合乎逻辑。本研究系统性地综合了比较DBMS性能的研究成果与方法,并为产业界和学术界提供了建议。结果表明,性能测试通常采用的方式未能反映真实应用场景,且测试报告的详细程度往往不足以支持重复实验或从所述结果中得出可靠结论。