CN110795447A - Data processing method, data processing system, electronic device, and medium - Google Patents
Data processing method, data processing system, electronic device, and medium Download PDFInfo
- Publication number
- CN110795447A CN110795447A CN201911043101.6A CN201911043101A CN110795447A CN 110795447 A CN110795447 A CN 110795447A CN 201911043101 A CN201911043101 A CN 201911043101A CN 110795447 A CN110795447 A CN 110795447A
- Authority
- CN
- China
- Prior art keywords
- information
- target change
- reverse
- change
- operations
- 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
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/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present disclosure provides a data processing method, including: acquiring and storing operation information of a plurality of change operations executed on a predetermined data set, wherein the operation information comprises identification information, statement information and operation object information; receiving a reverse operation request, wherein the reverse operation request comprises identification information of a target change operation in a plurality of change operations; obtaining operation information of a target change operation from the stored operation information of the plurality of change operations based on the identification information in the reverse operation request; and performing a reverse operation with respect to the target change operation based on the operation information of the target change operation to undo the target change operation. The present disclosure also provides a data processing system, an electronic device, and a computer-readable storage medium.
Description
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a data processing method, a data processing system, an electronic device, and a computer-readable storage medium.
Background
In the process of processing various services or services of an organization such as a financial institution, it is often necessary to perform a reverse operation of some services, for example, a user registers an account of an online bank, inserts information of the account into a corresponding database, and deletes information about the account from the database in order to log out the account.
In implementing the disclosed concept, the inventors found that there are at least the following problems in the related art:
in the prior art, if reverse operation of some services is to be realized, a corresponding reverse operation system needs to be configured for each service in a development process, which causes the problems of complicated development process and large workload of developers.
Disclosure of Invention
In view of the above, the present disclosure provides a data processing method, a data processing system, an electronic device, and a computer-readable storage medium.
One aspect of the present disclosure provides a data processing method, including: acquiring and storing operation information of a plurality of change operations executed on a predetermined data set, wherein the operation information comprises identification information, statement information and operation object information; receiving a reverse operation request, the reverse operation request including identification information of a target change operation of the plurality of change operations; obtaining operation information of the target change operation from stored operation information of a plurality of change operations based on the identification information in the reverse operation request; and performing a reverse operation with respect to the target change operation based on the operation information of the target change operation to revoke the target change operation.
According to the embodiment of the disclosure, the change operation comprises any one of an insert operation, an update operation and a delete operation; the obtaining and storing operation information of a plurality of change operations performed on a predetermined data set includes: in response to any one of an insert operation, an update operation, and a delete operation being performed on a predetermined data set, operation information about the corresponding operation is acquired and stored.
According to an embodiment of the present disclosure, the obtaining and storing operation information of a plurality of change operations performed on a predetermined data set further includes: under the condition that updating operation is executed on a preset data set, original data information of the operation object before the updating operation is executed is obtained, wherein the operation information of the updating operation comprises the original data information; and under the condition that a deletion operation is executed on a preset data set, acquiring original data information of the operation object before the deletion operation is executed, wherein the operation information of the deletion operation comprises the original data information.
According to an embodiment of the present disclosure, the performing, based on the operation information of the target change operation, a reverse operation with respect to the target change operation includes: generating a reverse operation statement based on the operation information of the target change operation; and executing the reverse operation statement.
According to an embodiment of the present disclosure, the performing, based on the operation information of the target change operation, a reverse operation with respect to the target change operation to undo the target change operation includes: when a plurality of target change operations are included, sorting the plurality of target change operations in the order of target change operation occurrence time from back to front; and sequentially executing reverse operations of the sequenced target change operations according to the sequence so as to sequentially cancel the target change operations from back to front according to the occurrence time of the target change operations.
Another aspect of the present disclosure provides a data processing system comprising: an obtaining operation module, configured to obtain operation information of a plurality of change operations performed on a predetermined data set from a predetermined plurality of change systems, where the operation information includes identification information, statement information, and operation object information, and store the operation information of the plurality of change operations; a receiving request module, configured to receive a reverse operation request, where the reverse operation request includes identification information of a target change operation in the multiple change operations; a target determining module, configured to determine, based on the identification information in the reverse operation request, operation information of the target change operation from among stored operation information of multiple change operations; and the reverse operation module is used for executing reverse operation related to the target change operation based on the operation information of the target change operation so as to cancel the target change operation.
According to the embodiment of the disclosure, the change operation comprises any one of an insert operation, an update operation and a delete operation; the acquisition operation module is used for: in response to any one of an insert operation, an update operation, and a delete operation being performed on a predetermined data set, acquiring and storing operation information on the corresponding operation; the obtaining operation module is further configured to: under the condition that updating operation is executed on a preset data set, original data information of the operation object before the updating operation is executed is obtained, wherein the operation information of the updating operation comprises the original data information; and under the condition that a deletion operation is executed on a preset data set, acquiring original data information of the operation object before the deletion operation is executed, wherein the operation information of the deletion operation comprises the original data information.
According to an embodiment of the present disclosure, the reverse operation module is further configured to: generating a reverse operation statement based on the operation information of the target change operation; executing the reverse operation statement; the reverse operation module is further configured to: when a plurality of target change operations are included, sorting the plurality of target change operations in the order of target change operation occurrence time from back to front; and sequentially executing reverse operations of the sequenced target change operations according to the sequence so as to sequentially cancel the target change operations from back to front according to the occurrence time of the target change operations.
Another aspect of the present disclosure provides an electronic device including: one or more processors; memory for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method as described above.
Another aspect of the present disclosure provides a computer-readable storage medium storing computer-executable instructions for implementing the method as described above when executed.
Another aspect of the disclosure provides a computer program comprising computer executable instructions for implementing the method as described above when executed.
According to the data processing method, the operation information of the plurality of change operations executed on the database is acquired and stored, when the reverse operation request is received, the operation information of the target change operation is found according to the identification information in the reverse operation request, and the reverse operation of the target change operation is executed based on the operation information of the target change operation to cancel the target change operation, so that the corresponding data can be restored to the state before the target change operation is executed. Therefore, the data processing method of the embodiment of the disclosure can execute the reverse operation of any change operation, so that a plurality of change operation systems can realize the reverse operation of various change operations in a manner of calling the data processing method, thereby at least partially solving the technical problems of large workload of developers and complex development process caused by the need of configuring corresponding reverse operation modules corresponding to each change operation in the prior art, thereby achieving the technical effects of reducing the workload of the developers and improving the development efficiency.
Drawings
The above and other objects, features and advantages of the present disclosure will become more apparent from the following description of embodiments of the present disclosure with reference to the accompanying drawings, in which:
fig. 1 schematically shows an exemplary system architecture to which a data processing method may be applied, according to an embodiment of the present disclosure;
FIG. 2 schematically shows a flow chart of a data processing method according to an embodiment of the present disclosure;
FIG. 3 schematically illustrates a flow chart of a method of obtaining operational information for a change operation according to an embodiment of the disclosure;
FIG. 4 schematically illustrates a schematic diagram of a reverse operation table according to an embodiment of the disclosure;
FIG. 5 schematically illustrates a flow chart of a method of performing a reverse operation in accordance with an embodiment of the present disclosure;
FIG. 6 schematically illustrates a flow diagram of a method of performing a reverse operation according to another embodiment of the present disclosure;
FIG. 7 schematically shows a block diagram of a data processing system according to an embodiment of the present disclosure; and
fig. 8 schematically shows a block diagram of an electronic device adapted to implement a data processing method according to an embodiment of the present disclosure.
Detailed Description
Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is illustrative only and is not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present disclosure.
The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The terms "comprises," "comprising," and the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.
All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It is noted that the terms used herein should be interpreted as having a meaning that is consistent with the context of this specification and should not be interpreted in an idealized or overly formal sense.
Where a convention analogous to "at least one of A, B and C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B and C" would include but not be limited to systems that have a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.). Where a convention analogous to "A, B or at least one of C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B or C" would include but not be limited to systems that have a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.).
An embodiment of the present disclosure provides a data processing method, including: the method comprises the steps of obtaining and storing operation information of a plurality of change operations executed on a preset data set, wherein the operation information comprises identification information, statement information and operation object information. A reverse operation request is received, the reverse operation request including identification information of a target change operation of the plurality of change operations. Operation information of a target change operation is obtained from the stored operation information of the plurality of change operations based on the identification information in the reverse operation request. And performing a reverse operation with respect to the target change operation based on the operation information of the target change operation to undo the target change operation.
Fig. 1 schematically shows an exemplary system architecture 100 to which the data processing method may be applied, according to an embodiment of the present disclosure. It should be noted that fig. 1 is only an example of a system architecture to which the embodiments of the present disclosure may be applied to help those skilled in the art understand the technical content of the present disclosure, and does not mean that the embodiments of the present disclosure may not be applied to other devices, systems, environments or scenarios.
As shown in fig. 1, the system architecture 100 may include n change operating systems and a reverse operating system, where n is an integer greater than or equal to 1. The data processing method of the embodiments of the present disclosure may be performed by, for example, a reverse operating system. Each of the change operating systems S1, S2, Sn may be a system for use by and interaction with staff of the organization, a system for use by and interaction with customers of the organization, or a system for performing other functions. The change operating systems S1, S2, Sn may perform operations such as insert, delete, update, and read operations on the database D, where the insert operation, the delete operation, and the update operation may be referred to as a change operation on the database D. The change operation may include other operations such as a merge operation that can change data in the database. The database D stores a plurality of data tables and some other types of files, each data table has a unique table name, one row in the table may be called a record, each record may contain a plurality of fields, and each field may be used to describe an attribute.
For example, the change operating system S1 may be used to implement related services of online banking, such as registering an online banking account, cancelling the online banking account, updating user information such as a mobile phone number associated with the account, and the like. During the account registration process, the change operating system S1 may insert the information of the new registered account into the corresponding data table in the database D to form a new record. During the account logout process, the change operating system S1 may query the record in the database D related to the account to be logged out and delete the record. In the process of updating the mobile phone number, the change operating system S1 may query the relevant record in the database D and update the value of the mobile phone number field in the relevant record. The change operating system S2 may be used, for example, to implement credit card related services.
For another example, the change operating system Sn may be configured to implement a function of performing data double writing on the host and the platform, in the data double writing process, data is written into the host and the platform at the same time, the data writing platform may be written into the database D, for example, and the change operating system Sn may also monitor whether the data is successfully written into the host and the platform at any time.
The back-end operating system may obtain, by using the interceptor, operation information of the change operation performed on the database D by each change operating system, and may store the operation information of each change operation, for example, may store the operation information of each change operation in a specific back-end operation table. The operation information may include identification information, statement information, and operation object information, the identification information may be generated by the interceptor, and the reverse operating system may send the identification information back to the corresponding change operating system, and use the identification information as an index of each change operation.
Each change operating system may, for example, include an operation sub-module, where the operation sub-module may store identification information of each change operation, and when a reverse operation of a certain change operation needs to be performed, the operation sub-module may send a reverse operation request to the reverse operating system, where the reverse operation request includes identification information corresponding to the change operation, and the change operation corresponding to the reverse operation request may become a target change operation, and after receiving the identification information, the reverse operating system may find operation information of the target change operation from the stored operation information of each change operation, and perform the reverse operation of the target change operation.
For example, at the first time, the user registers a new online banking account a through the change operating system S1, the change operating system S1 performs an insert operation a on the database D, where the insert operation a inserts a new record about the account a into the database D, and during the process of performing the insert operation a, the reverse operating system may acquire operation information of the insert operation a by using the interceptor and store the operation information into the reverse operation table. At a second time after the first time, the user submits a request to the change operating system S1 to log out the account a, and the operation submodule S11 of the change operating system S1 may send a reverse operation request to the reverse operating system, where the reverse operation request includes identification information of the insert operation a, and in this case, the insert operation a may be referred to as a target change operation. The reverse operation system may find out the operation information of the target change operation a in the stored reverse operation table according to the identification information of the target change operation a, and perform the reverse operation of the target change operation a according to the operation information of the target change operation a, where the reverse operation of the target change operation a may refer to, for example, deleting a record about the account a from the database D to log out the account a.
For another example, at the third time, the change operating system Sn writes the data B into the host and the database D at the same time, the change operating system Sn performs the change operation B on the database D, where the data B is written into the database D, for example, and during the execution of the change operation B, the reverse operating system may acquire the operation information of the change operation B by using the interceptor and store the operation information into the reverse operation table. If it is detected that the writing of the database D is successful but the writing of the host is failed, in order to ensure the data consistency between the host and the database D, the data B in the database D needs to be deleted, at this time, the operation submodule Snl of the change operating system Sn sends a reverse operation request to the reverse operating system, where the reverse operation request includes the identification information of the change operation B, and at this time, the change operation B may be referred to as a target change operation. The reverse operation system may find the operation information of the target change operation B in the stored reverse operation table according to the identification information of the target change operation B, and perform the reverse operation of the target change operation B, where the reverse operation of the target change operation B may refer to, for example, deleting the data B from the database D, so as to roll back the data in the database D to the state before writing the data B.
In the related art, if the reverse operations of multiple change operations are to be implemented, a corresponding reverse operation module needs to be configured for each change operation, for example, a corresponding logout account module needs to be configured for a change operation of a registered account, and a corresponding data deletion module needs to be configured for a change operation of written data, so that the development process is complicated, and the workload of developers is large.
According to the data processing method, the operation information of the plurality of change operations executed on the database is acquired and stored, when the reverse operation request is received, the operation information of the target change operation is found according to the identification information in the reverse operation request, and the reverse operation of the target change operation is executed based on the operation information of the target change operation to cancel the target change operation, so that the corresponding data can be restored to the state before the target change operation is executed. Therefore, the data processing method of the embodiment of the disclosure can execute the reverse operation of any change operation, so that a plurality of change operation systems can realize the reverse operation of various change operations in a manner of calling the data processing method, and therefore, a corresponding reverse operation module does not need to be configured for each change operation, the workload of developers is reduced, and the development efficiency is improved.
It should be understood that the number of change operating systems, reverse operating systems, and databases in FIG. 1 is merely illustrative. There may be any number of alternate operating systems, reverse operating systems, and databases, as desired for implementation.
Fig. 2 schematically shows a flow chart of a data processing method according to an embodiment of the present disclosure.
As shown in fig. 2, the method includes operations S110 to S140.
In operation S110, operation information of a plurality of change operations performed on a predetermined data set is acquired and stored, the operation information including identification information, statement information, and operation object information.
For example, the predetermined data set may refer to a certain database or may refer to a set of certain databases, and the database D is described as the predetermined data set as an example below.
According to an embodiment of the present disclosure, the change operation may refer to an operation of changing data in the database, and may include any one of an insert operation, an update operation, and a delete operation, for example, and may further include a merge operation, a flush operation, and the like. The inserting operation may include, for example, adding one or more new data tables or other types of files to the database D, or inserting one or more new records or one or more new fields into a certain data table in the database D. The update operation may include, for example, updating a certain data table in the database D to another data table, or updating a certain record in a certain data table to another record, or updating a value of a certain field in a certain record to another value, etc. The deletion operation may include, for example, deleting one or more tables or other types of files in database D, or deleting one or more records in a table in database D, etc.
According to an embodiment of the present disclosure, acquiring and storing operation information of a plurality of change operations performed on a predetermined data set includes: in response to any one of an insert operation, an update operation, and a delete operation being performed on a predetermined data set, operation information about the corresponding operation is acquired and stored.
For example, the data processing method according to the embodiment of the present disclosure may further monitor operations executed by each change operating system on the database in real time, and when it is monitored that some change operating systems execute change operations such as insertion, update, and deletion on the database, the operation information of each change operation may be acquired by the interceptor, where the operation information may include identification information, statement information, and operation object information.
According to an embodiment of the present disclosure, the identification information may also be referred to as a unique identification code (UUID), each change operation has unique identification information for distinguishing from other change operations, and the identification information may be generated by an interceptor. Statement information may refer to, for example, SQL statements (Structured query language), including, for example, SQL insert statements, SQL delete statements, SQL update statements, and the like. The method name and the operation object information can be obtained from the statement information, and the method name can represent what method the change operation performs on the database, for example, the method name corresponding to the sql insert statement can be insert; the method name corresponding to the sql delete statement may be delete, etc. The operation target information may include, for example, information such as a table name, a line number, and a field name corresponding to the change operation, where the table name may indicate which data table in the database is changed by the change operation, the line number may indicate which record in the data table is changed by the change operation, and the field name may indicate which field value in the record is changed by the change operation.
Fig. 3 schematically shows a flowchart of a method of obtaining operation information of a change operation according to an embodiment of the present disclosure.
As shown in fig. 3, when a change operation performed on a database is detected (S101), a unique identification code of the change operation, which may be alternatively referred to as a unique ID, may be generated by an interceptor (S102). The type of change operation may then be identified (S103), such as an insert operation, an update operation, or a delete operation. In the case where the change operation is an insert operation, information such as a unique ID, statement information, operation object information, and a method name of the insert operation may be acquired by the interceptor (S105) and stored as one record in the reverse operation table, and the unique ID may be returned to the corresponding change operation system as an index of the one record (S105).
When the change operation is an update operation or a delete operation, it is also necessary to acquire the original data information in the operation target before the update operation is performed (S104). For example, before performing the update and deletion, a query operation may be performed to query the original data in the corresponding operation object before performing the update and deletion, so that the original data can be recovered when the reverse operation of the update operation or the deletion operation is performed.
According to the embodiment of the disclosure, in the case of executing a deletion operation on a predetermined data set, original data information in an operation object before the deletion operation is executed is acquired, wherein operation information of the deletion operation includes the original data information.
For example, the deleting operation is to delete one record with the row number 100 in the data table E1, the corresponding query operation may refer to querying all information of the record, and all information of the record may be the original data information corresponding to the deleting operation. If the reverse operation of the delete operation is subsequently required, the record may be restored in the data table E1 according to the original data information.
According to the embodiment of the disclosure, in the case of performing an update operation on a predetermined data set, original data information in an operation object before the update operation is performed is acquired, wherein operation information of the update operation includes the original data information.
For example, the update operation is to update the mobile phone number field in one record with the row number of 200 in the data table E2, update the value of the current field from "130 xxxx 1111" to "130 xxxx 2222", and use the original field value "130 xxxx 1111" as the original data information corresponding to the update operation. If the reverse operation of the update operation needs to be performed subsequently, the value of the field can be restored back to "130 xxxx 1111" according to the original data information.
After the original data information is obtained, the interceptor can obtain the information of unique ID, statement information, operation object information, method name and the like of the deletion operation or the update operation (S105), store the information as a record in the reverse operation table, and return the unique ID as the index of the record to the corresponding change operation system (S105).
Based on the above manner, the reverse operation table may store operation information of a plurality of change operations.
FIG. 4 schematically illustrates a schematic diagram of a reverse operation table according to an embodiment of the disclosure.
As shown in fig. 4, each row in the reverse operation table except for the first row where the header is located may represent a record of a change operation, and it should be noted that each item of information recorded in the last two rows in the reverse operation table shown in fig. 4 is merely an illustration, and has no limiting effect on the data processing method of the embodiment of the present disclosure, and is not explained one by one here.
The reverse operation table may have a plurality of fields of UUID, TABLENAME, METHOD, ANTIMETHOD, ORIGINSQL, ORIGINPARAM, ANTIPARAM, and OPETIME. Wherein:
the UUID may refer to a unique ID of a change operation, and if a plurality of data tables are operated in the same change operation, a plurality of records may be separately formed, that is, a row may be formed for each data table, but a plurality of records belonging to the same change operation may use the same unique ID;
the TABLENAME can refer to a table name corresponding to the change operation and can be obtained by a getBeoundsql method of an interceptor;
the METHOD may refer to a METHOD name corresponding to a change operation, and may be acquired by a getSqlCommandType METHOD of an interceptor;
the anti-ethod may refer to a METHOD name of a reverse operation of the change operation, and may be generated according to the METHOD, for example, if the METHOD is update, the anti-ethod may be generated as update to perform a reverse update, if the METHOD is insert, the anti-ethod is delete, and if the METHOD is delete, the anti-ethod is insert;
ORIGINSQL can refer to SQL sentences of change operation and can be obtained by a getBeoundsql method of an interceptor;
ORIGINPARAM may refer to data after update or data after insertion, and may be obtained by executing a getParameterObject method on originql, and recording parameters sent up in SQL statements.
ANTIPARAM: if the change operation is an insert operation, ANTIPARAM may record the ID of a new record inserted in the database's data table after the insert operation is performed, and if the change operation is an update operation or a delete operation transaction, ANTIPARAM may record the original data information before the update operation or the delete operation.
Opertie may refer to the time at which the change operation occurs.
In operation S120, a reverse operation request is received, the reverse operation request including identification information of a target change operation among a plurality of change operations.
For example, a reverse operation request sent by the change operating system may be received, where the reverse operation request includes identification information of a change operation for which a reverse operation is to be performed, and the change operation may be referred to as a target change operation. The identification information may be, for example, a unique identification code (UUID).
In operation S130, operation information of a target change operation is obtained from the stored operation information of the plurality of change operations based on the identification information in the reverse operation request.
For example, operation information about the target change operation may be looked up from the reverse operation table according to the identification information of the target change operation, and the operation information of the target change operation may include, for example, operation object information, statement information, a method name of the reverse operation, and the like, and if the target change operation is a change operation or a delete operation, the operation information may further include original data information.
In operation S140, based on the operation information of the target change operation, a reverse operation with respect to the target change operation is performed to undo the target change operation and restore the corresponding data in the operation object to the state before the change operation was performed.
Fig. 5 schematically illustrates a flow chart of a method of performing a reverse operation in accordance with an embodiment of the present disclosure.
As shown in fig. 5, performing a reverse operation with respect to the target change operation based on the operation information of the target change operation in S140 may include operations S141 and S142:
in operation S141, a reverse operation statement is generated based on the operation information of the target change operation.
In operation S142, a reverse operation statement is executed.
For example, the operation information of the certain target changing operation X1 may be, for example: the operand information is [ data table E3], the statement information is sql insert statement, the method name is insert, the method name of the reverse operation is delete, and the inserted data includes [ name: zhang III; age: 30, of a nitrogen-containing gas; the mobile phone number is as follows: 130xxxx 1111; identification card number: 110xxxx1234], after performing the target change operation X1, a new record may be inserted in data table E3, for example, at row 300 in data table E3.
According to the above information, a reverse operation statement of the target change operation X1 may be generated, and the reverse operation statement may be, for example, a new sql delete statement, and the newly generated sql delete statement may be used to delete the record in row 300 in [ data table E3], execute the newly generated sql delete statement, and may implement the reverse operation of the target change operation X1, and restore the corresponding data in the operation object to the state before the target change operation X2 is executed.
For another example, the operation information of the certain target changing operation X2 may be, for example: the operation object information is [ data table E3, line number 300, mobile phone number field ], the statement information is sql update statement, the method name is update, the method name of the reverse operation is update, the original data information before updating is "130 xxxx 1111", and the information after updating is "130 xxxx 2222".
According to the above information, a reverse operation statement of the target change operation may be generated, and the reverse operation statement may be, for example, a new sql update statement, and the newly generated sql update statement may be used to update the value of [ data table E3, line number 300, and mobile phone number field ] from "130 xxxx 2222" to "130 xxxx 1111". Executing the newly generated sqlupdate statement may implement the reverse operation of target change operation X2, restoring the corresponding data in the operands to the state prior to executing target change operation X2.
In the above, the number of target change operations corresponding to the reverse operation request is described as one, but in some cases, the reverse operation request may correspond to a plurality of target change operations, for example, at a first time, a certain user registers an online banking account, inserts a new record into a certain data table of the database, and then at a second time after the first time, modifies the value of the mobile phone number field in the record. If the user wants to log out the account at a third time after the second time, the change operating system processing the account may send identification information of all change operations related to the account to the reverse operating system, so that the reverse operating system can sequentially withdraw a plurality of target change operations from back to front. For example, in the case of a change operation, if an insert operation is performed first and then an update operation is performed, when a reverse operation is performed, it is necessary to perform the update operation first, update the data back to the original data, and then perform a delete operation.
Fig. 6 schematically illustrates a flow chart of a method of performing a reverse operation according to another embodiment of the present disclosure.
As shown in fig. 6, according to an embodiment of the present disclosure, performing a reverse operation with respect to the target change operation based on the operation information of the target change operation in S140 to undo the target change operation may further include operations S143 and S144:
in operation S143, in a case where the reverse operation request includes identification information of the plurality of target change operations, sorting the plurality of target change operations in order of target change operation occurrence times from back to front;
in operation S144, the reverse operations of the sorted target change operations are sequentially performed in the above order to sequentially undo the target change operations from back to front according to the target change operation occurrence time.
For example, at a first time, the above-described target change operation X1 was performed on the database, and a new record was inserted in Table E3, which is located in Table E3 at line 300. At the second time after the first time, the above-mentioned target change operation X2 is performed on the database, and the value of the mobile phone number field in row 300 of the data table E3 is updated from "130 xxxx 2222" to "130 xxxx 1111".
At a third time after the second time, a reverse operation request is received, the reverse operation request comprises the identification information of the target change operation X1 and the identification information of the target change operation X2, the operation information of the two target change operations is found according to the two identification information, the operation information is sorted from back to front according to the occurrence time of the target change operation X1 and the target change operation X2, and the target change operation X1 is earlier than the target change operation X2, so that the two operations are sorted as follows: target Change operation X2-target Change operation X1.
When the reverse operation is performed, the reverse operation of the target change operation X2 is performed first, and then the reverse operation of the target change operation X1 is performed.
According to the data processing method, the operation information of the plurality of change operations executed on the database is acquired and stored, when the reverse operation request is received, the operation information of the target change operation is found according to the identification information in the reverse operation request, and the reverse operation of the target change operation is executed based on the operation information of the target change operation to cancel the target change operation, so that the corresponding data can be restored to the state before the target change operation is executed. Therefore, the data processing method of the embodiment of the disclosure can execute the reverse operation of any change operation, so that a plurality of change operation systems can realize the reverse operation of various change operations in a manner of calling the data processing method, and therefore, a corresponding reverse operation module does not need to be configured for each change operation, the workload of developers is reduced, and the development efficiency is improved.
Another aspect of the disclosed embodiments provides a data processing system.
FIG. 7 schematically shows a block diagram of a data processing system 200 according to an embodiment of the present disclosure.
As shown in FIG. 7, the data processing system 200 includes a get operation module 210, a receive request module 220, a determine target module 230, and a reverse operation module 240. Data processing system 200 may be, for example, the operating system depicted in FIG. 1 and described above as a reverse operating system.
The obtaining operation module 210 is configured to obtain operation information of a plurality of change operations performed on a predetermined data set from a predetermined plurality of change systems, where the operation information includes identification information, statement information, and operation object information, and stores operation information of the plurality of change operations;
the receiving request module 220 is configured to receive a reverse operation request, where the reverse operation request includes identification information of a target change operation in the multiple change operations;
the determination target module 230 is configured to determine operation information of a target change operation from the stored operation information of the plurality of change operations based on the identification information in the reverse operation request; and
the reverse operation module 240 is configured to perform a reverse operation with respect to the target change operation based on the operation information of the target change operation to undo the target change operation.
According to the embodiment of the disclosure, the change operation includes any one of an insert operation, an update operation, and a delete operation;
the acquisition operation module is used for: in response to any one of an insert operation, an update operation, and a delete operation being performed on a predetermined data set, operation information about the corresponding operation is acquired and stored.
According to an embodiment of the disclosure, the obtaining operation module is further configured to: under the condition that updating operation is executed on a preset data set, original data information of an operation object before the updating operation is executed is obtained, wherein the operation information of the updating operation comprises the original data information; and under the condition that the deletion operation is executed on the preset data set, acquiring original data information of an operation object before the deletion operation is executed, wherein the operation information of the deletion operation comprises the original data information.
According to an embodiment of the disclosure, the reverse operation module is further configured to: generating a reverse operation statement based on the operation information of the target change operation; the reverse operation statement is executed.
According to an embodiment of the disclosure, the reverse operation module is further configured to: when a plurality of target change operations are included, sorting the plurality of target change operations in the order of the target change operation occurrence time from back to front; and sequentially executing the reverse operations of the sequenced target change operations according to the sequence so as to sequentially cancel the target change operations from back to front according to the occurrence time of the target change operations.
Any number of modules, sub-modules, units, sub-units, or at least part of the functionality of any number thereof according to embodiments of the present disclosure may be implemented in one module. Any one or more of the modules, sub-modules, units, and sub-units according to the embodiments of the present disclosure may be implemented by being split into a plurality of modules. Any one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be implemented at least in part as a hardware circuit, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or may be implemented in any other reasonable manner of hardware or firmware by integrating or packaging a circuit, or in any one of or a suitable combination of software, hardware, and firmware implementations. Alternatively, one or more of the modules, sub-modules, units, sub-units according to embodiments of the disclosure may be at least partially implemented as a computer program module, which when executed may perform the corresponding functions.
For example, any plurality of the obtaining operation module 210, the request receiving module 220, the target determining module 230, and the reverse operation module 240 may be combined and implemented in one module/unit/sub-unit, or any one of the modules/units/sub-units may be split into a plurality of modules/units/sub-units. Alternatively, at least part of the functionality of one or more of these modules/units/sub-units may be combined with at least part of the functionality of other modules/units/sub-units and implemented in one module/unit/sub-unit. According to an embodiment of the present disclosure, at least one of the get operation module 210, the receive request module 220, the determine target module 230, and the reverse operation module 240 may be implemented at least partially as a hardware circuit, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or may be implemented in hardware or firmware in any other reasonable manner of integrating or packaging a circuit, or may be implemented in any one of three implementations of software, hardware, and firmware, or in a suitable combination of any of them. Alternatively, at least one of the get operation module 210, the receive request module 220, the determine target module 230, and the reverse operation module 240 may be implemented at least in part as a computer program module that, when executed, may perform corresponding functions.
It should be noted that, the data processing system part in the embodiment of the present disclosure corresponds to the data processing method part in the embodiment of the present disclosure, and the description of the data processing system part specifically refers to the data processing method part, which is not described herein again.
Fig. 8 schematically shows a block diagram of an electronic device adapted to implement the above described method according to an embodiment of the present disclosure. The electronic device shown in fig. 8 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present disclosure.
As shown in fig. 8, an electronic device 500 according to an embodiment of the present disclosure includes a processor 501 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM)502 or a program loaded from a storage section 508 into a Random Access Memory (RAM) 503. The processor 501 may comprise, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or associated chipset, and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), among others. The processor 501 may also include onboard memory for caching purposes. Processor 501 may include a single processing unit or multiple processing units for performing different actions of a method flow according to embodiments of the disclosure.
In the RAM 503, various programs and data necessary for the operation of the system 500 are stored. The processor 501, the ROM 502, and the RAM 503 are connected to each other by a bus 504. The processor 501 performs various operations of the method flows according to the embodiments of the present disclosure by executing programs in the ROM 502 and/or the RAM 503. Note that the programs may also be stored in one or more memories other than the ROM 502 and the RAM 503. The processor 501 may also perform various operations of method flows according to embodiments of the present disclosure by executing programs stored in the one or more memories.
According to an embodiment of the present disclosure, electronic device 500 may also include an input/output (I/O) interface 505, input/output (I/O) interface 505 also being connected to bus 504. The system 500 may also include one or more of the following components connected to the I/O interface 505: an input portion 506 including a keyboard, a mouse, and the like; an output portion 507 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 508 including a hard disk and the like; and a communication section 509 including a network interface card such as a LAN card, a modem, or the like. The communication section 509 performs communication processing via a network such as the internet. The driver 510 is also connected to the I/O interface 505 as necessary. A removable medium 511 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 510 as necessary, so that a computer program read out therefrom is mounted into the storage section 508 as necessary.
According to embodiments of the present disclosure, method flows according to embodiments of the present disclosure may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable storage medium, the computer program containing program code for performing the method illustrated by the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 509, and/or installed from the removable medium 511. The computer program, when executed by the processor 501, performs the above-described functions defined in the system of the embodiments of the present disclosure. The systems, devices, apparatuses, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the present disclosure.
The present disclosure also provides a computer-readable storage medium, which may be contained in the apparatus/device/system described in the above embodiments; or may exist separately and not be assembled into the device/apparatus/system. The computer-readable storage medium carries one or more programs which, when executed, implement the method according to an embodiment of the disclosure.
According to an embodiment of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium. Examples may include, but are not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
For example, according to embodiments of the present disclosure, a computer-readable storage medium may include ROM 502 and/or RAM 503 and/or one or more memories other than ROM 502 and RAM 503 described above.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
Those skilled in the art will appreciate that various combinations and/or combinations of features recited in the various embodiments and/or claims of the present disclosure can be made, even if such combinations or combinations are not expressly recited in the present disclosure. In particular, various combinations and/or combinations of the features recited in the various embodiments and/or claims of the present disclosure may be made without departing from the spirit or teaching of the present disclosure. All such combinations and/or associations are within the scope of the present disclosure.
The embodiments of the present disclosure have been described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described separately above, this does not mean that the measures in the embodiments cannot be used in advantageous combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be devised by those skilled in the art without departing from the scope of the present disclosure, and such alternatives and modifications are intended to be within the scope of the present disclosure.
Claims (10)
1. A method of data processing, comprising:
acquiring and storing operation information of a plurality of change operations executed on a predetermined data set, wherein the operation information comprises identification information, statement information and operation object information;
receiving a reverse operation request, the reverse operation request including identification information of a target change operation of the plurality of change operations;
obtaining operation information of the target change operation from stored operation information of a plurality of change operations based on the identification information in the reverse operation request; and
and performing a reverse operation on the target change operation based on the operation information of the target change operation to undo the target change operation.
2. The method of claim 1, wherein:
the change operation comprises any one operation of an insert operation, an update operation and a delete operation;
the obtaining and storing operation information of a plurality of change operations performed on a predetermined data set includes: in response to any one of an insert operation, an update operation, and a delete operation being performed on a predetermined data set, operation information about the corresponding operation is acquired and stored.
3. The method of claim 2, wherein said obtaining and storing operation information for a plurality of change operations performed on a predetermined set of data further comprises:
under the condition that updating operation is executed on a preset data set, original data information of the operation object before the updating operation is executed is obtained, wherein the operation information of the updating operation comprises the original data information;
and under the condition that a deletion operation is executed on a preset data set, acquiring original data information of the operation object before the deletion operation is executed, wherein the operation information of the deletion operation comprises the original data information.
4. The method of claim 1, wherein the performing a reverse operation with respect to the target change operation based on the operation information of the target change operation comprises:
generating a reverse operation statement based on the operation information of the target change operation;
and executing the reverse operation statement.
5. The method according to any one of claims 1 to 4, wherein the performing a reverse operation with respect to the target change operation based on the operation information of the target change operation to undo the target change operation comprises:
when a plurality of target change operations are included, sorting the plurality of target change operations in the order of target change operation occurrence time from back to front;
and sequentially executing reverse operations of the sequenced target change operations according to the sequence so as to sequentially cancel the target change operations from back to front according to the occurrence time of the target change operations.
6. A data processing system comprising:
an obtaining operation module, configured to obtain operation information of a plurality of change operations performed on a predetermined data set from a predetermined plurality of change systems, where the operation information includes identification information, statement information, and operation object information, and store the operation information of the plurality of change operations;
a receiving request module, configured to receive a reverse operation request, where the reverse operation request includes identification information of a target change operation in the multiple change operations;
a target determining module, configured to determine, based on the identification information in the reverse operation request, operation information of the target change operation from among stored operation information of multiple change operations; and
and the reverse operation module is used for executing reverse operation related to the target change operation based on the operation information of the target change operation so as to cancel the target change operation.
7. The module of claim 6, wherein:
the change operation comprises any one operation of an insert operation, an update operation and a delete operation;
the acquisition operation module is used for:
in response to any one of an insert operation, an update operation, and a delete operation being performed on a predetermined data set, acquiring and storing operation information on the corresponding operation;
the obtaining operation module is further configured to:
under the condition that updating operation is executed on a preset data set, original data information of the operation object before the updating operation is executed is obtained, wherein the operation information of the updating operation comprises the original data information;
and under the condition that a deletion operation is executed on a preset data set, acquiring original data information of the operation object before the deletion operation is executed, wherein the operation information of the deletion operation comprises the original data information.
8. The module of claim 6,
the reverse operation module is further configured to:
generating a reverse operation statement based on the operation information of the target change operation;
executing the reverse operation statement;
the reverse operation module is further configured to:
when a plurality of target change operations are included, sorting the plurality of target change operations in the order of target change operation occurrence time from back to front;
and sequentially executing reverse operations of the sequenced target change operations according to the sequence so as to sequentially cancel the target change operations from back to front according to the occurrence time of the target change operations.
9. An electronic device, comprising:
one or more processors;
a memory for storing one or more programs,
wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of any of claims 1-5.
10. A computer readable storage medium having stored thereon executable instructions which, when executed by a processor, cause the processor to carry out the method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911043101.6A CN110795447A (en) | 2019-10-29 | 2019-10-29 | Data processing method, data processing system, electronic device, and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911043101.6A CN110795447A (en) | 2019-10-29 | 2019-10-29 | Data processing method, data processing system, electronic device, and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110795447A true CN110795447A (en) | 2020-02-14 |
Family
ID=69442012
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911043101.6A Pending CN110795447A (en) | 2019-10-29 | 2019-10-29 | Data processing method, data processing system, electronic device, and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110795447A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111460476A (en) * | 2020-03-27 | 2020-07-28 | 腾讯科技（深圳）有限公司 | Account logout method and device, storage medium and electronic device |
| CN112151152A (en) * | 2020-09-27 | 2020-12-29 | 武汉联影智融医疗科技有限公司 | Misoperation processing method and device, computer equipment and storage medium |
| CN113297220A (en) * | 2021-05-21 | 2021-08-24 | 中国邮政储蓄银行股份有限公司 | Data recovery method and device, computer readable storage medium and processor |
| CN114064665A (en) * | 2022-01-19 | 2022-02-18 | 浙江省人力资源和社会保障信息中心 | Data rollback method, system, electronic equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102456036A (en) * | 2010-10-20 | 2012-05-16 | 金蝶软件（中国）有限公司 | Operation repealing method and system |
| CN107220142A (en) * | 2016-03-22 | 2017-09-29 | 阿里巴巴集团控股有限公司 | Perform the method and device of data recovery operation |
| CN107329854A (en) * | 2017-06-20 | 2017-11-07 | 算丰科技（北京）有限公司 | Operation repealing method and device, electronic equipment |
| CN109522078A (en) * | 2018-11-15 | 2019-03-26 | 用友网络科技股份有限公司 | Operation repealing method, computer equipment and computer readable storage medium |
-
2019
- 2019-10-29 CN CN201911043101.6A patent/CN110795447A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102456036A (en) * | 2010-10-20 | 2012-05-16 | 金蝶软件（中国）有限公司 | Operation repealing method and system |
| CN107220142A (en) * | 2016-03-22 | 2017-09-29 | 阿里巴巴集团控股有限公司 | Perform the method and device of data recovery operation |
| CN107329854A (en) * | 2017-06-20 | 2017-11-07 | 算丰科技（北京）有限公司 | Operation repealing method and device, electronic equipment |
| CN109522078A (en) * | 2018-11-15 | 2019-03-26 | 用友网络科技股份有限公司 | Operation repealing method, computer equipment and computer readable storage medium |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111460476A (en) * | 2020-03-27 | 2020-07-28 | 腾讯科技（深圳）有限公司 | Account logout method and device, storage medium and electronic device |
| CN112151152A (en) * | 2020-09-27 | 2020-12-29 | 武汉联影智融医疗科技有限公司 | Misoperation processing method and device, computer equipment and storage medium |
| CN112151152B (en) * | 2020-09-27 | 2023-07-21 | 武汉联影智融医疗科技有限公司 | Misoperation processing method, device, computer equipment and storage medium |
| CN113297220A (en) * | 2021-05-21 | 2021-08-24 | 中国邮政储蓄银行股份有限公司 | Data recovery method and device, computer readable storage medium and processor |
| CN114064665A (en) * | 2022-01-19 | 2022-02-18 | 浙江省人力资源和社会保障信息中心 | Data rollback method, system, electronic equipment and storage medium |
| CN114064665B (en) * | 2022-01-19 | 2022-07-05 | 浙江省人力资源和社会保障信息中心 | Data rollback method, system, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10678808B2 (en) | Eager replication of uncommitted transactions | |
| CN110795447A (en) | Data processing method, data processing system, electronic device, and medium | |
| US8671085B2 (en) | Consistent database recovery across constituent segments | |
| US8443006B1 (en) | Data propagation in a multi-shard database system | |
| US9811577B2 (en) | Asynchronous data replication using an external buffer table | |
| US10204125B2 (en) | Method, apparatus, and application platform for updating application object attribute | |
| CN107766080B (en) | Transaction message processing method, device, equipment and system | |
| US11822535B2 (en) | Director-based database system for transactional consistency | |
| US20220391291A1 (en) | History information in director-based database system for transactional consistency | |
| CN115145943B (en) | Method, system, equipment and storage medium for rapidly comparing metadata of multiple data sources | |
| JP2018538634A (en) | Database operating method and apparatus | |
| US11989051B2 (en) | Time alignment in director-based database system for transactional consistency | |
| US9009098B1 (en) | Methods and apparatus for creating a centralized data store | |
| CN113312259A (en) | Interface testing method and device | |
| US9015116B2 (en) | Consistent replication of transactional updates | |
| CN107391539B (en) | Transaction processing method, server and storage medium | |
| US11132351B2 (en) | Executing transactions based on success or failure of the transactions | |
| US11816020B2 (en) | Online query execution using a big data framework | |
| US11880495B2 (en) | Processing log entries under group-level encryption | |
| CN111753141A (en) | Data management method and related equipment | |
| CN107038617B (en) | Pre-creation method and device of payment order | |
| US9772842B2 (en) | Managing change sets | |
| US8321844B2 (en) | Providing registration of a communication | |
| CN111292028A (en) | Inventory information processing method and system, computer system and readable storage medium | |
| US11977457B2 (en) | Backup and recovery under group-level encryption |
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 |
Application publication date: 20200214 |
|
| RJ01 | Rejection of invention patent application after publication |