CN115203719B - SQL statement de-identification methods, devices, equipment, and computer-readable storage media - Google Patents

SQL statement de-identification methods, devices, equipment, and computer-readable storage media

Info

Publication number
CN115203719B
CN115203719B CN202210698972.7A CN202210698972A CN115203719B CN 115203719 B CN115203719 B CN 115203719B CN 202210698972 A CN202210698972 A CN 202210698972A CN 115203719 B CN115203719 B CN 115203719B
Authority
CN
China
Prior art keywords
target
desensitization
sql statement
desensitization rule
sql
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202210698972.7A
Other languages
Chinese (zh)
Other versions
CN115203719A (en
Inventor
骆奕先
黄威琪
胡小刚
陆棒
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Bank Co Ltd
Original Assignee
Ping An Bank Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ping An Bank Co Ltd filed Critical Ping An Bank Co Ltd
Priority to CN202210698972.7A priority Critical patent/CN115203719B/en
Publication of CN115203719A publication Critical patent/CN115203719A/en
Application granted granted Critical
Publication of CN115203719B publication Critical patent/CN115203719B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/602—Providing cryptographic facilities or services
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2433—Query languages
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
    • G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
    • G06F21/6245—Protecting personal data, e.g. for financial or medical purposes

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Health & Medical Sciences (AREA)
  • Bioethics (AREA)
  • General Health & Medical Sciences (AREA)
  • Computer Hardware Design (AREA)
  • Software Systems (AREA)
  • Computer Security & Cryptography (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Medical Informatics (AREA)
  • Computational Linguistics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The embodiment of the application provides a SQL statement desensitization method, device, equipment and a computer readable storage medium, wherein the method comprises the steps of obtaining a target SQL statement to be processed; determining target desensitization rules corresponding to the target SQL sentences from the candidate desensitization rules according to the comparison result of the target SQL sentences and the preset candidate desensitization rules, processing the target SQL sentences according to the target desensitization rules to obtain desensitization SQL sentences, and sending the desensitization SQL sentences to a preset database for processing. According to the technical scheme provided by the embodiment of the application, the SQL sentences are automatically matched with the preset candidate desensitization rules, so that the corresponding target desensitization rules are obtained, the desensitization processing can be realized by automatically utilizing the corresponding desensitization rules aiming at different SQL sentences, and the desensitized SQL sentences are executed, so that the safety of the SQL sentences is improved, and meanwhile, the writing efficiency of the SQL sentences is also ensured.

Description

SQL statement desensitization method, device, equipment and computer readable storage medium
Technical Field
The embodiment of the application relates to the technical field of data desensitization, in particular to a SQL statement desensitization method, device and equipment and a computer readable storage medium.
Background
SQL statements are a structured language for manipulating databases to effect the updating, addition, and subtraction of data in the databases. The security protection of SQL statements affects the security of data within the database.
However, the desensitization rule of the SQL sentence is single at present, and a certain safety problem still exists, but if the desensitization rule with complex configuration, the requirement on the writing of the user is higher, the sentence writing is inconvenient, and the writing efficiency is low.
Disclosure of Invention
The embodiment of the application provides an SQL sentence desensitizing method, an SQL sentence desensitizing device, SQL sentence desensitizing equipment and a computer readable storage medium, and aims to solve the technical problem that the existing SQL sentence desensitizing method cannot meet the requirements of safety and efficiency at the same time.
In one aspect, an embodiment of the present application provides a method for desensitizing an SQL statement, including:
Acquiring a target SQL sentence to be processed;
Determining a target desensitization rule corresponding to the target SQL statement from the candidate desensitization rules according to a comparison result of the target SQL statement and the preset candidate desensitization rule;
processing the target SQL statement according to the target desensitization rule to obtain a desensitized SQL statement;
The desensitization SQL statement is sent to a preset database for processing;
According to the comparison result of the target SQL sentence and a preset candidate desensitization rule, determining a target desensitization rule from the candidate desensitization rules comprises the following steps:
Analyzing the target SQL sentence, and determining a target character in the target SQL sentence;
And matching the character attribute of the target character with the processing attribute of the preset candidate desensitization rule, and determining the target desensitization rule corresponding to each target character in the target SQL sentence.
As a possible embodiment of the present application, the parsing the target SQL statement to determine a target character in the target SQL statement includes:
performing lexical analysis on the target SQL sentence to determine the type corresponding to each character in the target SQL sentence, wherein the type comprises at least one of keywords, expressions, literal quantities and operators;
and carrying out grammar analysis on the target SQL sentence according to the type corresponding to each character in the target SQL sentence, and determining the target character in the target SQL sentence.
As a possible embodiment of the present application, before matching the character attribute of the target character with the processing attribute of the preset candidate desensitization rule to determine the target desensitization rule corresponding to each target character in the target SQL statement, the method further includes:
Generating a first desensitization rule according to a summary algorithm selected on a preset configuration page, and setting a table name and a column name as processing attributes corresponding to the first desensitization rule;
Generating a second desensitization rule according to the encryption algorithm selected on the preset configuration page, and setting a table value as a processing attribute corresponding to the second desensitization rule;
And setting the first desensitization rule and the second desensitization rule as the preset candidate desensitization rule.
As a possible embodiment of the present application, before determining, from the candidate desensitization rules, a target desensitization rule corresponding to the target SQL statement according to a comparison result of the target SQL statement and a preset candidate desensitization rule, the method further includes:
acquiring a desensitization rule database corresponding to the user identification information according to the user identification information corresponding to the target SQL statement;
And setting the desensitization rule in the desensitization rule database as the preset candidate desensitization rule.
As a possible embodiment of the present application, after the desensitized SQL statement is sent to a preset database for processing, the method further includes:
And writing the target desensitization rule and the desensitization characters in the desensitization SQL statement into the preset database in an associated mode, so that after the target desensitization rule is updated to an updated desensitization rule, updating the desensitization characters in the preset database according to the target desensitization rule and the updated desensitization rule.
As a possible embodiment of the present application, after the desensitized SQL statement is sent to a preset database for processing, the method further includes:
if the target SQL statement is a query statement, a desensitization query result returned by the preset database and character attributes corresponding to the desensitization query result are obtained;
determining a restore desensitization rule corresponding to the desensitization query result according to the character attribute corresponding to the desensitization query result;
and processing the desensitization query result according to the reduction desensitization rule, and outputting a target query result.
On the other hand, the embodiment of the application also provides a device for desensitizing SQL sentences, which comprises:
the acquisition module is used for acquiring a target SQL statement to be processed;
The comparison module is used for determining a target desensitization rule corresponding to the target SQL statement from the candidate desensitization rules according to a comparison result of the target SQL statement and a preset candidate desensitization rule;
the desensitization module is used for processing the target SQL statement according to the target desensitization rule to obtain a desensitized SQL statement;
the processing module is used for sending the desensitized SQL statement to a preset database for processing;
According to the comparison result of the target SQL sentence and a preset candidate desensitization rule, determining a target desensitization rule from the candidate desensitization rules comprises the following steps:
Analyzing the target SQL sentence, and determining a target character in the target SQL sentence;
And matching the character attribute of the target character with the processing attribute of the preset candidate desensitization rule, and determining the target desensitization rule corresponding to each target character in the target SQL sentence.
On the other hand, the embodiment of the application also provides SQL sentence desensitizing equipment, which comprises a processor, a memory and an SQL sentence desensitizing program stored in the memory and capable of running on the processor, wherein the processor executes the SQL sentence desensitizing program to realize the steps in the SQL sentence desensitizing method.
On the other hand, the embodiment of the application also provides a computer readable storage medium, wherein the computer readable storage medium is stored with an SQL sentence desensitizing program, and the SQL sentence desensitizing program is executed by a processor to realize the steps in the SQL sentence desensitizing method.
According to the SQL statement desensitization method provided by the embodiment of the application, after the SQL statement written by the user is obtained, the SQL statement is automatically matched with the preset candidate desensitization rule, so that the corresponding target desensitization rule is obtained, the desensitization processing can be automatically carried out on different SQL statements by using the corresponding desensitization rule, and the desensitized SQL statement is executed, so that the safety of the SQL statement is improved, and meanwhile, the writing efficiency of the SQL statement is also ensured.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the description of the embodiments will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of an implementation scenario of an SQL statement desensitizing method according to an embodiment of the present application;
FIG. 2 is a schematic flow chart of steps of a method for desensitizing SQL statements according to an embodiment of the application;
FIG. 3 is a flowchart illustrating a step of determining a target desensitization rule according to an embodiment of the present application;
FIG. 4 is a flowchart illustrating steps for parsing sentences to obtain target characters according to an embodiment of the present application;
FIG. 5 is a flowchart illustrating a step of configuring candidate desensitization rules according to an embodiment of the present application;
FIG. 6 is a flowchart illustrating steps for configuring target desensitization rules based on user identifiers according to an embodiment of the present application;
FIG. 7 is a flowchart illustrating steps for updating a database based on updated target desensitization rules according to an embodiment of the present application;
FIG. 8 is a flowchart illustrating steps for restoring query results based on query SQL statements according to an embodiment of the present application;
FIG. 9 is a schematic structural diagram of an SQL statement desensitizing device according to an embodiment of the application;
Fig. 10 is a schematic structural diagram of an SQL statement desensitizing device according to an embodiment of the present application.
Detailed Description
The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be encompassed by the present application.
In the embodiments of the present application, the term "exemplary" is used to mean "serving as an example, instance, or illustration. Any embodiment described as "exemplary" in this disclosure is not necessarily to be construed as preferred or advantageous over other embodiments. The following description is presented to enable any person skilled in the art to make and use the application. In the following description, details are set forth for purposes of explanation. It will be apparent to one of ordinary skill in the art that the present application may be practiced without these specific details. In other instances, well-known structures and processes have not been described in detail so as not to obscure the description of the application with unnecessary detail. Thus, the present application is not intended to be limited to the embodiments shown, but is to be accorded the widest scope consistent with the principles and features disclosed herein.
The embodiment of the application provides a SQL statement desensitizing method, device, equipment and a computer readable storage medium, which are respectively described in detail below.
The SQL sentence desensitizing method in the embodiment of the application is that the SQL sentence desensitizing device is deployed in the form of a program, the SQL sentence desensitizing device is installed in the SQL sentence desensitizing equipment in the form of a processor, and the SQL sentence desensitizing device in the SQL sentence desensitizing equipment executes the program corresponding to the SQL sentence desensitizing method by running the program so as to execute the following steps:
As shown in fig. 1, fig. 1 is a schematic diagram of an implementation scenario of an SQL statement desensitizing method according to an embodiment of the present application, where the implementation scenario includes an SQL statement desensitizing device 100, a rule configuration library 200, and a database 300. The SQL statement desensitizing device 100 is mainly used for acquiring an SQL statement input by a user through any input mode such as a mouse input, a touch input or a voice input, wherein the SQL statement is a target SQL statement to be processed, and through interaction with the rule configuration library 200, a target desensitizing rule corresponding to the target SQL statement is acquired from the target SQL statement, thereby completing desensitizing processing of the target SQL statement, obtaining a desensitized SQL statement, and finally sending the desensitized SQL statement to the corresponding database 300, so that the database 300 executes the desensitized SQL statement, thereby completing desensitization and execution flow of the whole SQL statement.
It should be noted that, the schematic view of the scenario of the SQL statement desensitizing method provided in fig. 1 is only an example, and the scenario of the SQL statement desensitizing method described in the embodiment of the present application is for more clearly describing the technical solution of the embodiment of the present application, and does not constitute a limitation to the technical solution provided in the embodiment of the present application.
Based on the implementation scene schematic diagram of the SQL statement desensitization method, a specific embodiment of the SQL statement desensitization method is provided.
As shown in fig. 2, fig. 2 is a schematic step flow diagram of an SQL statement desensitizing method according to an embodiment of the present application, where the SQL statement desensitizing method in the embodiment of the present application includes steps 201 to 204:
and 201, acquiring a target SQL sentence to be processed.
In the embodiment of the application, SQL statement refers to a structured language used by program developers to operate on databases, and generally relates to updating, adding and deleting data in the databases. Examples include:
Creating a new table create table tabname (col 1 type1[ not null ] [ PRIMARY KEY ], col2 type2[ not null ],.);
One column Alter table tabname add column col type is added;
Deleting the primary key Alter table tabname drop PRIMARY KEY (col);
Creating an index, create [ unique ] index idxname on tabname (col.);
update table1 set field1 = value1 sphere range;
Find select from table1 WHERE FIELD1 like '% value1%' and so on.
In addition, SQL statements may also relate to statistics on data in a database, such as:
Ordering from table1 order by field1, field2[ desc ]
Summing select sum (field 1) as sumvalue from table1, and so on.
Because the SQL statement belongs to common general knowledge in the field of program development, the embodiment of the application is not described herein.
In the embodiment of the present application, the target SQL statement to be processed generally refers to an SQL statement input to the SQL statement desensitizing device by a user through any input mode such as a mouse input, a touch input or a voice input, and the embodiment of the present application is not described herein.
202, Determining a target desensitization rule corresponding to the target SQL statement from the candidate desensitization rules according to a comparison result of the target SQL statement and a preset candidate desensitization rule.
In the embodiment of the application, when the SQL sentence desensitizing device acquires the target SQL sentence input by the user, the target SQL sentence is compared with the preset candidate desensitizing rule, and the target desensitizing rule corresponding to the target SQL sentence is screened from the candidate desensitizing rules according to the comparison result. The candidate desensitization rule may include, for example, adding a part of key information to a star or adopting a preset encryption algorithm and a summary algorithm to desensitize the SQL statement, which is not described herein. Specifically, the candidate desensitization rule is stored in the Apollo configuration center.
Specifically, the comparison may be performed by comparing attribute information of the target SQL statement with attribute information configured in advance for the desensitization rule, or by using other information to achieve the comparison of the target SQL statement with the candidate desensitization rule. The embodiments of the present application are not described herein.
Furthermore, in order to facilitate the processing of the desensitized SQL statement by the subsequent database, some special characters, such as operators, logical operators, etc., in the target SQL statement are not desensitized, so as to be a feasible implementation scheme of the present application, the target SQL statement is parsed to obtain the character to be rewritten, and the target desensitization rule corresponding to the character is determined from the candidate desensitization rules, so that the rewriting of the target SQL statement is completed, and the specific implementation scheme can refer to the following fig. 3 and the explanation content thereof.
Of course, if the complete desensitization processing is also feasible for the target SQL statement, in this case, in the process of processing the desensitized SQL statement by the subsequent database, the database also needs to restore the desensitized SQL statement by using a restoration rule corresponding to the target desensitization rule.
In addition, as another alternative embodiment of the present application, different users may implement the self-defined desensitization processing by configuring different desensitization rule databases, and at this time, the target SQL statement obtained by the SQL statement desensitization device may additionally carry user identification information, so as to identify the corresponding desensitization rule database according to the user identification information, thereby taking the desensitization rule contained in the desensitization rule database as a candidate desensitization rule, and the implementation scheme may refer to the following fig. 6 and the explanation thereof.
203, Processing the target SQL statement according to the target desensitization rule to obtain a desensitized SQL statement.
In the embodiment of the application, after the target desensitization rule is determined from the candidate desensitization rules, the SQL statement desensitization device processes the SQL statement by using the target desensitization rule to obtain the desensitized SQL statement, namely the desensitized SQL statement, so that the database can be controlled by the desensitized SQL statement conveniently.
Further, in combination with the possible implementation scheme provided by the foregoing, the target SQL statement is parsed to extract the characters to be rewritten from the target SQL statement, and at this time, the target desensitization rule is used to process the SQL statement, which means that the target characters in the SQL statement are replaced by desensitization characters. Thereby obtaining the desensitized SQL statement.
And 204, sending the desensitized SQL statement to a preset database for processing.
In the embodiment of the application, after the SQL statement desensitizing device processes the SQL statement by utilizing the target desensitizing rule to obtain the desensitized SQL statement, the desensitized SQL statement is sent to a database corresponding to the SQL statement for processing. Of course, in combination with the foregoing description, if the desensitized SQL statement is obtained by processing the target SQL statement completely, the database needs to restore the desensitized SQL statement to retrieve special characters, such as operators, logical operators, and the like, when processing the desensitized SQL statement. On the contrary, if the desensitization SQL statement is obtained by analyzing the target SQL statement and desensitizing part of the characters in the target SQL statement, the database can directly process the desensitization SQL statement without intervention of a desensitization rule when processing the desensitization SQL statement.
Further, considering that when the database processes a specific type of desensitized SQL statement, for example, inserting, updating, etc. the desensitized characters processed according to the specific desensitization rule in the desensitized SQL statement are written into and updated into the database, when the corresponding desensitization rule changes, the characters in the database need to be cleaned, that is, updated, and the specific implementation scheme can refer to the following fig. 7 and the explanation thereof.
In addition, for the SQL statement of the query class, the database also returns the query result to the SQL statement desensitizing device, and based on the description, the query result may be written or updated into the database in the form of desensitizing characters, so as to be a feasible embodiment of the application, the SQL statement desensitizing device further utilizes corresponding desensitizing rules to restore the query result, thereby outputting the original text to the user. A specific implementation may refer to fig. 8 and the explanation thereof.
According to the SQL statement desensitization method provided by the embodiment of the application, after the SQL statement written by the user is obtained, the SQL statement is automatically matched with the preset candidate desensitization rule, so that the corresponding target desensitization rule is obtained, the desensitization processing can be automatically carried out on different SQL statements by using the corresponding desensitization rule, and the desensitized SQL statement is executed, so that the safety of the SQL statement is improved, and meanwhile, the writing efficiency of the SQL statement is also ensured.
As shown in fig. 3, fig. 3 is a schematic flowchart of a step of determining a target desensitization rule according to an embodiment of the present application, which is described in detail below.
In the embodiment of the application, a technical scheme is provided that target characters are extracted from SQL sentences through analysis, and target desensitization rules corresponding to the target characters are determined, and the method specifically comprises the steps 301-302:
and 301, analyzing the target SQL sentence and determining a target character in the target SQL sentence.
In the embodiment of the application, parsing the SQL sentence generally involves lexical parsing and grammar parsing of the SQL sentence. Specifically, when parsing an SQL statement, it is also generally necessary to find a database type corresponding to the SQL statement, for example mysql or oracle, by using the jdbc adapter in advance, and obtain different parsing engines according to the database, so as to complete parsing the SQL statement. A specific implementation may be found in the following description of fig. 4 and its explanation.
In the embodiment of the present application, the target character is generally a variable in the SQL statement, for example, taking the SQL statement of "add value" 123456789' "in the column of" mobile phone number ", then by parsing the SQL statement at this time, it can be determined that" mobile phone number "and" 123456789 "in the SQL statement are rewritable variable, so that the SQL statement desensitizing device will consider" mobile phone number "and" 123456789 "as target characters for subsequent desensitization processing.
302, Matching the character attribute of the target character with the processing attribute of the preset candidate desensitization rule, and determining the target desensitization rule corresponding to each target character in the target SQL sentence.
In the embodiment of the application, after the target characters in the SQL sentence are determined, the target characters are further matched according to the character attribute of each target character and the processing attribute of the preset candidate desensitization rule, so that the target desensitization rule corresponding to each target character is determined, and different desensitization rules are adopted for processing for different target characters. Specific implementations of configuring candidate desensitization rules may be found in fig. 5 and the description thereof, which follows.
According to the technical scheme provided by the embodiment of the application, the target characters in the SQL sentence are extracted by analyzing the SQL sentence, and different desensitization rules are utilized for processing different target characters, so that the desensitization effect can be further improved, meanwhile, the variable quantity in the SQL sentence can be used as the target character capable of being subjected to desensitization processing by analyzing the SQL sentence, and the special character is regarded as the non-target character not subjected to the desensitization processing, so that the processing of the subsequent database on the desensitized SQL sentence can be facilitated, and the processing efficiency of the SQL sentence is improved.
As shown in fig. 4, fig. 4 is a schematic flow chart of a step of parsing a sentence to obtain a target character according to an embodiment of the present application, which is described in detail below.
In the embodiment of the application, a specific implementation scheme for analyzing SQL sentences through lexical analysis and grammar analysis is provided, which specifically comprises the following steps:
and 401, performing lexical analysis on the target SQL sentence, and determining the type corresponding to each character in the target SQL sentence.
In the embodiment of the application, the lexical analysis is performed on the SQL sentence, that is, the SQL sentence desensitizing device disassembles the target SQL sentence into atomic symbols which are not subdivided, that is, characters by using a preset lexical analyzer, that is, an analysis engine corresponding to the database type corresponding to the SQL sentence, and classifies each character into keywords, expressions, literal amounts and operators according to the dictionary corresponding to the database type, that is, the type corresponding to each character in the target SQL sentence at least comprises one of keywords, expressions, literal amounts and operators.
And 402, carrying out grammar analysis on the target SQL sentence according to the types corresponding to the characters in the target SQL sentence, and determining the target characters in the target SQL sentence.
In the embodiment of the application, after the corresponding type of each character is determined, the SQL sentence desensitizing device further uses a preset grammar parser to convert the target SQL sentence into an abstract grammar tree, and extracts the context required by the segmentation by traversing the abstract grammar tree and combining the type corresponding to each character, thereby determining the position needing to be rewritten in the target SQL sentence, namely the target character in the target SQL sentence.
As shown in fig. 5, fig. 5 is a schematic flow chart of steps for configuring a candidate desensitization rule according to an embodiment of the present application. Detailed description is as follows.
In the embodiment of the application, a desensitization rule realized based on a digest algorithm and an encryption algorithm is provided, which specifically comprises the following steps of 501-503:
501, generating a first desensitization rule according to a summary algorithm selected on a preset configuration page, and setting a table name and a column name as processing attributes corresponding to the first desensitization rule.
In the embodiment of the application, the digest algorithm generally refers to an algorithm without a key, and the data processed by the digest algorithm cannot be decrypted, and the specific digest algorithm has a plurality of types, for example, including an MD5 algorithm, an SHA-1 algorithm and a plurality of variants thereof. In the embodiment of the application, the abstract algorithm is displayed on the preset configuration interface, and a user can select the abstract algorithm on the configuration interface in a self-defined way to be used as one of the desensitization rules.
Further, considering that the data processed by the digest algorithm cannot be decrypted, the character attribute processed by the desensitization rule generated by the digest algorithm should be a character that is not stored as a key value in the SQL statement, for example, a table name and a column name are common, and in the database, the table name and the column name are usually identification information, and both the original character before processing and the desensitized character after processing can play a role in identification. Therefore, the table names and the column names can be used as the processing attributes corresponding to the desensitization rules generated by the abstract algorithm, so that the subsequent target characters with the character attributes of 'table names' or 'column names' in the SQL sentence can be processed by adopting the corresponding abstract algorithm.
And 502, generating a second desensitization rule according to the encryption algorithm selected on the preset configuration page, and setting a table value as a processing attribute corresponding to the second desensitization rule.
In the embodiment of the application, the encryption algorithm generally refers to an algorithm for desensitizing by using a secret key, and the data processed by the encryption algorithm can be reversely decrypted by using the secret key so as to recover the original text data. In particular, there are also many kinds of encryption algorithms, such as DES, RSA, etc., which are relatively common. In the embodiment of the application, the encryption algorithm is displayed on the preset configuration interface, and a user can select the encryption algorithm on the configuration interface in a self-defined way to be used as one of the desensitization rules.
Further, considering that the data processed by the encryption algorithm can be decrypted reversely by using the key, the character attribute processed by the desensitization rule generated by the encryption algorithm should be a table value as an information carrier in the SQL sentence. Therefore, the table value can be used as the processing attribute corresponding to the desensitization rule generated by the encryption algorithm, so that the target character with the character attribute of 'table value' in the SQL sentence can be processed by adopting the corresponding encryption algorithm.
503, Setting the first desensitization rule and the second desensitization rule as the preset candidate desensitization rule.
In the embodiment of the application, the first desensitization rule and the second desensitization rule are both rules capable of realizing the desensitization effect and are configured with corresponding processing attributes, so that the first desensitization rule and the second desensitization rule can be used as candidate desensitization rules, and the corresponding target desensitization rules can be selected based on the attributes of target characters in SQL sentences. Specifically, for ease of understanding, the following description will take the SQL statement "add value in the column of 'mobile number' as an example.
Specifically, in the foregoing SQL statement, although the "mobile phone number" and the "123456789" may be regarded as target characters at this time, the corresponding attributes thereof are different, for example, the "mobile phone number" is generally a column name in a database, which is mainly used for playing a unique identification role, so that when desensitizing, a digest algorithm may be used for performing desensitization processing, and thus, the character after desensitization can also play a unique identification role. Conversely, "123456789" is more likely to be a table value in a database, which is used as an information carrier, and the carried information cannot be changed, so that the desensitization character corresponding to the target character needs to be restored to the original target character, and then the corresponding desensitization rule should be an encryption algorithm with a decryption function, so that after the desensitization character corresponding to "123456789" is extracted from the database, the desensitization character can be restored to the original text "123456789" based on the corresponding decryption rule for displaying to the user.
Fig. 6 is a schematic flowchart of a step of configuring target desensitization rule based on user identifier according to an embodiment of the present application, as shown in fig. 6. Detailed description is as follows.
In the embodiment of the application, an implementation scheme for configuring a target desensitization rule based on different user identifications is provided, and specifically includes steps 601-602:
601, acquiring a desensitization rule database corresponding to the user identification information according to the user identification information corresponding to the target SQL statement.
Different from other SQL sentences, in the embodiment of the application, when a user inputs the SQL sentences in any feasible input mode, the SQL sentence desensitizing device correspondingly acquires the user identification information corresponding to the SQL sentences and further acquires the corresponding desensitizing rule database based on the user identification information. That is, for each user, the corresponding desensitization rule can be configured in the database by creating a database, so that when the desensitization processing is performed subsequently, the corresponding desensitization rule database is obtained for the user identification information of different users.
Setting the desensitization rule in the desensitization rule database as the preset candidate desensitization rule 602.
In the embodiment of the application, as can be seen from the foregoing description, different users can self-configure corresponding desensitization rules in the database by creating a database, so that the desensitization rules in the desensitization rule database can be set as preset candidate desensitization rules, so that the target desensitization rules can be determined from the preset candidate desensitization rules.
Fig. 7 is a schematic flowchart of a step of updating a database based on updated target desensitization rules according to an embodiment of the present application, as shown in fig. 7. Detailed description is as follows.
In the embodiment of the application, after the desensitization rule is updated, an implementation scheme for cleaning and updating the data in the database is provided, which specifically comprises steps 701-702:
701, writing the target desensitization rule and the desensitization characters in the desensitization SQL sentence into the preset database in an associated mode.
In the embodiment of the application, the desensitization characters in the desensitization SQL statement refer to characters obtained by desensitizing target characters in the target SQL statement. Specifically, when the target SQL statement is a written and updated statement, the database can write the desensitization character in the desensitization SQL statement into the preset database in an associated manner when executing the desensitization SQL statement, and at this time, in order to facilitate the subsequent update of the desensitization character in the database when the target desensitization rule changes, the target desensitization rule and the desensitization character can be synchronously written in an associated manner when executing the desensitization SQL statement.
And 702, if the target desensitization rule is updated to an updated desensitization rule, updating the desensitization characters in the preset database according to the target desensitization rule and the updated desensitization rule.
In the embodiment of the application, if the target desensitization rule is updated to be a new desensitization rule, that is, the desensitization rule is updated, the database needs to be washed. Specifically, the characters associated with the target desensitization rule in the preset database are regarded as desensitization characters, the characters are restored by utilizing the restoring desensitization rule corresponding to the target desensitization rule, the restored characters are subjected to secondary desensitization by utilizing the updating desensitization rule, updated characters are obtained, and corresponding characters in the preset database are replaced, so that the updating of the characters is realized.
As shown in fig. 8, fig. 8 is a flowchart illustrating steps for restoring a query result based on a query SQL statement according to an embodiment of the present application. Detailed description is as follows.
In the embodiment of the application, an implementation scheme for restoring a query result after obtaining the query result for an SQL statement of a query class is provided, which specifically comprises steps 801-803:
801, obtaining a desensitization query result returned by the preset database and character attributes corresponding to the desensitization query result.
In the embodiment of the application, if the SQL sentence is query data, after the database is preset to process the SQL data, the corresponding desensitization query result is returned to the SQL sentence desensitization device, and the character attribute corresponding to the desensitization query result is returned at the same time. In connection with the foregoing description, it will be appreciated that the values in the predetermined database are typically in the form of desensitized characters, and thus, the desensitized query results are also in the form of desensitized characters.
And 802, determining a restore desensitization rule corresponding to the desensitization query result according to the character attribute corresponding to the desensitization query result.
In the embodiment of the application, the SQL sentence desensitization device acquires the desensitization query result returned by the preset database, and determines the corresponding target desensitization rule from the candidate desensitization rules based on the character attribute, and then acquires the restoration desensitization rule corresponding to the target desensitization rule, namely the restoration desensitization rule can be understood as the inverse processing process of the target desensitization rule, the target desensitization rule is used for encrypting the original text into the ciphertext, namely the desensitization character, and the restoration desensitization rule is used for restoring the encrypted ciphertext into the original text, namely the desensitization character can be restored into the original character.
803, Processing the desensitization query result according to the reduction desensitization rule, and outputting a target query result.
In the embodiment of the application, the desensitization query result is processed by utilizing a reduction desensitization rule, so that the initial character can be finally output and provided for a user.
In order to better implement the SQL statement desensitization method provided by the embodiment of the application, the embodiment of the application also provides a SQL statement desensitization device based on the SQL statement desensitization method. As shown in FIG. 9, FIG. 9 is a schematic diagram of a SQL statement desensitizing device according to an embodiment of the application. Specifically, the SQL statement desensitizing device comprises:
An obtaining module 901, configured to obtain a target SQL statement to be processed;
a comparison module 902, configured to determine, according to a comparison result between the target SQL statement and a preset candidate desensitization rule, a target desensitization rule corresponding to the target SQL statement from the candidate desensitization rules;
The desensitization module 903 is configured to process the target SQL statement according to the target desensitization rule to obtain a desensitized SQL statement;
and the processing module 904 is used for sending the desensitized SQL statement to a preset database for processing.
In some embodiments of the application, the comparison module includes:
the analysis sub-module is used for analyzing the target SQL sentence and determining a target character in the target SQL sentence;
And the matching sub-module is used for matching the character attribute of the target character with the processing attribute of the preset candidate desensitization rule and determining the target desensitization rule corresponding to each target character in the target SQL sentence.
In some embodiments of the present application, the parsing sub-module includes:
The lexical analysis unit is used for lexically analyzing the target SQL sentence and determining the type corresponding to each character in the target SQL sentence, wherein the type comprises at least one of keywords, expressions, literal quantity and operators;
the grammar analysis unit is used for carrying out grammar analysis on the target SQL sentence according to the type corresponding to each character in the target SQL sentence and determining the target character in the target SQL sentence.
In some embodiments of the present application, the comparison module further includes a rule configuration submodule, where the rule configuration submodule includes:
The first rule configuration unit is used for generating a first desensitization rule according to a summary algorithm selected on a preset configuration page, and setting a table name and a column name as processing attributes corresponding to the first desensitization rule;
The second rule configuration unit is used for generating a second desensitization rule according to the encryption algorithm selected on the preset configuration page and setting a table value as a processing attribute corresponding to the second desensitization rule;
and the rule setting unit is used for setting the first desensitization rule and the second desensitization rule as the preset candidate desensitization rule.
In some embodiments of the present application, the rule configuration submodule includes:
a rule database acquisition unit, configured to acquire a desensitization rule database corresponding to the user identification information according to the user identification information corresponding to the target SQL statement;
And the rule configuration unit is used for setting the desensitization rule in the desensitization rule database as the preset candidate desensitization rule.
In some embodiments of the present application, the above-mentioned SQL statement desensitizing apparatus includes:
And the updating module is used for writing the target desensitization rule and the desensitization characters in the desensitization SQL statement into the preset database in an associated mode, so that after the target desensitization rule is updated to update the desensitization rule, the desensitization characters in the preset database are updated according to the target desensitization rule and the update desensitization rule.
In some embodiments of the present application, the SQL statement desensitizing apparatus includes a restoration module, where the restoration module includes:
the query result acquisition sub-module is used for acquiring a desensitization query result returned by the preset database and character attributes corresponding to the desensitization query result if the target SQL statement is a query statement;
A restoration rule determining submodule, configured to determine a restoration desensitization rule corresponding to the desensitization query result according to a character attribute corresponding to the desensitization query result;
And the reduction sub-module is used for processing the desensitization query result according to the reduction desensitization rule and outputting a target query result.
The embodiment of the application also provides SQL sentence desensitizing equipment, as shown in FIG. 10, and FIG. 10 is a schematic structural diagram of the SQL sentence desensitizing equipment.
The SQL sentence desensitizing device comprises a memory, a processor and an SQL sentence desensitizing program which is stored in the memory and can run on the processor, wherein the processor realizes the steps in the SQL sentence desensitizing method provided by any embodiment of the application when executing the SQL sentence desensitizing program.
In particular, the SQL statement desensitizing device may comprise one or more processors 1001 of a processing core, one or more memories 1002 of a storage medium, a power supply 1003, and an input unit 1004. It will be appreciated by those skilled in the art that the SQL statement desensitizing device structure shown in FIG. 10 does not constitute a limitation of the SQL statement desensitizing device, and may include more or fewer components than shown, or some components in combination, or a different arrangement of components. Wherein:
The processor 1001 is a control center of the SQL statement desensitizing apparatus, connects respective parts of the whole SQL statement desensitizing apparatus using various interfaces and lines, and performs various functions and processes data of the SQL statement desensitizing apparatus by running or executing software programs and/or modules stored in the memory 1002 and calling data stored in the memory 1002, thereby performing overall monitoring of the SQL statement desensitizing apparatus. Optionally, the processor 1001 may include one or more processing cores, and preferably the processor 1001 may integrate an application processor and a modem processor, wherein the application processor primarily processes operating systems, user interfaces, application programs, etc., and the modem processor primarily processes wireless communications. It will be appreciated that the modem processor described above may not be integrated into the processor 1001.
The memory 1002 may be used to store software programs and modules, and the processor 1001 executes various functional applications and data processing by executing the software programs and modules stored in the memory 1002. The memory 1002 may mainly include a storage program area that may store an operating system, an application program required for at least one function (such as a sound playing function, an image playing function, etc.), etc., and a storage data area that may store data created according to the use of the SQL statement desensitizing apparatus, etc. In addition, memory 1002 may include high-speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid-state storage device. Accordingly, the memory 1002 may also include a memory controller to provide the processor 1001 with access to the memory 1002.
The SQL statement desensitizing device further comprises a power supply 1003 for supplying power to each component, and the power supply 1003 can be logically connected with the processor 1001 through a power management system, so that functions of charge, discharge, power consumption management and the like are managed through the power management system. The power supply 1003 may also include one or more of any of a direct current or alternating current power supply, a recharging system, a power failure detection circuit, a power converter or inverter, a power status indicator, and the like.
The SQL statement desensitizing device may further comprise an input unit 1004, the input unit 1004 being operable to receive input numeric or character information and to generate keyboard, mouse, joystick, optical or trackball signal inputs related to user settings and function control.
Although not shown, the SQL statement desensitizing apparatus may further include a display unit or the like, which is not described herein. In particular, in this embodiment, the processor 1001 in the SQL statement desensitizing apparatus loads executable files corresponding to the processes of one or more application programs into the memory 1002 according to the following instructions, and the processor 1001 runs the application programs stored in the memory 1002, so as to implement the steps in the SQL statement desensitizing method provided in any embodiment of the present application.
To this end, embodiments of the present application provide a computer-readable storage medium that may include a Read Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, etc. The computer readable storage medium stores an SQL statement desensitization program, and the SQL statement desensitization program realizes the steps in the SQL statement desensitization method provided by any embodiment of the application when being executed by a processor.
In the foregoing embodiments, the descriptions of the embodiments are focused on, and the portions of one embodiment that are not described in detail in the foregoing embodiments may be referred to in the foregoing detailed description of other embodiments, which are not described herein again.
In the implementation, each unit or structure may be implemented as an independent entity, or may be implemented as the same entity or several entities in any combination, and the implementation of each unit or structure may be referred to the foregoing method embodiments and will not be repeated herein.
The specific implementation of each operation above may be referred to the previous embodiments, and will not be described herein.
The above description is provided for describing the principles and embodiments of the present application by applying specific examples, and the description of the above examples is only for helping to understand the method and core ideas of the present application, and meanwhile, the present disclosure should not be construed as limiting the present application, since the skilled person will change the specific embodiments and application scope according to the ideas of the present application.

Claims (8)

1. A method for desensitizing an SQL statement, comprising:
Acquiring a target SQL sentence to be processed;
Determining a target desensitization rule corresponding to the target SQL statement from the candidate desensitization rules according to a comparison result of the target SQL statement and the preset candidate desensitization rule;
processing the target SQL statement according to the target desensitization rule to obtain a desensitized SQL statement;
The desensitization SQL statement is sent to a preset database for processing;
According to the comparison result of the target SQL sentence and a preset candidate desensitization rule, determining a target desensitization rule from the candidate desensitization rules comprises the following steps:
Performing lexical analysis on the target SQL sentence based on an analysis engine corresponding to the database type corresponding to the target SQL sentence to determine an atomic symbol which is not subdivided by the target SQL sentence, so as to obtain the type corresponding to each character in the target SQL sentence, wherein the type comprises at least one of a keyword, an expression, a word size and an operator;
Converting the target SQL sentence into an abstract syntax tree, and refining to obtain a context required by the segmentation according to the types corresponding to the characters by traversing the abstract syntax tree so as to determine target characters in the target SQL sentence, wherein the target characters are used for indicating the position needing to be rewritten in the target SQL sentence;
Matching the character attribute of the target character with the processing attribute of a preset candidate desensitization rule, and determining a target desensitization rule corresponding to each target character in the target SQL sentence;
the method further comprises the steps of matching the character attribute of the target character with the processing attribute of a preset candidate desensitization rule, and before determining the target desensitization rule corresponding to each target character in the target SQL sentence:
Generating a first desensitization rule according to a summary algorithm selected on a preset configuration page, and setting a table name and a column name as processing attributes corresponding to the first desensitization rule;
Generating a second desensitization rule according to the encryption algorithm selected on the preset configuration page, and setting a table value as a processing attribute corresponding to the second desensitization rule;
And setting the first desensitization rule and the second desensitization rule as the preset candidate desensitization rule.
2. The method for desensitizing an SQL statement according to claim 1, wherein before determining a target desensitization rule corresponding to the target SQL statement from the candidate desensitization rules according to a comparison result of the target SQL statement and a preset candidate desensitization rule, the method further comprises:
acquiring a desensitization rule database corresponding to the user identification information according to the user identification information corresponding to the target SQL statement;
And setting the desensitization rule in the desensitization rule database as the preset candidate desensitization rule.
3. The method for desensitizing an SQL statement according to claim 1, wherein after said sending said desensitized SQL statement to a preset database for processing, said method further comprises:
And writing the target desensitization rule and the desensitization characters in the desensitization SQL statement into the preset database in an associated mode, so that after the target desensitization rule is updated to an updated desensitization rule, updating the desensitization characters in the preset database according to the target desensitization rule and the updated desensitization rule.
4. The method for desensitizing an SQL statement according to claim 1, wherein after said sending said desensitized SQL statement to a preset database for processing, said method further comprises:
if the target SQL statement is a query statement, a desensitization query result returned by the preset database and character attributes corresponding to the desensitization query result are obtained;
determining a restore desensitization rule corresponding to the desensitization query result according to the character attribute corresponding to the desensitization query result;
and processing the desensitization query result according to the reduction desensitization rule, and outputting a target query result.
5. The SQL statement desensitization method according to any one of claims 1-4, wherein the candidate desensitization rules are stored in an Apollo configuration center.
6. An SQL statement desensitizing apparatus, comprising:
the acquisition module is used for acquiring a target SQL statement to be processed;
The comparison module is used for determining a target desensitization rule corresponding to the target SQL statement from the candidate desensitization rules according to a comparison result of the target SQL statement and a preset candidate desensitization rule;
the desensitization module is used for processing the target SQL statement according to the target desensitization rule to obtain a desensitized SQL statement;
the processing module is used for sending the desensitized SQL statement to a preset database for processing;
According to the comparison result of the target SQL sentence and a preset candidate desensitization rule, determining a target desensitization rule from the candidate desensitization rules comprises the following steps:
Performing lexical analysis on the target SQL sentence based on an analysis engine corresponding to the database type corresponding to the target SQL sentence to determine an atomic symbol which is not subdivided by the target SQL sentence, so as to obtain the type corresponding to each character in the target SQL sentence, wherein the type comprises at least one of a keyword, an expression, a word size and an operator;
Converting the target SQL sentence into an abstract syntax tree, and refining to obtain a context required by the segmentation according to the types corresponding to the characters by traversing the abstract syntax tree so as to determine target characters in the target SQL sentence, wherein the target characters are used for indicating the position needing to be rewritten in the target SQL sentence;
Matching the character attribute of the target character with the processing attribute of a preset candidate desensitization rule, and determining a target desensitization rule corresponding to each target character in the target SQL sentence;
The matching of the character attribute of the target character with the processing attribute of the preset candidate desensitization rule, before determining the target desensitization rule corresponding to each target character in the target SQL sentence, further comprises:
Generating a first desensitization rule according to a summary algorithm selected on a preset configuration page, and setting a table name and a column name as processing attributes corresponding to the first desensitization rule;
Generating a second desensitization rule according to the encryption algorithm selected on the preset configuration page, and setting a table value as a processing attribute corresponding to the second desensitization rule;
And setting the first desensitization rule and the second desensitization rule as the preset candidate desensitization rule.
7. An SQL statement desensitizing apparatus comprising a processor, a memory, and an SQL statement desensitizing program stored in the memory and executable on the processor, the processor executing the SQL statement desensitizing program to implement the steps in the SQL statement desensitizing method of any one of claims 1 to 5.
8. A computer readable storage medium having stored thereon an SQL statement desensitization program that is executed by a processor to implement the steps in the SQL statement desensitization method of any one of claims 1 to 5.
CN202210698972.7A 2022-06-20 2022-06-20 SQL statement de-identification methods, devices, equipment, and computer-readable storage media Active CN115203719B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210698972.7A CN115203719B (en) 2022-06-20 2022-06-20 SQL statement de-identification methods, devices, equipment, and computer-readable storage media

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210698972.7A CN115203719B (en) 2022-06-20 2022-06-20 SQL statement de-identification methods, devices, equipment, and computer-readable storage media

Publications (2)

Publication Number Publication Date
CN115203719A CN115203719A (en) 2022-10-18
CN115203719B true CN115203719B (en) 2026-04-28

Family

ID=83575367

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210698972.7A Active CN115203719B (en) 2022-06-20 2022-06-20 SQL statement de-identification methods, devices, equipment, and computer-readable storage media

Country Status (1)

Country Link
CN (1) CN115203719B (en)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115422597A (en) * 2022-11-08 2022-12-02 国家工业信息安全发展研究中心 Self-adaptive industrial data desensitization and reduction method and system
CN116881276A (en) * 2023-06-09 2023-10-13 中银金融科技有限公司 Data synchronization and desensitization integrated method, device, electronic equipment and storage medium
CN116795921A (en) * 2023-07-10 2023-09-22 湖南亚信软件有限公司 Database interaction method, device, equipment and storage medium
CN117390658B (en) * 2023-12-13 2024-03-05 北京宇信科技集团股份有限公司 Data security engine, data security access system and access method
CN118332592A (en) * 2024-04-09 2024-07-12 国网北京市电力公司 Data desensitization method, device, non-volatile storage medium and electronic device

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102902932A (en) * 2012-09-18 2013-01-30 武汉华工安鼎信息技术有限责任公司 Database External Encryption and Decryption System Based on SQL Rewriting and Its Application Method
CN110443059A (en) * 2018-05-02 2019-11-12 中兴通讯股份有限公司 Data protection method and device
CN113836171A (en) * 2021-09-27 2021-12-24 北京金山云网络技术有限公司 Data desensitization method, device, electronic device and readable storage medium

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106022143B (en) * 2016-05-10 2018-12-04 武汉华工安鼎信息技术有限责任公司 Method, device and system for operating security gateway of database security level mark

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102902932A (en) * 2012-09-18 2013-01-30 武汉华工安鼎信息技术有限责任公司 Database External Encryption and Decryption System Based on SQL Rewriting and Its Application Method
CN110443059A (en) * 2018-05-02 2019-11-12 中兴通讯股份有限公司 Data protection method and device
CN113836171A (en) * 2021-09-27 2021-12-24 北京金山云网络技术有限公司 Data desensitization method, device, electronic device and readable storage medium

Also Published As

Publication number Publication date
CN115203719A (en) 2022-10-18

Similar Documents

Publication Publication Date Title
CN115203719B (en) SQL statement de-identification methods, devices, equipment, and computer-readable storage media
JP6051212B2 (en) Processing iterative data
CN112560100A (en) Data desensitization method and device, computer readable storage medium and electronic equipment
CN114443699B (en) Information query method, device, computer equipment and computer readable storage medium
CN114969819A (en) Data asset risk discovery method and device
CN107330014B (en) Data table creating method and device
Fagin et al. Cleaning inconsistencies in information extraction via prioritized repairs
WO2019136855A1 (en) Method and apparatus for implementing multidimensional analysis on insurance policy, terminal device, and storage medium
CN112182637A (en) Safety control system, method, device and storage medium
CN108008947B (en) Intelligent prompting method and device for programming statement, server and storage medium
CN111221690B (en) Model determination method, device and terminal for integrated circuit design
CN116431481A (en) Code parameter verification method and device based on multi-code condition
CN117010358A (en) Message card generation method, device, computer equipment and storage medium
CN110309315B (en) Template file generation method and device, computer readable medium and electronic equipment
CN110795617A (en) A kind of error correction method of search word and related device
CN112799638B (en) Non-invasive rapid development method, platform, terminal and storage medium
CN107451050B (en) Function acquisition method and device, and server
CN114169003A (en) Dynamic desensitization method and system based on syntax tree parsing and result set rewriting
Reger Better Proof Output for Vampire.
CN117131538A (en) Data processing method, device, equipment and storage medium
KR20250161877A (en) Method and system for advanced retrieval-augmented generation through metadata extraction and retrieval engine mixing
CN114547066B (en) Standardization methods, devices and computer equipment for nuclear power business data
CN115309770B (en) Data analysis methods, apparatus, devices, and storage media based on custom strategies
CN117453437A (en) Database statement processing method, device, computer equipment and storage medium
CN114547086A (en) Data processing method, device, equipment and computer readable storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant