Performance Analysis of PostgreSQL, MySQL, Microsoft SQL Server Systems Based on TPC-H Tests

I. S. Vershinin, Asia R. Mustafina

20212021 International Russian Automation Conference (RusAutoCon)21 citationsDOI

Abstract

The development of information technologies requires the processing of an increasing amount of information. A great number of tools and DBMSs for working with big data have been created. Examples of DBMS are: MS SQL Server, Oracle Database, SciDB, VoltDB, PostgreSQL XL, Clusterix, etc. Most systems of the BigData class require serious computing power to ensure acceptable performance. This article discusses the TPC-H test and 22 of its queries, the execution of which allows you to analyze the performance of database management systems (DBMS). PostgreSQL, MySQL, and Microsoft SQL Server DBMS are considered and their performance is investigated based on TPC-H test queries with database (DB) of various sizes in the DbVisualizer Free version 11.0.6.

Topics & Concepts

Computer scienceDatabaseOracleSql serverIn-Memory ProcessingUser-defined functionSQLOperating systemData Transformation ServicesLog shippingRelational database management systemServerRelational databaseWorld Wide WebQuery by ExampleClient–server modelProgramming languageSearch engineWeb search queryCloud Computing and Resource ManagementAdvanced Data Processing TechniquesGraph Theory and Algorithms