CN109284282A - One kind being based on MySQL database O&M method and system - Google Patents
One kind being based on MySQL database O&M method and system Download PDFInfo
- Publication number
- CN109284282A CN109284282A CN201811230149.3A CN201811230149A CN109284282A CN 109284282 A CN109284282 A CN 109284282A CN 201811230149 A CN201811230149 A CN 201811230149A CN 109284282 A CN109284282 A CN 109284282A
- Authority
- CN
- China
- Prior art keywords
- sql statement
- rule
- unit
- pending
- audit
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of based on MySQL database O&M method and system, which comprises determines pending SQL statement;It audits the pending SQL statement and caches;Judge whether SQL statement needs to be implemented, if otherwise returning to the auditing result of the SQL statement of the audit in the form of result set;If SQL statement needs to be implemented, the SQL statement that audit passes through is executed one by one, while the implementing result for executing the SQL statement of mistake being returned in the form of result set.The application passes through the rule preestablished and audits to pending SQL statement, standardize and SQL statement and filters the very big SQL statement of risk, MySQL itself is realized to functions such as the audit of SQL statement, execution, backup, rollbacks, the problem of exchanging SQL statement with developer without DBA investment energy, modification and normalization, the working efficiency for increasing DBA improves the O&M efficiency of database.
Description
Technical field
The present invention relates to database technical fields, are based on MySQL database O&M method and system more particularly to one kind.
Background technique
In the work of database, MySQL database with its open source, it is free, powerful the features such as attracted increasingly
More companies, which are added, to be used, and following each company needs more data base administrator DBA to be responsible for the fortune of MySQL database
Tie up work.DBA is needed when being audited to SQL (Structured Query Language, structured query language) sentence
The problem of energy exchanges SQL statement with developer, modification and normalization are put into, reduces the working efficiency of DBA, and then drop
The low O&M efficiency of database.Meanwhile larger economic loss, existing SQL would generally be brought after the execution of SQL problem sentence
Audit and execution system cannot efficiently cancel execution, and economic loss is preferably minimized within the shortest time.
Therefore, the audit of SQL statement, execution, backup, rollback how to be carried out effectively to improve the efficiency of database O&M
The technical issues of being those skilled in the art's current urgent need to resolve.
Summary of the invention
In view of this, the present invention, which provides one kind, is based on MySQL database O&M method and system, it can be by MySQL certainly
Body realizes the functions such as audit, execution, backup, rollback to SQL statement, and DBA is solved from the work of audit SQL completely and is released
Come, to greatly improve the working efficiency of DBA and the O&M efficiency of database.
In a first aspect, providing a kind of based on MySQL database O&M method, which comprises
Determine pending SQL statement;
It audits the pending SQL statement and caches;
Judge whether pending SQL statement audits completion, if then judging whether SQL statement needs to be implemented, if otherwise will
The auditing result of the SQL statement of the audit is returned in the form of result set;
If SQL statement needs to be implemented, judge whether SQL statement is audited and pass through, if otherwise by the audit of the SQL statement
As a result it is returned in the form of result set;If then executing the SQL statement that audit passes through one by one;
Whether the SQL statement execution for judging that audit passes through malfunctions, if then judging whether to skip the SQL language for executing mistake
Sentence, if then continuing to execute next SQL statement, finishes until all SQL statements are performed both by, if it is not, then executing mistake for described
The implementing result of SQL statement accidentally is returned in the form of result set.
With reference to first aspect and its above-mentioned implementation, in the first possible implementation of the first aspect, described
If SQL statement needs to be implemented, judge whether SQL statement is audited and pass through, if otherwise by it is described do not audit the SQL statement that passes through with
The form of result set returns;If then executing the SQL statement that audit passes through one by one, further includes:
It obtains thread_id information and every SQL statement executes the binlog location information of front and back.
With reference to first aspect and its above-mentioned implementation, in the second possible implementation of the first aspect, described
Method further include:
Judge whether SQL statement needs to back up, if otherwise the implementing result of SQL statement is returned in the form of result set,
It is that the binlog location information that will acquire is filtered, obtains the binlog location information for currently executing sentence;
The current binlog location information for executing sentence is extracted, and parses the binlog location information, obtains institute
The corresponding rollback sentence of current execution sentence is stated, backup rollback is carried out;
Judge whether the backup is completed, if it is not, then continuing successively to execute filtering, backup rollback, until backup is completed.
With reference to first aspect, in a third possible implementation of the first aspect, the audit pending SQL
Sentence simultaneously caches, comprising:
Syntactic analysis is carried out one by one to the pending SQL statement according to preset syntax rule;
If the pending SQL statement does not meet the preset syntax rule, reporting an error and caching is unsatisfactory for default grammer
The SQL statement of rule;
Judge whether the syntactic analysis is completed, if so, according to preset semantic analysis rule to the SQL statement by
One carries out semantic analysis;
If the pending SQL statement does not meet the preset semantic analysis rule, report an error and cache be unsatisfactory for it is pre-
If the SQL statement of semantic analysis rule;
Judge whether the semantic analysis is completed, if so, according to preset filtering check rule to the SQL statement into
Line discipline filtering;
If the pending SQL statement does not meet the preset filtering and checks rule, report an error and cache be unsatisfactory for it is pre-
If filtering checks the SQL statement of rule.
With reference to first aspect and its above-mentioned implementation, in a fourth possible implementation of the first aspect, described
It determines pending SQL statement, the pending SQL statement is audited and cached, further includes:
By it is described deposit be unsatisfactory for the SQL statement of default syntax rule, the SQL statement that is unsatisfactory for default semantic analysis rule,
It is unsatisfactory for default filtering and checks that the SQL statement of rule is returned in a manner of result set.
Second aspect provides a kind of based on MySQL database operational system, comprising:
Determination unit, the determination unit is for determining pending SQL statement;
Unit is audited, the audit unit is for being audited and being cached to the pending SQL statement;
First judging unit, first judging unit is for judging whether pending SQL statement audits completion, if then
Judge whether SQL statement needs to be implemented, if otherwise returning the auditing result of the SQL statement of the audit in the form of result set
It returns;
Whether second judgment unit judges SQL statement if the second judgment unit is needed to be implemented for SQL statement
Audit passes through, if otherwise returning to the auditing result of the SQL statement in the form of result set;If it is logical then to execute audit one by one
The SQL statement crossed;
Whether third judging unit, the SQL statement execution that the third judging unit is used to judge that audit to pass through malfunction, if
It is to judge whether to skip the SQL statement for executing mistake, if next SQL statement is then continued to execute, until all SQL statements
It is performed both by and finishes, if it is not, then returning to the implementing result of the SQL statement for executing mistake in the form of result set.
In conjunction with second aspect, in the first possible implementation of the second aspect, the system also includes:
Acquiring unit, the acquiring unit is used to obtain thread_id information and every SQL statement executes front and back
Binlog location information.
In conjunction with second aspect, in a second possible implementation of the second aspect, the system also includes:
Second judgment unit, the backup judging unit is for judging whether SQL statement needs to back up, if otherwise by SQL
The implementing result of sentence is returned in the form of result set, is, the binlog location information that will acquire is filtered, and is obtained current
Execute the binlog location information of sentence;
Backup rollback unit, the backup rollback unit are used to extract the current position the binlog letter for executing sentence
Breath, and the binlog location information is parsed, the corresponding rollback sentence of the current execution sentence is obtained, backup rollback is carried out;
The second judgment unit is also used to judge whether the backup is completed, if it is not, then continuing successively to execute filtering, standby
Part rollback, until backup is completed.
It is in the third possible implementation of the second aspect, described in conjunction with second aspect and its above-mentioned implementation
Audit unit specifically includes:
Parsing unit, the parsing unit are used for according to preset syntax rule to the pending SQL language
Sentence carries out syntactic analysis one by one;
First cache unit, if first cache unit for the pending SQL statement do not meet it is described preset
Syntax rule reports an error and caches the SQL statement for being unsatisfactory for default syntax rule;
Semantic analysis unit, the semantic analysis unit for judging whether the syntactic analysis is completed, if so, according to
Preset semantic analysis rule carries out semantic analysis to the SQL statement one by one;
Second cache unit, if second cache unit for the pending SQL statement do not meet it is described preset
Semantic analysis rule then reports an error and caches the SQL statement for being unsatisfactory for default semantic analysis rule;
Rule-based filtering unit, the rule-based filtering unit for judging whether the semantic analysis is completed, if so, according to
Preset filtering checks that rule carries out rule-based filtering to the SQL statement;
Third cache unit, if the third cache unit for the pending SQL statement do not meet it is described preset
Filtering checks rule, then reporting an error and caching is unsatisfactory for the SQL statement that default filtering checks rule.
It is in the fourth possible implementation of the second aspect, described in conjunction with second aspect and its above-mentioned implementation
Audit unit further include:
Display unit, the display unit be used for by it is described deposit be unsatisfactory for the SQL statement of default syntax rule, be unsatisfactory for it is pre-
If the SQL statement of semantic analysis rule, the SQL statement for being unsatisfactory for default filtering inspection rule are returned in a manner of result set.
The third aspect provides a kind of controlled terminal, comprising:
Processor, memory, wherein
The receiver is used for processor controlled reception signal,
The transmitter is used for processor controlled transmission signal,
The memory is for storing computer program, and the processor from memory for calling and running the computer journey
Sequence, so that the method that terminal device executes above-mentioned terminal device.
Fourth aspect provides a kind of computer storage medium, instruction is stored in the computer readable storage medium,
When run on a computer, so that computer executes method described in above-mentioned various aspects.
5th aspect, provides a kind of computer program product comprising instruction, when run on a computer, so that
Computer executes method described in above-mentioned various aspects.
Therefore, the application pass through preestablish rule to pending SQL statement carry out syntactic analysis, semantic analysis,
Filtering checks, standardizes and SQL statement and filters the very big SQL statement of risk, MySQL itself realize audit to SQL statement,
The functions such as execution, backup, rollback put into the problem of energy exchanges SQL statement with developer, modification and normalization without DBA,
The working efficiency for increasing DBA improves the O&M efficiency of database.
Detailed description of the invention
Attached drawing for a better understanding of the present invention, does not constitute an undue limitation on the present invention.Wherein:
Fig. 1 is the schematic flow chart based on MySQL database O&M method of the application one embodiment;
Fig. 2 is the schematic flow chart based on MySQL database O&M method of another embodiment of the application;
Fig. 3 is the illustrative logical block diagram based on MySQL database O&M method of the application one embodiment;
Fig. 4 is the schematic flow chart of the method for the application another embodiment;
Fig. 5 is the schematic block diagram based on MySQL database operational system of the application one embodiment;
Fig. 6 is the schematic block diagram based on MySQL database operational system of another embodiment of the application;
Fig. 7 is the schematic block diagram based on MySQL database operational system of another embodiment of the application;
Fig. 8 is a kind of structural schematic diagram of controlled terminal of the application one embodiment.
Specific embodiment
Technical solution in order to enable those skilled in the art to better understand the present invention, below in conjunction with of the invention real
The attached drawing in example is applied, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described implementation
Example is only a part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, this field is common
Technical staff's every other embodiment obtained without making creative work, all should belong to protection of the present invention
Range.
It should be understood that the first, second of described in the text is intended merely to refer to and distinguish different signals, instruction etc., wherein the
One, the second restriction without sequencing.
Fig. 1 shows the schematic flow chart based on MySQL database O&M method of the application one embodiment.Its
In, Fig. 1 executing subject can be based on MySQL database operational system to be a kind of.
As shown in Figure 1, this method 100 includes:
Step 110, pending SQL statement is determined;
Step 120, it audits the pending SQL statement and caches;
Step 130, judge whether pending SQL statement audits completion, if then judging whether SQL statement needs to be implemented,
If otherwise the auditing result of the SQL statement of the audit is returned in the form of result set;
Step 140, if SQL statement needs to be implemented, judge whether SQL statement is audited and pass through, if otherwise by the SQL language
The auditing result of sentence is returned in the form of result set;If then executing the SQL statement that audit passes through one by one;
Step 150, whether the SQL statement execution for judging that audit passes through malfunctions, if then judging whether to skip execution mistake
SQL statement finished if then continuing to execute next SQL statement until all SQL statements are performed both by, if it is not, then will be described
The implementing result for executing the SQL statement of mistake is returned in the form of result set.
During specific implementation:
Step 110, determine that the SQL statement in pending database, the pending SQL statement include a plurality of SQL
Sentence, for a plurality of SQL statement, the SQL statement for needing to audit or execute is write in a manner of annotation up front with semicolon separated
Bright audit executes address, while the user name password of specified connection database, such as: (-- port=3306;-- user=
user;-- password=password;*/sql1;sql2;sql3;), auditing wrong SQL statement can be with intelligent recognition.
Step 120, the pending SQL statement is audited, i.e. DBA defines default auditing rule, examines according to preset rules
Core SQL statement, the SQL statement for cache and the audit fails for every SQL statement auditing result reports an error, for advising
Generalized SQL statement.
Step 130, judge whether pending SQL statement audits completion, continue to audit if not auditing completion, if audit
Completion then judges whether SQL statement needs to be implemented, by the auditing result of the SQL statement of the caching to tie if not needing to execute
The form of fruit collection returns, and the SQL statement of the appearance mistake of caching is also disposably fed back.
Step 140, if SQL statement needs to be implemented, judge whether SQL statement is audited and pass through, it will if if not auditing
The auditing result of the SQL statement of the caching is returned in the form of result set, and it is disposable anti-not audit the SQL statement passed through yet
Feedback;If auditing if, the SQL statement passed through is audited in execution one by one.Into after the execution stage, system can be as a client
End is connected to database on line and goes to execute SQL statement.
Step 150, whether the SQL statement execution for judging that audit passes through malfunctions, in implementation procedure, if error, needs
Judging whether to skip the SQL statement for executing mistake i.e. -- enable-force option skips option if executing, skips this
Item executes next SQL statement, and default executes interruption, successively executes, finish until all SQL statements are performed both by, if not skipping
It executes, then returns to the implementing result of the SQL statement in the form of result set, the SQL statement for executing appearance mistake is also primary
Property feedback.
Optionally, as the application one embodiment, the step 140, further includes:
It obtains thread_id information and every SQL statement executes the binlog location information of front and back.
During specific implementation:
The execution stage need to obtain the thread_id information of SQL statement, implementation procedure beginning binlog location information and
Terminate binlog location information and every target SQL statement executes the binlog location information of front and back, primarily to
Filtering is done when generating rollback sentence below to use.In this way in subsequent backed up, only backup it can start binlog location information
And the implementation procedure terminated between binlog location information can be according to the current execution sentence in subsequent progress rollback
Execution before and after binlog location information rollback go out corresponding rollback sentence.
Therefore, the embodiment of the present application can carry out syntactic analysis, language to pending SQL statement by the rule preestablished
Justice analysis, filtering check, standardizes and SQL statement and filters the very big SQL statement of risk, MySQL itself is realized to SQL statement
The functions such as audit, execution, the problem of exchanging SQL statement with developer without DBA investment energy, modification and normalization, increasing
The working efficiency for having added DBA improves the O&M efficiency of database.
Fig. 2 shows the schematic flow charts based on MySQL database O&M method of another embodiment of the application.
As shown in Fig. 2, this method 200 further include:
Step 210, judge whether SQL statement needs to back up, if otherwise by the implementing result of SQL statement with the shape of result set
Formula returns, and is that the binlog location information that will acquire is filtered, and obtains the binlog location information for currently executing sentence;
Step 220, the current binlog location information for executing sentence is extracted, and parses the position the binlog letter
Breath, obtains the corresponding rollback sentence of the current execution sentence, carries out backup rollback;
Step 230, judge whether the backup is completed, if it is not, then continuing successively to execute filtering, backup rollback, Zhi Daobei
Part is completed.
During specific implementation:
SQL statement execute after the completion of needs to judge whether to need to back up, if without if directly by current implementing result with
The mode of result set returns, and if necessary to back up, enters backup phase, according to the position binlog got above and
Thread_id filters the position binlog obtained from line, gets the position binlog for belonging to current statement generation, so
Afterwards according to data therein, corresponding rollback sentence is risked in turn.Then after backup is completed, whole operation is completed,
So whole process is all returned in a manner of result set again at this time.
Fig. 3 shows the logic diagram of the method for the application one embodiment, should be had based on MySQL database O&M method
Body includes the following steps:
Determine pending SQL statement;
It audits the pending SQL statement and caches;
Judge whether pending SQL statement audits completion, if then judging whether SQL statement needs to be implemented, if otherwise will
The auditing result of the SQL statement of the audit is returned in the form of result set;
If SQL statement needs to be implemented, judge whether SQL statement is audited and pass through, if otherwise by the audit of the SQL statement
As a result it is returned in the form of result set;If then executing the SQL statement that audit passes through one by one;
Whether the SQL statement execution for judging that audit passes through malfunctions, if then judging whether to skip the SQL language for executing mistake
Sentence, if then continuing to execute next SQL statement, finishes until all SQL statements are performed both by, if it is not, then executing mistake for described
The implementing result of SQL statement accidentally is returned in the form of result set;
Judge whether SQL statement needs to back up, if otherwise the implementing result of SQL statement is returned in the form of result set,
It is that the binlog location information that will acquire is filtered, obtains the binlog location information for currently executing sentence;
The current binlog location information for executing sentence is extracted, and parses the binlog location information, obtains institute
The corresponding rollback sentence of current execution sentence is stated, backup rollback is carried out;
Judge whether the backup is completed, if it is not, then continue successively to execute filtering, backup rollback, it, will until backup completion
Backup.
During specific implementation, by the transformation to MySQL code, retain a frame of former MySQL server,
Our completely new demands presented above are realized on this basic framework.
Agreement: agreement retains original format in the application, and the agreement of support is the primary agreement of MySQL, directly uses
MySQL interface can be completed, while the interface function that it has been supported is fairly perfect, support ratio for the agreement of various language
It is more complete.When exploitation needs to audit, it is only necessary to by the sentence for needing to audit or execute with semicolon separated, up front with annotation
Mode is write exactly will be in what address audit, execution, while specifying the user name password of connection database, of the present invention in this way
System can be very intelligent disposably point out the inside existing for whole issue.Such as :/* -- host=
127.0.0.1;-- port=3306;-- user=user;-- password=password;*/sql1;sql2;sql3.?
In agreement of the present invention, plus annotation before the sentence that audit or execute, to allow system of the present invention to know
Any operation is specifically done, this is to present system provides some interfaces of some external definitions, except described above four in fact
It further include some other option except a option, specifically: -- enable-check, for indicating that this is used only to audit,
It does not need to execute;-- enable-execute, the statement block for indicating current needs first to audit to be executed again;--enable-
Force, this is used to indicate, in the process of implementation, if mistake occurs in certain SQL execution, just skips this sentence, continues to execute
Subsequent sentence is defaulted as executing interruption;-- enable-remote-backup, this is used to indicate after executing completion,
Rollback sentence whether is backed up and generate, default is to open.
Audit: including grammer, semantic analysis, these stages of rule-based filtering.In audit, we introduce logical for the first time
Syntactic analysis is crossed to realize, and the syntax rule perfection of syntax rule and MySQL are compatible, the accuracy of audit is very high.Together
When some new rules are added, prevented some known appearance with the very SQL statement of high risk completely, while not seeing you again
There are some lower level errors, leading to DBA will also spend the additional time to handle, and DBA working efficiency and accuracy is greatly improved.?
After syntactic analysis is completed, into syntactic analysis, the semantic analysis stage is mainly to analyse whether that there are some in logic obvious
The problem of, if there is a problem it will report an error and cache, further include whether the object being related in some SQL statements exists
When doing semantic analysis, any database object needed to use, then requires connect to database server on line for problem, if needed
Database server on line is then connected to fetch object structure in local comparison, then by simple show order
Whether determination meets rule, does not meet, reports an error and cache.Semantic analysis is completed and then on the basis of grammatical and semantic analysis
On, rule-based filtering inspection is done, this is primarily used to do sentence standardization, because having there is the result of syntactic analysis,
It include the information that all these sentences are related in this result, then whether meeting rule to sentence inspection on this basis
Then, it is very easy to, and scalability is very good, after check, if not meeting the specification of our definition, reports an error and delay
It deposits, these specifications are defined by our DBA, are done for standardizing SQL statement.The institute referred here to is wrong,
It is all first first to be cached for every SQL statement, finally after completing all sentences, one by way of result set
It rises and returns.
It executes: on the basis of audit passes through above, because all SQL statements are all buffered, to execution rank
Section successively executes each sentence.The system of present invention is just used as the client of database on line to be connected to number on line at this time
According to library, sentence is then executed.If necessary to back up, then the position of database binlog and current is got on line before execution
The thread_id information of connection requires connect on line to fetch and, and it is also directly logical by being connected on line for executing operation itself
MySQL interface is crossed to execute corresponding SQL statement, also takes the position of binlog on primary line after execution, this will be with later
Backup in rollback.
Backup: needing the position binlog got according to front and thread_id to obtain binlog, this operation is
It needs to obtain from aol server, the role of this system is equivalent to one of aol server from library at this time.It is achieved in that
A remote back-up server is configured in system described in the present invention, in the case where doing execution operation and selecting backup, this
System can be automatically by above the relevant information back-up to remote back-up server of all SQL of this execution, these information include:
Every SQL statement executes the position binlog of front and back, and the database of operation, the database address of operation, rollback serial number is (below
Rollback part can use) etc..But database server is multiple on line, backup server only one, then between them
Corresponding relationship be it is corresponding by library, the library name in the corresponding backup server in a library on line is according to library address on line
IP plus port along with library name composition, so between library or one-to-one relationship.
Rollback: being a critically important part, relate to some very risky sentences or execute mistake after, how
, there is this function in the problem of processing, so that it may which the direct rollback in second grade avoids the occurrence of economic loss.Rollback includes DML language
The rollback of sentence and the rollback of DDL sentence, for the rollback of DML, because above in backup phase, it is known that every sentence is held
The position binlog of row correspondence and thread_id, then after executing completion, it, will be corresponding for every SQL statement
One's own binlog, which is fetched, to be come, because being inserted into, delete, updating the binlog that operation generates all includes required for our rollbacks
Data, then for insertion sentence, parse binlog, generate a DELETE sentence;For delete operation, generates one and insert
Enter sentence;For sentence is updated, an anti-update sentence is generated, the purpose of rollback is thus indirectly realized.All behaviour
Make rollback directly can just generate the rollback sentence for being performed SQL statement after executing completion in second grade, if
Rollback is needed, then directly takes out execution.But for updating or deleting, a usual SQL statement is possible to influence one
Data more than row, then the rollback sentence generated is exactly multiple, because a rollback sentence is just for a line, because this
In there is a problem to be noted that before execution to have to for binlog_format to be revised as row mode, could generate in this way
The binlog of row format, so that just can therefrom extract data generates rollback sentence.
Echo plex mode: there are what problem, especially audit part in audit or implementation procedure, there is what mistake to have to
It quotes and, exploitation could be allowed further to modify, meet specification, then needing exist for a very friendly, tractable mode
Solve this problem.The application for the first time put forward with result mode set by auditing result quote come, use this scheme
Benefit has very much, comprising: has had the MySQL interface of many maturations to can be convenient processing MySQL result set, so not needing this
System does extra work again supports the processing of result set;More contents can be accommodated, many auditing systems before, often
Secondary audit can only return to a mistake, very unfriendly, and the present invention can be disposably by all the problem of not meeting specification to tie
The mode of fruit collection returns, and it is very clear thus to accomplish, knows what's what, and then can disposably modify all problems
It is good, working efficiency is greatly improved.
As a result set content: all auditing results have been said above, have all been to be returned with MySQL result set, it includes following
Column: ID (serial number locating for single sentence in SQL block), mistake classification (influence execute sentence grade be 2, do not influence to hold
Row but the grade for not being inconsistent sentence normally are 1, absolutely not the grade of the sentence of problem be 0), error message (single sentence
The all problems or mistake occurred in audit are stored in this column), current SQL statement, influence line number (before execution
Be expected impact line number, be actual influence line number after execution, it is critically important that this audits a sentence to us), execute serial number (this
It should be mentioned that a value when a and backup above, for finding corresponding rollback sentence from backup table when rollback).Institute
After the operations such as some audits, execution, backup are completed, return information is returned in a manner of result set, incumbent out wherein
What mistake or problem, disposably can all return, very clear, and working efficiency is greatly improved.
Change table online: in MySQL system, to the DDL of big table operate the influence to database be it is very big, generally require
Table is locked, table is bigger, and the time of lock is longer, and during this period of time, whole table cannot be all accessed.In this application, in order to
Full automatic O&M executes to be operated on line, and the improvement done is mainly that one is first created on implementation by object table structural modification
Then the swap table of structure later creates three triggers again, be the trigger that additions and deletions change three kinds of events respectively, they are moved
It is respectively: when being inserted into new data, new data is just also inserted into swap table to portion, when more new data, are also updated
The corresponding data of swap table when deleting data, just execute primary in swap table simultaneously if there is no being ignored as
It is same to delete, there are these three triggers, so that it may by being carried from former table into swap table for data a part a part,
Because these three triggers can guarantee during changing table, all modifications to old table can all reflect above swap, then when
After having removed, the name of the two tables is exchanged, just completes the operation of entire modification table, and only this exchanges name
When just need very of short duration one following table of lock, do a little cleaning operations later, for example delete old table, trigger etc., it is thus complete
At table handling is changed online, will not occur the case where long-time lock table again.It supports to change table handling online, this system can be directly right
Big table on line executes the modification operation for not locking table, to avoid the generation of some failures, or from there on, changes table handling again
It does not need to midnight to do yet.
Fig. 4 shows the schematic flow chart based on MySQL database O&M method of another embodiment of the application.
As shown in figure 4, described audit the pending SQL statement and cache, specifically include:
Step 410, syntactic analysis is carried out one by one to the pending SQL statement according to preset syntax rule;
Step 420, if the pending SQL statement does not meet the preset syntax rule, reporting an error and caching is unsatisfactory for
The SQL statement of default syntax rule;
Step 430, judge whether the syntactic analysis is completed, if so, according to preset semantic analysis rule to described
SQL statement carries out semantic analysis one by one;
Step 440, it if the pending SQL statement does not meet the preset semantic analysis rule, reports an error and caches
It is unsatisfactory for the SQL statement of default semantic analysis rule;
Step 450, judge whether the semantic analysis is completed, if so, checking rule to described according to preset filtering
SQL statement carries out rule-based filtering;
Step 460, it if the pending SQL statement does not meet the preset filtering and checks rule, reports an error and caches
It is unsatisfactory for the SQL statement that default filtering checks rule.
During specific implementation, audit includes syntactic analysis, semantic analysis, these stages of rule-based filtering, is being examined
In core, preset syntax rule is set first, is judged one by one according to preset syntax rule and the syntax rule of MySQL pending
Whether SQL statement meets syntactic analysis, if so, the next SQL statement is judged, if it is not, then reporting an error and described will be discontented with
The SQL statement and corresponding error reason of the preset syntax rule of foot are cached, and the SQL statement is prompted to have grammer wrong
Accidentally, it and reports the reason of the SQL statement mistake, subsequent analysis modification is carried out to the SQL statement to report an error to facilitate.Judgement
Whether all SQL statements are completed syntactic analysis, if it is not, then continuing syntactic analysis, if so, to the target
SQL statement carries out semantic analysis.Judge whether SQL statement meets semantic rules one by one, if so, judging the next SQL
Sentence, if it is not, then reporting an error and delaying the SQL statement for being unsatisfactory for preset semantic rules and corresponding error reason
It deposits, prompts the SQL statement that there is semantic error, and report the reason of the SQL statement mistake.Judging the semantic analysis is
No completion, if so, checking that rule carries out rule-based filtering to the SQL statement according to preset filtering;One by one judgement it is described to
Whether audit SQL statement, which meets the preset filtering, checks rule, checks if otherwise reporting an error and caching to be unsatisfactory for presetting filtering
The SQL statement of rule.
The syntactic analysis identifies what meaning of SQL statement, passes through the syntax rule of preset syntax rule and MySQL
Perfection is compatible, determines whether SQL statement meets rule, does not meet, and reporting an error and caching, the accuracy of audit is very high, adds simultaneously
Enter some new syntax rules, after carrying out syntactic analysis by the new syntax rule of these preset syntax rules and setting,
Prevent the known appearance with the very SQL statement of high risk completely, while no longer will appear some lower level errors, leads to DBA
It also to spend the additional time to handle, DBA working efficiency and accuracy is greatly improved.Enter semanteme after syntactic analysis completion
Analysis phase.
The semantic analysis is that the object for be related in logic analysis and SQL statement to SQL statement is analyzed.Language
Justice analysis, which carries out the i.e. analysis SQL statement of logic analysis to SQL statement, whether there is some obvious problems in logic, if deposited
In problem, then report an error.Semantic analysis is analyzed the object being related in SQL statement and is analyzed involved in some SQL statements
To object whether exist the problems such as, if it is desired, be then connected on line database server and fetch object to come, comparison,
Then whether determination meets rule, does not meet, reports an error.
The rule-based filtering inspection, this is primarily used to do sentence standardization, because having there is syntactic analysis
As a result, in this result include information that all these sentences are related to, then being to sentence inspection on this basis
Meet filtering rule, do not meet, report an error and caches.
The institute referred here to is wrong, is all first first to be cached for every SQL statement, finally completes to own
Sentence after, returned together by way of result set.
It is optionally, described to audit the pending SQL statement and cache as the application one embodiment, further includes:
By it is described deposit be unsatisfactory for the SQL statement of default syntax rule, the SQL statement that is unsatisfactory for default semantic analysis rule,
It is unsatisfactory for default filtering and checks that the SQL statement of rule is returned in a manner of result set.
Fig. 5 shows the schematic block diagram based on MySQL database operational system of the application one embodiment.
As shown in figure 5, the system 500 includes:
Determination unit 510, the determination unit 510 is for determining pending SQL statement;
Unit 520 is audited, the audit unit 520 is for being audited and being cached to the pending SQL statement;
First judging unit 530, first judging unit 530 for judging whether pending SQL statement audits completion,
If then judging whether SQL statement needs to be implemented, if otherwise by the auditing result of the SQL statement of the audit with the shape of result set
Formula returns;
Second judgment unit 540 judges SQL language if the second judgment unit 540 is needed to be implemented for SQL statement
Whether sentence, which is audited, passes through, if otherwise returning to the auditing result of the SQL statement in the form of result set;If then executing one by one
Audit the SQL statement passed through;
Third judging unit 550, the third judging unit 550 is for judging whether audit the SQL statement passed through execution
Error, if then judging whether to skip the SQL statement for executing mistake, if then continuing to execute next SQL statement, until all
SQL statement, which is performed both by, to be finished, if it is not, then returning to the implementing result of the SQL statement for executing mistake in the form of result set.
Optionally, as the application one embodiment, above system 500 further include:
Acquiring unit, the acquiring unit is used to obtain thread_id information and every SQL statement executes front and back
Binlog location information.
Fig. 6 shows the schematic block diagram based on MySQL database operational system of another embodiment of the application.
As shown in fig. 6, the system 600 further include:
4th judging unit 610, the 4th judging unit 610 is for judging whether SQL statement needs to back up, if otherwise
The implementing result of SQL statement is returned in the form of result set, is that the binlog location information that will acquire is filtered, obtains
The current binlog location information for executing sentence;
Backup rollback unit 620, the backup rollback unit 620 are used to extract the current position binlog for executing sentence
Confidence breath, and the binlog location information is parsed, the corresponding rollback sentence of the current execution sentence is obtained, is backed up back
Rolling;
5th judging unit 630, the 5th judging unit 630 for judge it is described backup whether complete, if it is not, then after
It is continuous successively to execute filtering, backup rollback, until backup is completed.
Fig. 7 shows the schematic block diagram based on MySQL database operational system of another embodiment of the application.
As shown in fig. 7, the audit unit of the system 700 specifically includes:
Parsing unit 710, the parsing unit 710 are used for according to preset syntax rule to described pending
SQL statement carries out syntactic analysis one by one;
First cache unit 720, if first cache unit 720 do not met for the pending SQL statement it is described
Preset syntax rule reports an error and caches the SQL statement for being unsatisfactory for default syntax rule;
Semantic analysis unit 730, the semantic analysis unit 730 for judging whether the syntactic analysis is completed, if so,
Semantic analysis is then carried out one by one to the SQL statement according to preset semantic analysis rule;
Second cache unit 740, if second cache unit 740 do not met for the pending SQL statement it is described
Preset semantic analysis rule, then report an error and cache the SQL statement for being unsatisfactory for default semantic analysis rule;
Rule-based filtering unit 750, the rule-based filtering unit 750 for judging whether the semantic analysis is completed, if so,
Then check that rule carries out rule-based filtering to the SQL statement according to preset filtering;
Third cache unit 760, if the third cache unit 760 do not met for the pending SQL statement it is described
Preset filtering checks rule, then reporting an error and caching is unsatisfactory for the SQL statement that default filtering checks rule.
Optionally, as the application one embodiment, the audit unit 520 further include:
Display unit, the display unit be used for by it is described deposit be unsatisfactory for the SQL statement of default syntax rule, be unsatisfactory for it is pre-
If the SQL statement of semantic analysis rule, the SQL statement for being unsatisfactory for default filtering inspection rule are returned in a manner of result set.
Fig. 8 is a kind of structural schematic diagram of controlled terminal 800 provided in an embodiment of the present invention, which can be with
Method for executing O&M MySQL database provided by the embodiments of the present application.
Wherein, which may include: processor 810, memory 820 and communication unit 830.These components
It is communicated by one or more bus, it will be understood by those skilled in the art that the structure of server shown in figure is not
The restriction to the application is constituted, it is also possible to hub-and-spoke configuration either busbar network, can also include more than illustrating
Or less component, perhaps combine certain components or different component layouts.
Wherein, which can be used for executing instruction for storage processor 810, and memory 820 can be by any class
The volatibility or non-volatile memory device or their combination of type are realized, such as static random access memory (SRAM), electricity
Erasable Programmable Read Only Memory EPROM (EEPROM), Erasable Programmable Read Only Memory EPROM (EPROM), programmable read only memory
(PROM), read-only memory (ROM), magnetic memory, flash memory, disk or CD.When executing instruction in memory 820
When being executed by processor 810, so that terminal 800 some or all of is able to carry out in following above method embodiment step.
Processor 810 is the control centre for storing equipment, utilizes each of various interfaces and the entire electronic equipment of connection
A part by running or execute the software program and/or module that are stored in memory 820, and calls and is stored in storage
Data in device, to execute the various functions and/or processing data of electronic equipment.The processor can be by integrated circuit
(Integrated Circuit, abbreviation IC) composition, such as the IC that can be encapsulated by single are formed, can also be by more of connection
The encapsulation IC of identical function or different function and form.For example, processor 810 can only include central processing unit
(Central Processing Unit, abbreviation CPU).In the application embodiment, CPU can be single operation core, can also
To include multioperation core.
Communication unit 830, for establishing communication channel, so that the storage equipment be allow to be led to other equipment
Letter.Receive the user data or send user data to other equipment that other equipment are sent.
The application also provides a kind of computer storage medium, wherein the computer storage medium can be stored with program, the journey
Sequence may include step some or all of in each embodiment provided by the present application when executing.The storage medium can for magnetic disk,
CD, read-only memory (English: read-only memory, referred to as: ROM) or random access memory (English:
Random access memory, referred to as: RAM) etc..
In several embodiments provided herein, it should be understood that disclosed system and method can pass through it
Its mode is realized.For example, the apparatus embodiments described above are merely exemplary, for example, the division of the unit, only
Only a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components can be tied
Another system is closed or is desirably integrated into, or some features can be ignored or not executed.Another point, it is shown or discussed
Mutual coupling, direct-coupling or communication connection can be through some interfaces, the INDIRECT COUPLING or logical of device or unit
Letter connection can be electrical property, mechanical or other forms.The unit as illustrated by the separation member can be or can also be with
It is not physically separated, component shown as a unit may or may not be physical unit, it can be located at one
A place, or may be distributed over multiple network units.Part therein or complete can be selected according to the actual needs
Portion unit achieves the purpose of the solution of this embodiment.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.
Although by reference to attached drawing and combining the mode of preferred embodiment to the present invention have been described in detail, the present invention
It is not limited to this.Without departing from the spirit and substance of the premise in the present invention, those of ordinary skill in the art can be to the present invention
Embodiment carry out various equivalent modifications or substitutions, and these modifications or substitutions all should in covering scope of the invention/appoint
What those familiar with the art in the technical scope disclosed by the present invention, can easily think of the change or the replacement, answer
It is included within the scope of the present invention.Therefore, protection scope of the present invention is answered described is with scope of protection of the claims
It is quasi-.
Claims (10)
1. one kind is based on MySQL database O&M method, which is characterized in that the described method includes:
Determine pending SQL statement;
It audits the pending SQL statement and caches;
Judge whether pending SQL statement audits completion, if then judging whether SQL statement needs to be implemented, if otherwise will be described
The auditing result of the SQL statement of audit is returned in the form of result set;
If SQL statement needs to be implemented, judge whether SQL statement is audited and pass through, if otherwise by the auditing result of the SQL statement
It is returned in the form of result set;If then executing the SQL statement that audit passes through one by one;
Whether the SQL statement execution for judging that audit passes through malfunctions, if then judging whether to skip the SQL statement for executing mistake, if
It is to continue to execute next SQL statement, is finished until all SQL statements are performed both by, if it is not, then by the execution mistake
The implementing result of SQL statement is returned in the form of result set.
2. judge SQL statement the method according to claim 1, wherein if the SQL statement needs to be implemented
Whether audit passes through, if otherwise by it is described do not audit SQL statement returned in the form of result set;If then executing one by one
Audit the SQL statement passed through, further includes:
It obtains thread_id information and every SQL statement executes the binlog location information of front and back.
3. according to the method described in claim 2, it is characterized in that, the method also includes:
Judge whether SQL statement needs to back up, if otherwise returning to the implementing result of SQL statement in the form of result set, is
The binlog location information that will acquire is filtered, and obtains the binlog location information for currently executing sentence;
The current binlog location information for executing sentence is extracted, and parses the binlog location information, obtains described work as
The corresponding rollback sentence of preceding execution sentence, carries out backup rollback;
Judge whether the backup is completed, if it is not, then continuing successively to execute filtering, backup rollback, until backup is completed.
4. according to the method in any one of claims 1 to 3, which is characterized in that the audit pending SQL statement
And it caches, comprising:
Syntactic analysis is carried out one by one to the pending SQL statement according to preset syntax rule;
If the pending SQL statement does not meet the preset syntax rule, reporting an error and caching is unsatisfactory for default syntax rule
SQL statement;
Judge whether the syntactic analysis is completed, if so, according to preset semantic analysis rule to the SQL statement one by one into
Row semantic analysis;
If the pending SQL statement does not meet the preset semantic analysis rule, reporting an error and caching is unsatisfactory for default language
The SQL statement of adopted analysis rule;
Judge whether the semantic analysis is completed, if so, checking that rule advises the SQL statement according to preset filtering
Then filter;
If the pending SQL statement does not meet the preset filtering and checks rule, reporting an error and caching is unsatisfactory for presetting
Filter checks the SQL statement of rule.
5. method according to claim 4, which is characterized in that the pending SQL statement of determination, to described pending
SQL statement is audited and is cached, further includes:
By the SQL statement deposited the SQL statement for being unsatisfactory for presetting syntax rule, be unsatisfactory for default semantic analysis rule, it is discontented with
The default filtering of foot checks that the SQL statement of rule is returned in a manner of result set.
6. one kind is based on MySQL database operational system characterized by comprising
Determination unit, the determination unit is for determining pending SQL statement;
Unit is audited, the audit unit is for being audited and being cached to the pending SQL statement;
First judging unit, first judging unit is for judging whether pending SQL statement audits completion, if then judging
Whether SQL statement needs to be implemented, if otherwise returning to the auditing result of the SQL statement of the audit in the form of result set;
Second judgment unit judges whether SQL statement is audited if the second judgment unit is needed to be implemented for SQL statement
Pass through, if otherwise returning to the auditing result of the SQL statement in the form of result set;If then executing what audit passed through one by one
SQL statement;
Third judging unit, whether the SQL statement execution that the third judging unit is used to judge that audit to pass through malfunctions, if then
Judge whether to skip the SQL statement for executing mistake, if then continuing to execute next SQL statement, until all SQL statements are held
Row finishes, if it is not, then returning to the implementing result of the SQL statement for executing mistake in the form of result set.
7. system according to claim 6, which is characterized in that the system also includes:
Acquiring unit, the acquiring unit is used to obtain thread_id information and every SQL statement executes front and back
Binlog location information.
8. system according to claim 7, which is characterized in that the system also includes:
Second judgment unit, the backup judging unit is for judging whether SQL statement needs to back up, if otherwise by SQL statement
Implementing result returned in the form of result set, be that the binlog location information that will acquire is filtered, currently executed
The binlog location information of sentence;
Backup rollback unit, the backup rollback unit are used to extract the current binlog location information for executing sentence, and
The binlog location information is parsed, the corresponding rollback sentence of the current execution sentence is obtained, carries out backup rollback;
The second judgment unit is also used to judge whether the backup is completed, if it is not, then continuing successively to execute filtering, backing up back
Rolling, until backup is completed.
9. the system according to any one of claim 6 to 8, which is characterized in that the audit unit includes:
Parsing unit, the parsing unit be used for according to preset syntax rule to the pending SQL statement by
One carries out syntactic analysis;
First cache unit, if first cache unit does not meet the preset grammer for the pending SQL statement
Rule reports an error and caches the SQL statement for being unsatisfactory for default syntax rule;
Semantic analysis unit, the semantic analysis unit is for judging whether the syntactic analysis is completed, if so, according to default
Semantic analysis rule semantic analysis is carried out one by one to the SQL statement;
Second cache unit, if second cache unit does not meet the preset semanteme for the pending SQL statement
Analysis rule then reports an error and caches the SQL statement for being unsatisfactory for default semantic analysis rule;
Rule-based filtering unit, the rule-based filtering unit is for judging whether the semantic analysis is completed, if so, according to default
Filtering check rule to the SQL statement carry out rule-based filtering;
Third cache unit, if the third cache unit does not meet the preset filtering for the pending SQL statement
Check rule, then reporting an error and caching is unsatisfactory for the SQL statement that default filtering checks rule.
10. a kind of controlled terminal characterized by comprising
Processor;And the memory executed instruction for storage processor;
Wherein, the processor requires the described in any item methods of 1-5 for perform claim.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811230149.3A CN109284282A (en) | 2018-10-22 | 2018-10-22 | One kind being based on MySQL database O&M method and system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811230149.3A CN109284282A (en) | 2018-10-22 | 2018-10-22 | One kind being based on MySQL database O&M method and system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109284282A true CN109284282A (en) | 2019-01-29 |
Family
ID=65177841
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811230149.3A Pending CN109284282A (en) | 2018-10-22 | 2018-10-22 | One kind being based on MySQL database O&M method and system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109284282A (en) |
Cited By (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110597823A (en) * | 2019-09-20 | 2019-12-20 | 四川长虹电器股份有限公司 | Method for supporting online DDL operation of MySQL database |
CN110659327A (en) * | 2019-08-16 | 2020-01-07 | 平安科技(深圳)有限公司 | Method and related device for realizing interactive query of data between heterogeneous databases |
CN110674161A (en) * | 2019-09-20 | 2020-01-10 | 上海擎感智能科技有限公司 | Method, system, storage medium and SQL operation platform for online SQL |
CN110716922A (en) * | 2019-10-21 | 2020-01-21 | 深圳前海环融联易信息科技服务有限公司 | Incep-based database operation and maintenance method and device, computer equipment and storage medium |
CN110795450A (en) * | 2019-09-12 | 2020-02-14 | 连连银通电子支付有限公司 | SQL processing method and device |
CN111241125A (en) * | 2020-01-08 | 2020-06-05 | 成都嗨学洛子教育科技有限公司 | Method and device for recording operation log, electronic equipment and storage medium |
CN111259040A (en) * | 2020-02-19 | 2020-06-09 | 中国工商银行股份有限公司 | SQL statement auditing method and system |
CN111291990A (en) * | 2020-02-04 | 2020-06-16 | 浙江大华技术股份有限公司 | Quality monitoring processing method and device |
CN112035580A (en) * | 2020-06-30 | 2020-12-04 | 中国民航信息网络股份有限公司 | Intelligent checking method and system for Oracle database |
WO2021022702A1 (en) * | 2019-08-07 | 2021-02-11 | 平安科技(深圳)有限公司 | Log insertion method and apparatus, computer apparatus and storage medium |
CN113138974A (en) * | 2021-04-23 | 2021-07-20 | 建信金融科技有限责任公司 | Database compliance detection method and device |
CN113672491A (en) * | 2020-05-14 | 2021-11-19 | 深圳市华胜软件技术有限公司 | Method for detecting validity of SQL statement, storage medium and terminal equipment |
CN113742371A (en) * | 2021-11-08 | 2021-12-03 | 北京安华金和科技有限公司 | SQL statement block analysis processing method and device |
CN115757459A (en) * | 2022-10-20 | 2023-03-07 | 贵州多彩宝互联网服务有限公司 | MySQL database operation auditing and rollback method |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104391995A (en) * | 2014-12-15 | 2015-03-04 | 北京趣拿软件科技有限公司 | SQL (Structured Query Language) statement auditing method, and database operation and maintenance method and system |
US20160283506A1 (en) * | 2015-03-24 | 2016-09-29 | Datos IO Inc. | ON-THE-FLY DEDUPLICATION DURING DATA MOVEMENT FOR NoSQL DATA STORES |
CN106980637A (en) * | 2016-09-28 | 2017-07-25 | 平安科技(深圳)有限公司 | SQL checking methods and device |
CN108415991A (en) * | 2018-02-12 | 2018-08-17 | 广州市贝聊信息科技有限公司 | A kind of SQL checking methods and system |
-
2018
- 2018-10-22 CN CN201811230149.3A patent/CN109284282A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104391995A (en) * | 2014-12-15 | 2015-03-04 | 北京趣拿软件科技有限公司 | SQL (Structured Query Language) statement auditing method, and database operation and maintenance method and system |
US20160283506A1 (en) * | 2015-03-24 | 2016-09-29 | Datos IO Inc. | ON-THE-FLY DEDUPLICATION DURING DATA MOVEMENT FOR NoSQL DATA STORES |
CN106980637A (en) * | 2016-09-28 | 2017-07-25 | 平安科技(深圳)有限公司 | SQL checking methods and device |
CN108415991A (en) * | 2018-02-12 | 2018-08-17 | 广州市贝聊信息科技有限公司 | A kind of SQL checking methods and system |
Cited By (20)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021022702A1 (en) * | 2019-08-07 | 2021-02-11 | 平安科技(深圳)有限公司 | Log insertion method and apparatus, computer apparatus and storage medium |
CN110659327A (en) * | 2019-08-16 | 2020-01-07 | 平安科技(深圳)有限公司 | Method and related device for realizing interactive query of data between heterogeneous databases |
CN110795450A (en) * | 2019-09-12 | 2020-02-14 | 连连银通电子支付有限公司 | SQL processing method and device |
CN110597823A (en) * | 2019-09-20 | 2019-12-20 | 四川长虹电器股份有限公司 | Method for supporting online DDL operation of MySQL database |
CN110674161A (en) * | 2019-09-20 | 2020-01-10 | 上海擎感智能科技有限公司 | Method, system, storage medium and SQL operation platform for online SQL |
CN110716922A (en) * | 2019-10-21 | 2020-01-21 | 深圳前海环融联易信息科技服务有限公司 | Incep-based database operation and maintenance method and device, computer equipment and storage medium |
CN111241125A (en) * | 2020-01-08 | 2020-06-05 | 成都嗨学洛子教育科技有限公司 | Method and device for recording operation log, electronic equipment and storage medium |
CN111241125B (en) * | 2020-01-08 | 2023-06-02 | 北京数培通网络科技有限公司 | Method and device for recording operation log, electronic equipment and storage medium |
CN111291990B (en) * | 2020-02-04 | 2023-11-07 | 浙江大华技术股份有限公司 | Quality monitoring processing method and device |
CN111291990A (en) * | 2020-02-04 | 2020-06-16 | 浙江大华技术股份有限公司 | Quality monitoring processing method and device |
CN111259040B (en) * | 2020-02-19 | 2023-04-11 | 中国工商银行股份有限公司 | SQL statement auditing method and system |
CN111259040A (en) * | 2020-02-19 | 2020-06-09 | 中国工商银行股份有限公司 | SQL statement auditing method and system |
CN113672491A (en) * | 2020-05-14 | 2021-11-19 | 深圳市华胜软件技术有限公司 | Method for detecting validity of SQL statement, storage medium and terminal equipment |
CN113672491B (en) * | 2020-05-14 | 2024-06-04 | 深圳市华胜软件技术有限公司 | Method for detecting legality of SQL statement, storage medium and terminal equipment |
CN112035580A (en) * | 2020-06-30 | 2020-12-04 | 中国民航信息网络股份有限公司 | Intelligent checking method and system for Oracle database |
CN113138974A (en) * | 2021-04-23 | 2021-07-20 | 建信金融科技有限责任公司 | Database compliance detection method and device |
CN113138974B (en) * | 2021-04-23 | 2023-08-22 | 建信金融科技有限责任公司 | Method and device for detecting database compliance |
CN113742371A (en) * | 2021-11-08 | 2021-12-03 | 北京安华金和科技有限公司 | SQL statement block analysis processing method and device |
CN113742371B (en) * | 2021-11-08 | 2022-02-15 | 北京安华金和科技有限公司 | SQL statement block analysis processing method and device |
CN115757459A (en) * | 2022-10-20 | 2023-03-07 | 贵州多彩宝互联网服务有限公司 | MySQL database operation auditing and rollback method |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109284282A (en) | One kind being based on MySQL database O&M method and system | |
CN108600148B (en) | Transaction message processing method and device | |
CN104391995A (en) | SQL (Structured Query Language) statement auditing method, and database operation and maintenance method and system | |
US7213233B1 (en) | Modeling standards validation tool for use in enterprise architecture modeling | |
EP1819094A1 (en) | Script language based network device configuration management system and method | |
US7694272B2 (en) | Method, a language and a system for the definition and implementation of software solutions by using a visualizable computer executable modeling language | |
US20140109049A1 (en) | Code quality improvement | |
CN100462974C (en) | Apparatus and method for monitoring and debugging query execution objects | |
US7634766B2 (en) | Method and apparatus for pattern-based system design analysis using a meta model | |
CN101196926A (en) | Database access platform and access method thereof | |
CN108984712A (en) | Counting method, equipment and readable storage medium storing program for executing are made based on business scenario | |
CN102436473B (en) | Menu management device and menu managing method | |
US10915585B2 (en) | Data store interface that facilitates distribution of application functionality across a multi-tier client-server architecture | |
US9442822B2 (en) | Providing a visual representation of a sub-set of a visual program | |
CA2701046A1 (en) | Analysis of a system for matching data records | |
CN108694214A (en) | Generation method, generating means, readable medium and the electronic equipment of data sheet | |
US7448028B2 (en) | System and method for selective local object retrieval | |
US20080059563A1 (en) | Methods and Systems for Automated Data Processing | |
CN111767574A (en) | User permission determining method and device, electronic equipment and readable storage medium | |
WO2006126992A1 (en) | Method and apparatus for tracking changes in a system | |
CN110046153A (en) | A kind of method, device and equipment of account fund verification | |
Castro et al. | Testing data consistency of data-intensive applications using quickcheck | |
CN110597781B (en) | Flash deleting method and system for database | |
CN111352818B (en) | Application program performance analysis method and device, storage medium and electronic equipment | |
CN112417024A (en) | Method and device for quickly adapting database script, computer equipment and 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 | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20190129 |
|
WD01 | Invention patent application deemed withdrawn after publication |