An intelligent isolation method for ERP sensitive data

By calculating the abnormality and sensitivity of the employees' sensitive query instructions in the ERP system and dynamically adjusting the encryption level, the problem of lack of access control during sensitive data transmission in the ERP system is solved, and the security and detection capabilities of sensitive data are improved.

CN118802386BActive Publication Date: 2024-11-26SHCCIG YULIN CHEM CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411292267.2
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-09-14
Publication Date
2024-11-26
Estimated Expiration
2044-09-14

Smart Images

  • Figure CN118802386B_ABST
    Figure CN118802386B_ABST
Patent Text Reader

Abstract

The present invention belongs to the technical field of sensitive data encryption, and specifically relates to an ERP sensitive data intelligent isolation method, the method comprising: constructing keys of different levels, and assigning corresponding levels of private keys and data points in the access tree to employees of different levels in the enterprise according to the access tree constructed by the keys; configuring sensitive servers and normal servers for storing sensitive data and normal data; in response to the sensitive server receiving a sensitive query instruction sent by an employee, querying and obtaining query results according to the sensitive query instruction; taking the result of rounding up the sum of the abnormality degree and the sensitivity degree as the encryption level corresponding to when the employee sends the sensitive query instruction; encrypting the query result according to the encryption level, obtaining the return result corresponding to the sensitive query instruction and sending it to the employee. The present invention realizes access control and restriction on query behavior of sensitive data by dynamically adjusting the encryption level, thereby improving the security of sensitive data.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of sensitive data encryption technology, and more specifically, to an ERP sensitive data intelligent isolation method. Background Art

[0002] ERP (Enterprise Resource Planning) system is a common enterprise management software system. The system manages the logistics, personnel flow, capital flow and information flow of the enterprise in a unified manner in order to maximize the use of the enterprise's existing resources and maximize the enterprise's economic benefits.

[0003] In the related technology, for example, the Chinese patent application document with application publication number CN111835723A discloses a business data encryption transmission system and method based on a cloud platform, wherein the system includes an ERP client, a data encryption gateway and a cloud platform; the ERP client is connected to the cloud platform through a data encryption gateway; the ERP client is used to obtain business data and transmit the business data to the data encryption gateway; the data encryption gateway encrypts the business data and uploads the encrypted ciphertext data to the database of the cloud platform. The invention uses the data encryption gateway as the entrance and exit of the cloud platform database, encrypts the data uploaded by the ERP client and sends it to the database of the cloud platform, and decrypts the data when reading it. When the ERP client reads the data stored in the cloud platform through the data encryption gateway, it can obtain plaintext data, while external personnel can only obtain ciphertext by directly reading the data without going through the data encryption gateway, thereby improving the security of business data transmission.

[0004] In related technologies, when enterprises use ERP management software, uploading encrypted ciphertext data to the database of the cloud platform increases the security of data transmission, but there is no access control and restriction on the query behavior of sensitive data, which poses a security risk. Summary of the invention

[0005] In order to solve the technical problems, the present invention provides solutions in the following aspects.

[0006] In a first aspect, the present invention provides an ERP sensitive data intelligent isolation method, comprising: in response to a sensitive server receiving a sensitive query instruction sent by an employee, querying and obtaining a query result according to the sensitive query instruction; encrypting the query result according to an encryption level, obtaining a return result corresponding to the sensitive query instruction and sending it to the employee; the encryption level is obtained by: according to the time difference between the employee sending the sensitive query instruction and each normal query instruction, weighting the matching results of each query condition of the sensitive query instruction in each normal query instruction, and calculating the correlation between the sensitive query instruction and each normal query instruction; taking the difference between the total number of all query columns and all query conditions in the sensitive query instruction as the range size of the sensitive query instruction; The abnormality degree of the sensitive query instruction is calculated based on the correlation, range size, the time difference between the employee sending the sensitive query instruction and the last time the employee sent a sensitive query instruction, the time difference between the employee sending the sensitive query instruction and the last time the employee sent a normal query instruction, the employee's level and the encryption level corresponding to the last time the employee sent a sensitive query instruction; the sensitivity of each sensitive table in the sensitive query instruction is weighted according to the number of query columns belonging to each sensitive table in all query columns in the sensitive query instruction and the number of query conditions involving each sensitive table in all query conditions, and the sensitivity of the sensitive query instruction is calculated; the result of rounding up the sum of the abnormality degree and the sensitivity degree is used as the encryption level corresponding to the time when the employee sent the sensitive query instruction.

[0007] The present invention enhances the ability to detect potential abnormal query behaviors and reduces the possibility of sensitive data leakage by calculating the abnormality and sensitivity of sensitive query instructions sent by employees, and comprehensively evaluates the encryption level according to the abnormality and sensitivity, and then dynamically adjusts the encryption strength corresponding to when the employee sends the sensitive query instruction. By dynamically adjusting the encryption level to cope with different query risks, access control and restriction on query behaviors of sensitive data are achieved, security risks are eliminated, and the security of sensitive data is improved.

[0008] Preferably, the correlation between the sensitive query instruction and each normal query instruction satisfies the expression: ; In the formula, Indicates that the sensitive query instruction is The relevance of a normal query command, Indicates the time when the employee sent the sensitive query instruction. Indicates that the employee sent The time point of a normal query instruction, Indicates the preset time length. represents the maximum value function, Indicates the total number of all query conditions of the sensitive query instruction. Indicates the first The query condition is in a matching result in a normal query instruction; in response to being able to Find all the query conditions of the normal query command that match the sensitive query command. The query conditions are exactly the same. ,otherwise, .

[0009] The present invention calculates the correlation between sensitive query instructions and each normal query instruction, evaluates the relationship between sensitive query instructions and historical normal query instructions, helps to identify abnormal query behavior, and further improves the security of sensitive data by setting a higher encryption level.

[0010] Preferably, the range size of the sensitive query instruction satisfies the expression: ; In the formula, Indicates the scope of the sensitive query instruction. Indicates the total number of all query columns between the first keyword and the second keyword in the sensitive query instruction. Indicates the total number of all query conditions after the third keyword in the sensitive query instruction.

[0011] The present invention helps to evaluate the potential risk of sensitive query instructions by calculating the range of sensitive query instructions, and further improves the security of sensitive data by setting a higher encryption level.

[0012] Preferably, the calculation of the abnormality degree of the sensitive query instruction includes: in response to the existence of a correlation greater than a first threshold in the correlation between the sensitive query instruction and all normal query instructions, the abnormality degree of the sensitive query instruction satisfies the expression: In response to the fact that the correlation between the sensitive query instruction and all normal query instructions is not greater than the first threshold, but there is a correlation greater than the second threshold, then In response to the relevance of the sensitive query instruction to all normal query instructions being no greater than the second threshold, ; In the formula, Indicates the scope of the sensitive query instruction. Indicates the employee's level. Indicates parameters; , and They respectively represent the time when the employee sent the sensitive query instruction, the time when the employee last sent a sensitive query instruction, and the time when the employee last sent a normal query instruction. represents the natural exponential function, Indicates the encryption level corresponding to the last time the employee sent a sensitive query instruction. represents the maximum value function, Indicates that the sensitive query instruction is The relevance of a normal query command, Indicates a preset first quantity; the first threshold is greater than the second threshold.

[0013] The present invention combines the correlation between the sensitive query instruction and each normal query instruction, the range of the sensitive query instruction, the time difference between the employee sending the sensitive query instruction and the last time he sent a sensitive query instruction, the time difference between the employee sending the sensitive query instruction and the last time he sent a normal query instruction, the employee's level and the encryption level corresponding to the last time the employee sent a sensitive query instruction, and comprehensively evaluates the abnormality of the sensitive query instruction, thereby adjusting the encryption level to prevent potential abnormal query behavior on sensitive data, thereby improving the security of sensitive data.

[0014] Preferably, the sensitivity of the sensitive query instruction satisfies the expression: ; In the formula, Indicates the sensitivity of the sensitive query instruction. Indicates the total number of all sensitive tables between the second keyword and the third keyword in the sensitive query instruction. Indicates that all query columns between the first keyword and the second keyword in the sensitive query instruction belong to The number of query columns of sensitive tables, Indicates The number of all columns in the sensitive table, Indicates that all query conditions after the third keyword in the sensitive query instruction involve the The number of query conditions for sensitive tables, Indicates the total number of all query conditions after the third keyword in the sensitive query instruction. Indicates The sensitivity of the sensitivity table, represents the natural exponential function.

[0015] The present invention weights the sensitivity of the sensitive table by query columns and query conditions, and can accurately evaluate the sensitivity of the data involved in the sensitive query instruction, ensuring that the sensitive data is properly protected during the query process, thereby improving the security of the sensitive data.

[0016] Preferably, the method further comprises: setting Levels, respectively Level to grade, equal to the preset first number; set a key for each level, the key includes a public key and a private key, wherein the first The public key of the level is , the private key is , , , Respectively represent The first parameter, the second parameter and the third parameter in the key of the level.

[0017] Preferably, the method further comprises: constructing an access tree based on keys of all levels; the access tree is respectively from level 1 to level 2 from bottom to top. Layer, among which The layer has only one node, which is a non-leaf node; all nodes in the first layer are leaf nodes, and the number of all nodes is , represents the total number of all nodes in layer 1, represents the total number of all employees at level 1, Indicates the preset second quantity, Indicates the maximum value function; in the other layers, The number of all nodes in the layer is , Indicates The total number of all employees at the level; only one of the nodes is a non-leaf node, and the other nodes are leaf nodes; and The key for the level is stored in In the non-leaf nodes of the layer.

[0018] Preferably, the non-leaf nodes of each layer in the access tree correspond to a polynomial, and the leaf nodes of each layer correspond to a data point, specifically: The polynomial corresponding to the non-leaf nodes of the layer for The specific expression is: ; represents the independent variable, Indicates The polynomial corresponding to the non-leaf nodes of the layer Secondary The coefficient of , Indicates The polynomial corresponding to the non-leaf nodes of the layer, Indicates The independent variable in the polynomial corresponding to the non-leaf nodes of the layer The result of Layer The data points corresponding to the leaf nodes are , , Indicates The independent variable in the polynomial corresponding to the non-leaf nodes of the layer The result of time.

[0019] Preferably, the method further comprises: Level employees have Level to level; also has access to the private key of The data point corresponding to any leaf node of the layer.

[0020] Preferably, the method further comprises: after the employee receives the return result corresponding to the sensitive query instruction, the process of decrypting the return result is: in response to the encryption level corresponding to the sensitive query instruction sent by the employee , Indicates the employee's level. The private key of the level is used to decrypt the return result corresponding to the sensitive query instruction to obtain the query result; in response to , the same level is required An employee helps the employee complete the verification, and this An employee and all data points for that employee are not identical to each other, or a Only when an employee of the same level authorizes the sensitive query instruction of the employee can the return result corresponding to the sensitive query instruction be decrypted and the query result be obtained. Indicates a preset second quantity; in response to , then the employee cannot decrypt the return result corresponding to the sensitive query instruction.

[0021] The beneficial effects of the present invention are:

[0022] The present invention enhances the ability to detect potential abnormal query behaviors and reduces the possibility of sensitive data leakage by calculating the abnormality and sensitivity of sensitive query instructions sent by employees, and comprehensively evaluates the encryption level according to the abnormality and sensitivity, and then dynamically adjusts the encryption strength corresponding to when the employee sends the sensitive query instruction. By dynamically adjusting the encryption level to cope with different query risks, access control and restriction on query behaviors of sensitive data are achieved, security risks are eliminated, and the security of sensitive data is improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] The above and other purposes, features and advantages of the exemplary embodiments of the present invention will become readily understood by reading the detailed description below through the accompanying drawings. In the accompanying drawings, several embodiments of the present invention are shown in an exemplary and non-limiting manner, and the same or corresponding reference numerals represent the same or corresponding parts, wherein:

[0024] Figure 1is a flow chart schematically illustrating a method for intelligently isolating ERP sensitive data in the present invention;

[0025] Figure 2 Schematically illustrates the access tree constructed by the present invention;

[0026] Figure 3 is a flow chart schematically showing step S3 of the present invention. DETAILED DESCRIPTION

[0027] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative work are within the scope of protection of the present invention.

[0028] The specific embodiments of the present invention are described in detail below with reference to the accompanying drawings.

[0029] The embodiment of the present invention discloses an ERP sensitive data intelligent isolation method, referring to Figure 1 , including steps S1 to S3:

[0030] S1. Construct keys of different levels. According to the access tree constructed by the keys, assign corresponding private keys and data points in the access tree to employees of different levels in the enterprise.

[0031] It should be noted that if the enterprise does not set up strict authority control and data access policies, unauthorized personnel may easily access sensitive data. In this case, even if the data is encrypted and protected during transmission and storage, the security of the database may be threatened due to insufficient authority management. In order to ensure the ultimate security of data, the present invention constructs keys of different levels, and assigns corresponding private keys and data points in the access tree to employees of different levels in the enterprise according to the access tree constructed by the keys, so as to control the access rights to keys of each level to prevent data leakage and unauthorized access.

[0032] Specifically, set Levels, respectively Level to grade, equal to the preset first number; set a key for each level, the key includes a public key and a private key, wherein the first The public key of the level is , the private key is , , , Respectively represent The first parameter, the second parameter and the third parameter in the hierarchical key, the methods for obtaining the three parameters are all well-known methods in the RSA encryption algorithm, and will not be repeated here.

[0033] The specific value of the preset first number can be set according to actual application scenarios and requirements, and the preset first number is an integer in the range of [3, 10]. The present invention sets the preset first number to 6.

[0034] Furthermore, a ciphertext policy attribute-based encryption (CP-ABE) scheme is designed to control the access rights to keys of each level. The attribute-based encryption scheme mainly controls the access rights to keys of each level by constructing an access tree. The access tree can be used to hide keys of each level. The keys of the corresponding level can only be decrypted when certain conditions are met. The access tree is composed of leaf nodes and non-leaf nodes. Non-leaf nodes are also called threshold nodes. Employees can only decrypt the keys of the corresponding level of this node when the threshold value is met. Therefore, the keys of each level are stored in the non-leaf nodes of each layer corresponding to each level, and the keys of each level are stored in the non-leaf nodes of each layer corresponding to each level. The key for the level is stored in The non-leaf nodes of the layer, so only the The polynomial corresponding to the non-leaf nodes of the layer can be obtained The key of the level; the leaf node contains the data points passed from the parent node.

[0035] Among them, the access tree constructed by the present invention is as follows Figure 2 As shown, from bottom to top, they are layer 1 to layer 2. =6 layers, and the Layer corresponds to Level; Among them, the 6th layer has only one node, and it is a non-leaf node; all nodes in the 1st layer are leaf nodes, and the number of all nodes is , represents the total number of all nodes in layer 1, represents the total number of all employees at level 1, Indicates the preset second quantity, represents the maximum value function; the number of all nodes in the remaining layers is , Indicates The total number of nodes in the layer, Indicates The total number of all employees at the same level; among all the nodes in the remaining layers, only one node is a non-leaf node, and the other nodes are leaf nodes; the non-leaf nodes of each layer in the access tree correspond to a polynomial, and the leaf nodes of each layer correspond to a data point.

[0036] Among them, The polynomial corresponding to the non-leaf nodes of the layer for A polynomial includes each degree term and its coefficient. The specific expression of the polynomial is: ; represents the independent variable, Indicates The polynomial corresponding to the non-leaf nodes of the layer Secondary The coefficient of , Indicates The polynomial corresponding to the non-leaf nodes of the layer, Indicates The independent variable in the polynomial corresponding to the non-leaf nodes of the layer The result of time.

[0037] Among them, Layer The data points corresponding to the leaf nodes are , , Indicates The polynomial corresponding to the non-leaf nodes of the layer, Indicates The independent variable in the polynomial corresponding to the non-leaf nodes of the layer The result of time.

[0038] The specific value of the preset second number can be set according to the actual application scenario and requirements, and the preset second number is an integer in the range of [3,10]. The present invention sets the preset second number to 4.

[0039] For example, when the independent variable in the polynomial corresponding to the non-leaf node of the third layer is The result of When , for the polynomial corresponding to the non-leaf nodes in the second layer, it is required , then the polynomial corresponding to the non-leaf nodes of the second layer can be: , or: .

[0040] Exemplarily, when the polynomial corresponding to the non-leaf node of the second layer is: , and the number of all nodes in layer 1 When , the independent variable in the polynomial corresponding to the non-leaf node of the second layer The result is , then the data point corresponding to the first leaf node of the first layer is ; The independent variable in the polynomial corresponding to the non-leaf nodes of the second layer The result is , then the data point corresponding to the second leaf node of the first layer is ; The independent variable in the polynomial corresponding to the non-leaf nodes of the second layer The result is , then the data point corresponding to the third leaf node of the first layer is ; The independent variable in the polynomial corresponding to the non-leaf nodes of the second layer The result is , then the data point corresponding to the 4th leaf node of the first layer is ; The independent variable in the polynomial corresponding to the non-leaf nodes of the second layer The result is , then the data point corresponding to the 5th leaf node of the first layer is .

[0041] For example, the access tree hides the keys at each level. The key for the level is stored in Among the non-leaf nodes of the layer, only the The polynomial corresponding to the non-leaf nodes of the layer can be obtained Therefore, for employees who do not have the second-level key, if they want to obtain the second-level key, they need to obtain the polynomial corresponding to the non-leaf nodes of the second layer. Since the polynomial corresponding to the non-leaf nodes of the second layer is a cubic polynomial, it is necessary to know the data points corresponding to all leaf nodes of the first layer. , , , , By using the four data points in , we can solve the polynomial corresponding to the non-leaf nodes of the second layer, and then obtain the second-level key stored in the non-leaf nodes of the second layer.

[0042] Specifically, the first Level employees have Level to level; also has access to the private key of The data point corresponding to any leaf node of the layer.

[0043] S2. Configure sensitive servers and normal servers to store sensitive data and normal data.

[0044] Specifically, sensitive data is distributed in multiple data tables, which are recorded as sensitive tables; a database storing the sensitive tables is placed on a sensitive server, and at the same time, the sensitivity of each sensitive table is set, and the sensitivity of the query table is in the range of [0,1].

[0045] Furthermore, normal data is distributed in multiple data tables, which are recorded as normal tables; and a database storing the normal tables is placed on a normal server.

[0046] Furthermore, the sensitive server is connected to a normal server used by employees, so that employees can establish cross-database sensitive query instructions on the normal server to point to sensitive tables and sensitive data in the sensitive server.

[0047] The parameters configured in the sensitive server include: the names of all employees, the levels of all employees, the keys of all levels, and the access tree.

[0048] S3. In response to the sensitive server receiving the sensitive query instruction sent by the employee, the sensitive server queries and obtains the query result according to the sensitive query instruction; encrypts the query result according to the encryption level, obtains the return result corresponding to the sensitive query instruction and sends it to the employee.

[0049] Specifically, for any query instruction, when the query instruction is used to query sensitive data stored in a sensitive server, the query instruction is recorded as a sensitive query instruction; when the query instruction is used to query normal data stored in a normal server, the query instruction is recorded as a normal query instruction; when an employee wants to query sensitive data stored in a sensitive server, the employee sends a sensitive query instruction to the sensitive server.

[0050] It should be noted that SQL (Structured Query Language) is a "structured query language" that is an operating language for relational databases; DQL (Data Query Language) is a data query language. When a database executes a DQL statement, it will not change the data stored in the database, but will let the database send the result set to the employee.

[0051] Among them, the important syntax in DQL statements includes: , as well as ;in, The keyword includes at least one column name to be queried, and multiple column names to be queried are separated by commas; The keyword includes at least one name of a table to be queried. Multiple table names to be queried are connected through inner or outer joins to achieve multi-table join query. Among them, outer joins are divided into left joins and right joins. The keyword must be followed by at least one , multiple Through or The two keywords are concatenated.

[0052] Further, , , , and These five keywords are respectively recorded as the first keyword, the second keyword, the third keyword, the fourth keyword and the fifth keyword.

[0053] Furthermore, for any query instruction, the names of all columns that need to be queried are included between the first keyword and the second keyword, and these columns are recorded as query columns. It should be noted that when there is a "*" between the first keyword and the second keyword, all columns in the table that need to be queried are columns that need to be queried, and these columns are recorded as query columns; the names of all tables that need to be queried are included between the second keyword and the third keyword, and these tables are recorded as query tables, and the query tables include normal tables and sensitive tables; all query conditions are included between the third keyword, and the query conditions are divided as follows: the content after the third keyword in the query instruction is divided into multiple sub-contents through the fourth keyword and the fifth keyword, and one sub-content is used as a query condition, then the total number of all query conditions is equal to the total number of all sub-contents.

[0054] It is particularly important to note that when the third keyword does not exist in the query instruction, the names of all tables to be queried are included after the second keyword, and these tables are recorded as query tables, and there is no query condition in the query instruction.

[0055] Furthermore, in response to the sensitive server receiving the sensitive query instruction sent by the employee, the sensitive query instruction is used to query and obtain the query result in the sensitive data table on the sensitive server; the query result is encrypted according to the encryption level, and the return result corresponding to the sensitive query instruction is obtained and sent to the employee.

[0056] Among them, the method for obtaining the encryption level is: according to the time difference between the employee sending the sensitive query instruction and each normal query instruction, the matching results of each query condition of the sensitive query instruction in each normal query instruction are weighted to calculate the correlation between the sensitive query instruction and each normal query instruction; the difference between the total number of all query columns and all query conditions in the sensitive query instruction is used as the range size of the sensitive query instruction; according to the correlation, the range size, the time difference between the employee sending the sensitive query instruction and the last time the sensitive query instruction was sent, the time difference between the employee sending the sensitive query instruction and the last time the normal query instruction was sent, the level of the employee and the encryption level corresponding to the last time the employee sent the sensitive query instruction, the abnormality of the sensitive query instruction is calculated; according to the number of query columns belonging to each sensitive table in all query columns in the sensitive query instruction and the number of query conditions involving each sensitive table in all query conditions, the sensitivity of each sensitive table in the sensitive query instruction is weighted to calculate the sensitivity of the sensitive query instruction; the result of rounding up the sum of the abnormality and the sensitivity is used as the encryption level corresponding to when the employee sent the sensitive query instruction.

[0057] The flowchart of step S3 is shown in FIG. Figure 3 , including steps S301 to S307, specifically:

[0058] S301. Calculate the correlation between the sensitive query instruction and each normal query instruction.

[0059] Specifically, according to the time difference between the employee sending the sensitive query instruction and each normal query instruction, the matching results of each query condition of the sensitive query instruction in each normal query instruction are weighted, and the correlation between the sensitive query instruction and each normal query instruction is calculated, and the correlation satisfies the expression:

[0060] ;

[0061] In the formula, Indicates that the sensitive query instruction is The relevance of a normal query command, Indicates the sequence number of a normal query command. Take all All integers in the range, Indicates the preset third quantity, Indicates the time when the employee sent the sensitive query instruction. Indicates that the employee sent The time point of a normal query instruction, Indicates the preset time length. represents the maximum value function, Indicates the total number of all query conditions of the sensitive query instruction. Indicates the first The query condition is in The matching result in the normal query instruction: Find all the query conditions of the normal query command that match the sensitive query command. The query conditions are exactly the same. ,otherwise, .

[0062] It should be noted that This employee sent the sensitive query instruction to The time difference of a normal query command, represents the weight. The smaller the time difference, the greater the weight. The corresponding sensitive query instruction is The relevance of a normal query command The bigger; Represents the first The query condition is in The matching results in the normal query command, Represents all query conditions of the sensitive query instruction and The greater the value, the more sensitive the query instruction is. The relevance of a normal query command The bigger.

[0063] Among them, the specific values ​​of the preset time length and the preset third number can be set according to the actual application scenario and requirements, and the value range of the preset time length is [1,8], in minutes, and the preset third number is an integer in the range of [5,20]. The present invention sets the preset time length to 5 minutes and the preset third number to 10.

[0064] It should be further explained that the present invention calculates the correlation between sensitive query instructions and each normal query instruction and evaluates the relationship between sensitive query instructions and historical normal query instructions, which helps to identify abnormal query behavior and further improve the security of sensitive data by setting a higher encryption level.

[0065] S302: Calculate the range of the sensitive query instruction.

[0066] Specifically, the difference between the total number of all query columns and all query conditions in the sensitive query instruction is used as the range size of the sensitive query instruction; the range size satisfies the expression:

[0067] ;

[0068] In the formula, Indicates the scope of the sensitive query instruction. Indicates the total number of all query columns between the first keyword and the second keyword in the sensitive query instruction. Indicates the total number of all query conditions after the third keyword in the sensitive query instruction.

[0069] It should be noted that when the third keyword does not exist in the query instruction, there is no query condition in the query instruction. .

[0070] It should be noted that Represents the total number of all query columns. The larger the value, the more query results are obtained according to the sensitive query instruction, so the scope of the sensitive query instruction is larger; Represents the total number of all query conditions. The larger the value, the fewer query results obtained according to the sensitive query instruction, and the smaller the scope of the sensitive query instruction.

[0071] It should be further explained that the present invention helps to evaluate the potential risks of sensitive query instructions by calculating the range of sensitive query instructions, and then improves the security of sensitive data by setting a higher encryption level.

[0072] S303: Calculate the abnormality level of the sensitive query instruction.

[0073] Specifically, the abnormality of the sensitive query instruction is calculated based on the correlation between the sensitive query instruction and each normal query instruction, the scope of the sensitive query instruction, the time difference between the employee sending the sensitive query instruction and the last time the employee sent a sensitive query instruction, the time difference between the employee sending the sensitive query instruction and the last time the employee sent a normal query instruction, the employee's level and the encryption level corresponding to the last time the employee sent a sensitive query instruction. Specifically,

[0074] 1. In response to the fact that there is a correlation greater than a first threshold value in the correlation between the sensitive query instruction and all normal query instructions, the abnormality degree of the sensitive query instruction satisfies the expression:

[0075] ;

[0076] In the formula, Indicates the abnormality of the sensitive query instruction. Indicates the scope of the sensitive query instruction. Indicates the employee's level. Indicates parameters; Indicates the time when the employee sent the sensitive query instruction. Indicates the time when the employee last sent a sensitive query instruction. Indicates the time when the employee last sent a normal query instruction. represents the natural exponential function, Indicates the encryption level corresponding to the last time the employee sent a sensitive query instruction. Indicates the employee's level. Represents the maximum value function.

[0077] It should be noted that when there is a correlation greater than the first threshold value between the correlations between the sensitive query instruction and all the normal query instructions, it means that the employee sending the sensitive query instruction is more likely to be strongly correlated with a normal query instruction sent once. Therefore, it is only necessary to judge the abnormality of the sensitive query instruction by the range of the sensitive query instruction, the time difference between the employee sending the sensitive query instruction and the last time the sensitive query instruction was sent, the time difference between the employee sending the sensitive query instruction and the last time the normal query instruction was sent, the level of the employee, and the encryption level corresponding to the last time the employee sent the sensitive query instruction; wherein, Represents the size of the allowable range corresponding to the employee's level, and the ratio of the range of the sensitive query instructions sent by the employee to the size of the allowable range corresponding to the employee's level The larger the value, the more abnormal the sensitive query instruction is. The bigger; It represents the time difference between the time when the employee sent the sensitive query instruction and the last time he sent the sensitive query instruction. The smaller the value, the more frequently the employee sent the sensitive query instruction. The bigger; It represents the time difference between the time when the employee sent the sensitive query instruction and the time when the employee sent the normal query instruction last time. The larger the value, the more likely it is that the sensitive query instruction sent by the employee is related to the normal query instruction sent last time. The smaller the encryption level is; when the employee last sent a sensitive query command, the corresponding encryption level was greater than the employee's level When , it means that the employee has tried to query sensitive data with high sensitivity, and the abnormality of the sensitive query instruction is The bigger.

[0078] The specific value of the parameter can be set according to the actual application scenario and requirements, and the value range of the parameter is [1,3]. The present invention sets the parameter to 1.8.

[0079] 2. In response to the fact that the correlation between the sensitive query instruction and all normal query instructions is not greater than the first threshold, but there is a correlation greater than the second threshold, the abnormality degree of the sensitive query instruction satisfies the expression:

[0080] ;

[0081] In the formula, Indicates that the sensitive query instruction is The relevance of a normal query command, Indicates the preset first quantity, Represents the maximum value function.

[0082] It should be noted that when the correlation between the sensitive query instruction and all normal query instructions is not greater than the first threshold, but there is a correlation greater than the second threshold, it means that the correlation between the employee sending the sensitive query instruction and a normal query instruction is strong. Therefore, the maximum value of the correlation between the sensitive query instruction and all normal query instructions is obtained. The larger the value, the stronger the correlation between the employee sending the sensitive query instruction and a normal query instruction, and the higher the abnormality of the sensitive query instruction. The smaller.

[0083] 3. In response to the fact that the correlation between the sensitive query instruction and all normal query instructions is not greater than the second threshold, the abnormality degree of the sensitive query instruction satisfies the expression:

[0084] ;

[0085] It should be noted that when the correlation between the sensitive query instruction and all normal query instructions is not greater than the second threshold, it means that the correlation between the sensitive query instruction sent by the employee and all normal query instructions is not strong. Therefore, the average value of the correlation between the sensitive query instruction and all normal query instructions is obtained. The larger the value, the stronger the correlation between the employee sending the sensitive query instruction and a normal query instruction, and the higher the abnormality of the sensitive query instruction. The smaller.

[0086] The first threshold is greater than the second threshold; wherein, the specific values ​​of the first threshold and the second threshold can be set according to actual application scenarios and requirements, and the first threshold is greater than the second threshold, and the value range of the first threshold is [0.5,1]. Therefore, the present invention sets the first threshold to 0.8 and the second threshold to 0.6.

[0087] It should be further explained that the present invention combines the correlation between the sensitive query instruction and each normal query instruction, the range of the sensitive query instruction, the time difference between the employee sending the sensitive query instruction and the last time he sent a sensitive query instruction, the time difference between the employee sending the sensitive query instruction and the last time he sent a normal query instruction, the employee's level and the encryption level corresponding to the last time the employee sent a sensitive query instruction, to comprehensively evaluate the abnormality of the sensitive query instruction, thereby adjusting the encryption level to prevent potential abnormal query behavior on sensitive data, thereby improving the security of sensitive data.

[0088] S304: Calculate the sensitivity of the sensitive query instruction.

[0089] Specifically, according to the number of query columns belonging to each sensitive table in all query columns in the sensitive query instruction and the number of query conditions involving each sensitive table in all query conditions, the sensitivity of each sensitive table in the sensitive query instruction is weighted to calculate the sensitivity of the sensitive query instruction; the sensitivity satisfies the expression:

[0090] ;

[0091] In the formula, Indicates the sensitivity of the sensitive query instruction. Indicates the total number of all sensitive tables between the second keyword and the third keyword in the sensitive query instruction. Indicates that all query columns between the first keyword and the second keyword in the sensitive query instruction belong to The number of query columns of sensitive tables, Indicates The number of all columns in the sensitive table, Indicates that all query conditions after the third keyword in the sensitive query instruction involve the The number of query conditions for sensitive tables, Indicates the total number of all query conditions after the third keyword in the sensitive query instruction. Indicates The sensitivity of the sensitivity table, represents the natural exponential function.

[0092] It should be noted that Represents the The weight of the sensitive table, The larger the value is, the more the query results obtained according to the sensitive query instruction involve sensitive data in sensitive tables, then The larger the weight of a sensitive table; The larger the value, the more sensitive the query instruction is. The more query conditions there are for a sensitive table, the fewer the query results obtained according to the sensitive query instruction involve. sensitive data in sensitive tables, then The smaller the weight of a sensitive table.

[0093] It should be further explained that the present invention weights the sensitivity of the sensitive table by query columns and query conditions, and can accurately evaluate the sensitivity of the data involved in the sensitive query instruction, ensuring that the sensitive data is properly protected during the query process, thereby improving the security of the sensitive data.

[0094] S305: Calculate the encryption level corresponding to when the employee sends the sensitive query instruction.

[0095] Specifically, the sum of the abnormality level and the sensitivity level of the sensitive query instruction is calculated, and the result of rounding up the sum is used as the encryption level corresponding to when the employee sends the sensitive query instruction.

[0096] S306. Encrypt the query result according to the encryption level corresponding to when the employee sends the sensitive query instruction, obtain the return result corresponding to the sensitive query instruction and send it to the employee.

[0097] Specifically, the query result is encrypted using the RSA encryption algorithm according to the public key in the key of the encryption level corresponding to when the employee sends the sensitive query instruction, so as to obtain the return result corresponding to the sensitive query instruction.

[0098] S307: After receiving the return result corresponding to the sensitive query instruction, the employee decrypts the return result.

[0099] Specifically, after the employee receives the return result corresponding to the sensitive query instruction, the process of decrypting the return result is as follows: in response to the encryption level corresponding to the sensitive query instruction sent by the employee , Indicates the employee's level. The private key of the level is used to decrypt the return result corresponding to the sensitive query instruction to obtain the query result; in response to , the same level is required An employee helps the employee complete the verification, and this An employee and all data points for that employee are not identical to each other, or a Only when an employee of the same level authorizes the sensitive query instruction of the employee can the return result corresponding to the sensitive query instruction be decrypted to obtain the query result; in response to , then the employee cannot decrypt the return result corresponding to the sensitive query instruction.

[0100] For example, when accessing the data points corresponding to all leaf nodes in the first layer of the tree, they are , , , , , the employee's level And the data point that this employee has is , and the corresponding encryption level when the employee sends the sensitive query instruction Since the employee only has the first-level private key, in order to decrypt the return result corresponding to the sensitive query instruction, three first-level employees are needed to help the employee complete the verification. The employees and all the data points they have are different from each other, that is, the data points they need to have are , , , Only when three first-level employees of any three data points help the employee to complete the verification, or a second-level employee authorizes the employee's sensitive query instruction, can the polynomial corresponding to the non-leaf node of the second layer be solved, and then the second-level key stored in the non-leaf node of the second layer be obtained, and then the return result corresponding to the sensitive query instruction is decrypted according to the second-level private key to obtain the query result.

[0101] It should be noted that the present invention enhances the ability to detect potential abnormal query behaviors and reduces the possibility of sensitive data leakage by calculating the abnormality and sensitivity of sensitive query instructions sent by employees, and comprehensively evaluates the encryption level according to the abnormality and sensitivity, and then dynamically adjusts the encryption strength corresponding to when the employee sends the sensitive query instruction. By dynamically adjusting the encryption level to cope with different query risks, access control and restriction on query behaviors of sensitive data are implemented, security risks are eliminated, and the security of sensitive data is improved.

[0102] In the description of this specification, "plurality" or "several" means at least two, such as two, three or more, etc., unless otherwise clearly and specifically defined.

[0103] Although this specification has shown and described a number of embodiments of the present invention, it will be apparent to those skilled in the art that such embodiments are provided by way of example only. Those skilled in the art will conceive of many modifications, changes and alternatives without departing from the ideas and spirit of the present invention. It should be understood that in the practice of the present invention, alternatives to the embodiments of the present invention described herein may be employed.

Claims

1. An intelligent isolation method for ERP sensitive data, It is characterized in that include: In response to the sensitive server receiving the sensitive query instruction sent by the employee, querying and obtaining the query result according to the sensitive query instruction; The query result is encrypted according to the encryption level, and the return result corresponding to the sensitive query instruction is obtained and sent to the employee; the encryption level is obtained as follows: According to the time difference between the employee sending the sensitive query instruction and each normal query instruction, the matching results of each query condition of the sensitive query instruction in each normal query instruction are weighted, and the correlation between the sensitive query instruction and each normal query instruction is calculated to satisfy the expression: ; In the formula, Indicates that the sensitive query instruction is The relevance of a normal query command, Indicates the time when the employee sent the sensitive query instruction. Indicates that the employee sent The time point of a normal query instruction, Indicates the preset time length. represents the maximum value function, Indicates the total number of all query conditions of the sensitive query instruction. Indicates the first The query condition is in a matching result in a normal query instruction; in response to being able to Find all the query conditions of the normal query command that match the sensitive query command. The query conditions are exactly the same. ,otherwise, ; The difference between the total number of all query columns and all query conditions in the sensitive query instruction is used as the range size of the sensitive query instruction; According to the correlation, the range size, the time difference between the employee sending the sensitive query instruction and the last time the employee sent the sensitive query instruction, the time difference between the employee sending the sensitive query instruction and the last time the employee sent a normal query instruction, the employee's level and the encryption level corresponding to the last time the employee sent the sensitive query instruction, the abnormality degree of the sensitive query instruction is calculated, including: In response to the existence of a correlation greater than a first threshold value in the correlation between the sensitive query instruction and all normal query instructions, the abnormality degree of the sensitive query instruction satisfies the expression: In response to the fact that the correlation between the sensitive query instruction and all normal query instructions is not greater than the first threshold, but there is a correlation greater than the second threshold, then In response to the relevance of the sensitive query instruction to all normal query instructions being no greater than the second threshold, ; In the formula, Indicates the scope of the sensitive query instruction. Indicates the employee's level. Indicates parameters; , and They respectively represent the time when the employee sent the sensitive query instruction, the time when the employee last sent a sensitive query instruction, and the time when the employee last sent a normal query instruction. represents the natural exponential function, Indicates the encryption level corresponding to the last time the employee sent a sensitive query instruction. Indicates a preset first quantity; the first threshold is greater than the second threshold; According to the number of query columns belonging to each sensitive table in all query columns in the sensitive query instruction and the number of query conditions involving each sensitive table in all query conditions, the sensitivity of each sensitive table in the sensitive query instruction is weighted, and the sensitivity of the sensitive query instruction is calculated to satisfy the expression: ; In the formula, Indicates the sensitivity of the sensitive query instruction. Indicates the total number of all sensitive tables between the second keyword and the third keyword in the sensitive query instruction. Indicates that all query columns between the first keyword and the second keyword in the sensitive query instruction belong to The number of query columns of sensitive tables, Indicates The number of all columns in the sensitive table, Indicates that all query conditions after the third keyword in the sensitive query instruction involve the The number of query conditions for sensitive tables, Indicates the total number of all query conditions after the third keyword in the sensitive query instruction. Indicates The sensitivity of each sensitive table; The result of rounding up the sum of the abnormality degree and the sensitivity degree is used as the encryption level corresponding to when the employee sends the sensitive query instruction.

2. According to claim 1, a method for intelligently isolating ERP sensitive data, It is characterized in that The range size of the sensitive query instruction satisfies the expression: ; In the formula, Indicates the scope of the sensitive query instruction. Indicates the total number of all query columns between the first keyword and the second keyword in the sensitive query instruction. Indicates the total number of all query conditions after the third keyword in the sensitive query instruction.

3. According to claim 1, a method for intelligently isolating ERP sensitive data, It is characterized in that The method further comprises: set up Levels, respectively Level to grade, is equal to a preset first quantity; A key is set for each level, and the key includes a public key and a private key. The public key of the level is , the private key is , , , Respectively represent The first parameter, the second parameter and the third parameter in the key of the level.

4. According to claim 3, a method for intelligently isolating ERP sensitive data, It is characterized in that The method further comprises: The access tree constructed according to the keys of all levels; the access tree is from the 1st level to the 2nd level from bottom to top. Layer, among which the The layer has only one node, which is a non-leaf node; all nodes in the first layer are leaf nodes, and the number of all nodes is , represents the total number of all nodes in layer 1, represents the total number of all employees at level 1, Indicates the preset second quantity, Indicates the maximum value function; in the other layers, The number of all nodes in the layer is , Indicates The total number of all employees at the level; only one of the nodes is a non-leaf node, and the other nodes are leaf nodes; and The key of the level is stored in In the non-leaf nodes of the layer.

5. According to claim 4, a method for intelligently isolating ERP sensitive data, It is characterized in that The non-leaf nodes of each layer in the access tree correspond to a polynomial, and the leaf nodes of each layer correspond to a data point, specifically: No. The polynomial corresponding to the non-leaf nodes of the layer for The specific expression is: ; represents the independent variable, Indicates The polynomial corresponding to the non-leaf nodes of the layer Secondary The coefficient of , Indicates The polynomial corresponding to the non-leaf nodes of the layer, Indicates The independent variable in the polynomial corresponding to the non-leaf nodes of the layer The result of Layer The data points corresponding to the leaf nodes are , , Indicates The independent variable in the polynomial corresponding to the non-leaf nodes of the layer The result of time.

6. According to claim 5, a method for intelligently isolating ERP sensitive data, It is characterized in that The method further comprises: Enterprise Level employees have Level to level; also has access to the private key of The data point corresponding to any leaf node of the layer.

7. According to claim 1, a method for intelligently isolating ERP sensitive data, It is characterized in that The method further comprises: After the employee receives the return result corresponding to the sensitive query instruction, the process of decrypting the return result is as follows: responding to the encryption level corresponding to the sensitive query instruction sent by the employee , Indicates the employee's level. The private key of the level is used to decrypt the return result corresponding to the sensitive query instruction to obtain the query result; in response to , the same level is required An employee helps the employee complete the verification, and this An employee and all data points for that employee are not identical to each other, or a Only when an employee of the same level authorizes the sensitive query instruction of the employee can the return result corresponding to the sensitive query instruction be decrypted and the query result be obtained. Indicates a preset second quantity; in response to , then the employee cannot decrypt the return result corresponding to the sensitive query instruction.