CN110222028A - A kind of data managing method, device, equipment and storage medium - Google Patents
A kind of data managing method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN110222028A CN110222028A CN201910366894.9A CN201910366894A CN110222028A CN 110222028 A CN110222028 A CN 110222028A CN 201910366894 A CN201910366894 A CN 201910366894A CN 110222028 A CN110222028 A CN 110222028A
- Authority
- CN
- China
- Prior art keywords
- work order
- information
- data
- modification
- mentioned
- 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.)
- Granted
Links
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/21—Design, administration or maintenance of databases
- G06F16/219—Managing data history or versioning
-
- 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
Abstract
This application discloses a kind of data managing method, device, equipment and storage mediums, and wherein method is applied to MySQL database, comprising: receive the data modification request work order that user submits by WorkForm System, data modification request work order includes work order information；It is modified according to data modification request work order to MySQL database；The modification information of data modification request work order is recorded, modification information is used to indicate the data modified in database；Modification information is saved in search engine, and modification information and work order information are associated.It can be seen that, the application is by the way that modification information to be saved in search engine, and the work order information of modification information and data modification request work order is associated, the modification record of database is stored in search engine and WorkForm System for a long time, the modification situation of database is recalled at any time convenient for user.
Description
Technical field
This application involves database technical fields more particularly to a kind of data managing method, device, equipment and storage to be situated between
Matter.
Background technique
MySQL database can be with logarithm accordingly and the information such as data relationship are stored, and the information in database may be used also
To be performed the modifications such as increase and deletion operation, the information recorded to modification is referred to as modification record, due to modification
Record can reflect out history modification situation, and administrative staff is facilitated preferably to manage database, then save modification note
Record has important meaning.
MySQL database obtains modification record by way of incremental backup.Relative to the database after modification
All data backed up, incremental backup only need that the data modified in database are recorded to obtain include modification
The binlog log of record, data modification record include the data of modification time and modification front and back, and user is by searching for binlog
Log is recalled so as to the modification situation to database.
In the biggish situation of data volume of database storage, database, which can be deleted periodically, stores more long binlog day
Will, therefore, for the data that modification time is more long, it is understood that there may be the case where searching less than related amendments record.
Summary of the invention
The embodiment of the present application provides a kind of data managing method, can to modification information library during generate modification note
Record carries out efficient data management.
On the one hand, the embodiment of the present application provides a kind of data managing method, and this method includes that data management apparatus is first
The data modification request work order that user submits is received by WorkForm System, the data modification request work order includes work order information,
Then it is modified according to the data modification request work order to the MySQL database, records the data modification request work
Single modification information, the modification information is used to indicate the data modified in the database, finally by the modification information
It is saved in search engine, and the modification information and the work order information is associated.The side provided through this embodiment
Case, available includes the modification information and work order information of abundant information, thus realize to the modification situation of database into
Row is comprehensive and detailed record, and the application is by the way that modification information to be saved in search engine, and by modification information and number
According to modification request work order work order information be associated, allow the modification record of database be stored in for a long time search engine and
In WorkForm System, the modification situation of database is recalled at any time convenient for user.
In a kind of possible design, the work order information includes SQL statement, described to be mentioned by WorkForm System reception user
After the data modification request work order of friendship, syntactic analysis is carried out to the SQL statement, and be what there is no problem in analysis result
In the case of, call the SQL statement to execute the behaviour to modify according to the work order information to the MySQL database
Make.A possibility that database update is successful can be improved, to further increase data pipe in the scheme provided through this embodiment
The efficiency of reason.
In a kind of possible design, in the case where analyzing result is that there is no problem, pass through the WorkForm System pair
The SQL statement carries out Hash processing, obtains cryptographic Hash, and judge whether the cryptographic Hash is existing, if it does not, calling
The SQL statement executes the operation modified according to the work order information to the MySQL database.By this implementation
The scheme that example provides can prevent from carrying out repeating same modification operation to database, save computing resource, reduce redundancy
The generation of modification information, to further increase the efficiency of data management.
In a kind of possible design, in the case where the cryptographic Hash is not present, the cryptographic Hash is saved, and pass through institute
It states WorkForm System and generates the corresponding work order number of the data modification request work order, and by the work order number and the cryptographic Hash and institute
Work order information is stated to be associated.
In a kind of possible design, the keyword in the work order number and described search engine is established into incidence relation.
The scheme provided through this embodiment can be convenient user and obtain subsequently through search key in a search engine and key
The work order number of word association, thus obtain with the associated cryptographic Hash of work order number and work order information, further it is available obtain with
The associated modification information of work order information, then the present embodiment Data Data backdating capability further increases.
It is described that the MySQL database is carried out according to the data modification request work order in a kind of possible design
After modification, corresponding binlog log is generated, correspondingly, the modification information for recording the data modification request work order refers to
, the library name modified in the MySQL database, list name, major key ID are extracted from the binlog log and are repaired
The data for changing front and back, using the modification information as the data modification request work order.
In a kind of possible design, after repeatedly implementing above-mentioned steps, the more of database are saved in search engine
A modification information can also then obtain the query information that user is inputted by described search engine, in institute in the present embodiment
Search and the matched target keywords of the query information in search engine are stated, and search the associated target of the target keywords
Work order number, then in the WorkForm System inquiry with the associated target work order information of the target work order number, finally by institute
State WorkForm System export the target work order information and with the associated target modification information of the target work order information.It is logical
The quick backtracking to the modification information and work order information generated in the above process may be implemented in the scheme for crossing the present embodiment.
Another aspect, the embodiment of the present application provide a kind of data administrator, which includes receiving unit, modification list
Member, recording unit, storage unit and associative cell.Wherein, receiving unit, for receiving the number that user submits by WorkForm System
Work order is requested according to modification, the data modification request work order includes work order information；Unit is modified, for according to the data modification
Request work order modifies to the MySQL database；Recording unit, for recording the modification of the data modification request work order
Information, the modification information are used to indicate the data modified in the database；Storage unit is used for the modification information
It is saved in search engine；Associative cell, for the modification information and the work order information to be associated.
In a kind of possible design, the work order information includes SQL statement, and the data administrator further includes verifying
Unit, for carrying out syntactic analysis to the SQL statement；The modification unit, specifically for being that there is no ask in analysis result
In the case where topic, calls the SQL statement to execute and described modified to the MySQL database according to the work order information
Operation.
In a kind of possible design, the data administrator further includes duplicate checking unit, for being not in analysis result
In situation of problems, Hash processing is carried out to the SQL statement by the WorkForm System, obtains cryptographic Hash；Judge institute
Whether existing state cryptographic Hash；If it does not, call the SQL statement execute it is described according to the work order information to described
The operation that MySQL database is modified.
In a kind of possible design, the storage unit is also used in the case where the cryptographic Hash is not present, and is saved
The cryptographic Hash；The data administrator further includes numbered cell, is repaired for generating the data by the WorkForm System
Change the corresponding work order number of request work order；The associative cell is also used to the work order number and the cryptographic Hash and the work order
Information is associated.
In a kind of possible design, the associative cell, being also used to will be in the work order number and described search engine
Keyword establishes incidence relation.
In a kind of possible design, the data administrator further includes generation unit, for according to the data
After modification request work order modifies to the MySQL database, corresponding binlog log is generated；The recording unit,
Specifically for extracted from the binlog log library name modified in the MySQL database, list name, major key ID and
The data for modifying front and back, using the modification information as the data modification request work order.
In a kind of possible design, the receiving unit is inputted for obtaining user by described search engine
Query information；The data administrator further includes searching unit, for the search in described search engine and the inquiry
The target keywords of information matches, and the associated target work order number of the target keywords is searched, then in the WorkForm System
Middle inquiry and the associated target work order information of the target work order number；The data administrator further includes output unit, is used for
By the WorkForm System export the target work order information and with the associated target modification of the target work order information
Information.
In another aspect, the embodiment of the present application provides a kind of data management apparatus, including processor, memory and communication connect
Mouthful, the processor, memory and communication interface are connected with each other, wherein the data management apparatus passes through the communication interface
Data interaction is carried out with other equipment, for the memory for storing computer program, the computer program includes that program refers to
It enables, the processor is configured for calling described program instruction, to execute method as described in relation to the first aspect.
In another aspect, the embodiment of the present application provides a kind of computer readable storage medium, which is characterized in that the calculating
Machine storage medium is stored with computer program, and the computer program includes program instruction, and described program instruction is held by processor
Row, to execute method as described in relation to the first aspect.
In this application, it first passes through WorkForm System and receives the data modification request work order that user submits, then according to data
Modification request work order modifies to MySQL database, and records and obtain the modification information of data modification request work order, finally will
Modification information is saved in search engine, and modification information and the work order information in data modification request work order are associated.
As it can be seen that the application is by the way that modification information to be saved in search engine, and by the work of modification information and data modification request work order
Single information is associated, and the modification record of database is stored in search engine and WorkForm System for a long time, convenient for using
The modification situation of database is at any time recalled in family, and does not have to the problem of concern of data can lose.Then generally speaking, this Shen
It please provide a kind of efficient data managing method of modification situation for database.
Detailed description of the invention
Technical solution in ord to more clearly illustrate embodiments of the present application, below will be to needed in embodiment description
Attached drawing is briefly described.
Fig. 1 is a kind of application scenarios schematic diagram of data managing method provided by the embodiments of the present application；
Fig. 2 is a kind of schematic flow diagram of data managing method provided by the embodiments of the present application；
Fig. 3 is a kind of schematic flow diagram for data managing method that another embodiment of the application provides；
Fig. 4 is a kind of schematic block diagram of data administrator provided by the embodiments of the present application；
Fig. 5 is a kind of structural diagram of data management apparatus provided by the embodiments of the present application.
Specific embodiment
Below in conjunction with the attached drawing in the embodiment of the present application, technical solutions in the embodiments of the present application carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of embodiments of the present application, instead of all the embodiments.It is based on
Embodiment in the application, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
The application is mainly used in data management apparatus, which can be traditional data management equipment, number
According to data management apparatus described in library server, web server or the application fourth embodiment, the application does not limit this
System.When data management apparatus and other terminal devices carry out data interaction, data management apparatus and other terminal devices
The characteristic of data is recorded and transmitted all in accordance with preset format, wherein the characteristic of data includes time, place, class
Type etc..Wherein, terminal device, which can be, arbitrarily has the function of that the equipment of data transmit-receive and processing function, the application do not limit this
System.
Database can with logarithm accordingly and the information such as data relationship are stored, and the information in database can also by into
Row increases and the modifications such as deletion operation.In order to preferably be managed modification process, database is by log come record modification
Situation.But not only content is single for the modification situation recorded in log, but also increasing with content, and log is increasingly difficult to orderly
Management.In order to solve the problems, such as the data management of the modification situation for database, present applicant proposes a kind of efficient data
Management method.
In order to more fully understand the embodiment of the present invention, below in conjunction with Fig. 1, to the method for the application embodiment of the present invention
It is introduced, the embodiment of the present invention can be applied in the scene that database is modified.
This programme can be completed by client device and data management apparatus cooperation, can also be by with input/output function
Data management apparatus individually complete, the application is without limitation.When the application is by client device and data management apparatus
When this programme is completed in cooperation, as shown in Figure 1, client device and data management apparatus can be by wired or wirelessly
Carry out data interaction.Wherein, client device can by install application program on a client device or web page come
WorkForm System is logged in, and data interaction is carried out by WorkForm System and data management apparatus, likewise, data management apparatus can also
To log in WorkForm System by the application program being mounted on data management apparatus or web page, and pass through WorkForm System
Data interaction is carried out with client device.WorkForm System is that one kind can record the performance of work, handle, track
System.
Specifically, client device uploads data modification request work order in WorkForm System, the data modification request work order
It modifies for request data management equipment to database, then data management apparatus is receiving the number by WorkForm System
After modification request instruction, the work order information in the data modification request work order is extracted first, is wrapped in work order information
Containing information such as SQL statement, modification reason, uplink time and upload personnel.Wherein, SQL statement, that is, structured query language (SQL,
Structured Query Language) it is a kind of modification instruction applied to database, when database management apparatus calls number
When executing the SQL statement according to library, it can be operated with the modification of database.
After extraction obtains work order information, data management apparatus carries out syntactic analysis to SQL statement, to determine SQL language
Sentence whether there is problem, problem the problem of for example grammar issue, object information are incorrect or do not meet specification, and not meet people
Grammer is carried out to SQL statement aiming at the problem that the normative constraint of SQL statement etc., such as using syntax analyzer for customization
Analysis, prompt statement mistake information warning is needed if analysis result is there are problem with prompting user's SQL statement mistake
It modifies and uploads data modification request work order again.If analysis result be examine if there is no problem SQL statement whether by
It executed, that is, calculates the cryptographic Hash of SQL statement, identical cryptographic Hash then whether is stored in WorkForm System, is then said if it exists
Bright above-mentioned SQL statement had been performed, and then prompted repetitive operation information warning, to prompt user's SQL statement to be repeatedly executed,
Then illustrate that above-mentioned SQL statement was not performed, is then saved in the cryptographic Hash in WorkForm System, is then passed through work if it does not exist
Single system generates the corresponding work order number of above-mentioned data modification request work order, and work order number and the keyword in search engine are closed
Connection, and by the cryptographic Hash of above-mentioned SQL statement, the work order information and data modification request of corresponding data modification request work order
The work order number of work order is also associated.Wherein, work order number has uniqueness, and different data modification request work orders corresponds to different
Work order number can be the characters any combination such as digital English spcial character.
In the case where determining that SQL statement is correct and the SQL statement was not performed, data management apparatus recalls number
The SQL statement in the work order information is executed according to library, the modifications operation such as to be increased database and be deleted, and record is obtained and has
The binlog log of the modification situation of database, then from the library modified in extraction MySQL database in the binlog log
Data and modification time before and after name, list name, major key ID, modification etc. are believed as the modification of data modification request work order
Breath.
After obtaining the modification information and work order information of data modification request work order, modification information is saved in search
In engine, and modification information and the work order information in WorkForm System are associated.Wherein, search engine can be based on distribution
The search engine of formula storage, is had for the search engine that non-distributed stores based on the search engine of distributed storage
Stronger data search capabilities and data storage capacities.
After implementing multiple above-mentioned steps, some modification informations are saved in search engine, are also saved in WorkForm System
Some work order informations obtain the query information inputted by search engine, then search in a search engine in this case
Rope and the matched target keywords of the query information, and the associated target work order number of the target keywords is searched, subsequently in work
Inquiry and the associated target work order information of the target work order number in single system, and obtain believe with the target work order in a search engine
Cease associated target modification information, finally by WorkForm System export target work order information and with target modification information.As it can be seen that
Data management apparatus to modification information and work order information can orderly and efficiently manage, so that modification information and work order information
Can quickly it be recalled.
It should be noted that when this programme is individually completed by the data management apparatus with input/output function, data
Management equipment can log in WorkForm System by the application program that is mounted on data management apparatus or web page, and
Data management apparatus has the function of input and output, and user is allowed to log in WorkForm System simultaneously directly on data management apparatus
Upload the information such as data modification request work order.We are completed by client device and data management apparatus cooperation by described above
From the point of view of the process of case, it unquestionable can be inferred to individually complete the process of this programme, the application couple by data management apparatus
This is repeated no more.
It should be noted that content shown in Fig. 1 is a kind of citing, the restriction to the embodiment of the present invention is not constituted, because
It is not defined to 1 etc. for the application.Such as the application can use client device and data management apparatus cooperation completes this
Scheme only individually can also complete this programme using the data management apparatus with input/output function.
It referring to fig. 2, is that the embodiment of the present application provides a kind of schematic flow diagram of data managing method, data as shown in Figure 2
Management method can include:
201: the data modification request work order that user submits being received by WorkForm System, data modification request work order includes work
Single information.
In the embodiment of the present application, data management apparatus is used to indicate by WorkForm System reception and is modified to database
Data modification request work order, which can be through the input equipment of data management apparatus (such as key
Disk etc.) it is input in WorkForm System, it is also possible to user and is input in WorkForm System by the input equipment of client device,
Data management apparatus can log in WorkForm System by application program on the data management apparatus or web page, and
Data interaction is carried out by WorkForm System and other equipment (such as client device).
It should be noted that including work order information in data modification request work order, work order information is repaired for descriptive data base
Change the information such as situation, including SQL statement, modification reason, uplink time and upload personnel.Wherein, SQL statement is that one kind is applied to
The modification of database instructs, can be with database when database management apparatus calls database to execute the SQL statement
Modification operation.
It should also be noted that, WorkForm System can be a computer packages or the software package based on Web, for pair
The performance of work is recorded, is handled, is tracked.Specifically, WorkForm System can be used to create, hang up, solves user and mention
The transactions requests of friendship, and a kind of standardization, unitized and sharpening transaction management mode are provided.Work in the embodiment of the present application
Single system is used exclusively for the WorkForm System of the modification affairs of management database, and user is allowed to create thing on WorkForm System
Business, i.e. creation data modification request work order, WorkForm System save after the data modification request work order for receiving user's creation
The data modification request work order inquires affairs after allowing user to log in WorkForm System whenever and wherever possible, furthermore work
Single system can also to data management apparatus provide data modification request work order, in time to user feedback data management equipment according to
Data modification request work order modifies the modification result etc. of database, and then the WorkForm System of the embodiment of the present application, which can be, sees as
A kind of management system of database can not only assist the modification for completing database, moreover it is possible to obtain repairing for descriptive data base
Change the work order information of situation, is different from general WorkForm System.
202: being modified according to above-mentioned data modification request work order to MySQL database.
In the embodiment of the present application, it is modified according to above-mentioned data modification request work order to database, i.e. calling data
Library executes the SQL statement in above-mentioned data modification request work order, with the modification of database.
203: recording the modification information of above-mentioned data modification request work order.
In the embodiment of the present application, while database is modified, the modification information of data modification request work order is recorded, it should
Modification information is used to indicate the content modified in database, including modification front and back data, modification time, modification library name,
The information such as the table name and major key ID of modification.
In a kind of implementation, during calling database to execute the SQL statement in above-mentioned data modification request work order,
Binlog log can be generated, the information of the modification situation for descriptive data base is described in the binlog log, then from this
The library name modified in database, list name, major key ID, modification time and the number of modification front and back are extracted in binlog log
According to etc., as the modification information of data modification request work order.Wherein, binlog log is a kind of binary system day of database
Will, the information modified for database of record.
In a kind of implementation, before being modified according to the data modification request work order to database, to SQL statement
Syntactic analysis is carried out, i.e. whether detection SQL statement is correct, in the case where analyzing result is that there is no problem, calls SQL statement
The above-mentioned operation modified according to work order information to MySQL database is executed, is then determining the correct situation of SQL statement
Under, call database to execute SQL statement, to modify to database.In another scenario, that is, SQL statement mistake is being determined
In the case where accidentally, pass through WorkForm System prompt statement mistake information warning.
In the embodiment of the present application, before calling database to execute SQL statement, first according to the language of preset SQL statement
Whether regulation then examines the SQL statement correct, and only in the case where verifying the correct situation of the SQL statement, just to calling database
Execute the SQL statement.Successively judge SQL statement with the presence or absence of grammar issue, object information is incorrect or does not meet specification
Problem, and do not meet artificially customize aiming at the problem that the normative constraint of SQL statement the problems such as at least one of.
In a kind of implementation, syntactic analysis is carried out to SQL statement using syntax analyzer.Wherein, syntax analyzer is for example
There is the SQL resolver etc. based on MySQL.
In a kind of implementation, after whether above-mentioned inspection SQL statement is correct, the correctness of SQL statement can be not only determined,
The statement error information for being used to indicate SQL statement mistake, including SQL language can also be obtained in the situation for determining SQL statement mistake
The table for including in sentence, library, incorrect do not meet perhaps in specification or SQL statement of the information such as column contain one and are not present
Object or SQL statement do not meet preset SQL normalization constraint etc..For example, cancel statement does not indicate that needs are deleted
Data, creating in sentence does not have the information such as major key.
In a kind of implementation, after the case where determining above-mentioned SQL statement there is no problem and (determining that SQL statement is correct),
Whether detection SQL statement is repeatedly executed, and then in the case where determining that SQL statement is not repeatedly executed, database is called to hold
Row SQL statement, to modify to database.In another scenario, that is, the case where SQL statement is repeatedly executed is being determined
Under, repetitive operation information warning is prompted by WorkForm System.Specifically, whether above-mentioned detection SQL statement be repeatedly executed can be with
It is to calculate the cryptographic Hash of the SQL statement first with hash algorithm, then detects in WorkForm System whether be stored with the cryptographic Hash
To judge whether cryptographic Hash is existing, and in the case where be stored with the cryptographic Hash in detecting the WorkForm System, determine
SQL statement is repeatedly executed.In another case, i.e., not stored in detecting WorkForm System to have the case where cryptographic Hash
Under, determine that above-mentioned SQL statement is not repeatedly executed, and the cryptographic Hash is saved in WorkForm System, and SQL statement is called to execute
The above-mentioned operation modified according to work order information to MySQL database.
In the embodiment of the present application, in the embodiment of the present application, it before calling database to execute SQL statement, first passes through
The SQL statement in the SQL statement and WorkForm System in above-mentioned data modification request work order is compared, to examine above-mentioned data modification to ask
Ask whether the SQL statement in work order was performed, and only verify the SQL statement be not performed in the case where, just exchange
The SQL statement is executed with database.Specifically, if found in WorkForm System in above-mentioned data modification request work order
The consistent SQL statement of SQL statement, it is determined that SQL statement was performed, on the contrary then be not performed.In the specific implementation, using breathing out
It is uncommon to calculate to calculate the cryptographic Hash of SQL statement, due to the information different for any two, the cryptographic Hash that Hash calculation obtains
A possibility that identical, is minimum, and then cryptographic Hash can be used as the identification information of SQL statement, by comparing the mark between SQL statement
Know information, can determine whether SQL statement is identical.Then the embodiment of the present application passes through the cryptographic Hash for calculating SQL statement, so
The cryptographic Hash for comparing the Hash sentence of all WorkForm Systems saved in WorkForm System afterwards, can quickly determine in WorkForm System
Whether SQL statement consistent SQL statement with above-mentioned data modification request work order is had.Wherein, hash algorithm is also referred to as hashed and is calculated
Method, at one small string character, principle exactly to be protected as fingerprint extraction with shorter information by one big File Mapping
The mark of the uniqueness of file is demonstrate,proved, this mark is related to each byte of file, and is difficult to find that reverse rule, in
The cryptographic Hash for being SQL statement can be with the unique identification SQL statement.
In a kind of implementation, in the case where determining that cryptographic Hash is not present, which is saved in WorkForm System, and
The corresponding work order number of above-mentioned data modification request work order is generated by WorkForm System, and by work order number and cryptographic Hash and work order information
It is associated.Wherein, work order number can uniquely confirm corresponding work order information, can be the characters such as digital English spcial character
Any combination.
In a kind of implementation, the keyword in the work order number and search engine of above-mentioned data modification request work order is established and is closed
Connection relationship.
204: above-mentioned modification information being saved in search engine, and modification information and work order information are associated.
In the embodiment of the present application, modification information is obtained in record, and extracts and obtains in data modification request work order
After work order information, modification information is saved in search engine, and by the work order information in modification information and WorkForm System into
Row association.Specifically, the opening relationships mapping table between modification information and associated work order information, so that subsequent in search engine
In corresponding modification information can be found according to work order information.
In a kind of implementation, above-mentioned search engine is the search engine based on distributed storage.Wherein, it is deposited based on distribution
The search engine of storage refers to the search engine based on distributed memory system, i.e., data dispersion is stored in more and independent set
It is standby upper.For the search engine that non-distributed stores there are stronger data to search based on the search engine of distributed storage
Suo Nengli and data storage capacities, can satisfy Mass storage application needs, and using expansible system structure with
And more storage servers share storage load, not only increase the reliability, availability and access efficiency of system, are also easy to expand
Exhibition.
In a kind of implementation, if above-mentioned modify failed database according to data modification request work order, it that is to say calling data
Library executes failed database, then prompts modification failure information warning, to prompt customer data base modification failure.
In a kind of implementation, the query information that user is inputted by search engine is obtained, is then searched in a search engine
With the matched target keywords of the query information, and the associated target work order number of target keywords is searched, then in WorkForm System
Inquiry and the associated target work order information of target work order number export target work order information and and target finally by WorkForm System
The associated target modification information of work order information.
After implementing multiple above-mentioned steps, some modification informations are saved in search engine, are also saved in WorkForm System
Some work order informations obtain the query information inputted by search engine, then search in a search engine in this case
Rope and the matched target keywords of the query information, then obtain with the associated target work order number of target keywords, and in work order system
Acquisition and the associated target work order information of the target work order number, are inquired and the associated mesh of target work order in a search engine in system
Modification information is marked, exports the target modification information and the target work order information finally by WorkForm System.As it can be seen that data management is set
It is standby that modification information and work order information can be carried out orderly to allow modification information and work order information quick with efficient management
It searches.Wherein, query information can be any form of character.
In a kind of enforceable mode, other than above-mentioned modification information is saved in search engine, also by work order
Information is also saved in search engine, so that disposably getting target work in a search engine when subsequent backtracking data
Single information and target modification information, so as to save the backtracking time.
In the embodiment of the present application, it first passes through WorkForm System and receives the data modification request work order that user submits, then root
It modifies according to data modification request work order to MySQL database, and records and obtain the modification information of data modification request work order,
Finally modification information is saved in search engine, and the work order information in modification information and data modification request work order is carried out
Association.As it can be seen that the embodiment of the present application is by the way that modification information to be saved in search engine, and modification information and data modification are asked
It asks the work order information of work order to be associated, the modification record of database is allowed to be stored in search engine and WorkForm System for a long time
In, the modification situation of database is recalled at any time convenient for user, and do not have to the problem of concern of data can lose, and due to
Comprising the information such as SQL statement, modification reason, uplink time and upload personnel in work order information, allow user to data into
The accurate backtracking of row, such as navigate to specific upload personnel and modification reason.Then generally speaking, this application provides a kind of needles
To the efficient data managing method of the modification situation of database.
Referring to Fig. 3, it is that the embodiment of the present application provides the schematic flow diagram of another data managing method, counts as shown in Figure 3
According to management method can include:
301: the data modification request work order that user submits being received by WorkForm System, data modification request work order includes work
Single information, work order information include SQL statement.
302: syntactic analysis is carried out to above-mentioned SQL statement.
In the embodiment of the present application, whether correct if analyzing the SQL statement according to the syntax rule of preset SQL statement, or
Person carries out syntactic analysis to SQL statement using syntax analyzer, to determine whether SQL statement is correct.Wherein, syntax analyzer example
If any the SQL resolver etc. based on MySQL.
In a kind of implementation, after whether above-mentioned inspection SQL statement is correct, the correctness of SQL statement can be not only determined,
The statement error information for being used to indicate SQL statement mistake, including SQL language can also be obtained in the situation for determining SQL statement mistake
The table for including in sentence, library, incorrect do not meet perhaps in specification or SQL statement of the information such as column contain one and are not present
Object or SQL statement do not meet preset SQL normalization constraint etc..For example, cancel statement does not indicate that needs are deleted
Data, creating in sentence does not have the information such as major key.
303: in the case where analyzing result is that there is no problem, Hash processing is carried out to SQL statement by WorkForm System,
Obtain cryptographic Hash.
In the embodiment of the present application, in the case where analyzing result is that there is no problem, that is, the correct feelings of SQL statement are determined
Under condition, Hash processing is carried out to SQL statement by WorkForm System, obtains cryptographic Hash.Wherein, Hash processing refers to carrying out Hash
It calculates, hash algorithm is also referred to as hashing algorithm, is used for one big File Mapping into one small string character, principle and fingerprint extraction
Equally, exactly guarantee the mark of the uniqueness of file, each byte phase of this mark and file with shorter information
It closes, and is difficult to find that reverse rule, then the cryptographic Hash of SQL statement can be with the unique identification SQL statement.
304: whether existing above-mentioned cryptographic Hash is judged, if it does not, saving the cryptographic Hash, and raw by WorkForm System
At the corresponding work order number of above-mentioned data modification request work order, the work order number and above-mentioned cryptographic Hash and above-mentioned work order information are closed
Keyword in work order number and search engine is established incidence relation by connection.
In the embodiment of the present application, if not found in WorkForm System and above-mentioned cryptographic Hash, it is determined that SQL statement not by
It executed, and the cryptographic Hash was saved, and the corresponding work order number of above-mentioned data modification request work order was generated by WorkForm System, by the work
Odd numbers is associated with above-mentioned cryptographic Hash and above-mentioned work order information, and work order number is associated with the keyword foundation in search engine
System.In another case, i.e., not stored in the case where have the cryptographic Hash in detecting WorkForm System, determine above-mentioned SQL language
Sentence is not repeatedly executed, and the cryptographic Hash is saved in the work order information of data modification request work order, then pass through WorkForm System
Prompt statement mistake information warning.
305: calling SQL statement to modify to above-mentioned MySQL database, generate corresponding binlog log.
In the embodiment of the present application, determining that above-mentioned SQL statement is correct and in the case where not being repeatedly executed, data are called
Library executes the SQL statement in above-mentioned data modification request work order, with the modification of database, database is being called to execute
During stating the SQL statement in data modification request work order, binlog log can be generated, describes use in the binlog log
In the information of the modification situation of descriptive data base.Wherein, binlog log is a kind of binary log of database, for recording
The information that database is modified.
306: from above-mentioned binlog log extract MySQL database in modified library name, list name, major key ID and
The data for modifying front and back, using the modification information as above-mentioned data modification request work order.
In the embodiment of the present application, after obtaining above-mentioned binlog log, data are extracted from the binlog log
The data of library name, list name, major key ID and the modification front and back modified in library, using the modification as data modification request work order
Information
In a kind of implementation, after determining that above-mentioned SQL statement is correct, examining whether SQL statement is repeatedly executed it
Before, it detects whether to receive by WorkForm System and submits determine instruction, submission confirmation instruction, which is used to indicate, executes above-mentioned inspection SQL
Whether the step of whether sentence is repeatedly executed executes above-mentioned inspection SQL statement in the case where receiving submission confirmation instruction
The step of being repeatedly executed does not execute whether above-mentioned inspection SQL statement is weighed in the case where not receiving submission confirmation instruction
The step of executing again.
307: above-mentioned modification information being saved in search engine, and above-mentioned modification information and the work order information are carried out
Association.
308: obtaining the query information that user is inputted by above-mentioned search engine.
In the embodiment of the present application, data management apparatus receives query information, the query information by above-mentioned search engine
Can be consistent with the part words in modification information, the part words similar import being also possible in modification information, the application reality
Example is applied not limit this.
309: search and the matched target keywords of query information in a search engine, and search target keywords association
Target work order number.
In the embodiment of the present application, data management apparatus is searched for and the matched target of above-mentioned query information in a search engine
Keyword, and and search the associated target work order number of the target keywords, matched mode has fuzzy matching and accurate matching etc..
310: inquiry and the associated target work order information of above-mentioned target work order number in above-mentioned WorkForm System.
311: by WorkForm System export above-mentioned target work order information and with the above-mentioned associated target of target work order information
Modification information.
The embodiment of the present application proposes a kind of specific implementation method of data managing method.Specifically, data management apparatus
After receiving data modification request work order by WorkForm System, the SQL statement in first inspection data modification request work order is
No is correctly, and in the correct situation of SQL statement, to examine whether SQL statement is repeatedly executed, however, it is determined that SQL statement is
It is not repeatedly executed correctly and, then database is called to execute the SQL statement, with the modification of database, and record
To the modification information for the modification content for including database, the modification information is finally uploaded to search engine, and modification is believed
It ceases associated with work order information.As it can be seen that the application call database execute SQL statement to modify to database before,
First determine that SQL statement is correct and is not to be repeatedly executed, then the application can further data management efficiency.
It should be noted that tending to emphasize the difference between each embodiment to the description of each embodiment above
Place, same or similar place can refer to mutually, for sake of simplicity, repeats no more herein.
The embodiment of the present application also provides a kind of data administrator, which is used to execute any one of aforementioned
The unit of data managing method.It specifically, referring to fig. 4, is a kind of signal of data administrator provided by the embodiments of the present application
Block diagram.The data administrator of the present embodiment includes: receiving unit 401, modification unit 402, recording unit 403, storage unit
404 and associative cell 405.It is specific:
Receiving unit 401, for receiving the data modification request work order that user submits by WorkForm System, above-mentioned data are repaired
Changing request work order includes work order information；Unit 402 is modified, is used for according to above-mentioned data modification request work order to above-mentioned MySQL number
It modifies according to library；Recording unit 403, for recording the modification information of above-mentioned data modification request work order, above-mentioned modification information
It is used to indicate the data modified in above-mentioned database；Storage unit 404, for above-mentioned modification information to be saved in search engine
In；Associative cell 405, for above-mentioned modification information and above-mentioned work order information to be associated.
In a kind of implementation, above-mentioned work order information includes SQL statement, and above-mentioned data administrator further includes authentication unit
406, for carrying out syntactic analysis to above-mentioned SQL statement；Above-mentioned modification unit 402, be specifically used for analysis result be there is no
In the case where problem, call above-mentioned SQL statement execution is above-mentioned to be modified according to above-mentioned work order information to above-mentioned MySQL database
Operation.
In a kind of implementation, above-mentioned data administrator further includes duplicate checking unit 407, for analysis result be there is no
In the case where problem, Hash processing is carried out to above-mentioned SQL statement by above-mentioned WorkForm System, obtains cryptographic Hash；Judge above-mentioned Kazakhstan
Whether uncommon value is existing；If it does not, call above-mentioned SQL statement execute it is above-mentioned according to above-mentioned work order information to above-mentioned MySQL
The operation that database is modified.
In a kind of implementation, above-mentioned storage unit 404 is also used in the case where above-mentioned cryptographic Hash is not present, in preservation
State cryptographic Hash；Above-mentioned data administrator further includes numbered cell 408, is repaired for generating above-mentioned data by above-mentioned WorkForm System
Change the corresponding work order number of request work order；Above-mentioned associative cell 405 is also used to above-mentioned work order number and above-mentioned cryptographic Hash and above-mentioned work
Single information is associated.
In a kind of implementation, above-mentioned associative cell 405 is also used to the key in above-mentioned work order number and above-mentioned search engine
Word establishes incidence relation.
In a kind of implementation, above-mentioned data administrator further includes generation unit 409, for according to above-mentioned data modification
After request work order modifies to above-mentioned MySQL database, corresponding binlog log is generated；Above-mentioned recording unit 403, tool
Body from above-mentioned binlog log for extracting the library name modified in above-mentioned MySQL database, list name, major key ID and repairing
The data for changing front and back, using the modification information as above-mentioned data modification request work order.
In a kind of implementation, above-mentioned receiving unit 401 is looked into for obtaining user by what above-mentioned search engine inputted
Ask information；Above-mentioned data administrator further includes searching unit 410, for the search in above-mentioned search engine and above-mentioned inquiry letter
Matched target keywords are ceased, and search the associated target work order number of above-mentioned target keywords, then in above-mentioned WorkForm System
Inquiry and the associated target work order information of above-mentioned target work order number；Above-mentioned data administrator further includes output unit 411, is used for
By above-mentioned WorkForm System export above-mentioned target work order information and with the associated above-mentioned target modification of above-mentioned target work order information
Information.
It is a kind of data management apparatus schematic block diagram that another embodiment of the application provides referring to Fig. 5.Sheet as shown in the figure
Data management apparatus in embodiment may include: processor 510, memory 520 and communication interface 530.Above-mentioned processor
510, memory 520 and communication interface 530 are connected by bus 540.It is specific:
Communication interface 530, for executing the function of receiving unit 401, for receiving what user submitted by WorkForm System
Data modification request work order, above-mentioned data modification request work order includes work order information；Processor 510, for executing modification unit
402 function, for being modified according to above-mentioned data modification request work order to above-mentioned MySQL database；Above-mentioned processor
510, it is also used to execute the function of recording unit 403, it is above-mentioned to repair for recording the modification information of above-mentioned data modification request work order
It converts to breath and is used to indicate the data modified in above-mentioned database；Above-mentioned processor 510, is also used to execute storage unit 404
Function, for above-mentioned modification information to be saved in search engine；Above-mentioned processor 510, is also used to execute associative cell 405
Function, for above-mentioned modification information and above-mentioned work order information to be associated.
In a kind of implementation, above-mentioned work order information includes SQL statement；Above-mentioned processor 510, is also used to execute authentication unit
406, for carrying out syntactic analysis to above-mentioned SQL statement；Above-mentioned processor 510, specifically for being that there is no ask in analysis result
In the case where topic, calls above-mentioned SQL statement to execute and above-mentioned modified to above-mentioned MySQL database according to above-mentioned work order information
Operation.
In a kind of implementation, above-mentioned processor 510 is also used to execute the function of duplicate checking unit 407, in analysis result
In the case that there is no problem, Hash processing is carried out to above-mentioned SQL statement by above-mentioned WorkForm System, obtains cryptographic Hash；Sentence
Whether above-mentioned cryptographic Hash of breaking is existing；If it does not, call above-mentioned SQL statement execute it is above-mentioned according to above-mentioned work order information to upper
State the operation that MySQL database is modified.
In a kind of implementation, above-mentioned processor 510 is also used in the case where above-mentioned cryptographic Hash is not present, and is saved above-mentioned
Cryptographic Hash；Above-mentioned processor 510, is also used to execute the function of numbered cell 408, above-mentioned for being generated by above-mentioned WorkForm System
The corresponding work order number of data modification request work order；Above-mentioned processor 510 is also used to above-mentioned work order number and above-mentioned cryptographic Hash and upper
Work order information is stated to be associated.
In a kind of implementation, above-mentioned processor 510 is also used to the keyword in above-mentioned work order number and above-mentioned search engine
Establish incidence relation.
In a kind of implementation, above-mentioned processor 510 is also used to execute the function of generation unit 409, for according to above-mentioned
After data modification request work order modifies to above-mentioned MySQL database, corresponding binlog log is generated；Above-mentioned processor
510, specifically for extracting the library name modified in above-mentioned MySQL database, list name, major key ID from above-mentioned binlog log
And the data of modification front and back, using the modification information as above-mentioned data modification request work order.
In a kind of implementation, above-mentioned communication interface 530 is also used to obtain the inquiry that user is inputted by above-mentioned search engine
Information；Above-mentioned processor 510, is also used to execute the function of searching unit 410, in above-mentioned search engine search with it is above-mentioned
The matched target keywords of query information, and the associated target work order number of above-mentioned target keywords is searched, then in above-mentioned work order
Inquiry and the associated target work order information of above-mentioned target work order number in system；It is single to be also used to execute output for above-mentioned communication interface 530
The function of member 411, for exporting above-mentioned target work order information by above-mentioned WorkForm System and being closed with above-mentioned target work order information
The above-mentioned target modification information of connection.
It should be appreciated that in the embodiment of the present application, alleged processor 510 can be central processing unit (Central
Processing Unit, CPU), which can also be other general processors, digital signal processor (Digital
Signal Processor, DSP), specific integrated circuit (Application Specific Integrated Circuit,
ASIC), ready-made programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic
Device, discrete gate or transistor logic, discrete hardware components etc..General processor can be microprocessor or this at
Reason device is also possible to any conventional processor etc..
The memory 520 may include read-only memory and random access memory, and to processor 510 provide instruction and
Data.The a part of of memory 520 can also include nonvolatile RAM.For example, memory 520 can also be deposited
Store up the information of device type.
Computer readable storage medium can be the internal storage unit of the data management apparatus of aforementioned any embodiment, example
Such as the hard disk or memory of data management apparatus.The external storage that computer readable storage medium is also possible to data management apparatus is set
Plug-in type hard disk that is standby, such as being equipped on data management apparatus, intelligent memory card (Smart Media Card, SMC), safe number
Word (Secure Digital, SD) card, flash card (Flash Card) etc..Further, computer readable storage medium may be used also
With the internal storage unit both including data management apparatus or including External memory equipment.Computer readable storage medium is for depositing
Other programs and data needed for storing up computer program and data management apparatus.Computer readable storage medium can be also used for
Temporarily store the data that has exported or will export.
In the specific implementation, number provided by the embodiments of the present application can be performed in processor 510 described in the embodiment of the present application
Implementation described in first embodiment and second embodiment according to management method also can be performed the embodiment of the present application and be retouched
The implementation for the data administrator stated, details are not described herein.
Those of ordinary skill in the art may be aware that list described in conjunction with the examples disclosed in the embodiments of the present disclosure
Member and algorithm steps, can be realized with electronic hardware, computer software, or a combination of the two, in order to clearly demonstrate hardware
With the interchangeability of software, each exemplary composition and step are generally described according to function in the above description.This
A little functions are implemented in hardware or software actually, the specific application and design constraint depending on technical solution.Specially
Industry technical staff can realize described function to each specific application using different data management method, but this
Kind is realized it is not considered that exceeding scope of the present application.
It is apparent to those skilled in the art that for convenience of description and succinctly, the number of foregoing description
It, can be with reference in aforementioned data management method embodiment according to the specific work process of management equipment, data administrator and unit
Corresponding process, details are not described herein.
In several embodiments provided herein, it should be understood that disclosed data administrator, data management
Equipment and data managing method, may be implemented in other ways.For example, Installation practice described above is only to show
Meaning property, for example, the division of unit, only a kind of logical function partition, there may be another division manner in actual implementation,
Such as multiple units or components can be combined or can be integrated into another system, or some features can be ignored, or not hold
Row.In addition, shown or discussed mutual coupling, direct-coupling or communication connection can be through some interfaces, dress
It sets or the indirect coupling or communication connection of unit, is also possible to electricity, mechanical or other forms connections.
Unit may or may not be physically separated as illustrated by the separation member, shown as a unit
Component may or may not be physical unit, it can and it is in one place, or may be distributed over multiple networks
On unit.It can select some or all of unit therein according to the actual needs to realize the mesh of the embodiment of the present application scheme
's.
It, can also be in addition, each functional unit in each embodiment of the application can integrate in one processing unit
It is that each unit physically exists alone, is also possible to two or more units and is integrated in one unit.It is above-mentioned integrated
Unit both can take the form of hardware realization, can also realize in the form of software functional units.
It, can if integrated unit is realized in the form of SFU software functional unit and when sold or used as an independent product
To be stored in a computer readable storage medium.Based on this understanding, the technical solution of the application substantially or
Say that all or part of the part that contributes to existing technology or the technical solution can embody in the form of software products
Out, which is stored in a storage medium, including some instructions are used so that a computer equipment
The whole of (can be personal computer, data management apparatus or the network equipment etc.) execution each embodiment method of the application
Or part steps.And storage medium above-mentioned includes: USB flash disk, mobile hard disk, read-only memory (ROM, Read-Only
Memory), random access memory (RAM, Random Access Memory), magnetic or disk etc. are various can store journey
The medium of sequence code.
Claims (10)
1. a kind of data managing method is applied to MySQL database characterized by comprising
The data modification request work order that user submits is received by WorkForm System, the data modification request work order includes work order letter
Breath；
It is modified according to the data modification request work order to the MySQL database；
The modification information of the data modification request work order is recorded, the modification information is used to indicate in the database and is modified
Data；
The modification information is saved in search engine, and the modification information and the work order information are associated.
2. described to pass through work order the method according to claim 1, wherein the work order information includes SQL statement
After system receives the data modification request work order that user submits, the method also includes:
Syntactic analysis is carried out to the SQL statement；
In the case where analyzing result is that there is no problem, the SQL statement is called to execute described according to the work order information pair
The operation that the MySQL database is modified.
3. according to the method described in claim 2, it is characterized in that, it is described analyze result be there is no problem in the case where,
The method also includes:
Hash processing is carried out to the SQL statement by the WorkForm System, obtains cryptographic Hash；
Judge whether the cryptographic Hash is existing；
If it does not, calling the SQL statement execution is described to be repaired according to the work order information to the MySQL database
The operation changed.
4. according to the method described in claim 3, it is characterized in that, the method also includes:
In the case where the cryptographic Hash is not present, the cryptographic Hash is saved；
Generate the corresponding work order number of the data modification request work order by the WorkForm System, and by the work order number with it is described
Cryptographic Hash and the work order information are associated.
5. according to the method described in claim 4, it is characterized in that, the method also includes:
Keyword in the work order number and described search engine is established into incidence relation.
6. the method according to claim 1, wherein it is described according to the data modification request work order to described
After MySQL database is modified, the method also includes:
Generate corresponding binlog log；
The modification information for recording the data modification request work order, comprising:
The library name modified in the MySQL database, list name, major key ID and modification are extracted from the binlog log
The data of front and back, using the modification information as the data modification request work order.
7. according to claim 5 method, which is characterized in that the method also includes:
Obtain the query information that user is inputted by described search engine；
Search and the matched target keywords of the query information in described search engine, and search the target keywords and close
The target work order number of connection；
Inquiry and the associated target work order information of the target work order number in the WorkForm System；
By the WorkForm System export the target work order information and with the associated target of the target work order information
Modification information.
8. a kind of data administrator characterized by comprising
Receiving unit, for receiving the data modification request work order that user submits, the data modification request by WorkForm System
Work order includes work order information；
Unit is modified, for modifying according to the data modification request work order to the MySQL database；
Recording unit, for recording the modification information of the data modification request work order, the modification information is used to indicate described
The data modified in database；
Storage unit, for the modification information to be saved in search engine；
Associative cell, for the modification information and the work order information to be associated.
9. a kind of data management apparatus, which is characterized in that including processor, memory and communication interface, the processor, storage
Device and communication interface are connected with each other, wherein the data management apparatus carries out data by the communication interface and other equipment
Interaction, the memory is for storing computer program, and the computer program includes program instruction, and the processor is configured
For calling described program to instruct, to execute the method according to claim 1 to 7.
10. a kind of computer readable storage medium, which is characterized in that the computer storage medium is stored with computer program,
The computer program includes program instruction, and described program instruction is executed by processor, to execute as claim 1-7 is any
Method described in.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910366894.9A CN110222028B (en) | 2019-04-30 | 2019-04-30 | Data management method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910366894.9A CN110222028B (en) | 2019-04-30 | 2019-04-30 | Data management method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110222028A true CN110222028A (en) | 2019-09-10 |
| CN110222028B CN110222028B (en) | 2022-11-15 |
Family
ID=67820284
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910366894.9A Active CN110222028B (en) | 2019-04-30 | 2019-04-30 | Data management method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110222028B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111241125A (en) * | 2020-01-08 | 2020-06-05 | 成都嗨学洛子教育科技有限公司 | Method and device for recording operation log, electronic equipment and storage medium |
| CN111625552A (en) * | 2020-05-20 | 2020-09-04 | 北京百度网讯科技有限公司 | Data collection method, device, equipment and readable storage medium |
| CN111651431A (en) * | 2020-06-09 | 2020-09-11 | 中国雄安集团数字城市科技有限公司 | Database service oriented management flow standardization method |
| CN112862449A (en) * | 2021-03-02 | 2021-05-28 | 岭东核电有限公司 | Structural chemical industry bill generation method and device, computer equipment and storage medium |
| CN117153361A (en) * | 2023-10-30 | 2023-12-01 | 苏州阿基米德网络科技有限公司 | Data processing method and device of medical equipment asset management system |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080034393A1 (en) * | 2006-08-02 | 2008-02-07 | Aaron Crayford | Distribution of content and advertisement |
| CN102572134A (en) * | 2010-12-30 | 2012-07-11 | 上海博泰悦臻电子设备制造有限公司 | Work order processing method, work order building system and work order processing system |
| WO2014000825A1 (en) * | 2012-06-29 | 2014-01-03 | Data2Knowledge Gmbh | A method for maintaining one or more table values for a number of tables in a database system |
| CN103514166A (en) * | 2012-06-15 | 2014-01-15 | 阿里巴巴集团控股有限公司 | Method and device for SQL inspection |
| CN103729442A (en) * | 2013-12-30 | 2014-04-16 | 华为技术有限公司 | Method for recording event logs and database engine |
| CN103745283A (en) * | 2012-10-17 | 2014-04-23 | 镇江雅迅软件有限责任公司 | Method of automatically judging workflow transfer node |
| CN104376365A (en) * | 2014-11-28 | 2015-02-25 | 国家电网公司 | Method for constructing information system running rule libraries on basis of association rule mining |
| CN105373541A (en) * | 2014-08-22 | 2016-03-02 | 博雅网络游戏开发（深圳）有限公司 | Processing method and system for data operation request of database |
| CN105654311A (en) * | 2015-12-24 | 2016-06-08 | 北京京东尚科信息技术有限公司 | User information providing method and device |
| CN106716416A (en) * | 2014-11-19 | 2017-05-24 | 株式会社英弗麦斯 | Data retrieval apparatus, program and recording medium |
| CN106874440A (en) * | 2017-02-07 | 2017-06-20 | 杭州秘猿科技有限公司 | A kind of block chain state storage method based on SQL database |
| US20170264428A1 (en) * | 2016-03-08 | 2017-09-14 | Manifold Technology, Inc. | Data storage system with blockchain technology |
| CN108629564A (en) * | 2018-04-28 | 2018-10-09 | 中国船舶重工集团公司第七〇九研究所 | A kind of Management in Large Scale Project system and method based on block chain technology |
| CN108876122A (en) * | 2018-05-31 | 2018-11-23 | 康键信息技术（深圳）有限公司 | Processing method, device, computer equipment and the storage medium of batch work order |
| CN108876121A (en) * | 2018-05-31 | 2018-11-23 | 康键信息技术（深圳）有限公司 | Worksheet method, apparatus, computer equipment and storage medium |
-
2019
- 2019-04-30 CN CN201910366894.9A patent/CN110222028B/en active Active
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080034393A1 (en) * | 2006-08-02 | 2008-02-07 | Aaron Crayford | Distribution of content and advertisement |
| CN102572134A (en) * | 2010-12-30 | 2012-07-11 | 上海博泰悦臻电子设备制造有限公司 | Work order processing method, work order building system and work order processing system |
| CN103514166A (en) * | 2012-06-15 | 2014-01-15 | 阿里巴巴集团控股有限公司 | Method and device for SQL inspection |
| WO2014000825A1 (en) * | 2012-06-29 | 2014-01-03 | Data2Knowledge Gmbh | A method for maintaining one or more table values for a number of tables in a database system |
| CN103745283A (en) * | 2012-10-17 | 2014-04-23 | 镇江雅迅软件有限责任公司 | Method of automatically judging workflow transfer node |
| CN103729442A (en) * | 2013-12-30 | 2014-04-16 | 华为技术有限公司 | Method for recording event logs and database engine |
| CN105373541A (en) * | 2014-08-22 | 2016-03-02 | 博雅网络游戏开发（深圳）有限公司 | Processing method and system for data operation request of database |
| CN106716416A (en) * | 2014-11-19 | 2017-05-24 | 株式会社英弗麦斯 | Data retrieval apparatus, program and recording medium |
| CN104376365A (en) * | 2014-11-28 | 2015-02-25 | 国家电网公司 | Method for constructing information system running rule libraries on basis of association rule mining |
| CN105654311A (en) * | 2015-12-24 | 2016-06-08 | 北京京东尚科信息技术有限公司 | User information providing method and device |
| US20170264428A1 (en) * | 2016-03-08 | 2017-09-14 | Manifold Technology, Inc. | Data storage system with blockchain technology |
| CN106874440A (en) * | 2017-02-07 | 2017-06-20 | 杭州秘猿科技有限公司 | A kind of block chain state storage method based on SQL database |
| CN108629564A (en) * | 2018-04-28 | 2018-10-09 | 中国船舶重工集团公司第七〇九研究所 | A kind of Management in Large Scale Project system and method based on block chain technology |
| CN108876122A (en) * | 2018-05-31 | 2018-11-23 | 康键信息技术（深圳）有限公司 | Processing method, device, computer equipment and the storage medium of batch work order |
| CN108876121A (en) * | 2018-05-31 | 2018-11-23 | 康键信息技术（深圳）有限公司 | Worksheet method, apparatus, computer equipment and storage medium |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111241125A (en) * | 2020-01-08 | 2020-06-05 | 成都嗨学洛子教育科技有限公司 | Method and device for recording operation log, electronic equipment and storage medium |
| CN111625552A (en) * | 2020-05-20 | 2020-09-04 | 北京百度网讯科技有限公司 | Data collection method, device, equipment and readable storage medium |
| CN111625552B (en) * | 2020-05-20 | 2024-01-02 | 北京百度网讯科技有限公司 | Data collection method, device, equipment and readable storage medium |
| CN111651431A (en) * | 2020-06-09 | 2020-09-11 | 中国雄安集团数字城市科技有限公司 | Database service oriented management flow standardization method |
| CN111651431B (en) * | 2020-06-09 | 2023-06-27 | 中国雄安集团数字城市科技有限公司 | Database service-oriented management flow standardization method |
| CN112862449A (en) * | 2021-03-02 | 2021-05-28 | 岭东核电有限公司 | Structural chemical industry bill generation method and device, computer equipment and storage medium |
| CN117153361A (en) * | 2023-10-30 | 2023-12-01 | 苏州阿基米德网络科技有限公司 | Data processing method and device of medical equipment asset management system |
| CN117153361B (en) * | 2023-10-30 | 2024-01-26 | 苏州阿基米德网络科技有限公司 | Data processing method and device of medical equipment asset management system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110222028B (en) | 2022-11-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110222028A (en) | A kind of data managing method, device, equipment and storage medium | |
| JP6940662B2 (en) | Methods and systems for the protection and verification of identities and certificates via the blockchain | |
| US11182366B2 (en) | Comparing data stores using hash sums on disparate parallel systems | |
| CN110782240B (en) | Business data processing method and device, computer equipment and storage medium | |
| JP7126174B2 (en) | Verification system and method for collaboration of blockchain and off-chain devices | |
| US8949166B2 (en) | Creating and processing a data rule for data quality | |
| CN106603281A (en) | Configuration file management method and system | |
| US20200174870A1 (en) | Automated information technology system failure recommendation and mitigation | |
| CN105447046A (en) | Distributed system data consistency processing method, device and system | |
| CN109614262B (en) | Service checking method, device and computer readable storage medium | |
| WO2017165018A1 (en) | Automated event id field analysis on heterogeneous logs | |
| US10089334B2 (en) | Grouping of database objects | |
| JP7279904B2 (en) | Chain data verification system and method | |
| CN109359283A (en) | Method of summary, terminal device and the medium of list data | |
| CN108696511A (en) | A kind of public notification of information method, apparatus and relevant device based on block chain | |
| CN114500690B (en) | Interface data processing method and device, electronic equipment and storage medium | |
| CN109905293A (en) | A kind of terminal device recognition methods, system and storage medium | |
| CN111563016B (en) | Log collection and analysis method and device, computer system and readable storage medium | |
| CN110109824B (en) | Big data autoregression test method and device, computer equipment and storage medium | |
| CN110088744A (en) | A kind of database maintenance method and its system | |
| CN111680104B (en) | Data synchronization method, device, computer equipment and readable storage medium | |
| CN108460068A (en) | Method, apparatus, storage medium and the terminal that report imports and exports | |
| CN113377740A (en) | Railway metadata management method, application method and device | |
| CN109324963A (en) | The method and terminal device of automatic test profitable result | |
| CN111352818A (en) | Application program performance analysis method and device, storage medium and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |