Database configuration checking method and device, equipment, storage medium and program product

Abstract

The invention discloses a database configuration checking method and device, equipment, a storage medium and a program product, and relates to the technical field of data processing.The method comprises the steps that all obtained design files are converted into editable form files; according to the comparison use case template of the information of each to-be-checked category, extracting data of a target field specified by each comparison use case template from the table file into the comparison use case template to obtain an initial comparison use case form of each to-be-checked category; reading a station number corresponding to the point item identifier from the configuration database to a station number field of the initial comparison case form to obtain a target comparison case form; and for each to-be-checked category, comparing first to-be-compared information corresponding to the station number in the target comparison case form based on the to-be-checked category with second to-be-compared information corresponding to the station number in the configuration database, determining a check result, and adding the check result into the target comparison case form. Based on the method and the device, the efficiency and the accuracy of database configuration checking are improved.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a database configuration checking method, device, equipment, storage medium and program product. Background Art

[0002] Database configuration refers to the process of configuring the database in an automation or industrial control system (for example, a nuclear power distributed control system), including defining data structures, configuring data points, setting communication parameters, etc. It is an important part of the implementation of automation or industrial control systems and directly affects the performance, reliability and maintainability of the system. Therefore, after the database configuration is completed, the configured data needs to be checked to ensure the accuracy of the configured data.

[0003] Currently, database configuration checking is done manually, that is, the database configuration data is manually compared with the design files. This method is not only inefficient and labor-intensive, but also tests the patience and information retrieval and comparison capabilities of testers, and is prone to human errors. Summary of the invention

[0004] In view of the above problems, the present application provides a database configuration checking method, apparatus, device, storage medium and program product to improve the efficiency and accuracy of database configuration checking. The specific scheme is as follows:

[0005] The first aspect of the present application provides a database configuration checking method, comprising:

[0006] Obtaining a plurality of design files, wherein the plurality of design files include the following types of files: an input and output list and a display list;

[0007] Convert each design file into an editable table file;

[0008] According to the comparison case template of each category of information to be checked, extract the data of the target field specified by each comparison case template from the table file and put it into the comparison case template to obtain the initial comparison case form of each category to be checked; the target field includes a point item identifier and the first information to be compared corresponding to the point item identifier;

[0009] Read at least the station number corresponding to the point item identifier from the configuration database to the station number field of the initial comparison case form of each category to be checked, to obtain the target comparison case form of each category to be checked;

[0010] Corresponding to each category to be checked, a comparison check is performed based on the first information to be compared corresponding to the station number in the target comparison case form of the category to be checked, and the second information to be compared corresponding to the station number read from the configuration database, to determine the inspection result of the category to be checked and add it to the target comparison case form of the category to be checked; the inspection result indicates whether the information of the category to be checked corresponding to the station number in the configuration database is consistent with the information of the category to be checked corresponding to the station number in the design file.

[0011] In a possible implementation, the information of each category to be checked includes: basic variable information, variable information of the operating system of the main control room, variable information of the emergency alarm system, and important signal distribution information;

[0012] Among the basic variable information, the variable information of the operating system of the main control room and the variable information of the emergency alarm system, the first information to be compared corresponding to the point item identifier includes: signal description, upper limit of the range, lower limit of the range, and measurement unit;

[0013] In the important signal allocation information, the first information to be compared corresponding to the point item identifier includes: signal description, G / S grouping, and signal allocation requirements.

[0014] In a possible implementation, for each category to be checked, a comparison check is performed based on the first information to be compared corresponding to the station number in the target comparison case form of the check category and the second information to be compared corresponding to the station number in the configuration database, including:

[0015] If the information of the category to be checked is basic variable information, variable information of the operating system of the main control room, or variable information of the emergency alarm system, for each point item, the first information to be compared corresponding to the station number of the point item in the target comparison case form is compared with the second information to be compared corresponding to the station number in the configuration database, to obtain a first comparison result as the inspection result; the first comparison result indicates whether the second information to be compared of the category to be checked corresponding to the station number in the configuration database is consistent with the first information to be compared of the category to be checked corresponding to the station number in the target comparison case form;

[0016] If the information of the category to be checked is important signal allocation information, for each signal allocation requirement, a group of station numbers corresponding to the signal allocation requirement and the device addresses corresponding to the station numbers are compared with the signal allocation requirement to obtain a second comparison result as the inspection result; the second comparison result represents whether the station numbers corresponding to the signal allocation requirement and the device addresses corresponding to the station numbers are consistent with the signal allocation requirement.

[0017] In a possible implementation, the method further includes:

[0018] Extract the data of the target field specified by the comparison case template of each category of information to be checked from the configuration database into a database table to obtain a database master table;

[0019] Correspondingly, the station number corresponding to the point item identifier is read from the configuration database to the station number field of the initial comparison case form of each category to be checked, including:

[0020] The station number corresponding to the point item identification is read from the database master table and placed under the station number field of the initial comparison case form of each category to be checked.

[0021] In a possible implementation, the step of reading the station number corresponding to the point item identifier from the configuration database to the station number field of the initial comparison case form of each category to be checked, and obtaining the target comparison case form of each category to be checked, includes:

[0022] Converting the point item identifier into a point item identifier that can be recognized by the configuration database;

[0023] The station number corresponding to the converted point item identification is read from the configuration database to the station number field of the initial comparison case form of each category to be checked, so as to obtain the target comparison case form of each category to be checked.

[0024] A second aspect of the present application provides a database configuration checking device, comprising:

[0025] An acquisition module is used to acquire a number of design files, wherein the number of design files include the following types of files: an input and output list and a display list;

[0026] A conversion module, used to convert each design file into an editable table file;

[0027] An extraction module is used to extract data of a target field specified by each comparison case template from the table file into the comparison case template according to the comparison case template of each category of information to be checked, so as to obtain an initial comparison case form of each category of information to be checked; the target field includes a point item identifier and the first information to be compared corresponding to the point item identifier;

[0028] A reading module, used for reading at least the station number corresponding to the point item identification from the configuration database to the station number field of the initial comparison case form of each category to be checked, to obtain the target comparison case form of each category to be checked;

[0029] A comparison module is used to perform a comparison check on each category to be checked, based on the first information to be compared corresponding to the station number in the target comparison case form of the category to be checked, and the second information to be compared corresponding to the station number read from the configuration database, to determine the inspection result of the category to be checked and add it to the target comparison case form of the category to be checked; the inspection result indicates whether the information of the category to be checked corresponding to the station number in the configuration database is consistent with the information of the category to be checked corresponding to the station number in the design file.

[0030] A third aspect of the present application provides a computer program product, comprising computer-readable instructions. When the computer-readable instructions are executed on an electronic device, the electronic device implements the database configuration checking method of the first aspect or any implementation of the first aspect.

[0031] A fourth aspect of the present application provides an electronic device, comprising at least one processor and a memory connected to the processor, wherein:

[0032] The memory is used to store computer programs;

[0033] The processor is used to execute the computer program so that the electronic device can implement the database configuration checking method of the above-mentioned first aspect or any implementation manner of the first aspect.

[0034] A fifth aspect of the present application provides a computer storage medium, which carries one or more computer programs. When the one or more computer programs are executed by an electronic device, the electronic device can implement the database configuration checking method of the above-mentioned first aspect or any implementation of the first aspect.

[0035] By means of the above technical solution, the database configuration checking method, device, equipment, storage medium and program product provided by the present application obtain a plurality of design files, which include the following types of files: input and output lists and display lists; convert each design file into an editable table file; according to the comparison case template of each category of information to be checked, extract the data of the target field specified by each comparison case template from the table file into the comparison case template, and obtain the initial comparison case form of each category to be checked; the target field includes the point item identifier and the first information to be compared corresponding to the point item identifier; read the data from the configuration database; Take the station number corresponding to the point item identifier to the station number field of the initial comparison case form of each category to be checked, and obtain the target comparison case form of each category to be checked; for each category to be checked, compare the first information to be compared corresponding to the station number in the target comparison case form of the category to be checked with the second information to be compared corresponding to the above station number in the configuration database, determine the inspection result of the category to be checked and add it to the target comparison case form of the category to be checked; the inspection result indicates whether the information of the category to be checked corresponding to the station number in the configuration database is consistent with the information of the category to be checked corresponding to the station number in the design file. Based on this application, automatic inspection of database configuration is realized, human errors are avoided, and the efficiency and accuracy of database configuration inspection are improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the accompanying drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and the originals and elements are not necessarily drawn to scale.

[0037] Figure 1 A flowchart of an implementation of the database configuration checking method provided in this application;

[0038] Figure 2 An example of a comparison use case template for basic variable information provided for this application;

[0039] Figure 3 An example of a comparison use case template for KIC provided for this application;

[0040] Figure 4 An example of a comparison use case template for the ACP provided for this application;

[0041] Figure 5 An example of a comparison use case template for important signal allocation information provided for this application;

[0042] Figure 6 An example of an initial comparison use case form for basic variable information provided for this application;

[0043] Figure 7 An example of the initial comparison use case form of KIC provided for this application;

[0044] Figure 8 An example of an initial comparison use case form for the ACP provided for this application;

[0045] Fig. 9 When the item to be checked provided for this application is basic information of variables, an example after filling in the check result in the target comparison case form;

[0046] Fig.10 When the item to be checked provided for this application is important signal allocation information, an example after filling in the inspection result in the target comparison case form;

[0047] Fig.11 A schematic diagram of the structure of the database configuration checking device provided by the present application;

[0048] Fig.12 A schematic diagram of the structure of an electronic device provided in this application. DETAILED DESCRIPTION

[0049] The following describes the embodiments of the present application in conjunction with the drawings in the embodiments of the present application. The terms used in the implementation method section of the present application are only used to explain the specific embodiments of the present application, and are not intended to limit the present application.

[0050] The embodiments of the present application are described below in conjunction with the accompanying drawings. Those skilled in the art will appreciate that, with the development of technology and the emergence of new scenarios, the technical solutions provided in the embodiments of the present application are also applicable to similar technical problems.

[0051] The terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and need not be used to describe a specific order or sequential order. It should be understood that the terms used in this way can be interchangeable under appropriate circumstances, which is only to describe the distinction mode adopted by the objects of the same attributes when describing in the embodiments of the present application. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, so that the process, method, system, product or equipment comprising a series of units need not be limited to those units, but may include other units that are not clearly listed or inherent to these processes, methods, products or equipment.

[0052] The design documents of nuclear power distributed control system (DCS) are divided into input and output (IO) list and display list according to the content; among them, the display list is further divided into operator instruction list and other display list. Other display list refers to the collection of variable points outside the operator instruction list, which contains some variable point information to be tested and needs to be extracted.

[0053] Design files are usually non-editable files, such as PDF files. Traditional manual inspection methods require testers to first manually convert the design files from PDF format to editable tables (such as Excel tables), and sort and filter the information in the editable tables to eliminate the safety level list information (that is, the database configuration check only checks the non-safety level database configuration, and the safety level does not need to be checked) and irrelevant point items (irrelevant point items refer to variable points that are not within the scope of the nuclear power non-safety level database configuration information inspection and comparison test). Among them, the methods of sorting and filtering different types of editable tables are different: the sorting and filtering of the editable tables of the IO list can include but are not limited to: removing data classified as safety level by equipment function classification (for example, data classified as FSC1, FSC2), data belonging to third-party systems; data belonging to the PLC system, data not within the scope of the nuclear power DCS system, etc.; the sorting and filtering of the editable tables of the display list can include but are not limited to: removing the information located in the LOCAL part, and classifying the information located in ACP and KIC. The display list contains the parameter type of location, which includes three types: "LOCAL", "ACP" and "KIC", representing variable points at different locations. For example, ACP refers to the emergency alarm system (backup) after the panel system fails; KIC refers to the operating system of the main control room; LOCAL refers to the local operating system of conventional information (non-main control system). The non-security database configuration information check requires parameter information check for variable points at KIC and ACP locations, and does not examine variable points at LOCAL locations.

[0054] After sorting and filtering the information in the editable table, it is necessary to classify it according to the function level, parameter type, location and other information to form a test case file that meets the test specifications.

[0055] The above-mentioned format conversion, information sorting, screening, classification and other operations are all completed manually. In the nuclear power DCS system, a unit needs to convert about 450 PDF files, and it takes at least 60 man-days to complete the design and implementation of general comparison use cases (also called test cases). The workload is large and the repetitiveness is high. The generated use cases need to be passed by the testers before they can be put into testing.

[0056] During the comparison process, a unit needs to compare about 40,000 to 50,000 variable points, and it takes about 40 man-days to complete the comparison of one version of database information. This large amount of work also tests the patience and information retrieval and comparison capabilities of the testers, and is very prone to human errors.

[0057] In order to improve the efficiency and accuracy of database configuration checking, this application scheme is proposed.

[0058] like Figure 1 As shown, a flowchart of an implementation of the database configuration checking method provided in an embodiment of the present application may include:

[0059] Step S101: obtaining a number of design files, which include the following types of files: input and output lists and display lists.

[0060] The plurality of setting files may be all design files corresponding to the nuclear power DCS system, or part of the design files, and the plurality of design files may be read in batches.

[0061] Step S102: Convert each design file into an editable table file.

[0062] The preset format conversion code can be called to convert each design file into the word format, and then the information in the word format document can be copied into the editable table to obtain the editable table file.

[0063] Step S103: according to the comparison case template of each category of information to be checked, extract the data of the target field specified by each comparison case template from the above table file into the comparison case template to obtain the initial comparison case form of each category to be checked.

[0064] In an embodiment of the present application, the information of the category to be checked includes multiple categories, which are classified according to information such as functional level, parameter type and location, including basic variable information (also called basic variable information), variable information (KIC) of the operating system of the main control room, variable information (ACP) of the emergency alarm system and important signal distribution information, etc.

[0065] The target field specified in the comparison use case template of each category of information to be checked includes a point item identifier and the first information to be compared corresponding to the point item identifier.

[0066] The point item identifier may be composed of a device code and an extension code. If there is no extension code, the extension code is empty.

[0067] The first information to be compared corresponding to the basic information of the variables, KIC and ACP includes: signal description (also called point description), upper limit of the range, lower limit of the range, and measurement unit (also called dimension).

[0068] The first information to be compared corresponding to the important signal allocation information includes: signal description, G / S grouping, and signal allocation requirements (determined according to the G / S grouping in the design file and the system's signal allocation requirements). Among them, G refers to group, which means a group; S refers to separate, which means separation. G means that the equipment is divided into a group, and S means that the equipment is separated. Fig.10 As shown, Fig.10 The number after G or S indicates the group. For example, G1 indicates that the devices in group 1 need to be grouped together, and S1 indicates that the devices in group 1 need to be separated.

[0069] Optionally, the important signal allocation information may also include the power supply column of the equipment (which can be simply referred to as a column). The equipment in the nuclear power distributed control system has multiple power supply columns, which are recorded as A, B, C, D... columns. The equipment needs to be powered by some power supply columns. If one of the power supply columns is powered off, the other power supply columns need to be enabled as backup power supply columns. Since the "column" information is not within the scope of the database group inspection, the "column" field may not be included in the first information to be compared corresponding to the important signal allocation information. Of course, as an optional implementation method, the "column" field can be added for some business needs to facilitate subsequent business applications, etc.

[0070] like Figure 2-5 As shown, there are four examples of comparison use case templates provided in the embodiment of the present application, wherein: Figure 2 This is an example of a comparison use case template for basic variable information. Figure 3 This is an example of a comparison case template for KIC. Figure 4 An example of a comparison case template for ACP. Figure 5 Example of a comparison use case template that assigns information to important signals.

[0071] Figure 2-4 In the , the "point name" field is used to store the point item identifier, and Figure 5 In the signal field, the point item identifier is stored.

[0072] It should be noted that Figure 2-4 The comparison use case template shown has three fields: output substitute value QFIA, output substitute QFID, and output substitute mode QFM. These three fields are not within the scope of the database configuration check. Therefore, the comparison use case template may not have these three fields. However, as an optional implementation method, for some business needs, these three fields can be added to the comparison use case template for subsequent business applications.

[0073] Figure 5 In the example shown, the "System" field indicates the system to which the point item belongs.

[0074] like Figure 6 As shown, it is an example of an initial comparison use case form of basic variable information provided in an embodiment of the present application, wherein both the "station number" field and the "test result" field are empty. Figure 6 In the example shown, the point name "0XCA1001SY" with serial number 1 has only a device code but no extension code; in the point name "0XCA3102TOLC" with serial number 26, the device code is "0XCA3102TO" and the extension code is "LC".

[0075] like Figure 7 As shown, it is an example of the initial comparison use case form of KIC provided in the embodiment of the present application, wherein the "station number" field and the "test result" field are both empty.

[0076] like Figure 8 As shown, it is an example of the initial comparison use case form of ACP provided in the embodiment of the present application, wherein the "station number" field and the "test result" field are both empty.

[0077] exist Figure 6-8 In the example shown, fields without information are filled with "-", indicating that there is no such information.

[0078] Step S104: at least read the station number corresponding to the above point item identification from the configuration database to the station number field of the initial comparison case form of each category to be checked, and obtain the target comparison case form of each category to be checked.

[0079] The station number is an identifier used to distinguish different workstations in the current unit or system.

[0080] In the target comparison case form, the test result item is empty. After the comparison result is determined, add the comparison result to the column where the test result is located.

[0081] For the target comparison use case form of important signal allocation information, the device address field corresponding to the point item identifier can also be read from the configuration database to the target comparison use case form in this step (that is, the station number and device address corresponding to the point item identifier are read from the configuration database at one time) to facilitate the next step of checking whether the signal allocation requirements are consistent. Of course, the device address field corresponding to the point item identifier can also be read from the configuration database to the target comparison use case form when a comparison check is required in the next step.

[0082] Step S105: For each category to be inspected, a comparison check is performed based on the first information to be compared corresponding to the above-mentioned station number in the target comparison use case form of the category to be inspected, and the second information to be compared corresponding to the above-mentioned station number obtained from the configuration database, and the inspection result of the category to be inspected is determined and added to the target comparison use case form of the category to be inspected.

[0083] The inspection result indicates whether the information of the category to be inspected corresponding to the station number in the configuration database is consistent with the information of the category to be inspected corresponding to the station number in the design file.

[0084] After obtaining the target comparison use case form, the corresponding information to be compared (i.e., the second information to be compared) can be read from the configuration database according to the station number in the target comparison use case form, and then a comparison check is performed based on at least the second information to be compared and the first information to be compared. Of course, if the second information to be compared has been read from the configuration database into the target comparison use case form in advance, then this step does not require reading the second information to be compared from the configuration database. That is to say, in step S105, the second information to be compared corresponding to the above-mentioned station number obtained from the configuration database can be read from the configuration database into the target comparison use case form in advance, or can be read from the configuration database in real time. The second information to be compared read in real time can be stored in the target comparison use case form, or can be not stored in the target comparison use case form (can be placed in the cache).

[0085] Optionally, if the item to be checked is basic variable information, variable information of the operating system of the main control room, or variable information of the emergency alarm system, for each point item, the first information to be compared corresponding to the station number determined based on the point item in the target comparison case form can be compared with the second information to be compared corresponding to the same station number in the configuration database to obtain a first comparison result as the inspection result. The first comparison result indicates whether the second information to be compared corresponding to the station number in the configuration database is consistent with the first information to be compared corresponding to the station number in the target comparison case form.

[0086] like Fig. 9 As shown, when the item to be checked provided in the embodiment of the present application is the basic information of the variable, an example is given after the inspection result is filled in the target comparison use case form. In this example, the information to be compared includes: point description, dimension, lower limit of range and upper limit of range. The test result field is the inspection result, where "√" indicates that the second information to be compared corresponding to the station number in the configuration database is consistent with the first information to be compared corresponding to the station number in the target comparison use case form; "×" indicates that the second information to be compared corresponding to the station number in the configuration database is inconsistent with the first information to be compared corresponding to the station number in the target comparison use case form.

[0087] Furthermore, in order to facilitate user viewing, cells containing different comparison results may be marked, for example, by marking them with different colors. Fig. 9 In the example shown, the table where “√” is located is marked in green, and the table where “×” is located is marked in red. The first information to be compared corresponding to “×” is also marked, for example, with a specific color, so that the user can locate the abnormality. Fig. 9 In the example shown, this is marked in yellow.

[0088] If the item to be checked is important signal allocation information, for each signal allocation requirement, a set of station numbers corresponding to the signal allocation requirement and the device addresses corresponding to the station numbers can be compared with the signal allocation requirement to obtain a second comparison result as the inspection result; the second comparison result represents whether the station numbers corresponding to the signal allocation requirement and the device addresses corresponding to the station numbers are consistent with the signal allocation requirement.

[0089] Optionally, corresponding to each signal allocation requirement, a group of station numbers corresponding to the signal allocation requirement is formed into a first list, and a group of device addresses corresponding to the signal allocation requirement is formed into a second list. Then, according to the signal allocation requirement, each station number in the first list is checked and compared to determine whether the station numbers in the first list are consistent; according to the signal allocation requirement, each device address in the second list is checked and compared to determine whether the device addresses in the second list are consistent.

[0090] like Fig.10 As shown, when the item to be checked provided in the embodiment of the present application is important signal allocation information, an example is given after the inspection result is filled in the target comparison use case form. In this example, it is necessary to detect whether the station number and device address corresponding to each signal allocation requirement are consistent with the corresponding signal allocation requirement. Specifically, if the signal allocation requirement is to be allocated on the same card, the station numbers and device addresses of different signals corresponding to the signal allocation requirement are required to be the same; if the signal allocation requirement is to be allocated on different cards, the station numbers and device addresses of different signals corresponding to the signal allocation requirement are required to be different.

[0091] Fig.10 In the example shown, “√” indicates that the station number and device address corresponding to the signal allocation requirement are consistent with the corresponding signal allocation requirement; if they are inconsistent, they can be indicated by “×”.

[0092] The database configuration inspection method provided in the embodiment of the present application obtains a number of design files, which include the following types of files: an input and output list and a display list; converts each design file into an editable table file; according to the comparison case template of each category of information to be inspected, extracts the data of the target field specified by each comparison case template from the table file into the comparison case template to obtain the initial comparison case form of each category to be inspected; the target field includes a point item identifier and a first information to be compared corresponding to the point item identifier; reads at least the station number corresponding to the point item identifier from the configuration database into the station number field of the initial comparison case form of each category to be inspected, to obtain the target comparison case form of each category to be inspected; for each category to be inspected, based on the first information to be compared corresponding to the station number in the target comparison case form of the category to be inspected, compares it with the second information to be compared corresponding to the above station number in the configuration database, determines the inspection result of the category to be inspected and fills it into the target comparison case form of the category to be inspected; the inspection result represents whether the information of the category to be inspected corresponding to the station number in the configuration database is consistent with the information of the category to be inspected corresponding to the station number in the design file. Based on this application, automatic checking of database configuration is achieved, human errors are avoided, and the efficiency and accuracy of database configuration checking are improved.

[0093] In an optional embodiment, the database configuration checking method provided by the present application may further include:

[0094] Extract the data of the target field specified by the comparison use case template of each category of information to be checked from the configuration database into a database table to obtain a database master table.

[0095] Accordingly, the process of reading the station number corresponding to the point item identifier from the configuration database to the station number field of the initial comparison case form of each category to be checked to obtain the target comparison case form may include:

[0096] The station number corresponding to the point item identification is read from the database master table to the station number field of the initial comparison case form of each category to be checked to obtain a target comparison case form.

[0097] Since only part of the data in the configuration database is within the scope of the nuclear power non-safety database configuration information inspection and comparison test, if the data corresponding to the point item identifier is directly searched in the configuration database, the data processing volume is large. By constructing the database master table, the data processing volume for obtaining the second information to be compared is reduced, and the data processing volume for database configuration inspection is further reduced, which can further improve the efficiency of database configuration inspection.

[0098] In an optional embodiment, the station number corresponding to the point item identifier is read from the configuration database to the station number field of the initial comparison case form of each category to be checked, and an implementation method for obtaining the target comparison case form of each category to be checked may be:

[0099] Convert the point item identifier to a point item identifier that can be recognized by the configuration database.

[0100] According to different projects, the content of the point item identifier in the database is different. Based on this, in order to facilitate the comparison and inspection, the point item identifier can be converted into a point item identifier that can be recognized by the configuration database according to the preset mapping rules.

[0101] for example, Figure 6 In the example, the point name "0XCA1001SY" in the 4th row of the Excel table is "BJ0XCA1001SY" in the configuration database, that is, the first character 0 of the point name is mapped to BJ0. Figure 7 In the configuration database, the point name "9SE1210PO" with the serial number 1 is "BJ9SE1210PO", that is, the first character 9 of the point name is mapped to BJ9. Figure 8 In the configuration database, the point name "XAPG0001CG" with sequence number 1 is "BJ1APG0001CG", that is, the first character X in the point name is mapped to BJ1.

[0102] The station number corresponding to the converted point item identification is read from the configuration database to the station number field of the initial comparison case form of each category to be checked, and the target comparison case form of each category to be checked is obtained.

[0103] Optionally, the station number corresponding to the converted point item identifier can be read from the aforementioned database master table to the station number field of the initial comparison case form to obtain the target comparison case form.

[0104] Corresponding to the method embodiment, the present application also provides a database configuration checking device. A structural schematic diagram of the database configuration checking device provided in the embodiment of the present application is as follows: Fig.11 As shown, it may include:

[0105] Acquisition module 1101, conversion module 1102, extraction module 1103, reading module 1104 and comparison module 1105;

[0106] The obtaining module 1101 is used to obtain a number of design files, and the design files include the following types of files: input and output lists and display lists;

[0107] The conversion module 1102 is used to convert each design file into an editable table file;

[0108] The extraction module 1103 is used to extract the data of the target field specified by each comparison case template from the table file into the comparison case template according to the comparison case template of each category of information to be checked, so as to obtain the initial comparison case form of each category of information to be checked; the target field includes a point item identifier and the first information to be compared corresponding to the point item identifier;

[0109] The reading module 1104 is used to read at least the station number corresponding to the point item identifier from the configuration database to the station number field of the initial comparison case form of each category to be checked, so as to obtain the target comparison case form of each category to be checked;

[0110] The comparison module 1105 is used to perform a comparison check on each category to be checked, based on the first information to be compared corresponding to the station number in the target comparison case form of the category to be checked, and the second information to be compared corresponding to the station number read from the configuration database, to determine the inspection result of the category to be checked and add it to the target comparison case form of the category to be checked; the inspection result indicates whether the information of the category to be checked corresponding to the station number in the configuration database is consistent with the information of the category to be checked corresponding to the station number in the design file.

[0111] The database configuration inspection device provided in the embodiment of the present application obtains a number of design files, which include the following types of files: input and output lists and display lists; converts each design file into an editable table file; according to the comparison case template of each category of information to be inspected, extracts the data of the target field specified by each comparison case template from the table file into the comparison case template to obtain the initial comparison case form of each category to be inspected; the target field includes a point item identifier and a first information to be compared corresponding to the point item identifier; reads at least the station number corresponding to the point item identifier from the configuration database to the station number field of the initial comparison case form of each category to be inspected, to obtain the target comparison case form of each category to be inspected; for each category to be inspected, based on the first information to be compared corresponding to the station number in the target comparison case form of the category to be inspected, compares it with the second information to be compared corresponding to the above station number in the configuration database, determines the inspection result of the category to be inspected and fills it into the target comparison case form of the category to be inspected; the inspection result represents whether the information of the category to be inspected corresponding to the station number in the configuration database is consistent with the information of the category to be inspected corresponding to the station number in the design file. Based on this application, automatic checking of database configuration is achieved, human errors are avoided, and the efficiency and accuracy of database configuration checking are improved.

[0112] In an optional embodiment, the information of each category to be checked includes: basic variable information, variable information of the operating system of the main control room, variable information of the emergency alarm system, and important signal distribution information;

[0113] Among the basic variable information, the variable information of the operating system of the main control room and the variable information of the emergency alarm system, the first information to be compared corresponding to the point item identifier includes: signal description, upper limit of the range, lower limit of the range, and measurement unit;

[0114] In the important signal allocation information, the first information to be compared corresponding to the point item identifier includes: signal description, column division, G / S grouping, and signal allocation requirements.

[0115] In an optional embodiment, the comparison module 1105 is specifically used for:

[0116] If the information of the category to be checked is basic variable information, variable information of the operating system of the main control room, or variable information of the emergency alarm system, for each point item, the first information to be compared corresponding to the station number of the point item in the target comparison case form is compared with the second information to be compared corresponding to the station number in the configuration database, to obtain a first comparison result as the inspection result; the first comparison result indicates whether the second information to be compared of the category to be checked corresponding to the station number in the configuration database is consistent with the first information to be compared of the category to be checked corresponding to the station number in the target comparison case form;

[0117] If the information of the category to be checked is important signal allocation information, for each signal allocation requirement, a group of station numbers corresponding to the signal allocation requirement and the device addresses corresponding to the station numbers are compared with the signal allocation requirement to obtain a second comparison result as the inspection result; the second comparison result represents whether the station numbers corresponding to the signal allocation requirement and the device addresses corresponding to the station numbers are consistent with the signal allocation requirement.

[0118] In an optional embodiment, it also includes:

[0119] The database processing module is used to extract the data of the target field specified by the comparison case template of each category of information to be checked from the configuration database into a database table to obtain a database master table;

[0120] The reading module 1104 is specifically used to: read the station number corresponding to the point item identifier from the database master table to the station number field of the initial comparison case form of each category to be checked.

[0121] In an optional embodiment, the reading module 1104 is used to:

[0122] Converting the point item identifier into a point item identifier that can be recognized by the configuration database;

[0123] At least the station number corresponding to the converted point item identification is read from the configuration database to the station number field of the initial comparison case form of each category to be checked, so as to obtain the target comparison case form of each category to be checked.

[0124] The present application also provides an electronic device in an embodiment. Fig.12 As shown, it shows a structural schematic diagram of an electronic device suitable for implementing the embodiment of the present application. The electronic device in the embodiment of the present application can be a mobile terminal device, such as a mobile phone, a tablet computer, a laptop computer, etc.; it can also be a desktop computer device, such as a desktop computer, an all-in-one computer, etc.; or it can be a server or a server cluster, etc. Fig.12 The electronic device shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.

[0125] like Fig.12 As shown, the electronic device may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 1201, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 1202 or a program loaded from a storage device 1208 to a random access memory (RAM) 1203. When the electronic device is powered on, various programs and data required for the operation of the electronic device are also stored in the RAM 1203. The processing device 1201, the ROM 1202, and the RAM 1203 are connected to each other via a bus 1204. An input / output (I / O) interface 1205 is also connected to the bus 1204.

[0126] Typically, the following devices may be connected to the I / O interface 1205: an input device 1206 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; an output device 1207 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 1208 including, for example, a memory card, a hard disk, etc.; and a communication device 1209. The communication device 1209 may allow the electronic device to communicate with other devices wirelessly or by wire to exchange data. Although Fig.12 An electronic device having various devices is shown, but it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed instead.

[0127] An embodiment of the present application also provides a computer program product including computer-readable instructions. When the computer-readable instructions are executed on an electronic device, the electronic device implements any database configuration checking method provided in the embodiment of the present application.

[0128] A computer-readable storage medium is also provided in an embodiment of the present application. The storage medium carries one or more computer programs. When the one or more computer programs are executed by an electronic device, the electronic device can implement any database configuration checking method provided in the embodiment of the present application.

[0129] It should be noted that the device embodiments described above are merely schematic, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed over multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. In addition, in the drawings of the device embodiments provided by the present application, the connection relationship between the modules indicates that there is a communication connection between them, which may be specifically implemented as one or more communication buses or signal lines.

[0130] Through the description of the above implementation mode, the technicians in the field can clearly understand that the present application can be implemented by means of software plus necessary general hardware, and of course, it can also be implemented by special hardware including special integrated circuits, special CPUs, special memories, special components, etc. In general, all functions completed by computer programs can be easily implemented by corresponding hardware, and the specific hardware structure used to implement the same function can also be various, such as analog circuits, digital circuits or special circuits. However, for the present application, software program implementation is a better implementation mode in more cases. Based on such an understanding, the technical solution of the present application is essentially or the part that contributes to the prior art can be embodied in the form of a software product, which is stored in a readable storage medium, such as a computer floppy disk, a U disk, a mobile hard disk, a ROM, a RAM, a disk or an optical disk, etc., including a number of instructions to enable a computer device (which can be a personal computer, a training device, or a network device, etc.) to execute the methods described in each embodiment of the present application.

[0131] In the above embodiments, all or part of the embodiments may be implemented by software, hardware, firmware, or any combination thereof. When implemented by software, all or part of the embodiments may be implemented in the form of a computer program product. Professionals and technicians may use different methods to implement the described functions for each specific solution, but such implementation should not be considered beyond the scope of this application.

[0132] The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the process or function described in the embodiment of the present application is generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices. The computer instructions may be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer instructions may be transmitted from a website site, a computer, a training device, or a data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.) mode to another website site, computer, training device, or data center. The computer-readable storage medium may be any available medium that a computer can store or a data storage device such as a training device, a data center, etc. that includes one or more available media integrations. The available medium may be a magnetic medium, (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a solid-state drive (SSD)), etc.

[0133] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.

[0134] The above description of the disclosed embodiments enables those skilled in the art to implement or use the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A database configuration checking method, characterized in that: include: Obtaining a plurality of design files, wherein the plurality of design files include the following types of files: an input and output list and a display list; Convert each design file into an editable table file; According to the comparison case template of each category of information to be checked, extract the data of the target field specified by each comparison case template from the table file and put it into the comparison case template to obtain the initial comparison case form of each category to be checked; the target field includes a point item identifier and the first information to be compared corresponding to the point item identifier; Read at least the station number corresponding to the point item identifier from the configuration database to the station number field of the initial comparison case form of each category to be checked, to obtain the target comparison case form of each category to be checked; For each category to be inspected, a comparison check is performed based on the first information to be compared corresponding to the station number in the target comparison case form of the category to be inspected and the second information to be compared corresponding to the station number read from the configuration database, and the inspection result of the category to be inspected is determined and added to the target comparison case form of the category to be inspected; The inspection result indicates whether the information of the category to be inspected corresponding to the station number in the configuration database is consistent with the information of the category to be inspected corresponding to the station number in the design file.

2. The method according to claim 1, characterized in that The information of each category to be checked includes: basic variable information, variable information of the operating system of the main control room, variable information of the emergency alarm system, and important signal distribution information; Among the basic variable information, the variable information of the operating system of the main control room and the variable information of the emergency alarm system, the first information to be compared corresponding to the point item identifier includes: signal description, upper limit of the range, lower limit of the range, and measurement unit; In the important signal allocation information, the first information to be compared corresponding to the point item identifier includes: signal description, G / S grouping, and signal allocation requirements.

3. The method according to claim 2, characterized in that For each category to be checked, the first information to be compared corresponding to the station number in the target comparison case form of the inspection category and the second information to be compared corresponding to the station number read from the configuration database are compared and checked, including: If the information of the category to be checked is basic variable information, variable information of the operating system of the main control room, or variable information of the emergency alarm system, for each point item, the first information to be compared corresponding to the station number of the point item in the target comparison case form is compared with the second information to be compared corresponding to the station number in the configuration database, to obtain a first comparison result as the inspection result; the first comparison result indicates whether the second information to be compared of the category to be checked corresponding to the station number in the configuration database is consistent with the first information to be compared of the category to be checked corresponding to the station number in the target comparison case form; If the information of the category to be checked is important signal allocation information, for each signal allocation requirement, a group of station numbers corresponding to the signal allocation requirement and the device addresses corresponding to the station numbers are compared with the signal allocation requirement to obtain a second comparison result as the inspection result; the second comparison result represents whether the station numbers corresponding to the signal allocation requirement and the device addresses corresponding to the station numbers are consistent with the signal allocation requirement.

4. The method according to claim 1, characterized in that: Also includes: Extract the data of the target field specified by the comparison case template of each category of information to be checked from the configuration database into a database table to obtain a database master table; Correspondingly, the station number corresponding to the point item identifier is read from the configuration database to the station number field of the initial comparison case form of each category to be checked, including: The station number corresponding to the point item identification is read from the database master table and placed under the station number field of the initial comparison case form of each category to be checked.

5. The method according to claim 1, characterized in that The step of reading the station number corresponding to the point item identifier from the configuration database to the station number field of the initial comparison case form of each category to be checked, and obtaining the target comparison case form of each category to be checked, includes: Converting the point item identifier into a point item identifier that can be recognized by the configuration database; The station number corresponding to the converted point item identification is read from the configuration database to the station number field of the initial comparison case form of each category to be checked, so as to obtain the target comparison case form of each category to be checked.

6. A database configuration checking device, characterized in that: include: An acquisition module is used to acquire a number of design files, wherein the number of design files include the following types of files: an input and output list and a display list; A conversion module, used to convert each design file into an editable table file; An extraction module is used to extract data of a target field specified by each comparison case template from the table file into the comparison case template according to the comparison case template of each category of information to be checked, so as to obtain an initial comparison case form of each category of information to be checked; the target field includes a point item identifier and the first information to be compared corresponding to the point item identifier; A reading module, used for reading at least the station number corresponding to the point item identification from the configuration database to the station number field of the initial comparison case form of each category to be checked, to obtain the target comparison case form of each category to be checked; A comparison module, for performing a comparison check on each category to be checked, based on the first information to be compared corresponding to the station number in the target comparison case form of the category to be checked, and the second information to be compared corresponding to the station number read from the configuration database, to determine the inspection result of the category to be checked and add it to the target comparison case form of the category to be checked; The inspection result indicates whether the information of the category to be inspected corresponding to the station number in the configuration database is consistent with the information of the category to be inspected corresponding to the station number in the design file.

7. The device according to claim 6, characterized in that The information of each category to be checked includes: basic variable information, variable information of the operating system of the main control room, variable information of the emergency alarm system, and important signal distribution information; Among the basic variable information, the variable information of the operating system of the main control room and the variable information of the emergency alarm system, the first information to be compared corresponding to the point item identifier includes: signal description, upper limit of the range, lower limit of the range, and measurement unit; In the important signal allocation information, the first information to be compared corresponding to the point item identifier includes: signal description, column division, G / S grouping, and signal allocation requirements.

8. A computer program product, characterized in that It comprises computer-readable instructions, and when the computer-readable instructions are executed on an electronic device, the electronic device implements the database configuration checking method according to any one of claims 1 to 5.

9. An electronic device, characterized in that: The electronic device comprises at least one processor and a memory connected to the processor, wherein: The memory is used to store computer programs; The processor is used to execute the computer program so that the electronic device can implement the database configuration checking method as described in any one of claims 1 to 5.

10. A computer storage medium, characterized in that: The storage medium carries one or more computer programs, and when the one or more computer programs are executed by an electronic device, the electronic device can implement the database configuration checking method as described in any one of claims 1 to 5.

Images