CN113742371B - SQL statement block analysis processing method and device - Google Patents
SQL statement block analysis processing method and device Download PDFInfo
- Publication number
- CN113742371B CN113742371B CN202111310323.7A CN202111310323A CN113742371B CN 113742371 B CN113742371 B CN 113742371B CN 202111310323 A CN202111310323 A CN 202111310323A CN 113742371 B CN113742371 B CN 113742371B
- Authority
- CN
- China
- Prior art keywords
- sql
- sql statement
- keywords
- keyword
- block
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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/245—Query processing
- G06F16/2455—Query execution
Abstract
The application discloses a method and a device for analyzing and processing SQL statement blocks, wherein the method comprises the following steps: acquiring an SQL statement block, wherein the SQL statement block comprises a plurality of SQL statements; searching keywords from the SQL statement block, wherein the keywords are pre-configured and are SQL commands, and risks may occur when the command statement where the keywords are located is executed in the database; after the keywords are searched in the SQL sentences, the SQL sentences in which the keywords are located are obtained from the sentence blocks according to the keywords; extracting the SQL sentences in which the keywords are located from the sentence blocks; and analyzing the extracted SQL sentences, wherein the analysis is used for determining the risks generated when the SQL sentences are executed in the database. The problem that in the prior art, workload is large and efficiency is low when the statement blocks are split is solved, and analysis efficiency of the SQL statement blocks is improved to a certain extent.
Description
Technical Field
The application relates to the field of databases, in particular to a method and a device for analyzing and processing SQL statement blocks.
Background
In actual development, some SQL statement blocks may need to be written, data may need to be modified according to actual needs, or other operations may need to be performed.
When risk analysis needs to be performed on an SQL statement, how to split a statement block into single statements needs to be considered. Sometimes, a plurality of sentences in the sent sentence block are not marked and cannot be split according to special symbols.
When the sentence blocks are split, the sentence blocks need to be split in a manner similar to natural language splitting, and at this time, each word in the sentence blocks needs to be analyzed. The splitting method has the advantages of large workload and low splitting efficiency.
Disclosure of Invention
The embodiment of the application provides a method and a device for analyzing and processing an SQL statement block, which are used for at least solving the problem of low SQL statement block analysis efficiency caused by large workload when a statement block is split in the prior art.
According to an aspect of the present application, there is provided a method for analyzing and processing a block of SQL statements, including: acquiring an SQL statement block, wherein the SQL statement block comprises a plurality of SQL statements; searching keywords from the SQL statement block, wherein the keywords are configured in advance, the keywords are SQL commands, and the command statement where the keywords are located may have risks when being executed in a database; after the keywords are searched in the SQL sentences, the SQL sentences in which the keywords are located are obtained from the sentence blocks according to the keywords; extracting the SQL sentence in which the keyword is located from the sentence block; and analyzing the extracted SQL statement, wherein the analysis is used for determining the risk generated when the SQL statement is executed in the database.
Furthermore, the number of the keywords is multiple, the SQL statements are searched according to each keyword, and in the case of the search, the SQL statement where each searched keyword is located is extracted from the SQL statement block, and each extracted SQL statement is analyzed.
Further, still include: obtaining the result of analyzing each SQL statement; and summarizing the result corresponding to each SQL statement into a result set for analyzing the SQL statement.
Further, acquiring the SQL statement in which the keyword is located from the statement block according to the keyword includes: and acquiring the SQL sentence where the keyword is located from the sentence block according to the SQL grammatical feature corresponding to the keyword.
Further, analyzing the extracted SQL statement includes: and analyzing the extracted SQL sentences according to a preset rule.
According to another aspect of the present application, there is also provided an SQL statement block analysis processing apparatus, including: the system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring an SQL statement block, and the SQL statement block comprises a plurality of SQL statements; the search module is used for searching keywords from the SQL statement block, wherein the keywords are configured in advance, the keywords are SQL commands, and the command statement where the keywords are located may have risks when being executed in a database; the second obtaining module is used for obtaining the SQL sentence where the keyword is located from the sentence block according to the keyword after the keyword is searched in the SQL sentence; the extraction module is used for extracting the SQL sentences in which the keywords are positioned from the sentence blocks; and the analysis module is used for analyzing the extracted SQL statement, wherein the analysis is used for determining the risk generated when the SQL statement is executed in the database.
Furthermore, the number of the keywords is multiple, and the search module is used for searching in the SQL statement according to each keyword; the extraction module is used for extracting the SQL sentences of the searched keywords from the SQL sentence blocks respectively under the condition that the search module searches the SQL sentences; the analysis module is used for analyzing each extracted SQL statement.
Further, still include: the third acquisition module is used for acquiring the result of analyzing each SQL statement; and the summarizing module is used for summarizing the result corresponding to each SQL statement into a result set for analyzing the SQL statement.
Further, the second obtaining module is configured to: and acquiring the SQL sentence where the keyword is located from the sentence block according to the SQL grammatical feature corresponding to the keyword.
Further, the analysis module is to: and analyzing the extracted SQL sentences according to a preset rule.
In the embodiment of the application, an SQL statement block is obtained, wherein the SQL statement block comprises a plurality of SQL statements; searching keywords from the SQL statement block, wherein the keywords are configured in advance, the keywords are SQL commands, and the command statement where the keywords are located may have risks when being executed in a database; after the keywords are searched in the SQL sentences, the SQL sentences in which the keywords are located are obtained from the sentence blocks according to the keywords; extracting the SQL sentence in which the keyword is located from the sentence block; and analyzing the extracted SQL statement, wherein the analysis is used for determining the risk generated when the SQL statement is executed in the database. The problem that in the prior art, workload is large and efficiency is low when the statement blocks are split is solved, and analysis efficiency of the SQL statement blocks is improved to a certain extent.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this application, illustrate embodiments of the application and, together with the description, serve to explain the application and are not intended to limit the application. In the drawings:
fig. 1 is a flowchart of an SQL statement block analysis processing method according to an embodiment of the present application.
Detailed Description
It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict. The present application will be described in detail below with reference to the embodiments with reference to the attached drawings.
It should be noted that the steps illustrated in the flowcharts of the figures may be performed in a computer system such as a set of computer-executable instructions and that, although a logical order is illustrated in the flowcharts, in some cases, the steps illustrated or described may be performed in an order different than presented herein.
In this embodiment, a method for analyzing and processing a block of an SQL statement is provided, and fig. 1 is a flowchart of a method for analyzing and processing a block of an SQL statement according to an embodiment of the present application, and as shown in fig. 1, the flowchart includes the following steps:
step S102, obtaining an SQL statement block, wherein the SQL statement block comprises a plurality of SQL statements;
step S104, searching keywords from the SQL statement block, wherein the keywords are pre-configured and are SQL commands, and the command statement where the keywords are located may have risks when being executed in the database;
as an optional added embodiment, all commands in the SQL syntax, for example, select, etc., may be obtained, and all commands are ranked, where the keyword-forming statements that do not present risk when the database is executed are defined as first-level keywords, the keyword-forming statements that present risk when the database is executed are defined as second-level keywords, and the second-level keywords searched in step S104 are obtained.
If the process of analyzing in step S110 includes auditing, the first level keyword may also be used to perform searching, and the SQL statements corresponding to the first level keyword search are saved, and the saved SQL statements are used for auditing. And storing the SQL sentences corresponding to the keywords at the second level, wherein the stored SQL sentences are used for auditing and risk analysis.
When the keywords of all levels are used for searching, the first position of the keyword in the SQL statement block and the second position of the extracted SQL statement where the keyword is located in the SQL statement block can be obtained, the SQL statements extracted from the SQL statement block are arranged according to the first positions of all the searched keywords and the second positions of the SQL corresponding to all the keywords to obtain a second SQL statement block, the original SQL statement block is used as a first statement block, the difference between the second statement block and the first statement block can be obtained by comparing the second statement block and the first statement block, and if no difference exists, the extraction is correct. And if the difference exists, acquiring the content of the difference between the second statement block and the first statement block, and performing risk analysis on the content of the difference.
As another embodiment that can be added, after performing risk analysis on the difference content, a keyword may be obtained from the difference content, if it is determined that the difference content is risk-free after the analysis, the keyword is defined as a first level keyword and stored, and if it is determined that the difference content is risk-free after the analysis, the keyword is defined as a second level keyword and stored, where the stored keyword is used for performing retrieval and search of an SQL statement.
Step S106, after the keywords are searched in the SQL sentences, the SQL sentences in which the keywords are located are obtained from the sentence blocks according to the keywords;
step S108, extracting the SQL sentences in which the keywords are located from the sentence blocks;
step S110, analyzing the extracted SQL statement, wherein the analysis is used to determine a risk generated when the SQL statement is executed in the database.
In an optional implementation manner, the SQL code may be obtained, and whether the risk SQL exists in the SQL code is determined based on a preset code check rule; SQL code may be released to the test environment; calling a first risk identification model in the test environment to carry out risk identification on the SQL code; the first risk identification model is obtained based on SQL feature data training in a test environment; when risk SQL does not exist in the identification result, the SQL code is issued to the production environment; calling a second risk identification model in the production environment to carry out risk identification on slow SQL in the SQL codes to obtain a risk identification result; the second risk identification model is obtained based on SQL characteristic data training in the production environment; slow SQL is SQL that exceeds a preset threshold.
Or, it may be determined whether the risky SQL exists in the SQL code based on the preset code detection rule. First, a preset code check rule is created. For example, in some implementations, when creating the preset code checking rule, SQL may be parsed in conjunction with the metadata. The metadata may include a data dictionary (e.g., database, data table, table field, primary key definition), data capacity (e.g., database capacity size, data table partition capacity size), statistical information (e.g., data table record number, data table partition and distribution key, data distribution situation), and the like. After the preset code check rule is created, the preset code check rule can be stored in the code rule base, so that the preset code check rule can be directly called from the code rule base when needed subsequently, and the data processing efficiency can be effectively improved. The code rule base can be used for storing preset code checking rules, and can be an Oracle database, a MySQL database and the like.
Through the steps, all keywords which can generate risks, such as keywords like delete and create, are configured in advance, and statements of the keywords can be regarded as risk statements, so that the SQL statements where the keywords are located are further obtained by searching the keywords, and then risk analysis is performed on the SQL statements. Compared with the method of analyzing natural languages one by one, the method has the advantages that the execution speed is higher due to keyword matching, so that the problem of large workload and low efficiency when the sentence blocks are split in the prior art is solved, and the analysis efficiency of the SQL sentence blocks is improved to a certain extent.
In an optional implementation manner, the number of the keywords may be multiple, the SQL statements are searched according to each keyword, and in the case of the search, the SQL statement where each searched keyword is located is extracted from the SQL statement block, and each extracted SQL statement is analyzed. Under the condition that a plurality of SQL sentences exist, the result of analyzing each SQL sentence can be obtained; and summarizing the result corresponding to each SQL statement into a result set for SQL statement analysis.
When the SQL statements are extracted, the SQL statements where the keywords are located can be obtained from the statement blocks according to the SQL syntax features corresponding to the keywords.
For example, the complete syntax of the SELECT statement is:
SELECT[ALL|DISTINCT|DISTINCTROW|TOP]
{*|talbe.*|[table.]field1[AS alias1][,[table.]field2[AS alias2][,…]]}
FROM tableexpression[,…][IN externaldatabase]
[WHERE…]
[GROUP BY…]
[HAVING…]
[ORDER BY…]
[WITH OWNERACCESS OPTION]
wherein the portion enclosed by the middle brackets ([ ]) indicates that it is optional, and the portion enclosed by the large brackets ({ }) indicates that one of them must be selected.
The complete grammar can be used as a grammar feature, and grammar features of other commands can also be used as a basis for extracting SQL sentences, which is not described herein again.
And analyzing the extracted SQL statement according to a preset rule, wherein the preset rule has a plurality of implementation modes. The configured rule may treat a plurality of SQL statements as a whole statement, and record when a problem occurs, for example, if there is an error affecting the analysis of the SQL statement in the statement, the database may return information of a statement error, and record the whole statement at this time. If a statement reports an error but there is no syntax error, for example, a table does not exist, the continued execution of the following statements is not affected, so that the statement is recorded as a single statement at this time. In the case of the preceding statement, the result is normally returned, and the subsequent error report is performed, and in the case of the statement, the statement which is normally returned records the single statement, and the statement which is performed after the error report is not recorded. If some statement is blocked or interrupted, the whole statement is recorded, and the rule action is blocked or interrupted.
In this embodiment, an electronic device is provided, comprising a memory in which a computer program is stored and a processor configured to run the computer program to perform the method in the above embodiments.
The programs described above may be run on a processor or may also be stored in memory (or referred to as computer-readable media), which includes both non-transitory and non-transitory, removable and non-removable media, that implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
These computer programs may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks, and corresponding steps may be implemented by different modules. In this embodiment, there is provided an apparatus, which may be referred to as an SQL statement block analysis processing apparatus, including: the system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring an SQL statement block, and the SQL statement block comprises a plurality of SQL statements; the search module is used for searching keywords from the SQL statement block, wherein the keywords are configured in advance, the keywords are SQL commands, and the command statement where the keywords are located may have risks when being executed in the database; the second acquisition module is used for acquiring the SQL sentences in which the keywords are located from the sentence blocks according to the keywords after the keywords are searched in the SQL sentences; the extraction module is used for extracting the SQL sentences in which the keywords are located from the sentence blocks; and the analysis module is used for analyzing the extracted SQL statement, wherein the analysis is used for determining the risk generated when the SQL statement is executed in the database.
The modules in the apparatus correspond to the steps in the above method embodiments, which have already been described in the above method embodiments, and are not described again here.
For example, there are a plurality of keywords, and the search module is configured to search in the SQL statement according to each keyword; the extraction module is used for respectively extracting the searched SQL sentences of each keyword from the SQL sentence blocks under the condition that the search module searches the SQL sentences; the analysis module is used for analyzing each extracted SQL statement.
For another example, the apparatus may further include: the third acquisition module is used for acquiring the result of analyzing each SQL statement; and the summarizing module is used for summarizing the result corresponding to each SQL statement into a result set for SQL statement analysis.
For example, the second obtaining module is configured to: and acquiring the SQL sentence where the keyword is located from the sentence block according to the SQL grammatical feature corresponding to the keyword. The analysis module is used for: and analyzing the extracted SQL sentences according to a preset rule.
The purpose of splitting the SQL statement block may be to perform corresponding response and subsequent control, and at this time, all grammars need to be parsed to perform pairing. In the present embodiment, only detailed analysis that easily causes a conflict is performed, that is, different keywords are distinguished in the present embodiment, and detailed analysis is performed if a keyword is a keyword that is likely to cause a conflict, and skipping is performed if the keyword is a general keyword. After the keywords appear, the sentences under the keywords are obtained, and the obtained sentences are analyzed, so that the analysis efficiency is improved.
The above are merely examples of the present application and are not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A SQL statement block analysis processing method is characterized by comprising the following steps:
step S102, obtaining an SQL statement block, wherein the SQL statement block comprises a plurality of SQL statements;
step S104, searching keywords from the SQL statement block, wherein the keywords are configured in advance and are SQL commands;
step S106, after the keyword is searched in the SQL statement, obtaining the SQL statement where the keyword is located from the statement block according to the keyword;
step S108, extracting the SQL sentence where the keyword is from the sentence block;
step S110, analyzing the extracted SQL statement, wherein the analysis is used for determining the risk generated when the SQL statement is executed in the database; acquiring all commands in SQL grammar, and grading all commands, wherein keywords corresponding to risks are defined as first-level keywords when statements formed by the keywords are executed in a database, and keywords corresponding to risks are defined as second-level keywords when the statements formed by the keywords are executed in the database; the analysis process in step S110 includes auditing, using the first level keyword to perform search, storing the SQL statement corresponding to the first level keyword search, and using the stored SQL statement to perform audit; storing SQL sentences corresponding to the keywords at the second level, wherein the stored SQL sentences are used for auditing and risk analysis; when the keywords of all levels are used for searching, acquiring a first position of a searched keyword in an SQL statement block and a second position of an SQL statement of the searched keyword in the SQL statement block, arranging the SQL statements extracted from the SQL statement block according to the first positions of all searched keywords and the second positions of SQL corresponding to all the keywords to obtain a second SQL statement block, taking an original SQL statement block as a first SQL statement block, comparing the second SQL statement block with the first SQL statement block to obtain a difference between the second SQL statement block and the first SQL statement block, and if no difference exists, judging that the extraction is correct; and if the difference exists, acquiring the content of the difference between the second SQL statement block and the first SQL statement block, and carrying out risk analysis on the content of the difference.
2. The method according to claim 1, wherein the number of the keywords is plural, the SQL statements are searched according to each keyword, and in the case of the search, the SQL statements where each searched keyword is located are respectively extracted from the SQL statement block, and each extracted SQL statement is analyzed.
3. The method of claim 2, further comprising:
obtaining a result after analyzing each SQL statement;
and summarizing the result corresponding to each SQL statement into a result set for analyzing the SQL statement.
4. The method of claim 1, wherein obtaining the SQL statement in which the keyword is located from the statement block according to the keyword comprises:
and acquiring the SQL sentence where the keyword is located from the sentence block according to the SQL grammatical feature corresponding to the keyword.
5. The method of any of claims 1 to 4, wherein analyzing the extracted SQL statement comprises:
and analyzing the extracted SQL sentences according to a preset rule.
6. An SQL statement block analysis processing apparatus, comprising:
the system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring an SQL statement block, and the SQL statement block comprises a plurality of SQL statements;
the search module is used for searching keywords from the SQL statement block, wherein the keywords are configured in advance and are SQL commands;
the second obtaining module is used for obtaining the SQL sentence where the keyword is located from the sentence block according to the keyword after the keyword is searched in the SQL sentence;
the extraction module is used for extracting the SQL sentences in which the keywords are positioned from the sentence blocks;
the analysis module is used for analyzing the extracted SQL sentences, wherein the analysis is used for determining risks generated when the SQL sentences are executed in the database, all commands in the SQL grammar are obtained, and all the commands are classified, wherein keywords corresponding to the risks, which do not occur when the sentences formed by the keywords are executed in the database, are defined as keywords of a first level, and keywords corresponding to the risks, which occur when the sentences formed by the keywords are executed in the database, are defined as keywords of a second level; the process of analyzing in the analysis module comprises auditing, searching by using the keywords of the first level, storing SQL sentences corresponding to the keyword search of the first level, and using the stored SQL sentences for auditing; storing SQL sentences corresponding to the keywords at the second level, wherein the stored SQL sentences are used for auditing and risk analysis; when the keywords of all levels are used for searching, acquiring a first position of a searched keyword in an SQL statement block and a second position of an SQL statement where the searched keyword is located in the SQL statement block, arranging the SQL statements extracted from the SQL statement block according to the first positions of all searched keywords and the second positions of SQL corresponding to all the searched keywords to obtain a second SQL statement block, taking an original SQL statement block as a first SQL statement block, comparing the second SQL statement block with the first SQL statement block to acquire a difference between the second SQL statement block and the first SQL statement block, and if no difference exists, judging that the extraction is correct; and if the difference exists, acquiring the content of the difference between the second SQL statement block and the first SQL statement block, and carrying out risk analysis on the content of the difference.
7. The apparatus according to claim 6, wherein the keyword is plural, and the search module is configured to search in the SQL statement according to each keyword; the extraction module is used for extracting the SQL sentences of the searched keywords from the SQL sentence blocks respectively under the condition that the search module searches the SQL sentences; the analysis module is used for analyzing each extracted SQL statement.
8. The apparatus of claim 7, further comprising:
the third acquisition module is used for acquiring the result of analyzing each SQL statement;
and the summarizing module is used for summarizing the result corresponding to each SQL statement into a result set for analyzing the SQL statement.
9. The apparatus of claim 6, wherein the second obtaining module is configured to:
and acquiring the SQL sentence where the keyword is located from the sentence block according to the SQL grammatical feature corresponding to the keyword.
10. The apparatus of any one of claims 6 to 9, wherein the analysis module is to:
and analyzing the extracted SQL sentences according to a preset rule.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111310323.7A CN113742371B (en) | 2021-11-08 | 2021-11-08 | SQL statement block analysis processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111310323.7A CN113742371B (en) | 2021-11-08 | 2021-11-08 | SQL statement block analysis processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113742371A CN113742371A (en) | 2021-12-03 |
| CN113742371B true CN113742371B (en) | 2022-02-15 |
Family
ID=78727561
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111310323.7A Active CN113742371B (en) | 2021-11-08 | 2021-11-08 | SQL statement block analysis processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113742371B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107908739A (en) * | 2017-11-15 | 2018-04-13 | 湖南上容信息技术有限公司 | Dynamic syntax analytic method and its resolution system |
| CN109284282A (en) * | 2018-10-22 | 2019-01-29 | 北京极数云舟科技有限公司 | One kind being based on MySQL database O&M method and system |
| CN111460797A (en) * | 2020-06-09 | 2020-07-28 | 平安国际智慧城市科技股份有限公司 | Keyword extraction method and device, electronic equipment and readable storage medium |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104077530A (en) * | 2013-03-27 | 2014-10-01 | 国际商业机器公司 | Method and device used for evaluating safety of data access sentence |
| CN104391995A (en) * | 2014-12-15 | 2015-03-04 | 北京趣拿软件科技有限公司 | SQL (Structured Query Language) statement auditing method, and database operation and maintenance method and system |
| CN111522816B (en) * | 2020-04-16 | 2021-04-30 | 云和恩墨(北京)信息技术有限公司 | Data processing method, device, terminal and medium based on database engine |
| CN111949541B (en) * | 2020-08-14 | 2024-03-22 | 中国工商银行股份有限公司 | Multi-source database statement checking method and device |
-
2021
- 2021-11-08 CN CN202111310323.7A patent/CN113742371B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107908739A (en) * | 2017-11-15 | 2018-04-13 | 湖南上容信息技术有限公司 | Dynamic syntax analytic method and its resolution system |
| CN109284282A (en) * | 2018-10-22 | 2019-01-29 | 北京极数云舟科技有限公司 | One kind being based on MySQL database O&M method and system |
| CN111460797A (en) * | 2020-06-09 | 2020-07-28 | 平安国际智慧城市科技股份有限公司 | Keyword extraction method and device, electronic equipment and readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113742371A (en) | 2021-12-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111522816B (en) | Data processing method, device, terminal and medium based on database engine | |
| US9916368B2 (en) | Non-exclusionary search within in-memory databases | |
| WO2016188279A1 (en) | Generating method and device for fault spectra, and detecting method and device based on fault spectra | |
| US11755654B2 (en) | Category tag mining method, electronic device and non-transitory computer-readable storage medium | |
| US9753977B2 (en) | Method and system for managing database | |
| CN112511546A (en) | Vulnerability scanning method, device, equipment and storage medium based on log analysis | |
| CN109471889B (en) | Report accelerating method, system, computer equipment and storage medium | |
| CN114239591B (en) | Sensitive word recognition method and device | |
| CN113742371B (en) | SQL statement block analysis processing method and device | |
| CN112783916A (en) | SQL statement auditing method and device, storage medium and electronic equipment | |
| CN113641702B (en) | Method and device for interactive processing with database client after statement audit | |
| CN116610694A (en) | Rule verification method and system based on relation between columns and access sentences | |
| CN113326688A (en) | Ideological and political theory word duplication checking processing method and device | |
| CN117389980B (en) | Log file analysis method and device, computer equipment and readable storage medium | |
| CN116610567A (en) | Early warning method and device for abnormal application program, processor and electronic equipment | |
| CN111723104A (en) | Method, device and system for syntax analysis in data processing system | |
| US20100088306A1 (en) | Method, Computer Apparatus and Computer Program for Identifying Unusual Combinations of Values in Data | |
| CN114936212B (en) | Audit data synchronous processing method and device | |
| CN114253989A (en) | Data modification scheme detection method and device and electronic equipment | |
| CN117349721A (en) | Data quality checking method and system | |
| CN117472888A (en) | Fine data problem analysis method and system | |
| CN117632889A (en) | Full text index processing method and system for audit log | |
| CN117493391A (en) | Task matching method, device, computer equipment and storage medium | |
| CN116610700A (en) | Query statement detection method and device and storage medium | |
| CN117472958A (en) | Verification method, device, equipment and medium for SQL statement execution result |
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 | ||
| GR01 | Patent grant |