Data management method and system of trusted security management system

Abstract

The invention discloses a data management method and system of a trusted security management system, and belongs to the technical field of big data, the method comprises the following steps: setting a first constraint condition, and adopting the first constraint condition to carry out column constraint on a data table; constraining the data table by adopting a primary key constraint, so that each row of data in the data table can be uniquely identified; the UNIQUE constraint is adopted to constrain the data of the column which is not constrained by the primary key in the data table, so that each row of data in the data table can be uniquely identified; establishing a verification constraint in the data table, and enabling the data written in the column of the data table to meet a set condition; foreign key constraints are set between the data tables, foreign key association is established in the foreign key constraints, interaction is formed between the data tables, and consistency is kept; according to the method, the integrity and consistency of the data table are effectively guaranteed, the data quality is improved, the data operation is simplified, the data security is enhanced, and good flexibility and expandability are achieved.

Description

Technical Field

[0001] The present invention relates to the field of big data technology, and in particular to a data management method and system for a trusted security management system. Background Art

[0002] In the DCS system (Distributed Control System) of a thermal power plant, many devices such as controllers, engineer stations, historical stations, and operator stations will continuously generate a large amount of real-time and historical data. In order to ensure the effective management and utilization of this data, the data needs to be centrally aggregated, efficiently processed, and securely stored on a trusted management platform. Achieving data synchronization and consistency between devices is a complex and critical task. For a trusted management platform to be able to effectively manage these devices, the data it runs must have extremely high integrity and consistency, which is an important prerequisite for the reliable operation of the trusted management platform.

[0003] Data management is a comprehensive discipline covering multiple technical fields. It uses various technical means to ensure the accuracy, completeness, consistency, timeliness and credibility of data. Current data management technology still requires a lot of manual intervention, including defining rules, selecting appropriate data cleaning methods and data indicators, etc., which is prone to inefficiency and human errors. The DCS system of a thermal power plant belongs to an industrial control system, which has very strict requirements for data accuracy. In addition, the DCS system of a thermal power plant is highly dependent on real-time data. Any data delay, loss or inconsistency may affect the overall performance and decision-making accuracy of the DCS system of the thermal power plant, which may lead to confusion in the production process or even safety accidents. Summary of the invention

[0004] In view of the problems existing in the prior art, the present invention provides a data management method and system for a trusted safety management system, which ensures data integrity constraints, thereby providing accurate data services for a DCS system of a thermal power plant.

[0005] The present invention is achieved through the following technical solutions: In a first aspect, the present application provides a data management method for a trusted security management system, comprising the following process: Setting a first constraint condition, and using the first constraint condition to perform column constraints on a data table of the trusted security management system; The data table is constrained by a primary key constraint so that each row of data in the data table can be uniquely identified; Using UNIQUE constraints to constrain data in columns in the data table that are not subject to the primary key constraint, so that each row of data in the data table can be uniquely identified; Establishing a check constraint in the data table so that the data written in the column of the data table meets the set condition; Set foreign key constraints between data tables, and establish foreign key associations in the foreign key constraints to interact and maintain consistency between data tables; Rules are set for the columns of the data table, and the integrity of the data modified in the data table is detected by the rules.

[0006] Preferably, the first constraint condition is used to perform column constraints on a data table of the trusted security management system, including table-level constraints and column-level constraints.

[0007] Preferably, the adopting of primary key constraint to constrain the data table so that each row of data in the data table can be uniquely identified includes: A combination of one or more fields in a data table is used as a primary key constraint to uniquely identify each row in the data table. The columns subject to the primary key constraint are non-NULL values.

[0008] Preferably, the UNIQUE constraint ensures that the values ​​of all rows in the data table on the specified column are unique, there is at least one NULL value in the column of the UNIQUE constraint, and a data table includes multiple UNIQUE constraints.

[0009] Preferably, the check constraint is triggered when data is inserted or updated, and checks whether the data to be inserted or updated meets the set conditions.

[0010] Preferably, the rule is a conditional statement, which is bound to a column of a data table. When a value is inserted or modified in a column bound to the rule, the rule detects the integrity of the modified data.

[0011] Preferably, the method further comprises the following steps: Use default values ​​to insert starting values ​​into empty columns of the data table; Automatically generate unique values ​​for rows in a data table.

[0012] In a second aspect, the present application provides a data management system for a trusted security management system, including: A column constraint module, used to set a first constraint condition, and use the first constraint condition to perform column constraints on a data table of the trusted security management system; A primary key constraint module, used to constrain the data table using a primary key constraint so that each row of data in the data table can be uniquely identified; A UNIQUE constraint module, used to constrain the data in the columns of the data table that are not subject to the primary key constraint by using a UNIQUE constraint, so that each row of data in the data table can be uniquely identified; A checking constraint module, used to establish a checking constraint in the data table so that the data written in the column of the data table meets the set conditions; The foreign key constraint module is used to set foreign key constraints between data tables. In the foreign key constraints, foreign key associations are established to form interaction and consistency between data tables. The rule module is used to set rules for the columns of the data table and detect the integrity of the data modified in the data table through the rules.

[0013] In a third aspect, the present application provides an electronic device, including: Memory for storing computer programs; A processor is used to implement the steps of the data management method of a trusted security management system when executing the computer program.

[0014] In a fourth aspect, the present application provides a computer-readable storage medium, in which a computer program is stored. When the computer program is executed by a processor, the steps of the data management method of a trusted security management system are implemented.

[0015] Compared with the prior art, the present invention has the following beneficial technical effects: The present application provides a data management method for a trusted security management system, which uses primary key constraints and UNIQUE constraints to ensure the uniqueness of data in a data table. The primary key constraint is used to uniquely identify each row in the data table, while the UNIQUE constraint ensures that the data in the specified column of the data table is not repeated, and can maintain uniqueness even when it contains multiple NULL values, which is of great significance for avoiding data redundancy and data conflicts; secondly, the use of verification constraints and rules enables automatic verification of whether the data meets the set conditions or rules when inserting or updating data, thereby strengthening the integrity of the data. This automatic verification mechanism at the data level can greatly reduce the risk of data errors and anomalies; in addition, through automated constraints and rules, the data management process has been greatly simplified. Administrators do not need to manually check the integrity and consistency of each piece of data, and these tasks are automatically completed by the trusted security management system. This not only improves work efficiency, but also reduces the possibility of human error.

[0016] Furthermore, by setting default values ​​for empty columns in the data table, you can ensure that these columns will not miss values ​​when data is inserted, thereby improving data integrity. At the same time, the function of automatically generating unique values ​​can easily generate unique identifiers. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments will be briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without creative work.

[0018] Figure 1 The figure is a flow chart of the data management method of the trusted security management system of the present invention.

[0019] Figure 2 This is a structural diagram of the data management system of the trusted security management system of the present invention. DETAILED DESCRIPTION

[0020] The present invention will be further described in detail below in conjunction with the accompanying drawings, which are intended to explain the present invention rather than to limit it.

[0021] See also Figure 1 , a data management method for a trusted security management system, comprising the following steps: Step 1: Set a first constraint condition, use the first constraint condition to perform column constraints on a data table of a trusted security management system, and use the column constraints to implement data integrity.

[0022] The function of column constraints is to limit the range of values ​​input into the data. Column constraints can be divided into table-level constraints and column-level constraints.

[0023] Column-level constraints: Column-level constraints are part of the row definition and can only be applied to one column of a data table. Column-level constraints are specified directly when defining a column, and they ensure that the value of each row in that column meets specific conditions. For example, you can set a column-level constraint on the power generation column, limiting its value to between 300 megawatts and 1000 megawatts. Such a column-level constraint ensures that the power generation is valid.

[0024] Table-level constraints: Table-level constraints are independent of column definitions and can be applied to multiple columns in a data table. Table-level constraints do not rely on the definition of a single column, but are applied to multiple columns in a data table or the entire data table. Common table-level constraints include unique constraints and verification constraints, which can span multiple columns to maintain data integrity. For example, a data table may have a table-level constraint to ensure that the power generation does not exceed the maximum limit.

[0025] Step 2: Use primary key constraints to constrain the data table so that each row of data in the data table can be uniquely identified.

[0026] A primary key constraint is a combination of one or more fields in a data table that uniquely identifies each row in the data table. The value of the primary key must be unique and cannot be NULL. The choice of the primary key is crucial to the query efficiency of the data table. A good primary key design should be short, stable, and easy to generate. For example, in a power generation data table, the power generation can be used as the primary key because it is unique and does not change.

[0027] The primary key is unique and non-empty. The most basic characteristic of the primary key is to ensure that each row of data in the data table can be uniquely identified. This means that in the same data table, no two rows can have exactly the same primary key. This uniqueness ensures accurate identification and distinction of data. The primary key constraint uses one or more columns of data in the data table to uniquely identify a record. No rows with the same primary key are allowed to exist in the data table.

[0028] The value in the column corresponding to the primary key cannot be NULL. This is because NULL means "empty", and in a data table, the primary key must be able to uniquely identify a record. If NULL is allowed as a primary key, it will be impossible to determine which records are the same or different, which will violate the definition of the primary key, that is, the column constrained by the primary key must not be a NULL value, and a data table can only have one primary key.

[0029] Alternatively, a table can have only one explicitly identified primary key constraint, and the effect of multiple primary keys can be simulated by creating a unique index or a composite primary key (a primary key composed of multiple columns). However, these methods are still considered variants of the primary key constraint.

[0030] A composite primary key is a primary key that is composed of two or more columns. Composite primary keys are used when the value of a single column is not sufficient to ensure the uniqueness of records in a data table. The combined values ​​of these columns must be unique, and each component cannot be NULL.

[0031] When choosing a primary key, you should consider its impact on query performance. The primary key is the basis of the data table, and all data table operations (such as insert, update, delete, and query) will directly or indirectly affect the primary key. Therefore, it is very important to choose a column with good data distribution, fast query speed, and infrequent update operations as the primary key.

[0032] Step 3: Use the UNIQUE constraint to constrain the data in the columns of the data table that are not subject to the primary key constraint, so that each row of data in the data table can be uniquely identified.

[0033] The UNIQUE constraint ensures that all rows in a data table have unique values ​​in the specified columns (or column combinations). Unlike the primary key constraint, the UNIQUE constraint allows NULL values ​​in the column, and a data table can have multiple UNIQUE constraints, which is very useful for situations where you need to ensure the uniqueness of certain non-primary key fields.

[0034] The difference between a UNIQUE constraint and a primary key constraint is: 1. UNIQUE constraints are mainly used to require data to be unique on one or more columns that are not primary keys.

[0035] 2. The UNIQUE constraint allows NULL values ​​to exist in the column, while the primary key never allows them.

[0036] 3. You can create multiple UNIQUE constraints in a data table, but you can only set one primary key in a data table.

[0037] Step 4: Create a CHECK constraint in the data table to ensure that the data written in the columns of the data table meet the set conditions.

[0038] CHECK constraints are used to limit the range of values ​​in a column or to ensure that data meets certain conditions. CHECK constraints can verify the validity of data when inserting or updating data. The expression of a CHECK constraint can be any SQL (Structured Query Language) expression that returns a Boolean value. For example, in a data table, you can set a CHECK constraint to ensure that the total power generated by the data table is greater than 0, which can prevent invalid order records from being inserted or updated.

[0039] CHECK constraints are triggered when data is inserted or updated, and check whether the data to be inserted or updated meets the set conditions. If the set conditions are not met, the data table will reject the operation and may return an error message. By restricting the values ​​in the column to meet the set conditions, CHECK constraints help maintain the data integrity of the data table and ensure the consistency and accuracy of the data. Data verification through CHECK constraints can reduce tedious data checks in the application code, thereby improving the performance of the application.

[0040] The verification constraint maintains the integrity of the value domain by checking the value of the data in the input data table column. It is like a gatekeeper, checking each data that is about to enter the data table in turn. Only data that meets the conditions is allowed to enter the data table.

[0041] Step 5: Set foreign key constraints between data tables. In the foreign key constraints, establish foreign key associations to form interactions between data and maintain consistency. Foreign key constraints are used to establish and maintain a consistent relationship between two tables. The foreign key of one table is a reference to the primary key of another table. Foreign key constraints ensure that each value referenced in the child table must exist in the parent table. This helps maintain referential integrity of the data. For example, in the Orders table, the customer ID (Identifier) ​​of the order should be a reference to the primary key in the Customers table to ensure that each order is associated with a valid customer.

[0042] Foreign key constraints are mainly used to maintain the consistency between two data tables. Foreign key constraints are mainly established by including the columns where the primary key is located in one data table in another data table. These columns are the foreign key constraints of the other data table.

[0043] Step 6: Apply rules to the columns of the data table and use the rules to check the integrity of the modified data.

[0044] A rule is a set of conditional statements that are bundled with the columns of a data table. When values ​​are inserted or modified in a data column that is bound to a rule, the rule will detect the integrity of the modified data.

[0045] Differences between rules and CHECK constraints 1: CHECK constraints are directly associated with data table definitions and are applicable to all scenarios where you need to ensure that column values ​​meet specific conditions. They can be defined directly in the CREATE TABLE statement or added to an existing data table in the ALTER TABLE statement. CHECK constraints are simpler than rules. Only one rule can be applied to a column, but multiple CHECK constraints can be applied.

[0046] 2: CHECK constraints are specified as part of the CREATE TABLE statement, while rules must be created separately and bound to columns or user-defined data types using the ADD RULE clause of the ALTER TABLE statement or SP BINDRULE (Stored Procedure for Binding Rules).

[0047] Use of rules: A: For a rule to take effect, it must be bound to an object in the data table (such as a column or a user-defined data type). After binding, the rule check will be triggered whenever an insert, update, or delete operation is performed on the object.

[0048] B: Rules can be applied to user-defined data types and columns in data tables, and cannot be bound to any other objects. However, it should be noted that not all database systems support binding rules to user-defined data types, which depends on the specific database implementation.

[0049] C: If a rule is bound to a column in a data table, the column must comply with the definition of the rule. If a user-defined type is bound to a rule, all columns that reference this type will be subject to the rule.

[0050] Step 7. Use the default value to insert the starting value into the empty column of the data table.

[0051] A default value is a value that is automatically inserted when the user does not provide a value for a column. It provides a default, valid starting point value for the column, helping to reduce errors and omissions in data entry. For example, in an employee table, if the employee's start date is not provided, a default value (such as the current date) can be set to automatically fill in the field. When the user does not enter a value, a default value can be assigned to a column. The nature of the default value is very similar to that of a rule and also requires binding.

[0052] Step 8: Automatically generate unique values ​​for rows in the data table.

[0053] The IDENTITY property is used to automatically generate unique values ​​in a table. When a new row is inserted into a table, if the column is set to the IDENTITY property, the table automatically generates a unique value (usually increasing) for the column. This is very useful for scenarios that require unique identifiers (such as order numbers, employee identifiers, etc.). Using the IDENTITY property can simplify the data insertion process and ensure that each record has a unique identifier.

[0054] The data management method of a trusted security management system provided by this application has the following advantages: 1. Through column constraints (column-level constraints and table-level constraints), primary key constraints, UNIQUE constraints and CHECK constraints, the input range of data is strictly limited to ensure that the data complies with the preset business rules when inserted or updated, thereby ensuring the accuracy and reliability of the data. Foreign key constraints further maintain the data consistency between data tables, ensure reference integrity, and prevent data silos and redundancy.

[0055] 2. Automatically check and correct errors and omissions in data input by setting rules and default values, reducing data quality problems caused by human factors. Use the IDENTITY attribute to automatically generate unique values, avoiding duplication and errors that may occur during manual input, and improving data accuracy and uniqueness.

[0056] 3. The introduction of rules and constraints enables data verification and correction at the data table level, reducing the data verification burden of the application and improving the performance and response speed of the application. The default value and automatic numbering functions simplify data insertion operations, reduce the user's input workload, and improve the efficiency of data processing.

[0057] 4. By setting primary key constraints and UNIQUE constraints, the uniqueness of data is ensured, data conflicts and overwriting are prevented, and data security is protected. Foreign key constraints prevent the insertion of invalid or inconsistent data by maintaining the relationship between data tables, further enhancing data security.

[0058] This technical solution effectively ensures the integrity and consistency of data tables, improves data quality, simplifies data operations, enhances data security, and has good flexibility and scalability through a series of sophisticated constraints and rule settings. It is an efficient and reliable data management method.

[0059] See also Figure 2 , the present application also proposes a data management system for a trusted security management system, including: A column constraint module, used to set a first constraint condition, and use the first constraint condition to perform column constraints on a data table of the trusted security management system; A primary key constraint module, used to constrain the data table using a primary key constraint so that each row of data in the data table can be uniquely identified; A UNIQUE constraint module, used to constrain the data in the columns of the data table that are not subject to the primary key constraint by using a UNIQUE constraint, so that each row of data in the data table can be uniquely identified; A checking constraint module, used to establish a checking constraint in the data table so that the data written in the column of the data table meets the set conditions; The foreign key constraint module is used to set foreign key constraints between data tables. In the foreign key constraints, foreign key associations are established to form interaction and consistency between data tables. The rule module is used to set rules for the columns of the data table and detect the integrity of the data modified in the data table through the rules.

[0060] It should be noted that in the several embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of each module is only a logical function division. There may be other division methods in actual implementation. For example, multiple modules can be combined or integrated into another device, or some features can be ignored or not executed. The module described as a separate component may or may not be physically separated. The component displayed as a module may be a physical unit or multiple physical units, that is, it may be located in one place, or it may be distributed in multiple different places. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment.

[0061] In addition, each module in each embodiment of the present invention may be integrated into a processing unit, each module may exist physically separately, or two or more modules may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of a software functional unit.

[0062] An electronic device provided in an embodiment of the present application includes a memory and a processor. A computer program is stored in the memory. When the processor executes the computer program, the steps of a data management method for a trusted security management system described in any of the above embodiments are implemented.

[0063] Another electronic device provided in the embodiment of the present application may also include: an input port connected to the processor, used to transmit multimodal data collected by an external acquisition device to the processor; and a display unit connected to the processor, used to display the processing results of the processor to the outside world; a communication module connected to the processor, used to realize the communication between the electronic device and the outside world. The display unit can be a display panel, a laser scanning display, etc.; the communication method adopted by the communication module includes but is not limited to mobile high-definition link technology, universal serial bus, high-definition multimedia interface, wireless connection (including wireless fidelity technology, Bluetooth communication technology, low-power Bluetooth communication technology, communication technology based on IEEE802.11s), IEEE 802.11s is a standard formulated by IEEE (Institute of Electrical and Electronics Engineers) for wireless local area networks, specifically used to support the construction and management of wireless networks.

[0064] An embodiment of the present application provides a computer-readable storage medium, in which a computer program is stored. When the computer program is executed by a processor, the steps of a data management method for a trusted security management system described in any of the above embodiments are implemented.

[0065] The computer-readable storage medium involved in this application includes random access memory (RAM), internal memory, read-only memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disks, removable disks, CD-ROMs (Compact Disc Read-Only Memory), or any other form of storage medium known in the technical field.

[0066] For the description of the relevant parts of the data management system, electronic device and computer-readable storage medium of the trusted security management system provided in the embodiment of the present application, please refer to the detailed description of the corresponding parts in the data management method of a trusted security management system provided in the embodiment of the present application, which will not be repeated here. In addition, the parts of the above-mentioned technical solutions provided in the embodiment of the present application that are consistent with the implementation principles of the corresponding technical solutions in the prior art are not described in detail to avoid excessive elaboration.

[0067] The above contents are only for explaining the technical idea of ​​the present invention and cannot be used to limit the protection scope of the present invention. Any changes made on the basis of the technical solution in accordance with the technical idea proposed by the present invention shall fall within the protection scope of the claims of the present invention.

Claims

1. A data management method for a trusted security management system, characterized in that: The process includes: Setting a first constraint condition, and using the first constraint condition to perform column constraints on a data table of the trusted security management system; The data table is constrained by a primary key constraint so that each row of data in the data table can be uniquely identified; Using UNIQUE constraints to constrain data in columns in the data table that are not subject to the primary key constraint, so that each row of data in the data table can be uniquely identified; Establishing a check constraint in the data table so that the data written in the column of the data table meets the set conditions; Set foreign key constraints between data tables, and establish foreign key associations in the foreign key constraints to interact and maintain consistency between data tables; Rules are set for the columns of the data table, and the integrity of the data modified in the data table is detected by the rules.

2. The data management method of a trusted security management system according to claim 1, characterized in that: The adopting of the first constraint condition to perform column constraints on the data table of the trusted security management system includes table-level constraints and column-level constraints.

3. The data management method of a trusted security management system according to claim 1, characterized in that: The adopting of primary key constraint to constrain the data table so that each row of data in the data table can be uniquely identified includes: A combination of one or more fields in a data table is used as a primary key constraint to uniquely identify each row in the data table. The columns subject to the primary key constraint are non-NULL values.

4. The data management method of a trusted security management system according to claim 1, characterized in that: The UNIQUE constraint ensures that the values ​​of all rows in the data table on the specified column are unique, there is at least one NULL value in the column of the UNIQUE constraint, and a data table includes multiple UNIQUE constraints.

5. The data management method of a trusted security management system according to claim 1, characterized in that: The check constraint is triggered when data is inserted or updated, and checks whether the data to be inserted or updated meets the set conditions.

6. The data management method of a trusted security management system according to claim 1, characterized in that: The rule is a conditional statement, which is bound to a column of a data table. When a value is inserted or modified in a column bound to the rule, the rule detects the integrity of the modified data.

7. The data management method of a trusted security management system according to claim 1, characterized in that: The following processes are also included: Use default values ​​to insert starting values ​​into empty columns of the data table; Automatically generate unique values ​​for rows in a data table.

8. A data management system for a trusted security management system, characterized in that: include: A column constraint module, used to set a first constraint condition, and use the first constraint condition to perform column constraints on a data table of the trusted security management system; A primary key constraint module, used to constrain the data table using a primary key constraint so that each row of data in the data table can be uniquely identified; A UNIQUE constraint module, used to constrain the data in the columns of the data table that are not subject to the primary key constraint by using a UNIQUE constraint, so that each row of data in the data table can be uniquely identified; A checking constraint module, used to establish a checking constraint in the data table so that the data written in the column of the data table meets the set conditions; The foreign key constraint module is used to set foreign key constraints between data tables. In the foreign key constraints, foreign key associations are established to form interaction and consistency between data tables. The rule module is used to set rules for the columns of the data table and detect the integrity of the data modified in the data table through the rules.

9. An electronic device, characterized in that: include: Memory for storing computer programs; A processor, configured to implement the steps of a data management method for a trusted security management system as described in any one of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the data management method of a trusted security management system as described in any one of claims 1 to 7 are implemented.

Images