CN110674161A - Method, system, storage medium and SQL operation platform for online SQL - Google Patents
Method, system, storage medium and SQL operation platform for online SQL Download PDFInfo
- Publication number
- CN110674161A CN110674161A CN201910893887.4A CN201910893887A CN110674161A CN 110674161 A CN110674161 A CN 110674161A CN 201910893887 A CN201910893887 A CN 201910893887A CN 110674161 A CN110674161 A CN 110674161A
- Authority
- CN
- China
- Prior art keywords
- sql
- result
- online
- examination
- sql statement
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 35
- 238000003860 storage Methods 0.000 title claims abstract description 12
- 238000012552 review Methods 0.000 claims abstract description 39
- 238000004590 computer program Methods 0.000 claims description 9
- 230000000694 effects Effects 0.000 abstract description 6
- 238000012550 audit Methods 0.000 description 15
- 230000006870 function Effects 0.000 description 15
- 238000012545 processing Methods 0.000 description 11
- 238000007726 management method Methods 0.000 description 7
- 238000012986 modification Methods 0.000 description 7
- 230000004048 modification Effects 0.000 description 7
- 238000000586 desensitisation Methods 0.000 description 5
- 238000012423 maintenance Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 238000012827 research and development Methods 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000011084 recovery Methods 0.000 description 2
- 238000005096 rolling process Methods 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000009795 derivation Methods 0.000 description 1
- 235000019800 disodium phosphate Nutrition 0.000 description 1
- 230000014509 gene expression Effects 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
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
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
-
- 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/2452—Query translation
- G06F16/24528—Standardisation; Simplification
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
The invention provides an online SQL method, a system, a storage medium and an SQL operation platform, which comprises the following steps: sending SQL statements to the inclusion so that the inclusion can automatically check the SQL statements; sending a manual review request to a reviewer so that the reviewer can perform manual review on the SQL statement; and executing the SQL statement on line when the result of the automatic examination and the result of the manual examination both pass. According to the invention, by adopting the Incep, the automatic auditing function is realized on the SQL statement before the SQL statement is executed and is on-line, and the comprehensiveness of the SQL statement auditing is improved by combining the manual auditing operation of an auditor on the SQL statement in the prior art, so that the auditing effect is ensured, and the auditing efficiency on the SQL statement is improved.
Description
Technical Field
The invention belongs to the field of databases, and particularly relates to an online SQL method, a system, a storage medium and an SQL operation platform.
Background
In the work of the database, the SQL sentences executed by the database are often required to be checked, so that the SQL sentences with poor performance are prevented from entering a production system, and the overall performance of the database is prevented from being reduced. At present, the existing SQL examination and submission system only has the functions of flow submission and database management, cannot realize the automatic examination function of SQL grammar, and aims at the unified standard of the MySQL statement writing method, the manual examination is labored, the more the standard is, the more difficult the manual examination is, and the longer the examination period is, so that the operation of the manual examination is only relied on, heavy work burden is brought to an examiner, the problems of low examination efficiency and incomplete examination are caused, and the SQL execution online process is influenced.
Disclosure of Invention
In view of the above disadvantages of the prior art, an object of the present invention is to provide an online SQL method, system, storage medium, and SQL operating platform, which implement automatic audit on SQL statements by inclusion, and solve the problems of low audit efficiency and incomplete audit caused by dependence on manual audit in the prior art by combining with a manual audit mode.
In order to achieve the above objects and other related objects, the present invention provides an online SQL method, applied to an SQL operating platform, comprising the following steps: sending SQL statements to the inclusion so that the inclusion can automatically check the SQL statements; sending a manual review request to a reviewer so that the reviewer can perform manual review on the SQL statement; and executing the SQL statement on line when the result of the automatic examination and the result of the manual examination both pass.
In an embodiment of the present invention, executing the online SQL statement includes the following two ways: receiving the result of the automatic examination and the result of the manual examination, and executing the on-line SQL statement by the SQL operation platform when the result of the automatic examination and the result of the manual examination both pass; and receiving the result of the automatic examination and sending the result to a database administrator, so that the database administrator controls the SQL operation platform to execute the online SQL statement when the result of the automatic examination and the result of the manual examination both pass.
In an embodiment of the present invention, when the SQL operating platform executes the online SQL statement, the method further includes: and remotely connecting with a database, and executing online data backup on the SQL statement.
In an embodiment of the present invention, the method further includes: and when the result of the automatic examination is failed, modifying and backing up the SQL statement until the examination is passed.
In an embodiment of the present invention, the manual review request is sent to the reviewer by one or a combination of several manners of mails, short messages, and application messages of the intelligent terminal.
The invention provides an online SQL system, which is applied to an SQL operation platform and comprises the following components: the system comprises a first sending module, a second sending module and an execution online module; the first sending module is used for sending an SQL statement to the inclusion so that the inclusion can automatically check the SQL statement; the second sending module is used for sending a manual review request to a reviewer so that the reviewer can perform manual review on the SQL statement; and the online execution module is used for executing the online SQL statement when the result of the automatic examination and the result of the manual examination both pass.
In an embodiment of the present invention, the system further includes a data backup module, where the data backup module is used to remotely connect to a database and perform online data backup on the SQL statement.
The present invention provides a storage medium having stored thereon a computer program which, when executed by a processor, implements the above-described method of online SQL.
The invention provides an SQL operation platform, which comprises: a processor and a memory; the memory is used for storing a computer program; the processor is used for executing the computer program stored in the memory so as to enable the SQL operation platform to execute the online SQL method.
The invention provides a system of online SQL, which comprises an SQL operation platform, an inclusion and an intelligent terminal in claim 9; the inclusion is used for receiving the SQL sentences sent by the SQL operation platform and automatically auditing the SQL sentences; and the intelligent terminal is used for receiving the manual examination request sent by the SQL operation platform.
As described above, the online SQL method, system, storage medium, and SQL operating platform according to the present invention have the following advantages:
by adopting the inclusion, the automatic auditing function of the SQL statement is realized before the SQL statement is executed and is on-line, and the comprehensiveness of the SQL statement auditing is improved by combining the manual auditing operation of an auditor on the SQL statement in the prior art, so that the auditing effect is ensured, and the auditing efficiency of the SQL statement is improved.
Drawings
FIG. 1 is a flowchart illustrating a method for online SQL according to an embodiment of the present invention.
Fig. 2 is a schematic structural diagram of an online SQL system according to an embodiment of the invention.
Fig. 3 is a schematic structural diagram of an SQL operating platform according to an embodiment of the invention.
Fig. 4 is a schematic structural diagram of an online SQL system according to another embodiment of the invention.
Fig. 5 is a schematic diagram of the inclusion architecture of the present invention.
Description of the element reference numerals
21 first transmitting module
22 second sending module
23 execution online module
31 processor
32 memory
41 SQL operation platform
42 Inception
43 Intelligent terminal
S1-S3
Detailed Description
The embodiments of the present invention are described below with reference to specific embodiments, and other advantages and effects of the present invention will be easily understood by those skilled in the art from the disclosure of the present specification. The invention is capable of other and different embodiments and of being practiced or of being carried out in various ways, and its several details are capable of modification in various respects, all without departing from the spirit and scope of the present invention. It is to be noted that the features in the following embodiments and examples may be combined with each other without conflict.
It should be noted that the drawings provided in the following embodiments are only for illustrating the basic idea of the present invention, and the components related to the present invention are only shown in the drawings rather than drawn according to the number, shape and size of the components in actual implementation, and the type, quantity and proportion of the components in actual implementation may be changed freely, and the layout of the components may be more complicated.
According to the method, the system, the storage medium and the SQL operation platform for online SQL, the Incep is adopted, the automatic examination function is realized on the SQL statement before the SQL statement is online, and the comprehensiveness of the SQL statement examination is improved by combining the manual examination operation of an examiner on the SQL statement in the prior art, so that the examination effect is ensured, and the examination efficiency of the SQL statement is improved.
As shown in fig. 1, in an embodiment, the online SQL method of the present invention is applied to an SQL operating platform, and includes the following steps:
and step S1, sending the SQL statement to the inclusion so that the inclusion can automatically check the SQL statement.
It should be noted that SQL is a shorthand of the full-name Structured Query Language (SQL), is a special-purpose programming Language, is a database Query and programming Language, is used for accessing data, querying, updating, and managing a relational database system, and is also an extension of a database script file.
The Incep is an SQL statement auditing automatic operation and maintenance tool aiming at MySQL (MySQL is a relational database management system, the relational database stores data in different tables, but not puts all data in a large warehouse), is an automatic operation and maintenance system integrating auditing, execution and rollback, is modified according to MySQL codes, can be used for accurately auditing the SQL statement of MySQL in a clear, detailed and identical working mode with MySQL, can be directly connected by using a MySQL client without verification authority, is a server relative to an application program, needs to specify a server address and a port of an Incep server when in connection, is a client relative to an IncSQL server on a line corresponding to the statement to be audited or executed, and needs to be connected with a database server in real time to obtain required information inside, or directly executing corresponding statements on the online and obtaining binlog (the binlog is a binary log of the database and is used for recording SQL statements (except data query statement) information of the database operated by a user, the content of the binary log can be checked by using a bin command) and the like, the inclusion is an intermediate service, as shown in figure 5, the inclusion is a framework of the inclusion, the inclusion provides rich functions, firstly, the grammar analysis can be carried out on all submitted statements, if the grammar has problems, corresponding error information can be returned to a reviewer, the inclusion also provides semantic analysis, when the information of a table, a library, a column and the like is incorrect or not in accordance with the specification, or when a non-existing object is used, the error information is reported, and the like, the inclusion also provides a plurality of functions aiming at SQL normative constraint, and the database managers (DBAs) can be configured by system parameters, the higher level function is that it can also assist DBA to analyze the performance of a query statement, if it is not using index or some reason causes slow query, it can check, and also provide the execution function of SQL statement, the executable statement type includes that the commonly used DML (Data management Language) is the instruction set in SQL Language, which is responsible for running Data access work on database object, and the core is composed of three instructions of INSERT, UPDATE and DELETE, which represent INSERT, UPDATE and DELETE, respectively, which are used by the application program taking Data as center, and DDL (DDL, database schema Definition Language, which is used to describe the real world entity to be stored in database, and is the Language responsible for Data structure Definition and database object Definition in SQL Language set) statement and truntable (trune is an SQL syntax capable of quickly clearing all Data in the Data Table, and can make the effect of resetting the count to zero and recalculating) and so on, the inclusion also provides the function of generating the rollback statement when executing the DML, the corresponding operation record and rollback statement are stored on the backup machine, and the backup machine is designated by configuring the inclusion parameter; the inclusion is used to bring great convenience to the DBA, and the DBA is liberated from the tedious work.
Specifically, a user (operation and maintenance developer) submits the SQL statement on the SQL operating platform and initiates an SQL online request, and the SQL operating platform receives the SQL statement and then sends the SQL statement to the inclusion, so that the inclusion performs automatic auditing operation on the SQL statement.
It should be noted that, when a user (operation and maintenance developer) submits the SQL statement on the SQL operating platform, the SQL statement is the request for initiating the SQL on-line, and if the SQL operating platform successfully receives the SQL statement, the SQL on-line request is successfully initiated; on the contrary, if the SQL operation platform does not receive the SQL statement, it means that the SQL on-line request fails to be initiated, and therefore, the execution of the operation is stopped.
And step S2, sending a manual review request to a reviewer so that the reviewer can perform manual review on the SQL statement.
Specifically, the SQL operating platform sends the manual review request to the reviewer, and the reviewer receiving the manual review request performs a manual review operation on the SQL statement.
It should be noted that the manual review operation is reviewed by other research and development engineers or research and development managers, because the flow of the DBA operation to perform the SQL manual review follows the flow awareness of the online operation in the operation and maintenance field, one engineer needs to update the online database SQL, and is preferably checked by another engineer, and many times, the DBA does not know the business meaning of the SQL, so the manual review is preferably reviewed by other research and development engineers or research and development managers.
Further, step S1 and step S2 do not have a certain sequence, that is, the SQL statement may be automatically checked first by inclusion, or may be manually checked first.
And step S3, when the result of the automatic examination and the result of the manual examination both pass, executing the SQL statement of the online.
Specifically, the operation of executing the online SQL statement can be performed only on the premise that both the automatic review and the manual review pass.
In an embodiment of the present invention, executing the SQL statement on the upper line includes the following two ways:
(1) and receiving the result of the automatic examination and the result of the manual examination, and executing the on-line SQL statement by the SQL operation platform when the result of the automatic examination and the result of the manual examination both pass.
Specifically, the inclusion performs automatic review on the SQL statement, a generated automatic review result is sent to the SQL operation platform, a result generated by manual review is also sent to the SQL operation platform, and the SQL operation platform judges whether to execute the operation of the SQL statement on line based on the automatic review result and the manual review result.
It should be noted that, when one of the automatic review result and the manual review result is not passed or both of the automatic review result and the manual review result are not passed, the SQL operation platform does not execute the operation of the online SQL statement; the SQL operation platform executes the operation of the online SQL statement only when the automatic examination result and the manual examination result are both passed; the above judgment operation is actively completed by the SQL operation platform, and the operation of executing the SQL statement on line is also actively realized by the SQL operation platform.
(2) And receiving the result of the automatic examination and sending the result to a database administrator, so that the database administrator controls the SQL operation platform to execute the online SQL statement when the result of the automatic examination and the result of the manual examination both pass.
Specifically, the inclusion automatically checks the SQL statement, and sends a generated automatic checking result to the SQL operation platform, the SQL operation platform sends the received automatic checking result to the database administrator, and based on the above, a result generated by an auditor performing manual checking on the SQL statement is also sent to the database administrator, and when both the automatic checking result and the manual checking result pass, the database administrator clicks on the SQL operation platform for execution.
It should be noted that, the operation of causing the SQL operation platform to execute the online SQL statement by using the method (2) is performed passively, and the database administrator needs to be relied upon; in addition, a result generated by the auditor performing manual audit on the SQL statement may be sent to the SQL operating platform, and then the result of the automatic audit and the result of the manual audit are sent to the database administrator through the SQL operating platform, and finally the database administrator clicks on the SQL operating platform to execute the operation when both the result of the automatic audit and the result of the manual audit pass.
In an embodiment of the present invention, when the SQL operating platform executes the online SQL statement, the method further includes: and remotely connecting with a database, and executing online data backup on the SQL statement.
It should be noted that, by backing up the data on the SQL statement that is online, a data recovery function can be implemented, for example, when the SQL statement is executed, a problem that the condition is not satisfactory occurs, at this time, this problem can be solved by inserting one piece of data, but the inserted data may also be in error, when the inserted data is incorrect, the data state before the data is inserted can be recovered by Rollback (Rollback refers to a behavior that a program or data is processed incorrectly, and the Rollback includes types of program Rollback and data Rollback), but if no backup operation is performed, the data recovery cannot be implemented.
In an embodiment of the present invention, the method further includes: and when the result of the automatic examination is failed, modifying and backing up the SQL statement until the examination is passed.
Specifically, when the result of the automatic checking of the SQL statement by the inclusion is that the SQL statement does not pass, the SQL statement is modified and the SQL statement after each modification are backed up until the checking passes.
It should be noted that, since the result of the automatic audit is that the SQL statement does not pass through the automatic audit, multiple modification operations may need to be performed on the SQL statement, at this time, the SQL statement after each modification needs to be backed up, so that when the modification has an incorrect operation, the SQL statement before the incorrect operation can be restored by rolling back.
In an embodiment of the present invention, the manual review request is sent to the reviewer by one or a combination of several manners of mails, short messages, and application messages of the intelligent terminal.
It should be noted that the SQL operating platform may also send notification information of online application, permission application, audit result, and abnormal login to the user through one or a combination of several manners of mails, short messages, and application messages of the intelligent terminal.
It should be noted that the protection scope of the online SQL method according to the present invention is not limited to the execution sequence of the steps listed in this embodiment, and all the schemes implemented by adding, subtracting, and replacing steps in the prior art according to the principles of the present invention are included in the protection scope of the present invention.
As shown in fig. 2, in an embodiment, the system of the present invention is applied to an SQL operating platform, and includes: a first sending module 21, a second sending module 22 and an execution online module 23.
The first sending module 21 is configured to send an SQL statement to the inclusion, so that the inclusion performs automatic review on the SQL statement.
The second sending module 22 is configured to send a manual review request to a reviewer, so that the reviewer performs manual review on the SQL statement.
The online execution module 23 is configured to execute the online SQL statement when both the automatic review result and the manual review result pass.
In an embodiment of the present invention, the system further includes a data backup module, where the data backup module is used to remotely connect to a database and perform online data backup on the SQL statement.
It should be noted that the division of the modules of the above apparatus is only a logical division, and the actual implementation may be wholly or partially integrated into one physical entity, or may be physically separated. And these modules can be realized in the form of software called by processing element; or may be implemented entirely in hardware; and part of the modules can be realized in the form of calling software by the processing element, and part of the modules can be realized in the form of hardware. For example, the x module may be a processing element that is set up separately, or may be implemented by being integrated in a chip of the apparatus, or may be stored in a memory of the apparatus in the form of program code, and the function of the x module may be called and executed by a processing element of the apparatus. Other modules are implemented similarly. In addition, all or part of the modules can be integrated together or can be independently realized. The processing element described herein may be an integrated circuit having signal processing capabilities. In implementation, each step of the above method or each module above may be implemented by an integrated logic circuit of hardware in a processor element or an instruction in the form of software.
For example, the above modules may be one or more integrated circuits configured to implement the above methods, such as: one or more Application Specific Integrated Circuits (ASICs), or one or more microprocessors (DSPs), or one or more Field Programmable Gate Arrays (FPGAs), among others. For another example, when one of the above modules is implemented in the form of a Processing element scheduler code, the Processing element may be a general-purpose processor, such as a Central Processing Unit (CPU) or other processor capable of calling program code. For another example, these modules may be integrated together and implemented in the form of a system-on-a-chip (SOC).
The storage medium of the present invention stores thereon a computer program that, when executed by a processor, implements the above-described method of online SQL. The storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic disk, U-disk, memory card, or optical disk.
As shown in fig. 3, the SQL operating platform of the present invention includes a processor 31 and a memory 32.
The memory 32 is used for storing computer programs. Preferably, the memory 32 comprises: various media that can store program codes, such as ROM, RAM, magnetic disk, U-disk, memory card, or optical disk.
The processor 31 is connected to the memory 32, and is configured to execute the computer program stored in the memory 32, so that the SQL operating platform executes the above online SQL method.
Preferably, the Processor 31 may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; the integrated Circuit may also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, or discrete hardware components.
It should be noted that the online SQL system of the present invention can implement the online SQL method of the present invention, but the implementation apparatus of the online SQL method of the present invention includes, but is not limited to, the structure of the online SQL system described in this embodiment, and all the structural modifications and substitutions in the prior art made according to the principles of the present invention are included in the scope of the present invention.
As shown in fig. 4, in an embodiment, the system of the online SQL of the present invention includes the SQL operating platform 41, inclusion 42, and the intelligent terminal 43.
The inclusion 42 is configured to receive the SQL statement sent by the SQL operating platform 41, and perform automatic review on the SQL statement.
The intelligent terminal 43 is configured to receive a manual review request sent by the SQL operating platform 41.
It should be noted that the smart terminal 43 in the present invention includes, but is not limited to, a smart phone, a tablet computer, and a PDA, and also includes other terminal devices having a data processing function. Generally, an intelligent terminal is a terminal device that has an independent operating system, can be used by a user to install programs provided by third-party service providers such as software and games, continuously expands the functions of a handheld device through the programs, and can realize wireless network access through a mobile communication network.
Further, the SQL operating platform 41 also supports functions of rolling back data display, timing tasks, and pt-osc (pt-osc is used to perform DDL operations), and may also be configured with MySQL query, MySQL query authority management, dynamic desensitization of MySQL query, and slow log management; the display of the rollback data refers to displaying a rollback statement on the SQL operating platform 41 and supporting one-key submission of a rollback work order; the timing task means that the SQL statements passing both the automatic examination and the manual examination can be selected by the DBA to be executed on line at regular time, and the execution time can be modified before execution and can also be terminated at any time; the pt-osc means that the SQL operating platform 41 supports pt-osc execution progress presentation, and can click to stop pt-osc process; MySQL query refers to automatic completion of libraries, tables and keywords, limitation of query result sets, derivation of query results, display of table structures and display of multiple result sets; the MySQL query authority management means that query statements are analyzed based on inclusion, the support of query authority is limited to a table level, and the query authority is applied, audited and managed, supports audit flow configuration and multi-level audits; the MySQL query dynamic desensitization refers to resolving a query statement based on inclusion, and realizing dynamic desensitization of sensitive data by matching desensitization field configuration and desensitization rules (regular expressions); the slow log management means that a pt _ query _ digest (pt _ query _ digest tool can be used for log analysis of slow queries of MySQL, analyzes and counts basic information of each slow query, such as response time, maximum execution time, minimum execution time, median of execution time and the like), analyzes and stores a slow log, and presents the slow log on a web (webpage) end, wherein the supercona-toolkit is a set of advanced MySQL management toolkits which can be used for executing various complex and troublesome MySQL and system tasks by hand.
In summary, according to the method, the system, the storage medium and the SQL operation platform for online SQL, the inclusion is adopted, the automatic auditing function is realized for the SQL statement before the SQL statement is online, and the comprehensiveness of the SQL statement auditing is improved by combining the manual auditing operation of the auditor on the SQL statement in the prior art, so that the auditing effect is ensured, and the auditing efficiency of the SQL statement is improved. Therefore, the invention effectively overcomes various defects in the prior art and has high industrial utilization value.
The foregoing embodiments are merely illustrative of the principles and utilities of the present invention and are not intended to limit the invention. Any person skilled in the art can modify or change the above-mentioned embodiments without departing from the spirit and scope of the present invention. Accordingly, it is intended that all equivalent modifications or changes which can be made by those skilled in the art without departing from the spirit and technical spirit of the present invention be covered by the claims of the present invention.
Claims (10)
1. A method for on-line SQL is applied to an SQL operation platform and is characterized by comprising the following steps:
sending SQL statements to the inclusion so that the inclusion can automatically check the SQL statements;
sending a manual review request to a reviewer so that the reviewer can perform manual review on the SQL statement;
and executing the SQL statement on line when the result of the automatic examination and the result of the manual examination both pass.
2. The method of on-line SQL according to claim 1, wherein executing the on-line SQL statement comprises the following two ways:
receiving the result of the automatic examination and the result of the manual examination, and executing the on-line SQL statement by the SQL operation platform when the result of the automatic examination and the result of the manual examination both pass;
and receiving the result of the automatic examination and sending the result to a database administrator, so that the database administrator controls the SQL operation platform to execute the online SQL statement when the result of the automatic examination and the result of the manual examination both pass.
3. The method of online SQL according to claim 2, wherein the SQL operating platform executes the online SQL statement further comprising: and remotely connecting with a database, and executing online data backup on the SQL statement.
4. The method of inline SQL as claimed in claim 1, further comprising: and when the result of the automatic examination is failed, modifying and backing up the SQL statement until the examination is passed.
5. The on-line SQL method according to claim 1, wherein the manual review request is sent to the reviewer by one or a combination of mail, SMS and intelligent terminal application message.
6. The utility model provides a system of online SQL, is applied to SQL operation platform, its characterized in that includes: the system comprises a first sending module, a second sending module and an execution online module;
the first sending module is used for sending an SQL statement to the inclusion so that the inclusion can automatically check the SQL statement;
the second sending module is used for sending a manual review request to a reviewer so that the reviewer can perform manual review on the SQL statement;
and the online execution module is used for executing the online SQL statement when the result of the automatic examination and the result of the manual examination both pass.
7. The system of on-line SQL according to claim 6, further comprising a data backup module, which is configured to remotely connect to a database and perform data backup of the on-line SQL statements.
8. A storage medium on which a computer program is stored, the program, when executed by a processor, implementing the method of inline SQL according to any one of claims 1 to 5.
9. An SQL operating platform comprising: a processor and a memory;
the memory is used for storing a computer program;
the processor is used for executing the computer program stored in the memory to enable the SQL operation platform to execute the online SQL method according to any one of claims 1 to 5.
10. A system of online SQL comprising the SQL operating platform, inclusion and the intelligent terminal of claim 9;
the inclusion is used for receiving the SQL sentences sent by the SQL operation platform and automatically auditing the SQL sentences;
and the intelligent terminal is used for receiving the manual examination request sent by the SQL operation platform.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910893887.4A CN110674161A (en) | 2019-09-20 | 2019-09-20 | Method, system, storage medium and SQL operation platform for online SQL |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910893887.4A CN110674161A (en) | 2019-09-20 | 2019-09-20 | Method, system, storage medium and SQL operation platform for online SQL |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110674161A true CN110674161A (en) | 2020-01-10 |
Family
ID=69077057
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910893887.4A Pending CN110674161A (en) | 2019-09-20 | 2019-09-20 | Method, system, storage medium and SQL operation platform for online SQL |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110674161A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111078675A (en) * | 2020-03-23 | 2020-04-28 | 绿漫科技有限公司 | Multidimensional comprehensive database SQL (structured query language) auditing and optimizing method and system |
| CN111915275A (en) * | 2020-07-31 | 2020-11-10 | 上海燕汐软件信息科技有限公司 | Application operation process management method, device and system |
| CN112099806A (en) * | 2020-11-05 | 2020-12-18 | 四川新网银行股份有限公司 | CICD-based sql automatic auditing online and executing method |
| CN113111066A (en) * | 2021-04-20 | 2021-07-13 | 长沙市到家悠享网络科技有限公司 | Automatic online method, device and system for database operation work order and computer equipment |
| CN113190408A (en) * | 2021-05-07 | 2021-07-30 | 北京金融资产交易所有限公司 | Data operation and maintenance system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108415991A (en) * | 2018-02-12 | 2018-08-17 | 广州市贝聊信息科技有限公司 | A kind of SQL checking methods and system |
| CN108876283A (en) * | 2018-04-27 | 2018-11-23 | 淘然视界(杭州)科技有限公司 | A kind of automatic auditing system and method |
| CN109284282A (en) * | 2018-10-22 | 2019-01-29 | 北京极数云舟科技有限公司 | One kind being based on MySQL database O&M method and system |
-
2019
- 2019-09-20 CN CN201910893887.4A patent/CN110674161A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108415991A (en) * | 2018-02-12 | 2018-08-17 | 广州市贝聊信息科技有限公司 | A kind of SQL checking methods and system |
| CN108876283A (en) * | 2018-04-27 | 2018-11-23 | 淘然视界(杭州)科技有限公司 | A kind of automatic auditing system and method |
| CN109284282A (en) * | 2018-10-22 | 2019-01-29 | 北京极数云舟科技有限公司 | One kind being based on MySQL database O&M method and system |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111078675A (en) * | 2020-03-23 | 2020-04-28 | 绿漫科技有限公司 | Multidimensional comprehensive database SQL (structured query language) auditing and optimizing method and system |
| CN111915275A (en) * | 2020-07-31 | 2020-11-10 | 上海燕汐软件信息科技有限公司 | Application operation process management method, device and system |
| CN112099806A (en) * | 2020-11-05 | 2020-12-18 | 四川新网银行股份有限公司 | CICD-based sql automatic auditing online and executing method |
| CN113111066A (en) * | 2021-04-20 | 2021-07-13 | 长沙市到家悠享网络科技有限公司 | Automatic online method, device and system for database operation work order and computer equipment |
| CN113190408A (en) * | 2021-05-07 | 2021-07-30 | 北京金融资产交易所有限公司 | Data operation and maintenance system |
| CN113190408B (en) * | 2021-05-07 | 2024-03-26 | 北京金融资产交易所有限公司 | Data operation and maintenance system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110674161A (en) | Method, system, storage medium and SQL operation platform for online SQL | |
| US8386419B2 (en) | Data extraction and testing method and system | |
| US8972460B2 (en) | Data model optimization using multi-level entity dependencies | |
| Aboutorabiª et al. | Performance evaluation of SQL and MongoDB databases for big e-commerce data | |
| CN110795257A (en) | Method, device and equipment for processing multi-cluster operation records and storage medium | |
| US20210256079A1 (en) | Adapting database queries for data virtualization over combined database stores | |
| US11487742B2 (en) | Consistency checks between database systems | |
| CN110427188B (en) | Configuration method, device, equipment and storage medium of single-test assertion program | |
| CN107153609B (en) | Automatic testing method and device | |
| US20070174329A1 (en) | Presenting a reason why a secondary data structure associated with a database needs rebuilding | |
| US11238025B2 (en) | Data repair within productive system | |
| US10838947B2 (en) | Consistency check for foreign key definition | |
| CN113986766A (en) | Automatic testing method and device | |
| CN111367699B (en) | Method, system, device and medium for processing error information | |
| CN113886205A (en) | Database performance bottleneck positioning analysis method, device and system and storage medium | |
| US10635573B2 (en) | Auto-generated multiple input variants | |
| CN113779117A (en) | Data monitoring method and device, storage medium and electronic equipment | |
| US11782916B2 (en) | Autonomous testing of logical model inconsistencies | |
| CN111723104A (en) | Method, device and system for syntax analysis in data processing system | |
| US11704094B2 (en) | Data integrity analysis tool | |
| US20230342286A1 (en) | Codeless automatic testing framework | |
| CN112948181A (en) | Data modification backup recovery system | |
| US9600505B2 (en) | Code optimization based on customer logs | |
| CN117033410A (en) | Method and system for managing blood relationship of data | |
| de Castro et al. | An Approach to Perform Automated Functional Testing in Database-Driven Applications. |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200110 |