A xinyi database migration verification method for a power cloud

Abstract

The application provides a Xinxin database migration verification method for a power cloud, and belongs to the technical field of the power cloud, and specifically comprises the following steps: taking power cloud data to be migrated as migration data, determining a matching power distribution area of the migration data according to matched power equipment, determining an adaptation coefficient of a target server according to an adaptability evaluation result of a matching server and a basic server and the target server, determining a correlation coefficient of the target server and the migration data according to power equipment and a data amount of a matching power distribution area of storage data of the target server, determining a safety coefficient through a remaining storage space of the target server, determining a comprehensive evaluation coefficient in combination with the correlation coefficient and the adaptation coefficient, and determining a migration target server with the maximum comprehensive evaluation coefficient as a target, so that reliable verification of data migration is realized.

Description

Technical Field

[0001] This invention belongs to the field of power cloud technology, and in particular, it is a method for migration and verification of information technology application databases for power cloud. Background Technology

[0002] Against the backdrop of vigorously developing the information technology innovation industry and promoting domestic substitution, power grid companies need to migrate the data originally stored on ordinary servers to information technology innovation databases in order to achieve the localization of power cloud servers. However, how to verify the database during the migration process and reduce data loss or format corruption has become an urgent technical problem to be solved.

[0003] To address the aforementioned technical problems, existing technical solutions, such as the invention patent CN202110460007.1 "Database Comparison Method and Apparatus," analyze incompatible functions and syntax between different databases to achieve incompatibility analysis, thereby assessing the number of incompatibilities and the difficulty of data migration. However, these solutions suffer from the following technical issues:

[0004] Existing technical solutions neglect the determination of the domestically developed database for power cloud migration based on the compatibility analysis results of different databases. Specifically, different domestically developed databases have certain differences in compatibility with the original database of power cloud data. Therefore, the migration is more difficult and the risk of data corruption and loss in the migration process is greater. Therefore, if the above factors are not combined for migration verification analysis, the efficiency of migration processing cannot be guaranteed.

[0005] In existing technical solutions, when performing data migration, the correlation analysis between the existing stored data in different databases and the data to be migrated is neglected. Specifically, when analyzing and processing power equipment based on the stored data of the power cloud, if the stored data in the same substation or distribution network is placed on different information technology innovation servers, the efficiency of power cloud data processing cannot be guaranteed.

[0006] To address the aforementioned technical problems, this invention provides a method for migration verification of a domestically developed database for power cloud applications. Summary of the Invention

[0007] To achieve the objectives of this invention, the following technical solution is adopted:

[0008] According to one aspect of the present invention, a method for migration verification of a domestically developed database for power cloud is provided.

[0009] A method for migration verification of a domestically developed database for power cloud computing, characterized by comprising:

[0010] S1 uses the power cloud data to be migrated as migration data, and determines the importance evaluation coefficient of the migration data based on the matching power equipment and data volume of the migration data.

[0011] S2 determines the matching power distribution area of ​​the migration data based on the matched power equipment, and determines the matching server of the power distribution area based on the power cloud data storage server of the power equipment in the power distribution area. The storage server of the migration data and the server of the migration target are used as the base server and the migration server, and the adaptation coefficient of the migration server is determined based on the compatibility evaluation results of the matching server, the base server and the migration server.

[0012] S3 determines the adaptation coefficient threshold based on the importance assessment coefficient of the migration data, and when the adaptation coefficient of the migration server meets the requirements, determines the correlation coefficient between the migration server and the migration data based on the power equipment and data volume of the matching power distribution area of ​​the stored data of the migration server, and proceeds to the next step when the correlation coefficient meets the requirements.

[0013] S4 determines the security factor based on the remaining storage space of the migration server, and determines the comprehensive evaluation factor by combining the correlation factor and the adaptation factor, and determines the migration server with the goal of maximizing the comprehensive evaluation factor.

[0014] The beneficial effects of this invention are as follows:

[0015] 1. By determining the importance assessment coefficient of migration data based on the matching power equipment and data volume of the migration data, the importance of migration data can be assessed from the perspective of data volume and the power equipment corresponding to the migration data. This also lays the foundation for the differentiated determination of servers that can be migrated.

[0016] 2. The adaptation coefficient of the migration server is determined by the compatibility evaluation results of the matching server and the basic server and the migration server. This takes into account the differences in compatibility between the basic server and the migration server due to differences in system settings and functions, as well as the differences in the compatibility between the matching server and the migration server in the power distribution area, which affect the processing efficiency of power cloud data. This ensures the accuracy of the selection of migration servers.

[0017] 3. The safety factor is determined by the remaining storage space of the migration server, and a comprehensive evaluation factor is determined by combining the correlation factor and the adaptation factor. This takes into account the differences in correlation caused by the difference in the amount of data stored in the power distribution area between different migration servers, as well as the differences in adaptability and storage space of different migration servers, thereby achieving accurate screening of migration servers.

[0018] A further technical solution is that the matching power equipment for the migration data is determined based on the power equipment corresponding to the migration data, specifically including the type, model, and installation location of the power equipment.

[0019] A further technical solution is that the matching server is determined based on the storage server of the power cloud data of the power equipment of the preset type in the power distribution area. Specifically, when the amount of stored power cloud data of the power equipment of the preset type in the power distribution area in the storage server is greater than the preset amount of data, the storage server is used as the matching server.

[0020] A further technical solution is that the method for determining the comprehensive evaluation coefficient is as follows:

[0021] The security factor is determined by the ratio of the remaining storage space to the amount of migrated data, and the comprehensive evaluation factor is determined by a mathematical model based on the analytic hierarchy process (AHP) using the correlation coefficient, adaptation coefficient, and security factor.

[0022] On the other hand, the present invention provides a computer system comprising: a memory and a processor connected in communication, and a computer program stored in the memory and capable of running on the processor, characterized in that: when the processor runs the computer program, it executes the above-described method for migration verification of a domestically developed database for power cloud.

[0023] On the other hand, this application provides a computer-readable storage medium storing a computer program thereon. When the computer program is executed in a computer, it causes the computer to execute the above-mentioned method for migration and verification of a domestic information technology innovation database for power cloud.

[0024] Other features and advantages will be set forth in the description which follows, and will be apparent in part from the description, or may be learned by practicing the invention. The objects and other advantages of the invention are realized and obtained through the structures particularly pointed out in the description and the drawings.

[0025] To make the above-mentioned objects, features and advantages of the present invention more apparent and understandable, preferred embodiments are described below in detail with reference to the accompanying drawings. Attached Figure Description

[0026] The above and other features and advantages of the present invention will become more apparent from a detailed description of exemplary embodiments thereof with reference to the accompanying drawings.

[0027] Figure 1 This is a flowchart of a method for migrating and verifying a domestically developed database for power cloud applications;

[0028] Figure 2 It is a framework diagram of a computer system. Detailed Implementation

[0029] Exemplary embodiments will now be described more fully with reference to the accompanying drawings. However, these exemplary embodiments can be implemented in many forms and should not be construed as limited to the embodiments set forth herein; rather, they are provided so that the invention will be thorough and complete, and the concept of the exemplary embodiments will be fully conveyed to those skilled in the art. The same reference numerals in the drawings denote the same or similar structures, and therefore their detailed description will be omitted.

[0030] The terms “a,” “one,” “the,” and “the” are used to indicate the existence of one or more elements / components / etc.; the terms “including” and “having” are used to indicate an open-ended meaning of inclusion and that other elements / components / etc. may exist in addition to the listed elements / components / etc.

[0031] Example 1

[0032] To solve the above problems, according to one aspect of the present invention, such as Figure 1 As shown, according to one aspect of the present invention, a method for migration verification of a domestically developed information technology database for power cloud is provided, characterized in that it specifically includes:

[0033] S1 uses the power cloud data to be migrated as migration data, and determines the importance evaluation coefficient of the migration data based on the matching power equipment and data volume of the migration data.

[0034] Furthermore, the matching power equipment for the migration data is determined based on the power equipment corresponding to the migration data, specifically including the type, model, and installation location of the power equipment.

[0035] In one possible embodiment, the method for determining the importance assessment coefficient of the migration data in step S1 above is as follows:

[0036] S11 determines whether the amount of the migrated data is greater than a preset data amount threshold based on the amount of the migrated data. If yes, the importance evaluation coefficient of the migrated data is determined based on the amount of the migrated data. If no, proceed to the next step.

[0037] S12 Based on the type of power equipment matched by the migration data, the power equipment is divided into core power equipment and general power equipment, and the importance of the migration data is determined according to the number of core power equipment and the number of general power equipment. If it is important, proceed to step S14; otherwise, proceed to step S13.

[0038] S13 determines the power equipment of interest in the core power equipment based on the amount of migration data of the core power equipment, and determines the coreity evaluation coefficient of the migration data of the core power equipment based on the number of power equipment of interest in the core power equipment, the amount of migration data, the number of core power equipment, and the amount of migration data. Based on the coreity evaluation coefficient of the migration data of the core power equipment, it is determined whether the migration data is important. If so, proceed to step S14; otherwise, use the coreity evaluation coefficient as the importance evaluation coefficient of the migration data.

[0039] S14 determines the power equipment of interest in the general power equipment by the amount of migration data of the general power equipment, and determines the core evaluation coefficient of the migration data of the general power equipment based on the number of power equipment of interest in the general power equipment, the amount of migration data, the number of general power equipment, and the amount of migration data.

[0040] S15 determines the importance evaluation coefficient of the migration data by using the coreity evaluation coefficient of the migration data of general power equipment, the coreity evaluation coefficient of the migration data of core power equipment, the data volume of the migration data, and the number of matched power equipment.

[0041] It is understood that the importance assessment coefficient of the migration data ranges from 0 to 1.

[0042] In another possible embodiment, the method for determining the importance assessment coefficient of the migration data in step S1 above is as follows:

[0043] Based on the type of power equipment matched by the migration data, the power equipment is divided into core power equipment and general power equipment, and when the amount of migration data exceeds a preset data amount threshold:

[0044] The importance assessment coefficient of the migration data is determined by the amount of migration data, the amount of migration data for core power equipment and general power equipment.

[0045] When the amount of the migrated data is not greater than a preset data amount threshold:

[0046] Based on the amount of migration data of the core power equipment, the power equipment of interest in the core power equipment is determined. The coreity evaluation coefficient of the migration data of the core power equipment is determined according to the number of power equipment of interest in the core power equipment, the amount of migration data, the number of core power equipment, and the amount of migration data. Based on the coreity evaluation coefficient of the migration data of the core power equipment, it is determined whether the migration data is important. If it is, proceed to the next step. If not, the coreity evaluation coefficient is used as the importance evaluation coefficient of the migration data.

[0047] The amount of migration data from the general power equipment is used to identify the power equipment of interest within the general power equipment. The coreity evaluation coefficient of the migration data of the general power equipment is determined based on the number of power equipment of interest, the amount of migration data, the number of general power equipment, and the amount of migration data. Finally, the importance evaluation coefficient of the migration data is determined based on the coreity evaluation coefficient of the migration data of the general power equipment, the coreity evaluation coefficient of the migration data of the core power equipment, the amount of migration data, and the number of matching power equipment.

[0048] By determining the importance assessment coefficient of migration data based on the matching power equipment and data volume, the importance of migration data can be assessed from the perspective of data volume and the power equipment corresponding to the migration data. This also lays the foundation for the differentiated determination of servers that can be migrated.

[0049] S2 determines the matching power distribution area of ​​the migration data based on the matched power equipment, and determines the matching server of the power distribution area based on the power cloud data storage server of the power equipment in the power distribution area. The storage server of the migration data and the server of the migration target are used as the base server and the migration server, and the adaptation coefficient of the migration server is determined based on the compatibility evaluation results of the matching server, the base server and the migration server.

[0050] Furthermore, the matching server is determined based on the storage server of the power cloud data of the power equipment of the preset type in the power distribution area. Specifically, when the amount of stored power cloud data of the power equipment of the preset type in the power distribution area in the storage server is greater than the preset amount of data, the storage server is used as the matching server.

[0051] In another possible embodiment, the method for determining the adaptation coefficient of the migration server in step S2 above is as follows:

[0052] The compatibility coefficient between the migration server and the base server is determined by the number of inconsistencies in functions, syntax, and rules between the migration server and the base server. Based on this compatibility coefficient, it is determined when the migration server meets the requirements.

[0053] When the migration server does not meet the requirements based on the compatibility coefficient between the migration server and the base server:

[0054] The adaptation coefficient between the migration server and the matching server is determined by the number of inconsistencies in functions, syntax, and rules between the migration server and the matching server. The weight value of the matching server is determined based on the amount of power cloud data of power equipment in the power distribution area stored in the matching server and the number of power equipment in the power distribution area. Matching servers whose adaptation coefficients do not meet the requirements are designated as unadapted servers.

[0055] When the number of unfit servers and their weight values ​​do not meet the requirements:

[0056] The adaptation coefficient of the migration server is determined by the sum of the weight values ​​of the unadapted servers and the adaptation coefficient between the migration server and the base server.

[0057] When the number and weight values ​​of the unadapted servers meet the requirements:

[0058] The adaptation evaluation value of the unadapted servers is determined based on the number of unadapted servers, their proportion in the matching servers, the adaptation coefficient of the unadapted servers, and their weight values. Matching servers whose adaptation coefficients meet the requirements are designated as adaptable servers. The adaptation evaluation value of the adaptable servers is determined based on their adaptation coefficients, weight values, number, and proportion in the matching servers. The adaptation coefficient of the migration server is determined by combining the adaptation evaluation value of the unadapted servers and the adaptation coefficients between the migration server and the base server.

[0059] The adaptation coefficient of the migration server is determined based on the compatibility evaluation results of the matching server and the basic server and the migration server. This takes into account the differences in compatibility between the basic server and the migration server due to differences in system settings and functions, as well as the differences in the compatibility between the matching server and the migration server in the power distribution area, which affect the processing efficiency of power cloud data. This ensures the accuracy of the migration server selection.

[0060] S3 determines the adaptation coefficient threshold based on the importance assessment coefficient of the migration data, and when the adaptation coefficient of the migration server meets the requirements, determines the correlation coefficient between the migration server and the migration data based on the power equipment and data volume of the matching power distribution area of ​​the stored data of the migration server, and proceeds to the next step when the correlation coefficient meets the requirements.

[0061] In one possible embodiment, the method for determining the correlation coefficient between the migration server and the migration data in step S3 above is as follows:

[0062] S31 determines the amount of data in the power distribution area of ​​the migration server based on the power equipment of the power distribution area matched by the stored data of the migration server, and determines whether the amount of data in the power distribution area of ​​the migration server is within the preset data amount range. If yes, proceed to the next step; otherwise, determine the correlation coefficient between the migration server and the migration data based on the amount of data in the power distribution area of ​​the migration server.

[0063] S32 obtains the number of power devices in the matching power distribution area of ​​the migration server's stored data, and determines whether the number of power devices in the matching power distribution area of ​​the migration server's stored data is greater than the preset number of power devices. If so, the correlation coefficient between the migration server and the migration data is determined by the number of power devices in the matching power distribution area of ​​the migration server's stored data. If not, proceed to the next step.

[0064] S33 determines the number of power equipment with complex data volume based on the storage data of the power equipment in the matching power distribution area of ​​the migration server, and determines whether the number of the power equipment with complex data volume meets the requirements. If yes, proceed to the next step; otherwise, determine the correlation coefficient between the migration server and the migration data based on the number of the power equipment with complex data volume.

[0065] S34 obtains the number of complex power devices and the amount of stored data in different types of matching power distribution areas of the migration server's stored data, and determines the correlation coefficient of the migration server's data volume and complex power devices by combining the number of complex power devices and the amount of stored data in the matching power distribution areas of the migration server's stored data. The correlation coefficient between the migration server and the migration data is determined by the correlation coefficient of the migration server's data volume and complex power devices, the number of different types of power devices and the amount of stored data, the number of power devices and the amount of data in the power distribution areas of the migration server.

[0066] S4 determines the security factor based on the remaining storage space of the migration server, and determines the comprehensive evaluation factor by combining the correlation factor and the adaptation factor, and determines the migration server with the goal of maximizing the comprehensive evaluation factor.

[0067] In one possible embodiment, the method for determining the comprehensive evaluation coefficient in step S4 above is as follows:

[0068] The security factor is determined by the ratio of the remaining storage space to the amount of migrated data, and the comprehensive evaluation factor is determined by a mathematical model based on the analytic hierarchy process (AHP) using the correlation coefficient, adaptation coefficient, and security factor.

[0069] The safety factor is determined by using the remaining storage space of the migration server, and a comprehensive evaluation factor is determined by combining the correlation factor and the adaptation factor. This takes into account the differences in correlation between different migration servers due to the difference in the amount of data stored in the power distribution area, as well as the differences in adaptability and storage space of different migration servers, thereby achieving accurate screening of migration servers.

[0070] Example 2

[0071] like Figure 2 As shown, the present invention provides a computer system, comprising: a memory and a processor connected in communication, and a computer program stored in the memory and capable of running on the processor, characterized in that: when the processor runs the computer program, it executes the above-described method for migration verification of a domestically developed database for power cloud.

[0072] Example 3

[0073] This application provides a computer-readable storage medium storing a computer program. When the computer program is executed in a computer, it causes the computer to execute the above-described method for migration and verification of a domestically developed database for power cloud.

[0074] The various embodiments in this specification are described in a progressive manner. Similar or identical parts between embodiments can be referred to mutually. Each embodiment focuses on describing the differences from other embodiments. In particular, the embodiments of apparatus, devices, and non-volatile computer storage media are basically similar to the method embodiments, so the descriptions are relatively simple; relevant parts can be referred to the descriptions of the method embodiments.

[0075] The foregoing has described specific embodiments of this specification. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims may be performed in a different order than that shown in the embodiments and may still achieve the desired result. Furthermore, the processes depicted in the drawings do not necessarily require the specific or sequential order shown to achieve the desired result. In some embodiments, multitasking and parallel processing are possible or may be advantageous.

[0076] The above description is merely one or more embodiments of this specification and is not intended to limit this specification. Various modifications and variations can be made to the one or more embodiments of this specification by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principle of one or more embodiments of this specification should be included within the scope of the claims of this specification.

Claims

1. A method for migration verification of a domestically developed database for power cloud computing, characterized in that, Specifically, it includes: The power cloud data to be migrated is used as migration data, and the importance evaluation coefficient of the migration data is determined based on the matching power equipment and data volume of the migration data. The matching power distribution area for the migration data is determined based on the matching power equipment, and the matching server for the power distribution area is determined based on the power cloud data storage server of the power equipment in the power distribution area. The storage server of the migration data and the server of the migration target are used as the base server and the migration server, and the adaptation coefficient of the migration server is determined based on the compatibility evaluation results of the matching server, the base server and the migration server. The adaptation coefficient threshold is determined based on the importance assessment coefficient of the migration data. When the adaptation coefficient of the migration server meets the requirements, the correlation coefficient between the migration server and the migration data is determined based on the power equipment and data volume of the matching power distribution area of ​​the stored data of the migration server. When the correlation coefficient meets the requirements, proceed to the next step. If the adaptation coefficient or correlation coefficient of the migration server does not meet the requirements, then the migration server is determined to be unable to serve as the migration target server. The security factor is determined by the remaining storage space of the migration server, and a comprehensive evaluation factor is determined by combining the correlation factor and the adaptation factor. The target server for migration is determined with the goal of maximizing the comprehensive evaluation factor.

2. The method for migration verification of a domestically developed database for power cloud as described in claim 1, characterized in that, The matching power equipment for the migration data is determined based on the power equipment corresponding to the migration data, specifically including the type, model, and installation location of the power equipment.

3. The method for migration verification of a domestically developed database for power cloud as described in claim 1, characterized in that, The importance assessment coefficient of the migration data ranges from 0 to 1.

4. The method for migration verification of a domestically developed database for power cloud as described in claim 1, characterized in that, The method for determining the importance assessment coefficient of the migration data is as follows: Based on the type of power equipment matched by the migration data, the power equipment is divided into core power equipment and general power equipment, and when the amount of migration data exceeds a preset data amount threshold: The importance assessment coefficient of the migration data is determined by the amount of migration data, the amount of migration data for core power equipment and general power equipment. When the amount of the migrated data is not greater than a preset data amount threshold: Based on the amount of migration data of the core power equipment, the power equipment of interest in the core power equipment is determined. The coreity evaluation coefficient of the migration data of the core power equipment is determined according to the number of power equipment of interest in the core power equipment, the amount of migration data, the number of core power equipment, and the amount of migration data. Based on the coreity evaluation coefficient of the migration data of the core power equipment, it is determined whether the migration data is important. If it is, proceed to the next step. If not, the coreity evaluation coefficient is used as the importance evaluation coefficient of the migration data. The amount of migration data from the general power equipment is used to identify the power equipment of interest within the general power equipment. The coreity evaluation coefficient of the migration data of the general power equipment is determined based on the number of power equipment of interest, the amount of migration data, the number of general power equipment, and the amount of migration data. Finally, the importance evaluation coefficient of the migration data is determined based on the coreity evaluation coefficient of the migration data of the general power equipment, the coreity evaluation coefficient of the migration data of the core power equipment, the amount of migration data, and the number of matching power equipment.

5. The method for migration verification of a domestically developed database for power cloud as described in claim 1, characterized in that, The matching server is determined based on the storage server of the power cloud data of the power equipment of the preset type in the power distribution area. Specifically, when the amount of stored power cloud data of the power equipment of the preset type in the power distribution area in the storage server is greater than the preset amount of data, the storage server is used as the matching server.

6. The method for migration verification of a domestically developed database for power cloud as described in claim 1, characterized in that, The method for determining the comprehensive evaluation coefficient is as follows: The security factor is determined by the ratio of the remaining storage space to the amount of migrated data, and the comprehensive evaluation factor is determined by a mathematical model based on the analytic hierarchy process (AHP) using the correlation coefficient, adaptation coefficient, and security factor.

7. A computer system, comprising: A memory and processor connected by communication, and a computer program stored on the memory and capable of running on the processor, characterized in that: when the processor runs the computer program, it executes a method for migration and verification of a domestically developed database for power cloud as described in any one of claims 1-6.

8. A computer-readable storage medium having a computer program stored thereon, which, when executed in a computer, causes the computer to perform a migration verification method for a domestically developed database for power cloud as described in any one of claims 1-6.

Images