Calculation power evaluation method, electronic equipment, storage medium and program product

Abstract

The invention discloses a computing power evaluation method, electronic equipment, a storage medium and a program product. The method relates to the technical field of big data, and comprises the following steps: according to database dynamic views corresponding to a plurality of acquisition moments in a target time period, obtaining actual computing power required for executing database operation information at the corresponding acquisition moments; for each piece of database operation information, determining a calculation power proportion corresponding to the database operation information in the target time period according to actual calculation power required for executing the database operation information at each acquisition moment; and according to the computing power proportion corresponding to each piece of database operation information in the target time period, the full-load computing power of the database and the resource utilization rate corresponding to the target time period, determining evaluation computing power required for executing the database operation information in the target time period. According to the scheme provided by the invention, the computing power required for executing the database operation information can be accurately evaluated, a data basis is provided for construction and migration of the database, and the overall performance and stability of the system are ensured.

Description

Technical Field

[0001] The present invention relates to the field of big data technology, and in particular to a computing power evaluation method, electronic equipment, storage medium and program product. Background Art

[0002] The financial industry is a data-intensive industry that has accumulated a large amount of transaction data, customer data, and market data. Databases provide financial institutions with a platform for storing, managing, and retrieving this data.

[0003] When a database is being built or migrated, computing power evaluation is usually required. Existing computing power evaluation methods mainly include: benchmarking method and load testing method. Among them, the benchmarking method evaluates database performance by running a predefined workload, which may lead to inaccurate evaluation due to the predefined workload being too single; the load testing method evaluates database performance by simulating actual user loads. This method requires a lot of resources to simulate high loads, which will affect system performance. Summary of the invention

[0004] The present invention provides a computing power evaluation method, electronic device, storage medium and program product, which can accurately evaluate the computing power required to execute database operation information, provide a data basis for database construction and migration, and ensure the overall performance and stability of the system.

[0005] According to one aspect of the present invention, a computing power evaluation method is provided, comprising: obtaining actual computing power required to execute database operation information at corresponding collection moments according to a database dynamic view corresponding to several collection moments within a target time period; for each database operation information, determining the computing power proportion corresponding to the database operation information in the target time period according to the actual computing power required to execute the database operation information at each collection moment; determining the evaluation computing power required to execute the database operation information in the target time period according to the computing power proportion corresponding to each database operation information in the target time period, the full load computing power of the database and the resource utilization rate corresponding to the target time period.

[0006] Optionally, the database operation information includes database query statements and / or database stored procedures.

[0007] Optionally, based on the actual computing power required to execute the database operation information at each collection moment, the computing power ratio corresponding to the database operation information in the target time period is determined, including: taking any two collection moments among a number of collection moments as a moment group, and calculating the interval ratio of each moment group according to the actual computing power required to execute the database operation information at each collection moment; and determining the computing power ratio corresponding to the database operation information in the target time period according to all interval ratios.

[0008] Optionally, in the case where the database operation information is a database query statement, the interval ratio of any moment group is equal to the ratio of the relative computing power of the moment group to the comprehensive computing power of the database query statement; in the case where the database operation information is a database stored procedure, the interval ratio of any moment group is equal to the ratio of the relative computing power of the moment group to the comprehensive computing power of the database stored procedure; wherein, the relative computing power of the moment group is equal to the difference between the actual computing powers required to execute the database operation information at the two collection moments included in the moment group; the comprehensive computing power of the database query statement is equal to the sum of the actual computing powers required to execute the database query statement at all collection moments; the comprehensive computing power of the database stored procedure is equal to the sum of the actual computing powers required to execute the database stored procedure at all collection moments.

[0009] Optionally, when the database operation information includes database query statements, the evaluated computing power required to execute the database operation information in the target time period is determined based on the computing power ratio corresponding to each database operation information in the target time period, the full load computing power of the database, and the resource utilization rate corresponding to the target time period, including: determining the evaluated computing power required to execute each database query statement in the target time period based on the computing power ratio corresponding to each database query statement in the target time period, the full load computing power, and the resource utilization rate.

[0010] Optionally, when the database operation information includes database stored procedures, the assessed computing power required to execute the database operation information in the target time period is determined based on the computing power ratio corresponding to each database operation information in the target time period, the full load computing power of the database, and the resource utilization rate corresponding to the target time period, including: determining the calling relationship between all database stored procedures; determining the total computing power ratio corresponding to all database stored procedures based on the calling relationship and the computing power ratio corresponding to each database stored procedure in the target time period; determining the assessed computing power required to execute all database stored procedures in the target time period based on the total computing power ratio, the full load computing power, and the resource utilization rate.

[0011] Optionally, the total computing power ratio corresponding to all database stored procedures is determined based on the call relationship and the computing power ratio corresponding to each database stored procedure in the target time period, including: separately determining the target stored procedure at the top level of each call relationship; filtering out the target ratio corresponding to the target stored procedure from the computing power ratio corresponding to each database stored procedure in the target time period; and determining the total computing power ratio corresponding to all database stored procedures based on the target ratio corresponding to the target stored procedure.

[0012] According to another aspect of the present invention, an electronic device is provided, comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the computing power evaluation method of any embodiment of the present invention.

[0013] According to another aspect of the present invention, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer instructions, and the computer instructions are used to implement the computing power evaluation method of any embodiment of the present invention when executed by a processor.

[0014] According to another aspect of the present invention, a computer program product is provided. The computer program product includes a computer program. When the computer program is executed by a processor, the computing power evaluation method of any embodiment of the present invention is implemented.

[0015] The technical solution of the embodiment of the present invention collects the database dynamic view corresponding to several collection moments within the target time period, and obtains the actual computing power required to execute the database operation information at the corresponding collection moment based on the database dynamic view; then realizes the analysis of each database operation information, determines the computing power proportion corresponding to each database operation information in the target time period; then combines the full load computing power of the database and the resource utilization rate corresponding to the target time period, and determines the evaluation computing power required to execute the database operation information in the target time period. Compared with the traditional computing power evaluation method, on the first hand, the present invention evaluates the computing power based on the database dynamic view, and the database dynamic view reflects the real-time operation status of the database, avoiding the problem of inaccurate evaluation that may exist in evaluating the database performance by running a predefined workload, and at the same time, there is no need to consume additional resources to simulate the load, and will not increase the system burden. On the second hand, by executing the actual computing power required for the database operation information at each collection moment, determining the computing power proportion corresponding to the database operation information in the target time period, the computing power information with the moment as the granularity can be converted into the computing power information with the time period as the granularity, so that the evaluation result is more accurate and more suitable for describing the business situation in different time periods. Thirdly, database operation information includes database query statements and / or database stored procedures, which realizes information decoupling and provides a data basis for database construction, migration and even subsequent tuning, thereby realizing database pressure reduction, thereby ensuring the overall performance and stability of the system.

[0016] It should be understood that the contents described in this section are not intended to identify the key or important features of the embodiments of the present invention, nor are they intended to limit the scope of the present invention. Other features of the present invention will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0018] Figure 1 It is a flowchart of a computing power evaluation method provided by an embodiment of the present invention;

[0019] Figure 2 is a flowchart of another computing power evaluation method provided by an embodiment of the present invention;

[0020] Figure 3 is a structural schematic diagram of a computing power evaluation device provided by an embodiment of the present invention;

[0021] Figure 4 It is a structural schematic diagram of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0022] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0023] It should be noted that the terms "target", "actual", "assessment", "relative", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0024] Figure 1This is a flow chart of a computing power evaluation method provided by an embodiment of the present invention. This embodiment is applicable to the case of evaluating the computing power of a database. The method can be executed by a computing power evaluation device. The computing power evaluation device can be implemented in the form of hardware and / or software. The computing power evaluation device can be configured in an electronic device (such as a database, server, computer device, etc.). Figure 1 As shown, the method includes:

[0025] S110. According to the database dynamic views corresponding to several collection moments within the target time period, the actual computing power required to execute the database operation information at the corresponding collection moments is obtained.

[0026] In the present invention, the number of target time periods may be one or more. When the number of target time periods is more than one, the computing power evaluation method provided by the present invention may be executed once for each target time period. The more target time periods there are, the more data can be provided for the subsequent construction and migration of the database. The length of the target time period may also be set according to actual needs.

[0027] For example, assuming that a financial database is used as an example, 24 hours is an analysis cycle, and the number of target time periods in an analysis cycle is 12, namely 10:00:01-10:15:00, 10:15:01-10:30:00, 10:30:01-10:45:00, 10:45:01-11:00:00, 14:00:01-1 4:15:00, 14:15:01-14:30:00, 14:30:01-14:45:00, 14:45:01-15:00:00, 18:00:01-18:15:00, 18:15:01-18:30:00, 18:30:01-18:45:00, 18:45:01-19:00:00. By executing the computing power evaluation method provided by the present invention once for each target time period, the database computing power at 10-11 am, 14-15 pm and 18-19 pm can be analyzed.

[0028] A target time period includes several collection moments. The more collection moments included in a target time period, the more accurate the computing power determined in the subsequent steps. Optionally, the collection moments included in a target time period are evenly distributed, so that balanced collection of dynamic views of the database can be guaranteed.

[0029] Database dynamic view, also known as database dynamic performance view, is a logical structure of the database. Database dynamic view allows users to view and operate data in the database in different ways, making data operations more flexible and efficient.

[0030] In one embodiment, the dynamic view of the database may be obtained by printing a job task report, or may be collected at a corresponding collection time by a preset collection statement, and the embodiment of the present invention does not impose any specific limitation on this.

[0031] The database dynamic view is used to represent the actual computing power required to execute the database operation information at the corresponding collection time. Therefore, after obtaining the database dynamic view, by analyzing the database dynamic view, the actual computing power required to execute the database operation information at the corresponding collection time can be obtained.

[0032] For example, suppose there are three database operation information, namely database operation information 1, database operation information 2, and database operation information 3. The number of database dynamic views is 2, that is, database dynamic views Figure 1 Corresponding to the collection time 1, the database dynamic view Figure 2 Corresponding to the collection time 2. Then, by dynamically viewing the database Figure 1 Through analysis, we can obtain the actual computing power a required to execute database operation information 1 at collection time 1, the actual computing power b required to execute database operation information 2 at collection time 1, the actual computing power c required to execute database operation information 1 at collection time 2, and the actual computing power d required to execute database operation information 2 at collection time 2.

[0033] In one embodiment, the database operation information includes database query statements and / or database stored procedures. A database query statement is a command to retrieve data from a database, and a database stored procedure is a set of commands precompiled and stored in a database to perform a specific task. A database stored procedure may include one or more database query statements, or may not include a database query statement.

[0034] S120. For each database operation information, determine the computing power proportion corresponding to the database operation information in the target time period according to the actual computing power required to execute the database operation information at each collection moment.

[0035] In step S120, for each database operation information, it is necessary to determine the computing power ratio corresponding to the database operation information in the target time period. The method for determining the computing power ratio includes the following two steps:

[0036] Step a1: Take any two collection moments from a number of collection moments as a moment group, and calculate the interval proportion of each moment group according to the actual computing power required to execute the database operation information at each collection moment.

[0037] Assume that there are 4 collection moments, namely, collection moment 1, collection moment 2, collection moment 3, and collection moment 4. Taking any two of these 4 collection moments as a moment group, 6 moment groups can be obtained. Moment group 1: collection moment 1 + collection moment 2; moment group 2: collection moment 1 + collection moment 3; moment group 3: collection moment 1 + collection moment 4; moment group 4: collection moment 2 + collection moment 3; moment group 5: collection moment 2 + collection moment 4; moment group 6: collection moment 3 + collection moment 4. According to the actual computing power required to execute the database operation information at each collection moment, the interval proportion of each moment group is calculated respectively, and a total of 6 interval proportions are obtained.

[0038] Step a2: Determine the computing power proportion corresponding to the database operation information in the target time period based on the proportion of all intervals.

[0039] Specifically, the computing power proportion corresponding to the database operation information in the target time period can be any of the following: the average of all interval proportions, the maximum value of all interval proportions, the minimum value of all interval proportions, and the weighted value of all interval proportions.

[0040] S130. Determine the evaluation computing power required to execute the database operation information in the target time period according to the computing power ratio corresponding to each database operation information in the target time period, the full load computing power of the database, and the resource utilization rate corresponding to the target time period.

[0041] The full-load computing power reflects the upper limit of the computing power of the database when it is fully loaded. Usually, the full-load computing power is related to the model of the database.

[0042] Since database operation information includes database query statements and / or database stored procedures, database query statements are usually independent of each other, while there may be calling relationships between database stored procedures. Therefore, in order to ensure the accuracy of computing power evaluation, it is necessary to determine the evaluation computing power required to execute the database operation information in the target time period for different database operation information.

[0043] Specifically, the specific type of database operation information can be first determined (i.e., whether the database operation information includes only database query statements, only database stored procedures, or both database query statements and database stored procedures), and then, based on the specific type of database operation information, it can be determined whether there is a call relationship between the database operation information. If there is no call relationship, the evaluation computing power required to execute the database operation information in the target time period can be directly determined based on the computing power ratio corresponding to each database operation information in the target time period, the full load computing power of the database, and the resource utilization rate corresponding to the target time period; if there is a call relationship, it is necessary to eliminate the repeated calls, and then determine the evaluation computing power required to execute the database operation information in the target time period based on the computing power ratio corresponding to each database operation information in the target time period, the full load computing power of the database, and the resource utilization rate corresponding to the target time period.

[0044] The embodiment of the present invention provides a computing power evaluation method, including: according to the database dynamic views corresponding to several collection moments within the target time period, obtaining the actual computing power required to execute the database operation information at the corresponding collection moment; for each database operation information, according to the actual computing power required to execute the database operation information at each collection moment, determining the computing power proportion corresponding to the database operation information in the target time period; according to the computing power proportion corresponding to each database operation information in the target time period, the full load computing power of the database and the resource utilization rate corresponding to the target time period, determining the evaluation computing power required to execute the database operation information in the target time period. The technical solution of the embodiment of the present invention collects the database dynamic views corresponding to several collection moments within the target time period, and obtains the actual computing power required to execute the database operation information at the corresponding collection moment based on the database dynamic views; then realizes the analysis of each database operation information, determines the computing power proportion corresponding to each database operation information in the target time period; then combines the full load computing power of the database and the resource utilization rate corresponding to the target time period to determine the evaluation computing power required to execute the database operation information in the target time period. Compared with the traditional computing power evaluation method, on the first aspect, the present invention evaluates computing power based on the dynamic view of the database. The dynamic view of the database reflects the real-time operating status of the database, avoiding the problem of inaccurate evaluation that may exist when evaluating database performance by running predefined workloads. At the same time, there is no need to consume additional resources to simulate the load, and the system burden will not be increased. On the second aspect, by executing the actual computing power required for the database operation information at each collection moment, the computing power proportion corresponding to the database operation information in the target time period is determined, and the computing power information with the granularity of the moment can be converted into the computing power information with the granularity of the time period, so that the evaluation results are more accurate and more suitable for describing the business conditions in different time periods. On the third aspect, the database operation information includes database query statements and / or database stored procedures, which realizes information decoupling, provides a data basis for the construction, migration and even subsequent tuning of the database, and then realizes database decompression, thereby ensuring the overall performance and stability of the system.

[0045] Figure 2 FIG. 1 is a flow chart of another computing power evaluation method provided by an embodiment of the present invention. Based on the above embodiment, this embodiment provides a specific method for computing power evaluation when the database operation information includes database query statements and database stored procedures. Figure 2 As shown, the method includes:

[0046] S210. According to the database dynamic views corresponding to several collection moments within the target time period, the actual computing power required to execute the database operation information at the corresponding collection moments is obtained.

[0047] In the present invention, the number of target time periods may be one or more. When the number of target time periods is more than one, the computing power evaluation method provided by the present invention may be executed once for each target time period. The more target time periods there are, the more data can be provided for the subsequent construction and migration of the database. The length of the target time period may also be set according to actual needs.

[0048] A target time period includes several collection moments. The more collection moments included in a target time period, the more accurate the computing power determined in the subsequent steps. Optionally, the collection moments included in a target time period are evenly distributed, so that balanced collection of dynamic views of the database can be guaranteed.

[0049] Database dynamic view is a logical structure of the database. Database dynamic view allows users to view and operate the data in the database in different ways, making data operations more flexible and efficient.

[0050] In this embodiment, the database dynamic view can be collected at the corresponding collection time through a preset collection statement.

[0051] In one embodiment, the database operation information includes database query statements and / or database stored procedures. A database query statement is a command to retrieve data from a database, and a database stored procedure is a set of commands precompiled and stored in a database to perform a specific task.

[0052] Exemplarily, in this embodiment, the database operation information includes 3 database query statements and 5 database stored procedures, which are respectively recorded as statement 1, statement 2 and statement 3, stored procedure 1, stored procedure 2, stored procedure 3, stored procedure 4 and stored procedure 5. The number of database dynamic views is n (n is an integer greater than or equal to 2). Then, by analyzing the database dynamic view i (i=1,2,3,…,n), the actual computing power required to execute statement 1 at the collection time i, the actual computing power required to execute statement 2 at the collection time i, the actual computing power required to execute statement 3 at the collection time i, the actual computing power required to execute stored procedure 1 at the collection time i, the actual computing power required to execute stored procedure 2 at the collection time i, the actual computing power required to execute stored procedure 3 at the collection time i, the actual computing power required to execute stored procedure 4 at the collection time i, and the actual computing power required to execute stored procedure 5 at the collection time i can be obtained.

[0053] S220: For each database operation information, any two collection moments among a number of collection moments are taken as a moment group, and according to the actual computing power required to execute the database operation information at each collection moment, the interval proportion of each moment group is calculated respectively.

[0054] Optionally, in order to improve evaluation efficiency and reduce the amount of calculation, any two adjacent acquisition moments among a number of acquisition moments may be used as a moment group.

[0055] The interval proportion of the time group can be calculated according to the following rules:

[0056] Rule 1: When the database operation information is a database query statement, the interval ratio of any time group is equal to the ratio of the relative computing power of the time group to the comprehensive computing power of the database query statement.

[0057] Rule 2: When the database operation information is a database stored procedure, the interval ratio of any time group is equal to the ratio of the relative computing power of the time group to the comprehensive computing power of the database stored procedure.

[0058] Among them, the relative computing power of the moment group is equal to the difference between the actual computing powers required to execute the database operation information at the two collection moments included in the moment group; the comprehensive computing power of the database query statement is equal to the sum of the actual computing powers required to execute the database query statement at all collection moments; the comprehensive computing power of the database stored procedure is equal to the sum of the actual computing powers required to execute the database stored procedure at all collection moments.

[0059] Continuing with the above example, assuming that n collection moments can form n-1 moment groups, take the first moment group as an example, the first moment group includes collection moment 1 and collection moment 2. For statement 1, the interval ratio of the first moment group = (actual computing power required to execute statement 1 at collection moment 2 - actual computing power required to execute statement 1 at collection moment 1) / the sum of actual computing power required to execute all database query statements (i.e., statements 1 to 3) at all collection moments.

[0060] Similarly, for stored procedure 1, the interval ratio of the first time group = (the actual computing power required to execute stored procedure 1 at collection time 2 - the actual computing power required to execute stored procedure 1 at collection time 1) / the sum of the actual computing power required to execute all database stored procedures (i.e., stored procedure 1 to stored procedure 5) at all collection times.

[0061] S230. Determine the computing power proportion corresponding to the database operation information in the target time period according to the proportion of all intervals.

[0062] Specifically, the computing power proportion corresponding to the database operation information in the target time period can be any of the following: the average of all interval proportions, the maximum value of all interval proportions, the minimum value of all interval proportions, and the weighted value of all interval proportions.

[0063] Continuing with the above example, assuming that the computing power ratio of the database operation information in the target time period is the average of all interval ratios, then for statement 1, the computing power ratio of statement 1 in the target time period is equal to the average of the interval ratios of its n-1 groups of time groups. Similarly, for stored procedure 1, the computing power ratio of stored procedure 1 in the target time period is equal to the average of the interval ratios of its n-1 groups of time groups.

[0064] S240. For database query statements, determine the evaluation computing power required to execute each database query statement in the target time period based on the computing power proportion, full load computing power and resource utilization rate corresponding to each database query statement in the target time period.

[0065] The full-load computing power reflects the upper limit of the computing power of the database when it is fully loaded. Usually, the full-load computing power is related to the model of the database.

[0066] Continuing with the above example, assume that statement 1 accounts for 2% of the computing power in the target time period, statement 2 accounts for 3% of the computing power in the target time period, statement 3 accounts for 5% of the computing power in the target time period, the full load computing power is 1000, and the resource utilization rate in the target time period is 60%. Then the evaluation computing power required to execute statement 1 in the target time period is 1000*60%*2%=12; the evaluation computing power required to execute statement 2 in the target time period is 1000*60%*3%=18; the evaluation computing power required to execute statement 3 in the target time period is 1000*60%*5%=30.

[0067] In this way, the computing power required for each database query statement to be executed in the target time period can be evaluated. Each database query statement is independent and decoupled, which can facilitate subsequent database migration deployment and guide which functional modules should be built / migrated first.

[0068] S250: For database stored procedures, determine the calling relationship between all database stored procedures.

[0069] Since there may be calling relationships between database stored procedures, in order to ensure the accuracy of computing power evaluation, the database stored procedures need to be further processed.

[0070] Specifically, the calling relationships among all database stored procedures may be determined first. For example, the calling relationships among all database stored procedures may be determined based on a database configuration table or a storage call chain. The number of calling relationships may be one or more.

[0071] S260. Determine the total computing power share corresponding to all database storage procedures according to the call relationship and the computing power share corresponding to each database storage procedure in the target time period.

[0072] Specifically, the method of "determining the total computing power proportion corresponding to all database stored procedures according to the call relationship and the computing power proportion corresponding to each database stored procedure in the target time period" in step S260 may include the following three steps:

[0073] Step b1: Determine the target stored procedure at the top level of each call relationship.

[0074] Step b2: Filter out the target proportion corresponding to the target storage process from the computing power proportion corresponding to each database storage process in the target time period.

[0075] Continuing with the above example, assume that there are two call relationships between stored procedure 1 and stored procedure 5, namely call relationship 1 and call relationship 2. Call relationship 1: stored procedure 1 → stored procedure 2; call relationship 2: stored procedure 3 → stored procedure 4 → stored procedure 5. It can be seen from call relationship 1 and call relationship 2 that the target stored procedure at the top level of call relationship 1 is stored procedure 1, and the target stored procedure at the top level of call relationship 2 is stored procedure 3.

[0076] Therefore, the computing power proportion of storage process 1 in the target time period and the computing power proportion of storage process 3 in the target time period are the target proportions.

[0077] Step b3: Determine the total computing power ratio corresponding to all database stored procedures based on the target ratio corresponding to the target stored procedure.

[0078] Generally, the total computing power share of all database stored procedures is equal to the sum of the target share of the target stored procedures. That is, the sum of the computing power share of stored procedure 1 in the target time period and the computing power share of stored procedure 3 in the target time period in the above example is the total computing power share.

[0079] S270. Determine the evaluation computing power required to execute all database stored procedures in the target time period based on the total computing power ratio, the full-load computing power, and the resource utilization rate.

[0080] The full-load computing power reflects the upper limit of the computing power of the database when it is fully loaded. Usually, the full-load computing power is related to the model of the database.

[0081] Continuing with the above example, assuming that the total computing power accounts for 20%, the full-load computing power is 2000, and the resource utilization rate corresponding to the target time period is 40%, then the estimated computing power required to execute all database stored procedures in the target time period is 2000*40%*20%=160.

[0082] This avoids the problem of repeated calls causing low computing power evaluation results for the top-level stored procedure.

[0083] Optionally, after determining the evaluation computing power required to execute all database stored procedures in the target time period, the evaluation computing power required for each database stored procedure may be further decoupled.

[0084] The embodiment of the present invention provides a computing power evaluation method, including: according to the database dynamic views corresponding to several collection moments within the target time period, obtaining the actual computing power required to execute the database operation information at the corresponding collection moment; for each database operation information, according to the actual computing power required to execute the database operation information at each collection moment, determining the computing power proportion corresponding to the database operation information in the target time period; according to the computing power proportion corresponding to each database operation information in the target time period, the full load computing power of the database and the resource utilization rate corresponding to the target time period, determining the evaluation computing power required to execute the database operation information in the target time period. The technical solution of the embodiment of the present invention collects the database dynamic views corresponding to several collection moments within the target time period, and obtains the actual computing power required to execute the database operation information at the corresponding collection moment based on the database dynamic views; then realizes the analysis of each database operation information, determines the computing power proportion corresponding to each database operation information in the target time period; then combines the full load computing power of the database and the resource utilization rate corresponding to the target time period to determine the evaluation computing power required to execute the database operation information in the target time period. Compared with the traditional computing power evaluation method, on the first aspect, the present invention evaluates computing power based on the dynamic view of the database. The dynamic view of the database reflects the real-time operating status of the database, avoiding the problem of inaccurate evaluation that may exist when evaluating database performance by running predefined workloads. At the same time, there is no need to consume additional resources to simulate the load, and the system burden will not be increased. On the second aspect, by executing the actual computing power required for the database operation information at each collection moment, the computing power proportion corresponding to the database operation information in the target time period is determined, and the computing power information with the granularity of the moment can be converted into the computing power information with the granularity of the time period, so that the evaluation results are more accurate and more suitable for describing the business conditions in different time periods. On the third aspect, the database operation information includes database query statements and / or database stored procedures, which realizes information decoupling, provides a data basis for the construction, migration and even subsequent tuning of the database, and then realizes database decompression, thereby ensuring the overall performance and stability of the system.

[0085] Figure 3 Schematic diagram of a computing power evaluation device provided by an embodiment of the present invention. Figure 3 As shown, the device includes: a view acquisition module 301 and a computing power evaluation module 302.

[0086] The view collection module 301 is used to obtain the actual computing power required to execute the database operation information at the corresponding collection time according to the database dynamic views corresponding to several collection time within the target time period;

[0087] The computing power evaluation module 302 is used to determine the computing power ratio corresponding to each database operation information in the target time period according to the actual computing power required to execute the database operation information at each collection time; and to determine the evaluation computing power required to execute the database operation information in the target time period according to the computing power ratio corresponding to each database operation information in the target time period, the full load computing power of the database and the resource utilization rate corresponding to the target time period.

[0088] Optionally, the database operation information includes database query statements and / or database stored procedures.

[0089] Optionally, the computing power evaluation module 302 is specifically used to take any two collection moments among a number of collection moments as a moment group, and calculate the interval proportion of each moment group according to the actual computing power required to execute the database operation information at each collection moment; based on all interval proportions, determine the computing power proportion corresponding to the database operation information in the target time period.

[0090] Optionally, in the case where the database operation information is a database query statement, the interval proportion of any time group is equal to the ratio of the relative computing power of the time group to the comprehensive computing power of the database query statement;

[0091] When the database operation information is a database stored procedure, the interval ratio of any time group is equal to the ratio of the relative computing power of the time group to the comprehensive computing power of the database stored procedure;

[0092] Among them, the relative computing power of the moment group is equal to the difference between the actual computing powers required to execute the database operation information at the two collection moments included in the moment group; the comprehensive computing power of the database query statement is equal to the sum of the actual computing powers required to execute the database query statement at all collection moments; the comprehensive computing power of the database stored procedure is equal to the sum of the actual computing powers required to execute the database stored procedure at all collection moments.

[0093] Optionally, when the database operation information includes database query statements, the computing power evaluation module 302 is specifically used to determine the evaluation computing power required to execute each database query statement in the target time period based on the computing power ratio, full load computing power and resource utilization rate corresponding to each database query statement in the target time period.

[0094] Optionally, when the database operation information includes database stored procedures, the computing power evaluation module 302 is specifically used to determine the calling relationship between all database stored procedures; determine the total computing power ratio corresponding to all database stored procedures based on the calling relationship and the computing power ratio corresponding to each database stored procedure in the target time period; determine the evaluation computing power required to execute all database stored procedures in the target time period based on the total computing power ratio, full load computing power and resource utilization rate.

[0095] Optionally, the computing power evaluation module 302 is specifically used to determine the target stored procedure at the top level of each call relationship respectively; filter out the target proportion corresponding to the target stored procedure from the computing power proportion corresponding to each database stored procedure in the target time period; and determine the total computing power proportion corresponding to all database stored procedures based on the target proportion corresponding to the target stored procedure.

[0096] The computing power evaluation device provided in the embodiment of the present invention can execute the computing power evaluation method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0097] Figure 4 : is a schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workbenches, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or required herein.

[0098] like Figure 4 As shown, the electronic device 10 includes at least one processor 11, and a memory connected to the at least one processor 11, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc., wherein the memory stores a computer program that can be executed by at least one processor, and the processor 11 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 12 or the computer program loaded from the storage unit 18 to the random access memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other through a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0099] A number of components in the electronic device 10 are connected to the I / O interface 15, including: an input unit 16, such as a keyboard, a mouse, etc.; an output unit 17, such as various types of displays, speakers, etc.; a storage unit 18, such as a disk, an optical disk, etc.; and a communication unit 19, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0100] The processor 11 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The processor 11 executes the various methods and processes described above, such as the computing power evaluation method.

[0101] In some embodiments, the computing power evaluation method may be implemented as a computer program, which is tangibly contained in a computer-readable storage medium, such as a storage unit 18. In some embodiments, part or all of the computer program may be loaded and / or installed on the electronic device 10 via the ROM 12 and / or the communication unit 19. When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the computing power evaluation method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the computing power evaluation method in any other appropriate manner (e.g., by means of firmware).

[0102] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0103] Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that when the computer program is executed by the processor, the functions / operations specified in the flow chart and / or block diagram are implemented. The computer program may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0104] In the context of the present invention, a computer-readable storage medium may be a tangible medium that may contain or store a computer program for use by or in combination with an instruction execution system, device or equipment. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0105] To provide interaction with a user, the systems and techniques described herein may be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and a pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).

[0106] The systems and techniques described herein may be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0107] A computing system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The client and server relationship is generated by computer programs running on the corresponding computers and having a client-server relationship with each other. The server may be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system to solve the defects of difficult management and weak business scalability in traditional physical hosts and VPS services.

[0108] An embodiment of the present invention further provides a computer program product, including a computer program, which, when executed by a processor, implements a computing power evaluation method as provided in any embodiment of the present invention.

[0109] In the process of implementation, the computer program product can be written in one or more programming languages ​​or a combination thereof to perform the computer program code of the present invention, including object-oriented programming languages, such as Java, Smalltalk, C++, and conventional procedural programming languages, such as "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computer (for example, using an Internet service provider to connect through the Internet).

[0110] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps described in the present invention can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solution of the present invention can be achieved, and this document does not limit this.

[0111] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A computing power evaluation method, characterized in that: include: According to the database dynamic views corresponding to several collection moments within the target time period, the actual computing power required to execute the database operation information at the corresponding collection moment is obtained; For each of the database operation information, determine the computing power proportion corresponding to the database operation information in the target time period according to the actual computing power required to execute the database operation information at each collection moment; The evaluation computing power required to execute the database operation information in the target time period is determined based on the computing power ratio corresponding to each database operation information in the target time period, the full load computing power of the database and the resource utilization rate corresponding to the target time period.

2. The computing power evaluation method according to claim 1, characterized in that: The database operation information includes database query statements and / or database stored procedures.

3. The computing power evaluation method according to claim 2, characterized in that: Determining the computing power proportion corresponding to the database operation information in the target time period according to the actual computing power required to execute the database operation information at each collection moment includes: Taking any two collection moments among the plurality of collection moments as a moment group, and calculating the interval proportion of each moment group respectively according to the actual computing power required to execute the database operation information at each collection moment; According to the proportion of all the intervals, determine the computing power proportion corresponding to the database operation information in the target time period.

4. The computing power evaluation method according to claim 3, characterized in that: In the case where the database operation information is a database query statement, the interval ratio of any time group is equal to the ratio of the relative computing power of the time group to the comprehensive computing power of the database query statement; In the case where the database operation information is a database stored procedure, the interval ratio of any time group is equal to the ratio of the relative computing power of the time group to the comprehensive computing power of the database stored procedure; The relative computing power of the moment group is equal to the difference between the actual computing power required to execute the database operation information at the two collection moments included in the moment group; the comprehensive computing power of the database query statement is equal to the sum of the actual computing power required to execute the database query statement at all collection moments; The comprehensive computing power of the database storage process is equal to the sum of the actual computing power required to execute the database storage process at all acquisition moments.

5. The computing power evaluation method according to claim 2, characterized in that: When the database operation information includes database query statements, determining the evaluation computing power required to execute the database operation information in the target time period according to the computing power proportion corresponding to each database operation information in the target time period, the full load computing power of the database and the resource utilization rate corresponding to the target time period includes: Determine the evaluation computing power required to execute each of the database query statements in the target time period according to the computing power ratio corresponding to each of the database query statements in the target time period, the full load computing power and the resource utilization rate.

6. The computing power evaluation method according to claim 2, characterized in that: When the database operation information includes a database stored procedure, determining the evaluation computing power required to execute the database operation information in the target time period according to the computing power ratio corresponding to each database operation information in the target time period, the full load computing power of the database and the resource usage rate corresponding to the target time period includes: Determine the calling relationship between all the database stored procedures; Determine the total computing power ratio corresponding to all the database stored procedures according to the call relationship and the computing power ratio corresponding to each of the database stored procedures in the target time period; The estimated computing power required to execute all the database stored procedures in the target time period is determined according to the total computing power ratio, the full load computing power and the resource utilization rate.

7. The computing power evaluation method according to claim 6, characterized in that: Determining the total computing power proportion corresponding to all the database stored procedures according to the call relationship and the computing power proportion corresponding to each of the database stored procedures in the target time period includes: Determine the target stored procedure at the top level of each call relationship respectively; Filter out the target proportion corresponding to the target storage process from the computing power proportion corresponding to each database storage process in the target time period; According to the target proportion corresponding to the target stored procedure, the total computing power proportion corresponding to all the database stored procedures is determined.

8. An electronic device, characterized in that: The electronic device comprises: at least one processor; and a memory in communication with the at least one processor; wherein, The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the computing power evaluation method according to any one of claims 1 to 7.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the computing power evaluation method described in any one of claims 1 to 7 when executed.

10. A computer program product, characterized in that The computer program product comprises a computer program, which, when executed by a processor, implements the computing power evaluation method according to any one of claims 1 to 7.

Images