CN109460318B - Import method of rollback archive collected data, computer device and computer readable storage medium - Google Patents
Import method of rollback archive collected data, computer device and computer readable storage medium Download PDFInfo
- Publication number
- CN109460318B CN109460318B CN201811261269.XA CN201811261269A CN109460318B CN 109460318 B CN109460318 B CN 109460318B CN 201811261269 A CN201811261269 A CN 201811261269A CN 109460318 B CN109460318 B CN 109460318B
- Authority
- CN
- China
- Prior art keywords
- log
- data
- rollback
- management system
- difference
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1415—Saving, restoring, recovering or retrying at system level
- G06F11/1438—Restarting or rejuvenating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides an importing method of collected data of a rollback archive, a computer device and a computer readable storage medium, wherein the method comprises the steps of acquiring the collected data, wherein the collected data comprises an identifier of the collected data, and importing the collected data into a data management system; after the collected data are imported into a data management system, comparing the original data value of the data management system with the new data value of the data management system, if a difference occurs, generating a corresponding difference log, storing the difference log, and matching the difference log with the identifier; after the collected data are imported into a data management system, generating a corresponding rollback log according to the original data value of the data management system, storing the rollback log, and matching the rollback log with the identifier; and judging whether the steps are finished or not, and if so, updating and storing the data management system. The method can quickly recover the original data during the error operation, is convenient for searching the error data source, and ensures the safety, accuracy and high efficiency of importing the collected data into the data management system.
Description
Technical Field
The invention relates to the field of data storage, in particular to a method for importing rollback archive collected data, a computer device and a computer readable storage medium.
Background
With the rapid development of computer network technology, the digitization of files has become a necessary trend for the development of file work. Archives storage space not only can be saved in the archives digitization, alleviates storehouse pressure, can properly solve the utilization problem of archives again, reduces because of the wearing and tearing that cause frequently using archives original paper, is favorable to protecting archives original paper. The method is characterized in that file data are recorded according to a scientific method and a unified data standard, electronic records in the existing file system are corrected and corrected according to original paper files, and file acquisition data are imported into a file management system, so that the consistency of file records in various forms, the integrity of electronic data and the logic tightness among various data are realized, and the aim of improving the utilization efficiency of the files is finally achieved.
The existing file acquisition data storage has the following defects:
(1) most of the existing file acquisition data warehousing methods are that data writing personnel directly proofread and correct in a file management system, and once data are corrected or deleted, the data cannot be quickly recovered, and only checking and inputting can be performed according to a physical file.
(2) A small part of the existing file acquisition data is separately recorded by file digital processing software and then imported by a data storage program. In the process of data import, the archive management system is directly updated by using the archive acquisition data, once the data is modified or deleted, the data cannot be quickly recovered, and only the verification and entry can be carried out according to the physical archive.
(3) In the existing file data bibliography, after the collected data is put in storage, if a file collected data error is found in the subsequent file utilization process, the responsibility and the error reason of the imported file collected data error cannot be quickly tracked.
Disclosure of Invention
The first purpose of the present invention is to provide an import method of rollback archive collected data, which can quickly recover original data in case of error operation, and is convenient for searching the source of error data.
The second objective of the present invention is to provide a computer device capable of implementing the importing method of rollback archive collection data.
A third object of the present invention is to provide a computer-readable storage medium capable of implementing the method for importing rollback archive collection data.
In order to achieve the first object, the present invention provides a method for importing rollback archive collected data, including acquiring collected data, where the collected data includes an identifier of the collected data, and importing the collected data into a data management system; after the collected data are imported into a data management system, generating a corresponding rollback log according to the original data value of the data management system, storing the rollback log, and matching the rollback log with the identifier; after the collected data are imported into a data management system, comparing the original data value of the data management system with the new data value of the data management system, if the original data value and the new data value are different, generating a corresponding difference log, storing the difference log, and matching the difference log with the identifier; and judging whether the steps are finished or not, and if so, updating and storing the data management system.
According to the scheme, the identifier can search the corresponding rollback log in a targeted manner through matching the rollback log with the identifier, the corresponding difference log can be called and read at any time by using the identifier, and the corresponding original number can be recovered at any time according to the rollback log under the condition that data has errors.
Through the matching of the difference logs and the identifiers, the corresponding difference logs can be searched in a targeted manner according to the identifiers, and the corresponding difference logs can be retrieved at any time by utilizing the identifiers, so that a user can look up the modified content before and after the import of the collected data, the process of data change is conveniently recorded according to the difference logs, and the original input record of the related data can be searched.
The import method of the rollback archive collected data enables the data to be safely, accurately and efficiently put in storage.
The specific scheme is that after the data management system is updated and stored, an operation instruction for opening a difference log query interface is received, the difference log query interface is opened, input identifier information is received, and the corresponding difference log is searched and displayed according to the identifier.
According to the scheme, the function of searching and displaying the difference log is provided, and the use is convenient and simple.
Another specific scheme is that the collected data import data management system includes: and importing the collected data into a data management system, generating a corresponding import log, storing the import log, and matching the import log with the identifier.
According to the scheme, the import log is convenient for recording the import records of the related collected data, more identifiers matched with the imported collected data are generated, and the related data content is convenient to accurately query.
After the data management system is updated and stored, an operation instruction for opening an import log query interface is received, the import log query interface is opened, input identifier information is received, and a corresponding import log is searched and displayed according to the identifier.
According to the scheme, the function of searching and displaying the import log is provided, and the use is convenient and simple.
The data collected is the files accepted in the same batch, and at least one file is accepted in the same batch; the file comprises a plurality of data tables, and each data table comprises a plurality of fields; generating a corresponding difference log according to the original data value of the data management system and the new data value of the data management system specifically comprises the following steps: generating a corresponding difference log according to the original field value of the data management system and the new field value of the data management system; the specific steps of producing the corresponding rollback log according to the original data value of the data management system are as follows: and generating a corresponding rollback log according to the field original value of the data management system.
According to the scheme, the field value of the minimum unit is directly matched with the difference log and the rollback log, so that the records of the difference log and the rollback log are detailed, the related change data can be conveniently consulted, the related data can be conveniently replied, and the integrity of the data is ensured.
In another specific scheme, each field with difference produces a corresponding difference log; matching the acceptance batch numbers with corresponding difference logs, wherein each acceptance batch number corresponds to at least one difference log or no corresponding difference log; and matching the file number with the corresponding difference logs, wherein each file number corresponds to at least one difference log or no corresponding difference log.
As can be seen from the above scheme, any field change value included in the acceptance batch number or the file number can be seen through inputting the acceptance batch number or the file number, and the details are clear.
Matching the file number with a corresponding rollback log, wherein each file number in each acceptance batch number corresponds to one rollback log; after the data management system is updated and stored, receiving input file number information, searching and displaying a corresponding rollback log according to the file number, receiving an instruction whether the rollback log needs to be searched, and displaying the details of the rollback log according to the file number if the rollback log needs to be searched; and receiving an instruction whether the rollback log needs to be recovered, and if so, recovering the original data value of the data management system according to the rollback log single volume.
According to the scheme, the original data value of the rollback log can be restored in a single volume by inputting the file number, so that the relevant data can be restored in a targeted manner.
In another specific scheme, the checking and accepting batch number is matched with the corresponding rollback log, and each rollback log corresponding to the checking and accepting batch number is matched with each file corresponding to each checking and accepting batch number; after the data management system is updated and stored, receiving input acceptance batch number information, and searching and displaying a corresponding rollback log according to the acceptance batch number; and receiving an instruction whether the rollback log needs to be restored in batch, and if so, restoring the original data value of the data management system in batch according to the rollback log.
According to the scheme, the original data value of the rollback log can be recovered in batches by inputting the batch number, and the recovery of related data is facilitated under the condition of batch operation error.
In order to achieve the second object, the present invention further provides a computer device, which includes a processor and a memory, where the memory stores a computer program, and the computer program, when executed by the processor, implements the steps of the method for importing rollback file acquisition data.
In order to achieve the third object, the present invention further provides a computer-readable storage medium having a computer program, where the computer program is executed by a processor to implement the steps of the method for importing rollback archive collection data.
Drawings
FIG. 1 is a flowchart of an embodiment of a method for importing rollback archive collection data of the present invention.
FIG. 2 is a diagram of an application interface for importing a title file according to an embodiment of the method for importing rollback file collection data of the present invention.
Fig. 3 is a first application interface diagram for importing log queries according to an embodiment of the import method for rollback archive collection data of the present invention.
FIG. 4 is a diagram of an application interface for query of a difference log according to an embodiment of an importing method for rollback archive collection data of the present invention.
FIG. 5 is a diagram of an application interface for case volume difference log query according to an embodiment of the importing method of rollback archive collection data of the present invention.
FIG. 6 is a first application interface diagram of the archive query according to the embodiment of the import method of the rollback archive collected data of the present invention.
Fig. 7 is a second application interface diagram for importing log queries according to the import method of rollback archive collection data of the present invention.
Fig. 8 is an application interface diagram of rollback log query according to an embodiment of the import method of rollback archive collection data of the present invention.
FIG. 9 is a second diagram of an application interface for querying a file according to an embodiment of the importing method for rollback file collection data according to the present invention.
Fig. 10 is a third application interface diagram for importing log queries according to the import method of rollback archive collection data of the present invention.
Fig. 11 is a fourth application interface diagram for importing log queries according to the import method of rollback archive collection data of the present invention.
The invention is further explained with reference to the drawings and the embodiments.
Detailed Description
The importing method of the rollback archive collected data is applied to terminal equipment with a data management system, typically, terminals such as computers, and the like, the terminal equipment can import collected data, generate corresponding import logs, difference logs and rollback logs according to the collected data, provide the functions of looking up the corresponding import logs, difference logs and rollback logs, and provide the functions of recovering single-volume rollback and batch rollback of the rollback logs. The computer of the present invention may be the terminal device, and the computer-readable storage medium may be various storage media having a data storage function, such as a non-volatile memory, e.g., FLASH, EEPROM, and the like.
The embodiment of the importing method of the rollback archive acquisition data comprises the following steps:
the collected data are a plurality of files which are checked and accepted in the same batch, such as: property files, the identifier of the collected data includes the number of the lot, the time of the lot, and the file number of each file in the lot.
The file comprises a plurality of data tables, such as a basic information table, a room information table, a right list, a file right number and the like, wherein each data table comprises a plurality of fields, and for example, a file right number data table is provided with a right state number.
Referring to fig. 1, the importing method of the rollback archive collected data of the present invention is as follows:
step S1 is executed first, the collected data is obtained and imported into the data management system, the data is added, deleted and modified, a corresponding import log is generated, the import log is stored, and the import log is matched with the corresponding acceptance batch number;
then, step S2 is executed to generate a corresponding rollback log according to the original value of each field in the data management system, store the rollback log, and match the rollback log with the corresponding acceptance batch number and the corresponding document number.
Since the same checking batch number includes a plurality of files, the files include a plurality of data tables, the data tables include a plurality of fields, and each file number corresponds to one rollback log, the same checking batch number corresponds to a plurality of rollback logs.
Step S3 may be executed while step S2 is executed to match the import log with the acceptance batch number, and then compare the new values of the fields in the data management system with the original values of the fields corresponding to the new values of the fields in the data management system one by one. If a difference occurs, step S4 is executed to generate a corresponding difference log, store the difference log, and match the difference log with the corresponding acceptance batch number and the corresponding document number. If no difference exists, step S5 is executed to determine whether the above steps are completed.
Since the same checking batch number includes a plurality of files, the file includes a plurality of data tables, the data tables include a plurality of fields, and each field with difference generates a corresponding difference log, the same checking batch number corresponds to at least one difference log or no corresponding difference log, and the same file number may correspond to at least one difference log or no corresponding difference log.
After the steps S1, S2, S3 and S4 are completed, step S5 is performed to determine whether the above steps are completed, and if so, step S6 is performed to update and save the data management system. If not, the process returns to step S1.
Referring to fig. 2, the specific application interfaces of step S1, step S2, step S3, step S4, step S5 and step S6 are as follows:
after logging in the data management system and clicking an import-property file import menu item, the data management system displays an import interface of the property file.
The title file import interface comprises a text box for checking and accepting a batch number, a text box for a file number, a selection box for judging whether to enforce import, an import button, an abort button and an import detail window. The import schedule window displays the related schedule operation and the operation time corresponding to the schedule operation.
After the acceptance batch number is input 20170816020001 and G2001-05409 is input in the file number, the import button is clicked, the detail operation firstly displays the number of files imported by the acceptance batch number, the number is one, and then the following operations are sequentially executed: opening the data of the property file, recording the import journal detail table of the property file, opening the corresponding data table in the property file, and updating all the data tables, the corresponding import mark and the completion mark of the import journal detail table in the data management system after one opening is finished.
During the completion of the above process, the data management system will automatically generate the import log, difference log, and rollback log for the acceptance batch number 20170816020001. The import log is used for consulting import records, the difference log is used for consulting modification contents before and after the import of the collected data and seeking sources of related error data, and the rollback log is used for recovering corresponding original values of the fields.
Referring to fig. 1, after step S6 is completed, step S7 is performed to determine whether to query the import log, and if so, step S8 is performed to search and display the import log; if not, go to step S9, determine whether to query the difference log. In this embodiment, step S7 is specifically to determine whether the query-import log query menu item is clicked, and if so, the system displays an interface for importing log query.
Step S8: finding and displaying import logs
Referring to fig. 3, the operation of referring to the import log is as follows: the import log query interface comprises an import date pull-down menu bar, an import end date pull-down menu bar and an import type pull-down menu bar, wherein the import type pull-down menu bar selects 'all' by default, an import batch number text box, a check batch number text box, a case number text box, a registration number text box, a success pull-down menu bar, the success pull-down menu bar selects 'all' by default, an error type pull-down menu bar, the error type pull-down menu bar selects 'all' by default, an error description text box, a selection box for specifying a file, a selection box for selecting a descending order of detail, a query button, an operation button, an import log display window and a detail log list window in an import log.
Selecting the data import time range from 2018-7-20 to 2018-10-2, and inputting a file number: g2001-05409, according to the above query conditions, the system will search and display the corresponding import log and the corresponding detail log table.
The import log display window displays the serial number of the import log: 1. the introduction date: 2018-7-20, import batch number: 201807200052, import type: title archive data import, import total: 1. total number of successes: 1, total number of errors: 0, import start time: 2018-7-20, import end time: 2018-7-20, and an introducer: system administrator and acceptance lot number: 20170816020001.
the detail log displays all files in the import log, and only one file is in the collected data with the acceptance batch number of 20170816020001, so that the corresponding serial number of the file is 1, and the file case number of the file is as follows: g2001-05409, file registration number: qdd20011030, the error type of the file is null value, the error description of each file is null value, the rollback log of each file is null value, whether the successful hook option is imported is checked.
When the step S9 is executed to determine whether to query the difference log, if yes, the step S10 is executed: searching and displaying a difference log; if not, step S11 is executed to determine whether to import the single volume rollback log. In this embodiment, step S9 is to determine whether the query-difference log query menu item is clicked, and if so, the system displays an interface for importing log query.
Step S10, finding and displaying difference log
Referring to fig. 4, the operation of referring to the difference log is as follows: clicking the query-difference log query menu item, the system will display the difference log query interface.
The difference log query interface comprises a pull-down menu bar of an import date, a pull-down menu bar of an end date and a pull-down menu bar of an import type, wherein all, a text box of a checking and accepting batch number, a text box of a file number, a text box of a registration number, a text box of a data table name, a text box of a field name, a query button, an export button and a difference log display window are selected by default in the pull-down menu bar of the import type.
Selecting a data import time range: 2018-7-20 to 2018-7-20, inputting an import batch number: 201807200052, case number: g2001-05409, clicking the query button, the system will search and display the corresponding difference log.
The difference log shows that the profile number is: two difference logs corresponding to G2001-05409, wherein the sequence number of the file is shown in one difference log: 1, file number of file: g2001-05409, file registration number: qdd20011030, operation of archive: modification and data table name: TBRWRRECORCLINK, primary key value of the file 3147712, field name of the file RIGHTCERTSTATEID, field original value of the file: unchanged, field new value: partial change, lead-in date: 2018-7-20, import batch number: 201807200052.
the other difference log comprises the sequence number of the file: 2, file number of file: g2001-05409, file registration number: qdd20011030, operation of archive: modification and data table name: TBRWRIRIGTERT, 1850748 as the primary key value of the file, RIGHTCERTSTATEID as the field name of the file, and RIGHTCERTSTATEID as the original value of the field of the file: partial change, field new value: all change, import date: 2018-7-20, import batch number: 201807200052. when step S11 is executed, it is determined whether to import a single volume rollback log, if yes, step S12 is executed to import a single volume rollback log; if not, go to step S13: and judging whether to import the rollback log in batch.
In the data use process, if the document state number of the file with the file number of G2001-05409 is found to be wrong, in order to analyze the error reason of the file data, the file with the file number of G2001-05409 is opened in the file management system, a difference log button is clicked, the system displays all the difference logs with the file number of G2001-05409, referring to the attached figure 5, a key difference log list window and a pull-down menu bar of a lookup mode are displayed in a file difference log interface, the lookup mode selects 'simplification', and the field name is found: a difference log of ticket status numbers. The difference log shows the import lot number of the file: 201807200052, operation type: modification and data table name: file ticket number, primary key field value: 1850748, field name: ticket state number, field original value: partial change, field new value: all of which are changed. Therefore, the import single roll rollback is needed to be performed when the import data is collected and put in storage.
Referring to fig. 6, in order to compare the effects before and after rollback, the file information before rollback is recorded, the query-file query menu item is clicked, and the file query interface is opened, which includes a pull-down menu bar, text boxes associated with the pull-down menu bar, selection boxes for fuzzy query, text boxes for each page, advanced query buttons, and a file display window.
Selecting 'file number' in a drop-down menu bar, filling G2001-05409 in a text box associated with the drop-down menu bar, filling the number of each page as 1000, and clicking for query.
The file display window displays the sequence numbers: 1. the file number: g2001-05409, registration number: qdd20011030, the number of online application is null value, service detail item: historical archive arrangement and right document number: 440421, ticket type: property right of the house and the number of the property right: 2499422, title serial number: 2499422, the ticket status is: all changed profile information.
Referring to fig. 7, in the import log query interface, the import date is filled: 2018-7-20, end date: 2018-10-2, inputting in a case number text box: g2001-05409, click query.
The archive detail with the file number G2001-05409, which needs to be rolled back, is selected in the detail log table of the import log, and then the "…" button in the roll-back log is clicked.
The data management system will pop up the "rollback log consult" form, click the "rollback" button, and click the "yes" button in the popped confirmation rollback dialog, thereby performing step S11 of determining whether to import the single roll rollback log. The data management system will roll back the import data for the current archive details to perform step S12, import single volume roll back log. See fig. 8.
After the import single volume rollback is executed, the data of the file with the file number G2001-05409 in the file management system is restored to the state before the import.
When the archive with the archive number of G2001-05409 is queried again in the archive query interface, it can be found that the archive information is restored, i.e., the ticket state is restored from "all changes" to "partial changes". See fig. 9.
When step S13 is executed, it is determined whether to import the rollback log in batch, if yes, step S14 is executed to import the rollback log in batch; if not, the import method of the rollback file acquisition data is ended.
In the import log query, if it is desired to roll back the data whose acceptance lot number is 20170816020001, it is necessary to check a "descending order of detail" check box and enter the import date: 2018-7-20, end date: 2018-10-2, 20170816020001 can be filled in the text box of the acceptance batch number, or the document number G2001-05409 in the acceptance batch number can be filled in the document number, so as to inquire out the specified acceptance batch. In the import batch grid, an import batch to be rolled back is selected, an 'operation' button is clicked, and an 'import batch roll back' menu item is selected in a pop-up menu. As shown in fig. 10.
Clicking the "yes" button in the popped confirm rollback dialog executes step S13 to determine whether to import a batch rollback log. The system will roll back the import data for the currently selected batch to perform step S14, batch import rollback log. As shown in fig. 11.
After performing the batch rollback, the data of all the archives of the batch in the data management system will be restored to the pre-import state. The rollback effect is the same as that of the imported single roll, and is not described herein.
Therefore, the embodiment can quickly analyze the reason causing the file data error by generating the difference log, and can find the person responsible for inputting the error data according to the corresponding import log; by generating the rollback log, data before import can be quickly recovered.
The embodiment of the computer device comprises:
the computer device of the present embodiment includes a processor, a memory, and a computer program stored in the memory and executable on the processor, such as a data management system for generating a difference log. The processor realizes the steps of the importing method of the rollback archive acquisition data when executing the computer program.
For example, a computer program may be partitioned into one or more modules that are stored in a memory and executed by a processor to implement the modules of the present invention. One or more of the modules may be a series of computer program instruction segments capable of performing certain functions, which are used to describe the execution of the computer program in the terminal device.
It should be noted that the terminal device may be a desktop computer, a notebook, a palm computer, a cloud server, or other computing devices. The terminal device may include, but is not limited to, a processor, a memory. It will be understood by those skilled in the art that the schematic diagram of the present invention is merely an example of a terminal device, and does not constitute a limitation of the terminal device, and may include more or less components than those shown, or combine some components, or different components, for example, the terminal device may further include an input-output device, a network access device, a bus, etc.
The Processor may be a Central Processing Unit (CPU), or may be other general-purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, a discrete Gate or transistor logic device, a discrete hardware component, or the like. The general-purpose processor may be a microprocessor or the processor may be any conventional processor or the like, the processor being the control center of the terminal device and connecting the various parts of the entire terminal device using various interfaces and lines.
The memory may be used to store computer programs and/or modules, and the processor may implement various functions of the terminal device by running or executing the computer programs and/or modules stored in the memory and invoking data stored in the memory. The memory may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data (such as audio data, a phonebook, etc.) created according to the use of the cellular phone, and the like. In addition, the memory may include high speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other volatile solid state storage device.
Computer-readable storage medium embodiments:
the module integrated with the terminal device may be stored in a computer-readable storage medium if it is implemented in the form of a software functional unit and sold or used as a separate product. Based on such understanding, all or part of the processes in the method according to the embodiments of the present invention may also be implemented by a computer program, which may be stored in a computer-readable storage medium, and when the computer program is executed by a processor, the computer program may implement the steps of the importing method of the rollback profile collection data.
Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer readable medium may include: any entity or device capable of carrying computer program code, recording medium, U.S. disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution media, and the like. It should be noted that the computer readable medium may contain other components which may be suitably increased or decreased as required by legislation and patent practice in jurisdictions, for example, in some jurisdictions, in accordance with legislation and patent practice, the computer readable medium does not include electrical carrier signals and telecommunications signals.
The above-described embodiments are merely preferred examples of the present invention, and not intended to limit the scope of the invention, so that equivalent changes or modifications in the structure, features and principles of the invention described in the claims should be included in the claims.
Claims (9)
1. An importing method of rollback archive collected data, comprising:
acquiring collected data, wherein the collected data comprises an identifier of the collected data, the collected data is imported into a data management system, the collected data is files accepted in the same batch, at least one file is accepted in the same batch, the identifier of the collected data comprises an acceptance batch number corresponding to the batch and a file number corresponding to each file, the file comprises a plurality of data tables, and each data table comprises a plurality of fields;
after the collected data are imported into a data management system, generating a corresponding rollback log according to a field original value of the data management system, storing the rollback log, and matching the rollback log with the identifier;
after the collected data are imported into a data management system, comparing the original data value of the data management system with the new data value of the data management system, and if the original data value and the new data value are different, generating a corresponding difference log: generating a corresponding difference log according to the original field value of the data management system and the new field value of the data management system, storing the difference log, and matching the difference log with the identifier;
and judging whether the steps are finished or not, and if so, updating and storing the collected data, the rollback log and the difference log of the data management system.
2. An importing method of rollback archive collection data according to claim 1, wherein:
after the collected data, the rollback log and the difference log of the data management system are updated and stored, an operation instruction for opening a difference log query interface is received, the difference log query interface is opened, the input identifier information is received, and the corresponding difference log is searched and displayed according to the identifier.
3. An importing method of rollback archive collection data according to claim 1, wherein:
the collected data import data management system comprises: and importing the collected data into a data management system, generating a corresponding import log, storing the import log, and matching the import log with the identifier.
4. An importing method of rollback archive collection data according to claim 3, wherein:
after the collected data, the rollback log and the difference log of the data management system are updated and stored, an operation instruction for opening the import log query interface is received, the import log query interface is opened, the input identifier information is received, and the corresponding import log is searched and displayed according to the identifier.
5. An importing method of rollback archive collection data according to claim 1, wherein:
generating a corresponding difference log for each field with difference;
matching said acceptance batch numbers with corresponding difference logs, each said acceptance batch number corresponding to at least one of said difference logs or no corresponding said difference log;
and matching the file number with corresponding difference logs, wherein each file number corresponds to at least one difference log or no corresponding difference log.
6. An importing method of rollback archive collection data according to claim 1, wherein:
matching the file number with a corresponding rollback log, wherein each file number in each acceptance batch number corresponds to one rollback log;
after the collected data, the rollback log and the difference log of the data management system are updated and stored, receiving the input information of the file number, searching and displaying the corresponding rollback log according to the file number, receiving an instruction whether the rollback log needs to be consulted, and displaying the details of the rollback log according to the file number if the rollback log needs to be consulted;
and receiving an instruction whether the rollback log needs to be recovered, and if so, recovering the original data value of the data management system according to the rollback log single volume.
7. An importing method of rollback archive collection data according to claim 1, wherein:
matching the acceptance batch number with a corresponding rollback log, wherein each rollback log corresponding to the acceptance batch number is matched with each file corresponding to the acceptance batch number;
after the collected data, the rollback log and the difference log of the data management system are updated and stored, receiving the input acceptance batch number information, and searching and displaying the corresponding rollback log according to the acceptance batch number;
and receiving an instruction whether the rollback log needs to be restored in batch, and if so, restoring the original data value of the data management system in batch according to the rollback log.
8. Computer arrangement, characterized in that it comprises a processor and a memory, said memory storing a computer program which, when being executed by the processor, carries out the steps of the method for importing rollback profile collection data according to any one of claims 1 to 7.
9. A computer-readable storage medium having stored thereon a computer program, characterized in that: the computer program when executed by a processor performs the steps of the method of importing rollback archive collection data according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811261269.XA CN109460318B (en) | 2018-10-26 | 2018-10-26 | Import method of rollback archive collected data, computer device and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811261269.XA CN109460318B (en) | 2018-10-26 | 2018-10-26 | Import method of rollback archive collected data, computer device and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109460318A CN109460318A (en) | 2019-03-12 |
| CN109460318B true CN109460318B (en) | 2021-01-01 |
Family
ID=65608668
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811261269.XA Active CN109460318B (en) | 2018-10-26 | 2018-10-26 | Import method of rollback archive collected data, computer device and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109460318B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110909031A (en) * | 2019-11-28 | 2020-03-24 | 深圳明辉智能技术有限公司 | Distributed personnel file management system |
| CN111638996B (en) * | 2020-05-14 | 2023-04-11 | 华中科技大学 | Method and system for ensuring fault atomicity in nonvolatile memory |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2011008806A1 (en) * | 2009-07-15 | 2011-01-20 | Bbs Technologies, Inc. | System, method, and computer program product for creating a virtual database |
| CN104301360A (en) * | 2013-07-19 | 2015-01-21 | 阿里巴巴集团控股有限公司 | Method, log server and system for recording log data |
| CN106681863A (en) * | 2016-12-30 | 2017-05-17 | 北京天健源达科技有限公司 | Method for storing edited contents of electronic medical records and terminal equipment |
| CN107276814A (en) * | 2017-06-30 | 2017-10-20 | 郑州云海信息技术有限公司 | A kind of distributed storage Troubleshooting information management system and method |
| CN108629026A (en) * | 2018-05-09 | 2018-10-09 | 上海达梦数据库有限公司 | A kind of update method of full-text index, device, equipment and storage medium |
Family Cites Families (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020178146A1 (en) * | 2001-05-24 | 2002-11-28 | International Business Machines Corporation | System and method for selective object history retention |
| JP4301849B2 (en) * | 2003-03-31 | 2009-07-22 | 株式会社日立製作所 | Information processing method and its execution system, its processing program, disaster recovery method and system, storage device for executing the processing, and its control processing method |
| US8768890B2 (en) * | 2007-03-14 | 2014-07-01 | Microsoft Corporation | Delaying database writes for database consistency |
| CN102096623A (en) * | 2009-12-14 | 2011-06-15 | 深圳速浪数字技术有限公司 | Operation log generation method, server and business operational support system |
| US20110161917A1 (en) * | 2009-12-29 | 2011-06-30 | Microgen Plc | Processing collections of data items |
| US8666944B2 (en) * | 2010-09-29 | 2014-03-04 | Symantec Corporation | Method and system of performing a granular restore of a database from a differential backup |
| CN102508835B (en) * | 2011-09-22 | 2015-04-15 | 用友软件股份有限公司 | Incremental data real-time synchronizing device based on log management packet and incremental data real-time synchronizing method based on same |
| US9501501B2 (en) * | 2013-03-15 | 2016-11-22 | Amazon Technologies, Inc. | Log record management |
| CN105843702B (en) * | 2015-01-14 | 2019-04-12 | 阿里巴巴集团控股有限公司 | A kind of method and device for data backup |
| CN105573863A (en) * | 2015-12-14 | 2016-05-11 | 北京尚易德科技有限公司 | Index file recovery method and apparatus and video monitoring system |
| CN106502825B (en) * | 2016-10-13 | 2020-02-14 | 中国联合网络通信集团有限公司 | Data processing method and device |
| US10261868B2 (en) * | 2016-11-17 | 2019-04-16 | International Business Machines Corporation | Using a forward log storage and backward log storage to recover a storage to a forward or backward point-in-time |
-
2018
- 2018-10-26 CN CN201811261269.XA patent/CN109460318B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2011008806A1 (en) * | 2009-07-15 | 2011-01-20 | Bbs Technologies, Inc. | System, method, and computer program product for creating a virtual database |
| CN104301360A (en) * | 2013-07-19 | 2015-01-21 | 阿里巴巴集团控股有限公司 | Method, log server and system for recording log data |
| CN106681863A (en) * | 2016-12-30 | 2017-05-17 | 北京天健源达科技有限公司 | Method for storing edited contents of electronic medical records and terminal equipment |
| CN107276814A (en) * | 2017-06-30 | 2017-10-20 | 郑州云海信息技术有限公司 | A kind of distributed storage Troubleshooting information management system and method |
| CN108629026A (en) * | 2018-05-09 | 2018-10-09 | 上海达梦数据库有限公司 | A kind of update method of full-text index, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109460318A (en) | 2019-03-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2020253399A1 (en) | Log classification rule generation method, device, apparatus, and readable storage medium | |
| CN108334609B (en) | Method, device, equipment and storage medium for realizing JSON format data access in Oracle | |
| WO2020155740A1 (en) | Information query method and apparatus, and computer device and storage medium | |
| WO2022134583A1 (en) | Insurance data information generation method, apparatus, server, and storage medium | |
| CN102110102A (en) | Data processing method and device, and file identifying method and tool | |
| CN109460318B (en) | Import method of rollback archive collected data, computer device and computer readable storage medium | |
| CN111061733B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| CN111460232A (en) | Functional module searching method, device, terminal and computer readable storage medium | |
| CN114510478A (en) | General data entry method, device, equipment and medium based on data model | |
| CN108345658B (en) | Decomposition processing method of algorithm calculation track, server and storage medium | |
| CN115757629A (en) | Multi-source heterogeneous data increment synchronization method and system, storage medium and electronic equipment | |
| CN112765102B (en) | File system management method and device | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| CN112988280A (en) | Configuration data processing method and device | |
| CN112631833A (en) | Data archiving and querying method, system, storage medium and equipment | |
| CN111858581A (en) | Page query method and device, storage medium and electronic equipment | |
| CN115544050A (en) | Operation log recording method, device, equipment and storage medium | |
| CN113434585B (en) | Resource preservation method and equipment | |
| WO2018206819A1 (en) | Data storage method and apparatus | |
| CN114443634A (en) | Data quality checking method, device, equipment and storage medium | |
| CN112817931B (en) | Incremental version file generation method and device | |
| CN112287027A (en) | Database synchronization method, device, equipment and storage medium | |
| CN111859863A (en) | Document structure conversion method and device, storage medium and electronic equipment | |
| CN111045983A (en) | Nuclear power station electronic file management method and device, terminal equipment and medium | |
| JP2021056704A (en) | Data extracting method and data extracting program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |