Unlock instant, AI-driven research and patent intelligence for your innovation.

SQL processing method and device

A processing method and grammar technology, applied in the database field, to achieve the effect of improving the correct rate and accuracy

Inactive Publication Date: 2020-02-14
连连银通电子支付有限公司
View PDF3 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] This application provides a SQL processing method and device, the purpose is to solve the problem of improving the correct rate of auditing the standardization of SQL statements and improving the accuracy rate of database data changes

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • SQL processing method and device
  • SQL processing method and device
  • SQL processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0070] figure 2 for figure 1 An implementation of executing the SQL text in the database in S105 includes the following steps:

[0071] It should be noted that S201-S206 are executed under the condition that the execution environment is the production environment.

[0072] S201. Determine the database corresponding to the SQL text according to the database identity identifier corresponding to the SQL text.

[0073] The application system often includes multiple databases. In order to execute the SQL text in the specified data, in the SQL work order, the database identity corresponding to the SQL text is preset. As described in the foregoing embodiments, the database identity can be It is the name of the database, and it can also be the address of the database connection. Since the identity of each database is different, the database can be determined according to the identity of the database.

[0074] S202. Back up the data of the database corresponding to the SQL text.

...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides an SQL processing method and device. The method comprises: obtaining at least one SQL statement in the SQL text, specific to each SQL statement, extracting feature information of the SQL statement; and according to the feature information of the SQL statements, judging whether each SQL statement meets a preset auditing standard or not, if all the SQL statements meet the auditing standard, judging whether the grammar of each SQL statement is correct or not in a test environment, and if the grammar of all the SQL statements is correct, executing the SQL text in a database.According to the method provided by the invention, the SQL statement is audited through the preset auditing standard, and the accuracy of the grammar is further judged in the test environment after the SQL statement is determined to meet the auditing standard, so that the normative accuracy of the SQL statement is improved, and finally, the accuracy of database change is improved.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to an SQL processing method and device. Background technique [0002] As the business volume of the enterprise increases, the number of databases in the application system of the enterprise also increases accordingly. The data in the database needs to be queried, updated, or other operations every day. Usually, structured query language SQL is used to implement these operations. [0003] In the process of using SQL statements to operate the database, if the SQL statements are not standardized, it will cause database operation errors, so before executing the SQL statements, it is necessary to review the standardization of the SQL statements. [0004] Auditing the standardization of SQL statements is usually done manually. However, some non-standard SQL statements will pass the audit, so the accuracy of the audit results is low, resulting in a high error rate in database ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/242G06F16/22
CPCG06F16/2433G06F16/2282
Inventor 宋城孔万群
Owner 连连银通电子支付有限公司