Database system query method, server and energy consumption test system

Abstract

Embodiments of the invention provide a database system query method, a server and an energy consumption test system. The method comprises: obtaining CPU power consumption and disk power consumption of a database system within an acquisition time and a training parameter of each physical operation of the database system within the acquisition time; according to the CPU power consumption and the disk power consumption, calculating actual power consumption of each physical operation, and performing regression analysis by taking the training parameter of each physical operation as an independent variable and the actual power consumption of each physical operation as a dependent variable to obtain a power consumption prediction function of each physical operation; and calculating the energy consumption cost of each execution plan of an SQL statement according to the power consumption prediction function of each physical operation. According to the method, the power consumption prediction function of each physical operation is obtained with the regression analysis method, so that the power consumption prediction function of each physical operation is more accurate. In addition, an adjustment factor is introduced to adjust the energy consumption cost and the time cost of a database, so that the energy consumption of the database system can be flexibly adjusted.

Description

technical field [0001] The embodiment of the present invention relates to database technology, in particular to a database system query method, server and energy consumption testing system. Background technique [0002] Building a low-carbon society has become a global consensus, and how to build a new database system with low cost and low energy consumption in the database system has become a crucial issue. The traditional database system only considers the performance optimization of the database system, without estimating the energy consumption cost of the database system. With the rise of data-centric computing models and the development of concepts such as big data, how to reduce the energy consumption of database systems has become a hot topic of widespread concern in academia and industry. [0003] In the prior art, a method for estimating energy consumption of a database system is proposed, in which it is assumed that the power consumption of each tuple and each dis...

AI Technical Summary

Problems solved by technology

[0004] However, the energy consumption estimation method in the prior art also has the following problems: in the prior art, it is assumed that the power consumption of each tuple or disk block is fixed, but recent studies have found that different physical operations have different power consumption, Even if the CPU utilization rates of two physical operations are the same, the power consumption difference can reach 60%. Therefore, the method in the prior art cannot accurately obtain the power consumption of each physical operation, so that the measured performance of the database system There is a big difference between the consumption value and the actual energy consumption value

Images