CN113111066A - Automatic online method, device and system for database operation work order and computer equipment - Google Patents
Automatic online method, device and system for database operation work order and computer equipment Download PDFInfo
- Publication number
- CN113111066A CN113111066A CN202110426120.8A CN202110426120A CN113111066A CN 113111066 A CN113111066 A CN 113111066A CN 202110426120 A CN202110426120 A CN 202110426120A CN 113111066 A CN113111066 A CN 113111066A
- Authority
- CN
- China
- Prior art keywords
- work order
- online
- information
- work
- rollback
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 69
- 230000008859 change Effects 0.000 claims abstract description 81
- 238000012550 audit Methods 0.000 claims abstract description 56
- 238000012545 processing Methods 0.000 claims description 21
- 230000000007 visual effect Effects 0.000 claims description 19
- 238000012552 review Methods 0.000 claims description 13
- 238000012795 verification Methods 0.000 claims description 13
- 238000012217 deletion Methods 0.000 claims description 5
- 230000037430 deletion Effects 0.000 claims description 5
- 238000003780 insertion Methods 0.000 claims description 5
- 230000037431 insertion Effects 0.000 claims description 5
- 230000004044 response Effects 0.000 claims description 3
- 230000008569 process Effects 0.000 description 18
- 238000004590 computer program Methods 0.000 description 10
- 238000010586 diagram Methods 0.000 description 8
- 230000000694 effects Effects 0.000 description 6
- 238000013500 data storage Methods 0.000 description 4
- 230000000644 propagated effect Effects 0.000 description 3
- 230000003252 repetitive effect Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 238000012827 research and development Methods 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention belongs to the field of housekeeping services, and provides a method, a device, a system and computer equipment for automatically online database operation work orders, wherein the method comprises the following steps: establishing a work order on-line platform, and receiving a database operation work order on-line request initiated by a user through the work order on-line platform; allocating storage space for different users to store database operation work orders and online states thereof initiated by different users; automatically identifying the type of the work order based on the work order parameters, and performing matching audit by using a preset audit rule; storing the checked database operation work order into a work order list to be on-line; and performing online operation on the work orders in the work order list to be online, generating corresponding rollback information in real time when the work orders are executed, and performing rollback information auditing and recording on the rollback information. The invention can effectively improve the auditing efficiency, reduce the cost, effectively solve the problems of mixed execution of multiple work orders such as the work order of table structure change and the work order of the table database, and the like, and also improve the online efficiency.
Description
Technical Field
The invention belongs to the technical field of internet, particularly relates to the field of housekeeping service, and more particularly relates to a method, a device, a system and computer equipment for automatically online database operation worksheets.
Background
In recent years, with the age-old population times and the "second-birth" times, the demand for home services is increasing and various home services are increasing, and users mainly search for home service staff through offline or online home service systems. The home services include a month-sister service, a nurse service, and the like. The existing household service system can provide on-line reservation household service items for consumers, and other requirements can only depend on telephone communication of brokers or promoters or on-line social tools, wherein the on-line social tools comprise Instant Messaging (IM) chat tools.
For Database security, most of the existing home services systems manage databases related to various home services by Database administrators (DBAs). In order to avoid the risk brought to the database performance by tasks such as database updating and Query, the DBA needs to examine and evaluate whether an SQL (Structured Query Language) work order submitted by research and development personnel is reasonable and effective, and evaluate that a task corresponding to the SQL work order can be safely executed on a corresponding database through the rear.
The prior art has the following problems: 1) the more SQL standards, the more laborious manual review; 2) the auditing effect depends on the individual ability and detection method of the DBA; 3) from the audit to the execution, the manual execution is needed on the corresponding database, and when the database is a distributed database, the correctness and timeliness of manual operation are difficult to ensure. All the above results in that the dependency of the existing manual review mode on the DBA is too large, so that the review efficiency of the SQL work order is low. In addition, the method also has the problems of mixed execution of multiple work orders such as the work order of changing the table structure and the work order of the table database, failure of generating the text information of the rollback SQL due to the mixed execution, low online efficiency and the like.
Therefore, there is a need for a more efficient method for automatically bringing a database operation work order online.
Disclosure of Invention
Technical problem to be solved
The invention aims to solve the problems that the error-free performance and timeliness of manual operation are difficult to ensure, the dependence of the existing auditing mode on DBA is too large, the manual auditing efficiency is low, the cost is high, the multiple work orders such as a table structure change work order and a table database work order are mixed and executed, the generated rollback SQL text information is invalid and the online efficiency is low due to the mixed execution, and the like.
(II) technical scheme
In order to solve the technical problem, an aspect of the present invention provides an automatic online method for database operation work orders, including: establishing a work order on-line platform, and receiving a database operation work order on-line request initiated by a user through the work order on-line platform, wherein the on-line request comprises user information, work order parameters and database operation statements; allocating storage space for different users to store database operation work orders and online states thereof initiated by different users; automatically identifying the type of the work order based on the work order parameters, and performing matching audit by using a preset audit rule; storing the checked database operation work order into a work order list to be on-line; and performing online operation on the work orders in the work order list to be online, generating corresponding rollback information in real time when the work orders are executed, and performing rollback information auditing and recording on the rollback information.
According to the preferred embodiment of the present invention, the database is an SQL database, and the work order types include DDL work orders and DML work orders.
According to the preferred embodiment of the present invention, the work order parameters include domain name, port, database name, and SQL text information.
According to a preferred embodiment of the present invention, further comprising: setting a first auditing rule, wherein the first auditing rule comprises first change keywords and prompt information corresponding to the first change keywords, the first change keywords are used for matching with changes of an auditing table structure, and the first change keywords comprise change keywords for creating a table, deleting the table and changing the table structure; the first examination rule also comprises a judgment rule, wherein the judgment rule comprises that the table structure in the work order is changed if only one first change keyword is successfully matched, and the table structure in the work order is changed if only one specific change keyword is successfully matched.
According to a preferred embodiment of the present invention, further comprising: setting a second auditing rule, wherein the setting of the second auditing rule comprises setting second change keywords for matching with auditing table data changes and prompt information corresponding to the second change keywords, and the second change keywords comprise inquiry, insertion, update and deletion; the second examination rule also comprises a judgment rule, wherein the judgment rule comprises that the table data in the work order is changed if only one second change keyword is successfully matched, and the table data in the work order is changed if only one specific change keyword is successfully matched.
According to a preferred embodiment of the present invention, the generating corresponding rollback information in real time when each work order is executed, and performing rollback information audit on the rollback information includes: each work order during execution comprises at least one piece of SQL text information, each piece of SQL text information comprises corresponding rollback information, and all the rollback information can be displayed in corresponding modules, wherein the rollback information comprises rollback SQL text information and rollback detail information; and judging the error operation or other error operations in the work order execution according to the rollback SQL text information and the rollback detail information in the rollback information so as to complete rollback information audit.
According to a preferred embodiment of the invention, said database is used for a housekeeping service; the step of performing online operation on the work orders in the to-be-online work order list comprises the following steps: setting a work order execution strategy, wherein the work order execution strategy comprises the following steps: and judging whether the current time is in a low-peak business period of the home administration service, wherein when the current time is in the low-peak business period of the home administration service, the DDL work orders in the to-be-on-line list are subjected to on-line processing according to the to-be-on-line sequence.
According to a preferred embodiment of the present invention, the performing online processing includes: setting execution priorities of a DDL (distributed data language) work order and a DML (digital document language) work order according to the online time, wherein the priority of the DDL work order is higher than that of the DML work order when the online time is a business low peak period of the home service; and when the online time is other times of the business of the home services, the priority of the DDL work order is lower than that of the DML work order.
According to a preferred embodiment of the present invention, comprises: and a functional button for executing operation and withdrawing operation is arranged on the visual page to be on-line, and the functional button is used for executing operation or withdrawing operation on the work order which passes the matching examination.
According to a preferred embodiment of the present invention, comprises: returning the refused DDL work order or DML work order to the corresponding user; and storing the execution information and the rollback information of each work order into a database, directly inquiring correct information before misoperation from the rollback information, and re-executing the correct information.
The invention provides a work order automatic auditing device in a second aspect, which comprises a server and a visual interface, wherein the device is connected with a plurality of clients on each housekeeping service line and a work order online platform, and the server comprises an identification file for automatically identifying work order parameters, an auditing rule file for automatically matching auditing, a storage space for storing database operation work orders of different users and related data thereof, and an execution file for executing the work order online; the processor is used for receiving the database operation work order on-line request shared by the work order on-line platform, performing work order parameter identification on the work order, determining the work order type of the work order, calling a corresponding auditing rule and performing automatic matching auditing; the visual interface is used for displaying a work order list to be checked or checked, a work order list to be on-line or above, providing corresponding visual operable pages for users with different authorities, and the server receives page operation information of each user and returns response information to each user.
The third aspect of the present invention provides an automatic on-line system for database operation work orders, which comprises the automatic work order auditing device of the present invention, and further comprises: the system comprises an establishing module, a verification module and a verification module, wherein the establishing module is used for establishing a work order online platform which is connected with the work order self-use verification device, and receiving a database operation work order online request initiated by a user through the work order online platform, and the online request comprises user information, work order parameters and database operation statements; the distribution module is used for distributing storage space for different users so as to store database operation work orders initiated by different users and online states thereof; the matching auditing module is used for automatically identifying the work order type based on the work order parameters and performing matching auditing by using a preset auditing rule; the storage module is used for storing the checked database operation work order into a work order list to be on-line; and the on-line operation module is used for carrying out on-line operation on the work orders in the work order list to be on-line, generating corresponding rollback information in real time when the work orders are executed, and auditing and recording the rollback information.
The fourth aspect of the present invention further provides a computer device, which includes a processor and a memory, where the memory is used to store a computer executable program, and when the computer program is executed by the processor, the processor executes the automatic online method for the database operation work order.
The fifth aspect of the present invention further provides a computer program product, which stores a computer executable program, and when the computer executable program is executed, the method for automatically online database operation work orders is implemented.
(III) advantageous effects
Compared with the prior art, the invention can effectively manage the auditing process of each work order by adding the work order parameter identification process and the user permission judgment process, can improve the auditing efficiency and can also improve the safety of data processing; the storage space is allocated for different users to store database operation work orders and related data thereof initiated by different users, so that more reasonable data storage can be realized, and each work order can be called or processed more quickly to further improve the work order auditing efficiency; the work order type is automatically judged by identifying the work order parameters of each work order, the auditing rule corresponding to each work order is determined according to the judged work order type, and the automatic matching auditing process is carried out, so that the automatic auditing of each work order is effectively realized, a database administrator (DBA) is not required to participate, and the influence of the table structure change work order on the online data service is effectively avoided; the corresponding priorities of the work orders and the table database work orders are changed by setting the table structure, an online sequence with a specific sequence is formed, online processing is carried out according to the online sequence, the auditing efficiency is effectively improved, the cost is reduced, the problems that the multiple work orders such as the table structure change work order and the table database work order are mixed and executed, and the generated rollback SQL text information is invalid due to the mixed execution are effectively solved, and the online efficiency is also improved.
Drawings
Fig. 1 is a flowchart of an example of an automatic on-line method of a database operation work order according to embodiment 1 of the present invention;
FIG. 2 is a flowchart of another example of a database operation work order automatic on-line method according to embodiment 1 of the present invention;
FIG. 3 is a flowchart of yet another example of a database operation work order automatic on-line method according to embodiment 1 of the present invention;
fig. 4 is a schematic view of an example of an automatic database operation work order audit device according to embodiment 2 of the present invention;
FIG. 5 is a schematic diagram of an example of a database operation work order automatic on-line system of embodiment 3 of the present invention;
FIG. 6 is a schematic diagram of another example of a database operation work order automatic on-line system of embodiment 3 of the present invention;
FIG. 7 is a schematic structural diagram of a computer apparatus according to embodiment 4 of the present invention;
fig. 8 is a schematic diagram of a computer program product of embodiment 4 of the present invention.
Detailed Description
In describing particular embodiments, specific details of structures, properties, effects, or other features are set forth in order to provide a thorough understanding of the embodiments by one skilled in the art. However, it is not excluded that a person skilled in the art may implement the invention in a specific case without the above-described structures, performances, effects or other features.
The flow chart in the drawings is only an exemplary flow demonstration, and does not represent that all the contents, operations and steps in the flow chart are necessarily included in the scheme of the invention, nor does it represent that the execution is necessarily performed in the order shown in the drawings. For example, some operations/steps in the flowcharts may be divided, some operations/steps may be combined or partially combined, and the like, and the execution order shown in the flowcharts may be changed according to actual situations without departing from the gist of the present invention.
The block diagrams in the figures generally represent functional entities and do not necessarily correspond to physically separate entities. That is, these functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different network and/or processing unit systems and/or microcontroller systems.
The same reference numerals denote the same or similar elements, components, or parts throughout the drawings, and thus, a repetitive description thereof may be omitted hereinafter. It will be further understood that, although the terms first, second, third, etc. may be used herein to describe various elements, components, or sections, these elements, components, or sections should not be limited by these terms. That is, these phrases are used only to distinguish one from another. For example, a first device may also be referred to as a second device without departing from the spirit of the present invention. Furthermore, the term "and/or", "and/or" is intended to include all combinations of any one or more of the listed items.
In the prior art, the problems of mixed execution of multiple work orders such as a table structure change work order and a table database work order, failure of generating rollback SQL text information, low online efficiency and the like caused by the mixed execution exist.
Because the influence of the change of the table structure on the online data service is larger than that of the change of the table data, and the influence factors of the change work order of the table data and the change work order of the table structure are different in online time. Therefore, the invention provides an automatic online method of a database operation work order, which can set automatic matching audit matching corresponding to a table structure change work order and a table database work order from the aspects of influence factors of the online time of the table data change work order and the table structure change work order and the influence on online database service, perform automatic matching audit, set the priority corresponding to the table structure change work order and the table database work order, form an online sequence with a specific sequence, and perform online processing according to the online sequence. Therefore, the method effectively improves the auditing efficiency, reduces the cost, effectively solves the problems of mixed execution of multiple work orders such as the work order of table structure change and the work order of the table database, and invalidation of the text information of the generated rollback SQL caused by the mixed execution, and also improves the online efficiency.
In order that the objects, technical solutions and advantages of the present invention will become more apparent, the present invention will be further described in detail with reference to the accompanying drawings in conjunction with the following specific embodiments.
In describing particular embodiments, specific details of structures, properties, effects, or other features are set forth in order to provide a thorough understanding of the embodiments by one skilled in the art. However, it is not excluded that a person skilled in the art may implement the invention in a specific case without the above-described structures, performances, effects or other features.
The flow chart in the drawings is only an exemplary flow demonstration, and does not represent that all the contents, operations and steps in the flow chart are necessarily included in the scheme of the invention, nor does it represent that the execution is necessarily performed in the order shown in the drawings. For example, some operations/steps in the flowcharts may be divided, some operations/steps may be combined or partially combined, and the like, and the execution order shown in the flowcharts may be changed according to actual situations without departing from the gist of the present invention.
The block diagrams in the figures generally represent functional entities and do not necessarily correspond to physically separate entities. That is, these functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different network and/or processing unit systems and/or microcontroller systems.
The same reference numerals denote the same or similar elements, components, or parts throughout the drawings, and thus, a repetitive description thereof may be omitted hereinafter. It will be further understood that, although the terms first, second, third, etc. may be used herein to describe various elements, components, or sections, these elements, components, or sections should not be limited by these terms. That is, these phrases are used only to distinguish one from another. For example, a first device may also be referred to as a second device without departing from the spirit of the present invention. Furthermore, the term "and/or", "and/or" is intended to include all combinations of any one or more of the listed items.
Example 1
Fig. 1 is a flowchart of an example of an automatic online method of a database operation work order according to embodiment 1 of the present invention.
As shown in fig. 1, an automatic online method for database operation work orders is provided, which specifically includes the following steps.
S101, establishing a work order on-line platform, and receiving a database operation work order on-line request initiated by a user through the work order on-line platform, wherein the on-line request comprises user information, work order parameters and database operation statements.
And S102, allocating storage space for different users to store database operation work orders initiated by different users and online states of the work orders.
And S103, automatically identifying the type of the work order based on the work order parameters, and performing matching audit by using a preset audit rule.
And S104, storing the checked database operation work order into a work order list to be on-line.
And S105, performing online operation on the work orders in the work order list to be online, generating corresponding rollback information in real time when the work orders are executed, and performing rollback information auditing and recording on the rollback information.
Firstly, in step S101, a work order on-line platform is established, and a database operation work order on-line request initiated by a user is received through the work order on-line platform, where the on-line request includes user information, work order parameters, and database operation statements.
Specifically, a work order online platform is established, and the work order online platform further comprises a work order automatic auditing device, and the work order automatic auditing device is used for auditing all work orders to be online and enabling the work orders passing the auditing to be online.
In this example, the database is for a home service, and is a SQL database related to each home service business, which includes a month-to-law service, a nurse service, and the like.
Further, when a database operation work order on-line request initiated by a user is received, the database operation work order on-line request is identified so as to identify the work order parameters of the work order.
Specifically, the work order parameters include a domain name, a port, a database name, and SQL text information.
Preferably, the work order types include a DDL work order (i.e., a table data change work order) and a DML work order (i.e., a table structure change work order).
It should be noted that the SQL text information is a text composed of SQL Language, and SQL is an abbreviation of Structured Query Language (Structured Query Language). The SQL language is a database query and programming language for accessing data and querying, updating, and managing relational database systems, and is also an extension of database script files.
Preferably, the work order types include a DDL work order and a DML work order. But not limited thereto, in other examples, other types of work orders may also be set according to the housekeeping service business.
As shown in fig. 2, a step S201 of parsing the user information and checking the user right is further included.
In step S201, the user information is analyzed and the user authority is checked to determine the operation authority of the user in the work order automatic checking apparatus.
Specifically, the information of the user account, the name, the belonging workgroup and the like of the user is analyzed, and the analyzed user account, the analyzed name, the belonging workgroup and the user information prestored in the user database are compared to judge whether the user has the authority and the authority.
More specifically, the user right includes uploading a work order, deleting the work order, checking the audit state of the work order, auditing the work order, and the like.
And further, returning a corresponding visual interface to the user according to the determined user authority.
For example, a user 1 sends a database operation work order on-line request to the work order on-line platform, the work order automatic auditing device analyzes the database operation work order on-line request, and performs user permission auditing to determine that the user 1 has permission to upload a work order and delete a work order, the work order automatic auditing device returns a visual interface to the user 1, and the visual interface includes an input box or an operation button for receiving the operation of the user 1, so that the user 1 performs the operations of uploading a work order, deleting a work order and the like.
Therefore, by adding the work order parameter identification process and the user permission judgment process, the auditing process of each work order can be effectively managed, the auditing efficiency can be improved, and the data processing safety can be improved.
It should be noted that the above description is only an example, and the present invention is not limited thereto.
Next, in step S102, a storage space is allocated to different users to store the database operation work orders initiated by different users and their online states.
Specifically, according to the type of the housekeeping service and the determined user permission, a storage module of the work order online platform allocates storage space for different users.
In another example, the method further comprises the step of allocating storage space for different users on a storage module of the work order online platform according to the type of the housekeeping service business, the type of the housekeeping service product and the online time of each product.
In yet another example, a storage module of the work order online platform allocates storage space for the user according to the type of the housekeeping service business, the user authority, and/or the work order type.
And further, storing information data such as database operation work orders, work order on-line requests, work order auditing results, on-line states and the like initiated by different users into storage spaces corresponding to the users.
For example, the relevant data of each work order from each time node of the work order application, the audit, the on-line and the like are recorded, the relevant data comprise the account number, the uploading time, the audit state, whether error information exists, influence information, whether the work order is on-line, the on-line state, the work order number and/or the work order type and the like of the user, and all the relevant data are associated by using the user account number or the work order number.
Therefore, storage space is allocated for different users to store database operation work orders and related data thereof initiated by different users, more reasonable data storage can be realized, and each work order can be called or processed more quickly to further improve the work order auditing efficiency.
It should be noted that the above description is only given by way of example, and the present invention is not limited thereto.
Next, in step S103, a work order type is automatically identified based on the work order parameters, and a preset auditing rule is used for matching and auditing.
In this example, the work order automatic auditing device identifies the on-line request of the operation work order to identify the work order parameters of the work order, automatically identifies the work order type, and determines the corresponding auditing rule to perform matching auditing.
The physical meaning and specific parameters included in the work order parameters in this step are the same as those indicated by the work order parameters in step S101, and therefore, the description thereof will be omitted.
As shown in fig. 3, the method further includes a step S301 of setting an audit rule for matching audit.
In step S301, an audit rule for matching audit is set.
Specifically, a first audit rule is set, wherein the first audit rule includes first change keywords set for matching audit table structure changes and prompt information corresponding to the first change keywords, and the first change keywords include change keywords for creating a table, deleting the table, and changing the table structure.
Further, the first audit rule further includes a judgment rule, where the judgment rule includes that only one first change keyword is successfully matched to indicate that the table structure in the work order has been changed, and only a specific change keyword is successfully matched to indicate that the table structure in the work order has been changed.
Preferably, a second review rule is set, wherein the setting of the second review rule includes setting second change keywords for matching review table data changes and prompt information corresponding to each second change keyword, and the second change keywords include query, insertion, update and deletion.
Further, the second auditing rule further includes a judgment rule, where the judgment rule includes that only one second change keyword is successfully matched to indicate that the form data in the work order has a change, and only a specific change keyword is successfully matched to indicate that the form data in the work order has a change.
For example, the domain name in the work order parameters of the identified current work order is jz x rm.db.djdns.cn, the database name is d1, the port is k1, and the SQL text message is delete from db x-domain.
Specifically, the user 2 is a work order auditor, and the user 2 starts an automatic matching audit process by clicking an audit button corresponding to each work order, and then the background automatically identifies the work order type according to the work order parameters, where the work order type is a DML work order, determines a first audit rule corresponding to the DML, audits the current work order according to the determined first audit rule, and returns an audit result to the user 2 in a visual interface manner.
In another example, user 2 initiates an automated matching review process by manually entering work order parameters for the current work order on the visual review interface. For example, the back end judges the SQL text information in the current work order through regular expression according to the first change keyword to determine an audit state, and returns error information (including syntax error information) or warning information and audit pass information, where the audit state includes audit pass, audit reject, review after modification, and the like.
Therefore, the work order type is automatically judged by identifying the work order parameters of each work order, the auditing rule corresponding to each work order is determined according to the judged work order type, and the automatic matching auditing process is carried out, so that the automatic auditing of each work order is effectively realized without the participation of a database administrator (DBA), and the influence of the change of the table structure on the data service on the line is effectively avoided.
It should be noted that the above description is only given as a preferred example, and the present invention is not limited thereto.
Next, in step S104, the checked database operation work order is stored in the work order list to be on-line.
In this example, the visualization interface includes DDL audit, DML audit, DDL to go online list, DML to go online list, automatic online list, and the like.
On one hand, the work order automatic auditing device stores the database operation work orders passing the auditing into the work order list to be on-line, and the user as the auditing personnel can check the auditing result from the DDL or DML to be on-line.
On the other hand, the automatic work order auditing device returns the refusal information to the corresponding user for the DDL work order or the DML work order which is not approved.
Preferably, when each work order is executed, corresponding rollback information is generated in real time, and rollback information is audited for the rollback information.
It should be noted that the above description is only given by way of example, and the present invention is not limited thereto.
Next, in step S105, performing online operation on the work order in the to-be-online work order list, generating corresponding rollback information in real time when the work order is executed, and performing rollback information audit and recording on the rollback information.
Preferably, the method further comprises setting a work order execution strategy, wherein the work order execution strategy comprises: and judging whether the current time is in a low-peak business period of the home administration service, wherein when the current time is in the low-peak business period of the home administration service, the DDL work orders in the to-be-on-line list are subjected to on-line processing according to the to-be-on-line sequence.
Specifically, the execution priority of the DDL work order and the DML work order is set according to the on-line time of each work order, and when the on-line time of each work order is a business low peak period of the home service, the priority of the DDL work order is higher than that of the DML work order.
Further, when the business served for the home is in other periods in the online time, the priority of the DDL work order is lower than that of the DML work order.
In this example, on a visual page to be on-line of the automatic operation work order on-line platform, an execution operation button and a withdrawal operation button are provided for operating each work order, so that a user with an operation right performs an execution operation or a withdrawal operation on a work order that passes the matching audit by using the function buttons.
Preferably, the corresponding rollback information is generated in real time when each work order is executed, and rollback information audit is performed on the rollback information.
Specifically, each work order during execution includes at least one piece of SQL text information, each piece of SQL text information includes corresponding rollback information, and all the rollback information may be displayed in a corresponding module, where the rollback information includes rollback SQL text information and rollback detail information.
More specifically, a work order may have a SQL text message or a plurality of SQL text messages during execution, and each SQL text message may generate a corresponding rollback message.
For example, the work order number is 0011, the SQL text information of the work order 0011 at execution time includes "INSERT int tb _ aggregate _ subset _ config '(' id ',' category _ id ',' service _ id ',' city _ id '… …' type ',' money ',' create _ time ',' update _ time ') VALUES (' 229 ',' 201 ',' 1 ',' 37 '… …' 0 ',' 10000 ',' 2020-12-3111: 00 ',' 2020-12-3111: 00 '), and the generated rollback information includes" DELETE FROM' dbjz _ zt _ casepo '. tb _ aggregate _ subset _ config' 229 ═ wh; ".
Further, according to the rollback SQL text information and the rollback detail information in the rollback information, error operation or other error operation in the work order execution is judged so as to complete rollback information audit.
Preferably, the execution information and the rollback information of each work order are stored in a database, correct information before misoperation is directly inquired from the rollback information, and the correct information is re-executed.
Therefore, the corresponding priority of the work order and the work order of the table database is changed by setting the table structure, an online sequence with a specific sequence is formed, online processing is carried out according to the online sequence, the auditing efficiency is effectively improved, the cost is reduced, the problems of mixed execution of the work orders of the table structure change work order and the work order of the table database and the like and failure of generating the rollback SQL text information due to the mixed execution are effectively solved, and the online efficiency is also improved.
It should be noted that the above description is only given by way of example, and the present invention is not limited thereto.
Compared with the prior art, the invention can effectively manage the auditing process of each work order by adding the work order parameter identification process and the user permission judgment process, can improve the auditing efficiency and can also improve the safety of data processing; the storage space is allocated for different users to store database operation work orders and related data thereof initiated by different users, so that more reasonable data storage can be realized, and each work order can be called or processed more quickly to further improve the work order auditing efficiency; the work order type is automatically judged by identifying the work order parameters of each work order, the auditing rule corresponding to each work order is determined according to the judged work order type, and the automatic matching auditing process is carried out, so that the automatic auditing of each work order is effectively realized, a database administrator (DBA) is not required to participate, and the influence of the table structure change work order on the online data service is effectively avoided; the corresponding priorities of the work orders and the table database work orders are changed by setting the table structure, an online sequence with a specific sequence is formed, online processing is carried out according to the online sequence, the auditing efficiency is effectively improved, the cost is reduced, the problems that the multiple work orders such as the table structure change work order and the table database work order are mixed and executed, and the generated rollback SQL text information is invalid due to the mixed execution are effectively solved, and the online efficiency is also improved.
Example 2
Embodiments of the apparatus of the present invention are described below, which may be used to perform method embodiments of the present invention. Details described in the system embodiments of the invention should be considered supplementary to the above-described method embodiments; reference is made to the above-described method embodiments for details not disclosed in the system embodiments of the invention.
Referring to fig. 4, an automatic work order audit apparatus 400 of the present invention will be described. The automatic work order auditing device 400 comprises a server 401 and a visual interface 402, and the device is connected with a plurality of clients on each housekeeping service line and a work order online platform, wherein the server 401 comprises an identification file for automatically identifying work order parameters, an auditing rule file for automatically matching auditing, a storage space for storing database operation work orders of different users and related data thereof, and an execution file for executing the work order online.
Specifically, the apparatus 400 further includes a processor 403, where the processor 403 is configured to receive a work order online request for database operation shared by the work order online platform, perform work order parameter identification on the work order, determine a work order type of the work order, call a corresponding audit rule, and perform automatic matching audit.
Further, the system further includes a visual interface 402, where the visual interface 402 is configured to display a list of work orders to be checked or checked, a list of work orders to be on-line or above, and provide corresponding visual operable pages for users with different permissions, and the server 403 receives page operation information of each user and returns response information to each user.
In this example, the work order parameters include domain name, port, database name, SQL text information.
Preferably, the method further comprises the following steps: setting a first auditing rule, wherein the first auditing rule comprises first change keywords and prompt information corresponding to the first change keywords, the first change keywords are used for matching with changes of an auditing table structure, and the first change keywords comprise change keywords for creating a table, deleting the table and changing the table structure; the first examination rule also comprises a judgment rule, wherein the judgment rule comprises that the table structure in the work order is changed if only one first change keyword is successfully matched, and the table structure in the work order is changed if only one specific change keyword is successfully matched.
Preferably, the method further comprises the following steps: setting a second auditing rule, wherein the setting of the second auditing rule comprises setting second change keywords for matching with auditing table data changes and prompt information corresponding to the second change keywords, and the second change keywords comprise inquiry, insertion, update and deletion; the second examination rule also comprises a judgment rule, wherein the judgment rule comprises that the table data in the work order is changed if only one second change keyword is successfully matched, and the table data in the work order is changed if only one specific change keyword is successfully matched.
It should be noted that the above description is only given by way of example, and the present invention is not limited thereto. In embodiment 2, the same portions as those in embodiment 1 are not described.
Compared with the prior art, the invention can effectively manage the auditing process of each work order by adding the work order parameter identification process and the user permission judgment process, can improve the auditing efficiency and can also improve the safety of data processing; the storage space is allocated for different users to store database operation work orders and related data thereof initiated by different users, so that more reasonable data storage can be realized, and each work order can be called or processed more quickly to further improve the work order auditing efficiency; the work order type is automatically judged by identifying the work order parameters of each work order, the auditing rule corresponding to each work order is determined according to the judged work order type, and the automatic matching auditing process is carried out, so that the automatic auditing of each work order is effectively realized, a database administrator (DBA) is not required to participate, and the influence of the table structure change work order on the online data service is effectively avoided; the corresponding priorities of the work orders and the table database work orders are changed by setting the table structure, an online sequence with a specific sequence is formed, online processing is carried out according to the online sequence, the auditing efficiency is effectively improved, the cost is reduced, the problems that the multiple work orders such as the table structure change work order and the table database work order are mixed and executed, and the generated rollback SQL text information is invalid due to the mixed execution are effectively solved, and the online efficiency is also improved.
Example 3
Embodiments of systems of the present invention are described below, which may be used to perform method embodiments of the present invention. Details described in the system embodiments of the invention should be considered supplementary to the above-described method embodiments; reference is made to the above-described method embodiments for details not disclosed in the system embodiments of the invention.
Referring to fig. 5 and fig. 6, a database operation work order automatic on-line system 500 according to embodiment 3 of the present invention will be described, where the system 500 includes the work order automatic audit apparatus 400 according to the present invention, and further includes: the system comprises an establishing module 501, a verification module and a verification module, wherein the establishing module is used for establishing a work order online platform, the work order online platform is connected with the work order self-use verification device, and receives a database operation work order online request initiated by a user through the work order online platform, and the online request comprises user information, work order parameters and database operation statements; the allocation module 502 is configured to allocate storage spaces for different users, so as to store database operation work orders initiated by different users and online states thereof; the matching auditing module 503 is used for automatically identifying the work order type based on the work order parameters and performing matching auditing by using a preset auditing rule; the storage module 504 is configured to store the checked database operation work order into a work order list to be online; and the online operation module 505 is configured to perform online operation on the work orders in the work order list to be online, generate corresponding rollback information in real time when the work orders are executed, and perform rollback information auditing and recording on the rollback information.
Preferably, the database is an SQL database, and the work order types include DDL work orders and DML work orders.
Preferably, the work order parameters include a domain name, a port, a database name, and SQL text information.
As shown in fig. 6, the system further includes a setting module 601, where the setting module 601 is configured to set a first audit rule, where the first audit rule includes first change keywords configured to match with changes of the structure of the audit table and prompt information corresponding to each first change keyword, and the first change keywords include change keywords for creating a table, deleting a table, and changing a table structure; the first examination rule also comprises a judgment rule, wherein the judgment rule comprises that the table structure in the work order is changed if only one first change keyword is successfully matched, and the table structure in the work order is changed if only one specific change keyword is successfully matched.
Preferably, the setting module 601 is configured to set a second review rule, where the setting of the second review rule includes setting second change keywords for matching review table data changes and prompt information corresponding to each second change keyword, where the second change keywords include query, insertion, update, and deletion; the second examination rule also comprises a judgment rule, wherein the judgment rule comprises that the table data in the work order is changed if only one second change keyword is successfully matched, and the table data in the work order is changed if only one specific change keyword is successfully matched.
Preferably, each work order during execution includes at least one piece of SQL text information, each piece of SQL text information includes corresponding rollback information, and all the rollback information may be displayed in a corresponding module, where the rollback information includes rollback SQL text information and rollback detail information; and judging the error operation or other error operations in the work order execution according to the rollback SQL text information and the rollback detail information in the rollback information so as to complete rollback information audit.
Preferably, the database is for a home service; the step of performing online operation on the work orders in the to-be-online work order list comprises the following steps: setting a work order execution strategy, wherein the work order execution strategy comprises the following steps: and judging whether the current time is in a low-peak business period of the home administration service, wherein when the current time is in the low-peak business period of the home administration service, the DDL work orders in the to-be-on-line list are subjected to on-line processing according to the to-be-on-line sequence.
Preferably, the performing online processing includes: setting execution priorities of a DDL (distributed data language) work order and a DML (digital document language) work order according to the online time, wherein the priority of the DDL work order is higher than that of the DML work order when the online time is a business low peak period of the home service; and when the online time is other times of the business of the home services, the priority of the DDL work order is lower than that of the DML work order.
Preferably, the method comprises the following steps: and a functional button for executing operation and withdrawing operation is arranged on the visual page to be on-line, and the functional button is used for executing operation or withdrawing operation on the work order which passes the matching examination.
It should be noted that the above description is only given by way of example, and the present invention is not limited thereto. In embodiment 3, the same portions as those in embodiments 1 and 2 are not described.
Example 4
The following describes an embodiment of the computer apparatus of the present invention, which may be considered as a concrete physical implementation of the above-described embodiments of the method and system of the present invention. Details described in relation to the computer device embodiment of the present invention should be considered supplementary to the method or system embodiment described above; for details not disclosed in the computer device embodiments of the invention, reference may be made to the above-described method or system embodiments.
Fig. 7 is a schematic structural diagram of a computer device according to an embodiment of the present invention, the computer device including a processor and a memory, the memory storing a computer-executable program, the processor executing the method of fig. 1 when the computer program is executed by the processor.
As shown in fig. 7, the computer device is in the form of a general purpose computing device. The processor can be one or more and can work together. The invention also does not exclude that distributed processing is performed, i.e. the processors may be distributed over different physical devices. The computer device of the present invention is not limited to a single entity, and may be a sum of a plurality of entity devices.
The memory stores a computer executable program, typically machine readable code. The computer readable program may be executed by the processor to enable a computer device to perform the method of the invention, or at least some of the steps of the method.
The memory may include volatile memory, such as Random Access Memory (RAM) and/or cache memory, and may also be non-volatile memory, such as read-only memory (ROM).
Optionally, in this embodiment, the computer device further includes an I/O interface, which is used for data exchange between the computer device and an external device. The I/O interface may be a local bus representing one or more of several types of bus structures, including a memory unit bus or memory unit controller, a peripheral bus, an accelerated graphics port, a processing unit, and/or a memory storage device using any of a variety of bus architectures.
It should be understood that the computer device shown in fig. 7 is only one example of the present invention, and elements or components not shown in the above examples may also be included in the computer device of the present invention. For example, some computer devices also include display units such as display screens, and some computer devices also include human-computer interaction elements such as buttons, keyboards, and the like. The computer device can be considered to be covered by the present invention as long as the computer device can execute the computer readable program in the memory to implement the method of the present invention or at least part of the steps of the method.
FIG. 8 is a schematic diagram of a computer program product of an embodiment of the invention. As shown in fig. 8, the computer program product has stored therein a computer executable program, which when executed, implements the above-described method of the present invention. The computer program product may comprise a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. The computer program product may be transmitted, propagated, or transported by a computer to be used by or in connection with an instruction execution system, or device. Program code embodied on the computer program product may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., through the internet using an internet service provider).
From the above description of the embodiments, those skilled in the art will readily appreciate that the present invention can be implemented by hardware capable of executing a specific computer program, such as the system of the present invention, and electronic processing units, servers, clients, mobile phones, control units, processors, etc. included in the system. The invention may also be implemented by computer software for performing the method of the invention, e.g. control software executed by a microprocessor, an electronic control unit, a client, a server, etc. It should be noted that the computer software for executing the method of the present invention is not limited to be executed by one or a specific hardware entity, and can also be realized in a distributed manner by non-specific hardware. For computer software, the software product may be stored in a computer readable storage medium (which may be a CD-ROM, a usb disk, a removable hard disk, etc.) or may be distributed over a network, as long as it enables the computer device to perform the method according to the present invention.
While the foregoing detailed description has described the objects, aspects and advantages of the invention in further detail, it should be appreciated that the present invention is not inherently related to any particular computer, virtual machine, or computer apparatus, as various general purpose systems may also implement the invention. The invention is not to be considered as limited to the specific embodiments thereof, but is to be understood as being modified in all respects, all changes and equivalents that come within the spirit and scope of the invention.
Claims (12)
1. An automatic online method for database operation work orders is characterized by comprising the following steps:
establishing a work order on-line platform, and receiving a database operation work order on-line request initiated by a user through the work order on-line platform, wherein the on-line request comprises user information, work order parameters and database operation statements;
allocating storage space for different users to store database operation work orders and online states thereof initiated by different users;
automatically identifying the type of the work order based on the work order parameters, and performing matching audit by using a preset audit rule;
storing the checked database operation work order into a work order list to be on-line;
and performing online operation on the work orders in the work order list to be online, generating corresponding rollback information in real time when the work orders are executed, and performing rollback information auditing and recording on the rollback information.
2. The method of claim 1, wherein the database is a SQL database and the work order types include DDL work orders and DML work orders.
3. The method of claim 2, wherein the work order parameters include domain name, port, database name, SQL text information.
4. The method of automatically online database operation work orders as set forth in claim 2, further comprising:
a first audit rule is set, wherein,
the first examination and verification rule comprises first change keywords and prompt information, wherein the first change keywords are used for matching examination and verification table structure changes, and the prompt information corresponds to each first change keyword;
the first examination rule also comprises a judgment rule, wherein the judgment rule comprises that the table structure in the work order is changed if only one first change keyword is successfully matched, and the table structure in the work order is changed if only one specific change keyword is successfully matched.
5. The method of automatically online database operation work orders as set forth in claim 2, further comprising:
a second audit rule is set, wherein,
the setting of the second examination and verification rule comprises setting second change keywords for matching examination and verification table data changes and prompt information corresponding to the second change keywords, wherein the second change keywords comprise inquiry, insertion, update and deletion;
the second examination rule also comprises a judgment rule, wherein the judgment rule comprises that the table data in the work order is changed if only one second change keyword is successfully matched, and the table data in the work order is changed if only one specific change keyword is successfully matched.
6. The method as claimed in claim 1, wherein the generating corresponding rollback information in real time when each work order is executed and performing rollback information review on the rollback information comprises:
each work order during execution comprises at least one piece of SQL text information, each piece of SQL text information comprises corresponding rollback information, and all the rollback information can be displayed in corresponding modules, wherein the rollback information comprises rollback SQL text information and rollback detail information;
and judging the error operation or other error operations in the work order execution according to the rollback SQL text information and the rollback detail information in the rollback information so as to complete rollback information audit.
7. The method of automatically online database operation worksheets of claim 2, wherein the database is used for housekeeping services;
the step of performing online operation on the work orders in the to-be-online work order list comprises the following steps:
setting a work order execution strategy, wherein the work order execution strategy comprises the following steps:
determining whether the current time is in a business low peak period of the home services, wherein,
and when the current time is in the low peak period of the services of the home services, performing online processing on the DDL work orders in the to-be-online list according to the to-be-online sequence.
8. The method of claim 7, wherein the performing online processing comprises:
setting the execution priority of the DDL work order and the DML work order according to the online time,
when the online time is the low peak period of the service of the home services, the priority of the DDL work order is higher than that of the DML work order;
and when the online time is other times of the business of the home services, the priority of the DDL work order is lower than that of the DML work order.
9. The database operation work order automatic online method according to claim 1 or 2, comprising:
and a functional button for executing operation and withdrawing operation is arranged on the visual page to be on-line, and the functional button is used for executing operation or withdrawing operation on the work order which passes the matching examination.
10. The database operation work order automatic online method of claim 9, comprising:
returning the refused DDL work order or DML work order to the corresponding user;
and storing the execution information and the rollback information of each work order into a database, directly inquiring correct information before misoperation from the rollback information, and re-executing the correct information.
11. The utility model provides an automatic device that audits of work order, its includes server and visual interface, and the device is connected with a plurality of customer ends and the work order platform of going on the line on each housekeeping service line, its characterized in that:
the server comprises an identification file for automatically identifying the parameters of the work order, an audit rule file for automatically matching audit, a storage space for storing database operation work orders of different users and related data thereof and an execution file for executing the work order online;
the processor is used for receiving the database operation work order on-line request shared by the work order on-line platform, performing work order parameter identification on the work order, determining the work order type of the work order, calling a corresponding auditing rule and performing automatic matching auditing; and
the visual interface is used for displaying a work order list to be checked or checked, a work order list to be on-line or above, providing corresponding visual operable pages for users with different authorities, and the server receives page operation information of each user and returns response information to each user.
12. An automatic on-line system for database operation work orders, which comprises the automatic work order auditing device of claim 11, and is characterized by further comprising:
the system comprises an establishing module, a verification module and a verification module, wherein the establishing module is used for establishing a work order online platform which is connected with the work order self-use verification device, and receiving a database operation work order online request initiated by a user through the work order online platform, and the online request comprises user information, work order parameters and database operation statements;
the distribution module is used for distributing storage space for different users so as to store database operation work orders initiated by different users and online states thereof;
the matching auditing module is used for automatically identifying the work order type based on the work order parameters and performing matching auditing by using a preset auditing rule;
the storage module is used for storing the checked database operation work order into a work order list to be on-line;
and the on-line operation module is used for carrying out on-line operation on the work orders in the work order list to be on-line, generating corresponding rollback information in real time when the work orders are executed, and auditing and recording the rollback information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110426120.8A CN113111066A (en) | 2021-04-20 | 2021-04-20 | Automatic online method, device and system for database operation work order and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110426120.8A CN113111066A (en) | 2021-04-20 | 2021-04-20 | Automatic online method, device and system for database operation work order and computer equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113111066A true CN113111066A (en) | 2021-07-13 |
Family
ID=76718848
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110426120.8A Pending CN113111066A (en) | 2021-04-20 | 2021-04-20 | Automatic online method, device and system for database operation work order and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113111066A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114528514A (en) * | 2022-04-24 | 2022-05-24 | 飞狐信息技术（天津）有限公司 | Content processing method, system, storage medium and electronic equipment |
| CN114676152A (en) * | 2022-04-08 | 2022-06-28 | 北京自如信息科技有限公司 | Work order management method and device and electronic equipment |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050131966A1 (en) * | 2003-12-15 | 2005-06-16 | Sbc Knowledge Ventures, L.P. | Architecture of database application with robust online recoverability |
| CN101566986A (en) * | 2008-04-21 | 2009-10-28 | 阿里巴巴集团控股有限公司 | Method and device for processing data in online business processing |
| CN103268399A (en) * | 2013-04-25 | 2013-08-28 | 深圳Tcl新技术有限公司 | Health management method and system based on video processing device |
| CN103995691A (en) * | 2014-05-21 | 2014-08-20 | 中国人民解放军国防科学技术大学 | Service state consistency maintenance method based on transactions |
| CN107831903A (en) * | 2017-11-24 | 2018-03-23 | 科大讯飞股份有限公司 | The man-machine interaction method and device that more people participate in |
| CN110263054A (en) * | 2019-05-30 | 2019-09-20 | 世纪龙信息网络有限责任公司 | Auditing system, checking method, device and the computer equipment of SQL work order |
| CN110489436A (en) * | 2019-08-16 | 2019-11-22 | 北京百度网讯科技有限公司 | Variation and platform, computer equipment and readable medium on the line of database |
| CN110674161A (en) * | 2019-09-20 | 2020-01-10 | 上海擎感智能科技有限公司 | Method, system, storage medium and SQL operation platform for online SQL |
| CN111177181A (en) * | 2019-12-11 | 2020-05-19 | 天翼电子商务有限公司 | SQL text auditing method, system, storage medium and device |
-
2021
- 2021-04-20 CN CN202110426120.8A patent/CN113111066A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050131966A1 (en) * | 2003-12-15 | 2005-06-16 | Sbc Knowledge Ventures, L.P. | Architecture of database application with robust online recoverability |
| CN101566986A (en) * | 2008-04-21 | 2009-10-28 | 阿里巴巴集团控股有限公司 | Method and device for processing data in online business processing |
| CN103268399A (en) * | 2013-04-25 | 2013-08-28 | 深圳Tcl新技术有限公司 | Health management method and system based on video processing device |
| CN103995691A (en) * | 2014-05-21 | 2014-08-20 | 中国人民解放军国防科学技术大学 | Service state consistency maintenance method based on transactions |
| CN107831903A (en) * | 2017-11-24 | 2018-03-23 | 科大讯飞股份有限公司 | The man-machine interaction method and device that more people participate in |
| CN110263054A (en) * | 2019-05-30 | 2019-09-20 | 世纪龙信息网络有限责任公司 | Auditing system, checking method, device and the computer equipment of SQL work order |
| CN110489436A (en) * | 2019-08-16 | 2019-11-22 | 北京百度网讯科技有限公司 | Variation and platform, computer equipment and readable medium on the line of database |
| CN110674161A (en) * | 2019-09-20 | 2020-01-10 | 上海擎感智能科技有限公司 | Method, system, storage medium and SQL operation platform for online SQL |
| CN111177181A (en) * | 2019-12-11 | 2020-05-19 | 天翼电子商务有限公司 | SQL text auditing method, system, storage medium and device |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114676152A (en) * | 2022-04-08 | 2022-06-28 | 北京自如信息科技有限公司 | Work order management method and device and electronic equipment |
| CN114528514A (en) * | 2022-04-24 | 2022-05-24 | 飞狐信息技术（天津）有限公司 | Content processing method, system, storage medium and electronic equipment |
| CN114528514B (en) * | 2022-04-24 | 2022-07-12 | 飞狐信息技术（天津）有限公司 | Content processing method, system, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107679749B (en) | Authority application approval method and authorization management platform | |
| CN111192004A (en) | Method for displaying current to-do task and subsequent to-do workflow | |
| CN104160381A (en) | Managing tenant-specific data sets in a multi-tenant environment | |
| CN113111066A (en) | Automatic online method, device and system for database operation work order and computer equipment | |
| CN111401029A (en) | Document version updating system and method based on document partition and collaborative editing | |
| CN111143074B (en) | Method and device for distributing translation files | |
| CN111245642A (en) | Method and device for acquiring dependency relationship between multiple systems and electronic equipment | |
| CN111124917A (en) | Public test case management and control method, device, equipment and storage medium | |
| CN111126948A (en) | Processing method and device for approval process | |
| CN111783050A (en) | Role and authority control system of website user | |
| CN111831682A (en) | Method, device, equipment and computer readable medium for processing accumulation fund service | |
| CN112765102B (en) | File system management method and device | |
| CN113127906A (en) | Unified authority management platform, method and storage medium based on C/S architecture | |
| CN108170860A (en) | Data query method, apparatus, electronic equipment and computer readable storage medium | |
| CN112580065A (en) | Data query method and device | |
| CN110750509A (en) | Enterprise name duplicate checking method and device, equipment and medium | |
| US20230195792A1 (en) | Database management methods and associated apparatus | |
| CN115640457A (en) | Information management method, apparatus, device, medium, and program product | |
| CN113240266A (en) | Risk management method and device | |
| CN111680069B (en) | Database access method and device | |
| CN112037048A (en) | Method and device for using online bank of enterprise user | |
| CN115794827B (en) | Data table structure management system and method | |
| CN116307894A (en) | Method, apparatus, electronic device and computer readable medium for executing evaluation task | |
| CN112416935A (en) | Data operation management method and device | |
| CN117290312A (en) | Information merging processing method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210713 |