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

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.