CN106021369A - Method and equipment for data change management - Google Patents
Method and equipment for data change management Download PDFInfo
- Publication number
- CN106021369A CN106021369A CN201610307891.4A CN201610307891A CN106021369A CN 106021369 A CN106021369 A CN 106021369A CN 201610307891 A CN201610307891 A CN 201610307891A CN 106021369 A CN106021369 A CN 106021369A
- Authority
- CN
- China
- Prior art keywords
- data
- information
- record
- data record
- target data
- 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
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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2474—Sequence data queries, e.g. querying versioned data
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Fuzzy Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The purpose of the invention is to provide a method and equipment for data change management. The method specifically comprises the steps of: acquiring a trace instruction relevant to a target data object, wherein the trace instruction corresponds to a specified historical period of time; acquiring data records in the specified historical period of time according to identifying information of the target data object; and determining change information of the target data object according to the data records. According to the method and the equipment for data change management provided by the invention, the trace instruction relevant to the target data object is acquired, the data records in the corresponding historical period of time are acquired according to the identifying information of the target data object and thus the change information of the target data object is determined so that a user can inquire the historical change information in multiple versions when inquiring the change information of a target object and can carry out uniformed management and operations to adapt various services, thereby reducing the burden of background maintenance.
Description
Technical field
The application relates to computer realm, particularly relates to a kind of technology for data change management.
Background technology
At the business module that some are important, the such as module such as order processing, financial management, user is to amendment
Information is the most sensitive, needs the data variation before and after record modification, in order to audit in the future or other purposes.
Usual this data modification following function is all to add concrete in corresponding business module by developer
Tracking code, detailed data before and after the field that is modified of record.
But, existing processing mode deposits deficiency, such as: to specify good needs before exploitation and retain history version
This business object which attribute concrete, then carries out code development targetedly；It is required for difference
Business object write the different codes that realizes, and for the attribute of business object or the different numbers of field
Different logical process is carried out according to type；Data variation before and after the last data modification can only be contrasted；
Once data are deleted, and tightly associate with business datum owing to reviewing code, are difficult to its deletion action
Review；Code realizes upper attribute or field with business object and firmly binds, and once needs to review
Field changes, and reduces field or the data attribute etc. of amendment field as increased, all can cause needs
Again write and review code, thus cause the cost realizing business datum version management much more expensive.
Summary of the invention
One purpose of the application is to provide a kind of method and apparatus for data change management.
For achieving the above object, according to an aspect of the application, it is provided that a kind of for data change
The method of management, the method includes:
Obtain and review instruction about target data objects, wherein, described in review instruction correspondence and specify history
Period；
The data record identifying acquisition of information appointment historical period according to described target data objects；
The modification information of described target data objects is determined according to described data record.
According to further aspect of the application, it is provided that a kind of equipment for data change management, should
Equipment includes:
Review instruction acquisition device, review instruction for obtaining about target data objects, wherein, institute
State and review instruction correspondence appointment historical period；
Data record acquisition device, specifies for the identification acquisition of information according to described target data objects and goes through
The data record of history period；
Modification information determines device, for determining the change of described target data objects according to described data record
More information.
Compared with prior art, the application reviews instruction by obtaining about target data objects, according to
Data record in target data objects identification acquisition of information correspondence historical period, and determine therefrom that number of targets
Modification information according to object so that user can inquire about multiple version when inquiring about destination object modification information
Historical changing information, and can be managed collectively and operate adaptation multiple business, reduce background maintenance burden, enter
One step ground, identifies information by the first identification information and second in identification information, can be to target data pair
As effectively searching, do not affected by factors such as target data objects are deleted, further, counted
By serializing, current data record is preserved after changing according to object, thus optimize data management, keep away
Exempt from needing the data object reviewed to carry out classification process, thus raising efficiency.
Accompanying drawing explanation
The detailed description that non-limiting example is made made with reference to the following drawings by reading, this Shen
Other features, objects and advantages please will become more apparent upon:
Fig. 1 illustrates that a kind of equipment for data change management according to one aspect of the application is illustrated
Figure；
Fig. 2 illustrates and illustrates according to the application a kind of equipment for data change management in terms of another
Figure；
Fig. 3 illustrates the data recording equipment signal according to the application a kind of preferred embodiment in terms of another
Figure；
Fig. 4 illustrates according to the application a kind of method flow for data change management in terms of another
Figure；
Fig. 5 illustrates according to the application a kind of method flow for data change management in terms of another
Figure；
Fig. 6 illustrates the step S2 schematic diagram according to the application a kind of preferred embodiment in terms of another；
Fig. 7 illustrates the method flow diagram of a kind of preferred embodiment according to one aspect of the application.
In accompanying drawing, same or analogous reference represents same or analogous parts.
Detailed description of the invention
Below in conjunction with the accompanying drawings the application is described in further detail.
In one typical configuration of the application, terminal, the equipment of service network and trusted party all include
One or more processors (CPU), input/output interface, network interface and internal memory.
Internal memory potentially includes the volatile memory in computer-readable medium, random access memory
(RAM) and/or the form such as Nonvolatile memory, such as read only memory (ROM) or flash memory (flash
RAM).Internal memory is the example of computer-readable medium.
Computer-readable medium includes that removable media permanent and non-permanent, removable and non-is permissible
Information storage is realized by any method or technology.Information can be computer-readable instruction, data knot
Structure, the module of program or other data.The example of the storage medium of computer includes, but are not limited to phase
Become internal memory (PRAM), static RAM (SRAM), dynamic random access memory
(DRAM), other kinds of random access memory (RAM), read only memory (ROM), electricity
Erasable Programmable Read Only Memory EPROM (EEPROM), fast flash memory bank or other memory techniques, read-only
Compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage,
Magnetic cassette tape, magnetic disk storage or other magnetic storage apparatus or any other non-transmission medium,
Can be used for the information that storage can be accessed by a computing device.According to defining herein, computer-readable
Medium does not include non-temporary computer readable media (transitory media), as modulation data signal and
Carrier wave.
Fig. 1 illustrates that a kind of equipment for data change management according to one aspect of the application is illustrated
Figure.Described equipment 1 includes reviewing instruction acquisition device 11, data record acquisition device 12, change letter
Breath determines device 13.
Wherein, review instruction acquisition device 11 and obtain and review instruction about target data objects, wherein,
Described instruction correspondence of reviewing specifies historical period；Data record acquisition device 12 is according to described target data pair
The data record identifying acquisition of information appointment historical period of elephant；Modification information determines that device 13 is according to described
Data record determines the modification information of described target data objects.
Specifically, review instruction acquisition device 11 and obtain and review instruction about target data objects, its
In, described in review instruction correspondence specify historical period.Described target data objects refers to that user needs to follow the tracks of
Service data object, or service data object and under all subservice objects, such as, whole
Financial statement or order processing table, or the date of tax levied in financial statement, in order processing business
Logistics approach place, the quantity in stock of goods.Described review instruction refer to user at needs to target data pair
The instruction that the amendment of elephant or variation history are issued when inquiring about, such as, inquires about in certain warehouse certain
The change record of the every month of goods, or the variation entirety change conditions of inquiry material handling form, bag
Kuo Cang district changes, the change of picking people, obtains the change etc. of quantity.Described review instruction issued by user,
The data record of all historical period of corresponding target data objects is have recorded due to the application place system,
Therefore, review instruction and may specify that multiple versions of any historical period are reviewed, thus be used for comparing
Relatively, or determine therefrom that change record.Such as, shown in Fig. 7, obtain reviewing about number of targets object
Instruction be with circular frame figure indicate " reviewing " step, the step for after i.e. start target data pair
As specifying the inquiry of the data record of historical period.
Those skilled in the art will be understood that the mode reviewing instruction of above-mentioned acquisition target data objects is only
Citing, other modes reviewing instruction stating acquisition target data objects that are existing or that be likely to occur from now on
As being applicable to the application, within also should being included in the application protection domain, and at this with way of reference bag
It is contained in this.
Then, data record acquisition device 12 is specified according to the identification acquisition of information of described target data objects
The data record of historical period.Described identification information, refers to for identifying target data objects historical period
The information of middle data record, such as, the major key ID of certain business object, such as in student information form
Number, or the business row of certain business object are not, and described identification information can be unified to set or identify, as long as
Can identify that target data objects taken in conjunction is to corresponding historical information.Therefore, data record is obtained accordingly
Mode include but not limited to, review the identification information of business object as required and preserving data record
Retrieve in data base or in other module, such as on the left of Fig. 7 shown in flow process, after reviewing initiation,
Find " business major key ", then " searching database ", it would be desirable to the business object major key ID reviewed is going through
History data acknowledgment number is retrieved according in storehouse, finds corresponding a series of amendment record, here, amendment note
Record is desired data record.
Those skilled in the art will be understood that above-mentioned being only according to the mode identifying acquisition of information data record is lifted
Example, other modes according to identification acquisition of information data record that are existing or that be likely to occur from now on such as can be fitted
For the application, within also should being included in the application protection domain, and it is incorporated herein with way of reference at this.
Preferably, described identification information includes the first identification information and the second identification information.Described first knows
Other information refers to unique corresponding certification identification information of target data objects, including business major key, such as,
Diploma numbering in student's diploma Statistics table, can uniquely determine target data objects, and can
The most accurately find target data objects.Described second identification information refers to that target data objects is corresponding
Type or other wider range of scope identification information that can make a look up, including class of service or classification,
Such as, the affiliated institute in student's diploma Statistics table or class, first identify loss of learning or
When cannot inquire data record corresponding to target data objects, general this situation datum target data pair
As deleted situation, target data objects the first identification information, such as industry accurately now cannot be obtained
Business major key, then can be made a look up by the second identification information, such as class of service, thus retrieve this industry
The data record of the target data objects being deleted under business classification, thus launch accordingly to review further.Logical
Cross the second identification information so that reviewing of deleted target data objects is also possibly realized, thus increases
Data management comprehensive and improve the safety of data.
Then, modification information determines that device 13 determines described target data objects according to described data record
Modification information.Described modification information, including the data record of target data objects in historical period many
Alteration between individual version, or the alteration that each historical period is respectively and between existing version.
Data corresponding to target data objects that find in data base or other memory module the most mentioned above are remembered
After record, the BeanUtils instrument of such as apache or similar module is i.e. utilized to record data in appointment and go through
Between multiple versions in the history period or only some old version and existing version are compared namely
" contrasting each property value " shown in Fig. 7, wherein, property value is the data in target data objects,
The sex of such as student, home address etc., thus find the property value of the destination object revised, here,
When data record is searched, if the data that character string etc. were serialized, then can preferentially carry out anti-
Serializing, as shown in Figure 7 " antitone sequence chemical conversion java object ".Preferably, the attribute revised can be entered
Line flag shows " the display different information " in namely Fig. 7, the most highlighted manifest or uses specific character
Labelling.
Fig. 2 illustrates and illustrates according to the application a kind of equipment for data change management in terms of another
Figure.Described equipment 1 includes changing dynamic acquisition device 24, data record save set 25, reviewing finger
Acquisition device 21, data record acquisition device 22, modification information is made to determine device 23.
Wherein, change dynamic acquisition device 24 and obtain the change multidate information of data object；Data record
Save set 25 serializes described data object and preserves the data record of present period；Review instruction to obtain
Device 21 obtains reviews instruction about target data objects, wherein, described in review instruction correspondence and specify and go through
The history period；Data record acquisition device 22 is specified according to the identification acquisition of information of described target data objects and is gone through
The data record of history period；Modification information determines that device 23 unserializing specifies the described data of historical period
Record, determines the modification information of described target data objects according to the described data record after unserializing.
Here, reviewing in instruction acquisition device 21, data record acquisition device 22 and Fig. 2 in Fig. 2
To review instruction acquisition device 11, data record acquisition device 12 same or similar, repeat no more.
Specifically, change dynamic acquisition device 24 and obtain the change multidate information of data object.Described data
The change multidate information of object refers to the situation being modified or occurring change of business object, such as, actively
Inquire about or be found to data object and be altered, or use MD5 calibration technology that target data objects is entered
Row detection, once changes, then by reporting or the mode such as active obtaining obtains change multidate information,
Here, for finding and the change such as the amendment of Monitoring Data object or corrigendum when changing the acquisition of multidate information
Operation, such that it is able to after changing, immediately the data record of current data object is preserved,
Or further process, so that when reviewing, the data record that amendment every time is corresponding can be carried out
Inquiry.
Those skilled in the art will be understood that the mode of above-mentioned acquisition change multidate information is only for example, other
The mode obtaining change multidate information that is existing or that be likely to occur from now on is such as applicable to the application, also should
Within being included in the application protection domain, and it is incorporated herein with way of reference at this.
Then, data record save set 25 serializes described data object and preserves the data of present period
Record.I.e. it is being found to have after data object occurs to change or change to enter the data record in the corresponding period
Row preserves, and uses the mode of serializing, preserves, such as after data record is converted to character string
In Fig. 7 shown in " serializing JSON ", the whole service data object needing to follow the tracks of is used JSON sequence
Row preserve after turning to a file, then carry out version management, and are saved in background data base, Ke Yishi
Arbitrary data storehouse, such as oracle, mysql, mongodb etc., or data file.Here, use
JSON serializes, and the compatibility of data and pardon can be made higher, simultaneously by data after serializing
Record is unified carries out version management, can follow the tracks of the change of all of field, and can contrast random time section
Data variation, simultaneously for only needing for developer to write line code, throws away needing the data followed the tracks of
In version management framework, there is logic follow the tracks of without writing big section more targetedly and review generation
Code, refers to multiple history revisions of data object in this version management.
Those skilled in the art will be understood that the mode of above-mentioned serialized data record is only for example, and other are existing
The mode of serialized data record that is that have or that be likely to occur from now on is such as applicable to the application, also should comprise
Within the application protection domain, and it is incorporated herein with way of reference at this.
Preferably, data record save set 25 is by the key message in the described data object after serializing
Saving as the data record of present period, wherein, described key message includes the knowledge of described data object
Other information.Described key message refers to for being saved in the data record that can carry out historical period inquiry
Information, can be used for identifying the information of data object, or record time, modification time, amendment people etc. some
Necessary information, and user need follow the trail of information.Such as shown in Fig. 7 " record key message UUID,
PK, UserID, Timstamp, Action ", business object that This move will be changed and subobject thereof
After being converted into a json character string, generate a UUID of this amendment record as PK major key, with
Time extract the major key ID of this business object, class of service, current time is stabbed, amendment people's information, increasing/
Delete/change the data such as labelling and be saved in background data base as a record, identify for unique at this UUID
Data object.Preserving key message makes data preservation have specific aim, also makes follow-up reviewing search more
Add efficiently.
Then, in trace back process, modification information determines that device 23 unserializing is specified described in historical period
Data record, determines the change letter of described target data objects according to the described data record after unserializing
Breath.Connect literary composition, if data record is when stored by unserializing, then when searching and obtain appointment history
After section corresponding data record, for allowing users to intuitively to browse or related data contrast instrument can logarithm
Process according to data record, need the data record being currently rendered as character string state is carried out antitone sequence
Change, i.e. as Fig. 7 " is deserialized as java object ", the business object major key reviewed as required
ID retrieves in colophon background data base, finds corresponding a series of amendment record, and passes through JSON
Instrument antitone sequence chemical conversion java object.
Those skilled in the art will be understood that the mode of above-mentioned unserializing data record is only for example, other
The mode of unserializing data record that is existing or that be likely to occur from now on is such as applicable to the application, also should
Within being included in the application protection domain, and it is incorporated herein with way of reference at this.
Fig. 3 illustrates the data recording equipment signal according to the application a kind of preferred embodiment in terms of another
Figure.It is single that described data record acquisition device 12 includes that data record search unit 121, data record obtain
Unit 122.
Wherein, according to described first, data record search unit 121 identifies that information searching specifies historical period
Data record；If data record acquiring unit 122 finds described data record, then obtain described number
According to record, otherwise identify data record described in acquisition of information according to described second.
Specifically, when according to described first, data record search unit 121 identifies that information searching specifies history
The data record of section.Described first identification information refers to unique corresponding certification identification of target data objects
Information, including business major key, such as, the diploma numbering in student's diploma Statistics table, can be only
One determines target data objects, and can the most accurately find target data objects.Therefore according to first
The major key ID of identification information, such as business object retrieves or many of corresponding historical period in data base
The data record of individual version, such as, in the figure 7, " searching database " if existing, then obtains data note
Next step is jumped to after record.
Then, if data record acquiring unit 122 finds described data record, then described data are obtained
Record, otherwise identifies data record described in acquisition of information according to described second.Described second identification information is
Refer to type or other wider range of scope identification information that can make a look up that target data objects is corresponding,
Including class of service or classification, such as, the affiliated institute in student's diploma Statistics table or class.
When first identifies that loss of learning maybe cannot inquire data record corresponding to target data objects, such as, scheme
In 7 there is not the data record of the target data objects of needs, general this situation in " searching database "
The situation that datum target data object is deleted, now cannot obtain target data objects the first knowledge accurately
Other information, such as business major key, then can be made a look up by the second identification information, such as class of service,
Thus retrieve the data record of the target data objects being deleted under this class of service, thus launch accordingly
Review further.If the second identification information is still not found, then can directly terminate to chase after as shown in Figure 7
Trace back.Information is identified so that reviewing of deleted target data objects is also possibly realized by second, from
And add the comprehensive of data management and improve the safety of data.
Those skilled in the art will be understood that and only identify the mode of information searching data record above by second
For citing, other sides by the second identification information searching data record that are existing or that be likely to occur from now on
Formula is such as applicable to the application, within also should being included in the application protection domain, and at this with way of reference
It is incorporated herein.
Fig. 4 illustrates according to the application a kind of method flow for data change management in terms of another
Figure.Described method includes step S1, step S2, step S3.
Wherein, equipment 1 obtains and reviews instruction about target data objects in step sl, wherein, and institute
State and review instruction correspondence appointment historical period；Equipment 1 is according to described target data objects in step s 2
Identify that acquisition of information specifies the data record of historical period；Equipment 1 is remembered according to described data in step s3
Record determines the modification information of described target data objects.
Specifically, equipment 1 obtains and reviews instruction about target data objects in step sl, wherein,
Described instruction correspondence of reviewing specifies historical period.Described target data objects refers to that user needs the industry followed the tracks of
Business data object, or service data object and under all subservice objects, such as, whole finance
Form or order processing table, or the date of tax levied in financial statement, the logistics in order processing business
Approach place, the quantity in stock of goods.Described review instruction refer to that user is needing target data objects
The instruction that amendment or variation history are issued when inquiring about, such as, inquires about certain goods in certain warehouse
The change record of every month, or the variation entirety change conditions of inquiry material handling form, including storehouse
District changes, the change of picking people, obtains the change etc. of quantity.Described review instruction issued by user, by
The data record of all historical period of corresponding target data objects is have recorded in the application place system, because of
This, review instruction and may specify that multiple versions of any historical period are reviewed, thus is used for comparing,
Or determine therefrom that change record.Such as, shown in Fig. 7, obtain and review instruction about number of targets object
Be " reviewing " step indicated with circular frame figure, the step for after i.e. start target data objects referred to
Determine the inquiry of the data record of historical period.
Those skilled in the art will be understood that the mode reviewing instruction of above-mentioned acquisition target data objects is only
Citing, other modes reviewing instruction stating acquisition target data objects that are existing or that be likely to occur from now on
As being applicable to the application, within also should being included in the application protection domain, and at this with way of reference bag
It is contained in this.
Then, equipment 1 is gone through according to the identification acquisition of information appointment of described target data objects in step s 2
The data record of history period.Described identification information, refers to for identifying in target data objects historical period
The information of data record, such as, the major key ID of certain business object, such as the student number in student information form,
Or the business row of certain business object are not, described identification information can be unified to set or identify, as long as can know
Other target data objects taken in conjunction is to corresponding historical information.Therefore, the side of data record is obtained accordingly
Formula includes but not limited to, reviews the identification information of business object as required in the data preserving data record
Retrieve in storehouse or in other module, such as, on the left of Fig. 7 shown in flow process, after reviewing initiation, find
" business major key ", then " searching database ", it would be desirable to the business object major key ID reviewed is at history number
Retrieve according in database of record, find corresponding a series of amendment record, here, amendment record is i.e.
For desired data record.
Those skilled in the art will be understood that above-mentioned being only according to the mode identifying acquisition of information data record is lifted
Example, other modes according to identification acquisition of information data record that are existing or that be likely to occur from now on such as can be fitted
For the application, within also should being included in the application protection domain, and it is incorporated herein with way of reference at this.
Preferably, described identification information includes the first identification information and the second identification information.Described first knows
Other information refers to unique corresponding certification identification information of target data objects, including business major key, such as,
Diploma numbering in student's diploma Statistics table, can uniquely determine target data objects, and can
The most accurately find target data objects.Described second identification information refers to that target data objects is corresponding
Type or other wider range of scope identification information that can make a look up, including class of service or classification,
Such as, the affiliated institute in student's diploma Statistics table or class, first identify loss of learning or
When cannot inquire data record corresponding to target data objects, general this situation datum target data pair
As deleted situation, target data objects the first identification information, such as industry accurately now cannot be obtained
Business major key, then can be made a look up by the second identification information, such as class of service, thus retrieve this industry
The data record of the target data objects being deleted under business classification, thus launch accordingly to review further.Logical
Cross the second identification information so that reviewing of deleted target data objects is also possibly realized, thus increases
Data management comprehensive and improve the safety of data.
Then, equipment 1 determines the change of described target data objects according to described data record in step s3
More information.Described modification information, including multiple in historical period of the data record of target data objects
Alteration between version, or the alteration that each historical period is respectively and between existing version.
Data corresponding to target data objects that find in data base or other memory module the most mentioned above are remembered
After record, the BeanUtils instrument of such as apache or similar module is i.e. utilized to record data in appointment and go through
Between multiple versions in the history period or only some old version and existing version are compared namely
" contrasting each property value " shown in Fig. 7, wherein, property value is the data in target data objects,
The sex of such as student, home address etc., thus find the property value of the destination object revised, here,
When data record is searched, if the data that character string etc. were serialized, then can preferentially carry out anti-
Serializing, as shown in Figure 7 " antitone sequence chemical conversion java object ".Preferably, the attribute revised can be entered
Line flag shows " the display different information " in namely Fig. 7, the most highlighted manifest or uses specific character
Labelling.
Fig. 5 illustrates according to the application a kind of method flow for data change management in terms of another
Figure.Described method includes step S4, step S5, step S1, step S2, step S3.
Wherein, equipment 1 obtains the change multidate information of data object in step s 4；In step s 5
Equipment 1 serializes described data object and preserves the data record of present period；Equipment 1 in step sl
Obtain and review instruction about target data objects, wherein, described in review instruction correspondence and specify historical period；
Equipment 1 is according to the number identifying acquisition of information appointment historical period of described target data objects in step s 2
According to record；Equipment 1 unserializing specifies the described data record of historical period in step s3, according to instead
Described data record after serializing determines the modification information of described target data objects.
Here, step S1 in Fig. 5, step S2 and step S1 in Fig. 4, step S2 are identical or
Similar, repeat no more.
Specifically, equipment 1 obtains the change multidate information of data object in step s 4.Described data pair
The change multidate information of elephant refers to the situation being modified or occurring change of business object, such as, actively looks into
Ask or be found to data object and be altered, or use MD5 calibration technology that target data objects is carried out
Detection, once changes, then by reporting or the mode such as active obtaining obtains change multidate information,
This, grasp for discovery and the change such as the amendment of Monitoring Data object or corrigendum when changing the acquisition of multidate information
Make, such that it is able to after changing, immediately the data record of current data object is preserved, or
Further process, so that when reviewing, the data record that amendment every time is corresponding can be looked into
Ask.
Those skilled in the art will be understood that the mode of above-mentioned acquisition change multidate information is only for example, other
The mode obtaining change multidate information that is existing or that be likely to occur from now on is such as applicable to the application, also should
Within being included in the application protection domain, and it is incorporated herein with way of reference at this.
Then, equipment 1 serializes described data object and preserves the data note of present period in step s 5
Record.I.e. after being found to have data object generation change or change, the data record in the corresponding period is carried out
Preserve, and use the mode of serializing, preserve after data record is converted to character string, such as, scheme
In 7 shown in " serializing JSON ", the whole service data object needing to follow the tracks of is used JSON sequence
Preserve after turning to a file, then carry out version management, and be saved in background data base, can be to appoint
Meaning data base, such as oracle, mysql, mongodb etc., or data file.Here, use JSON
Serialize, the compatibility of data and pardon can be made higher, simultaneously by data record after serializing
Unification carries out version management, can follow the tracks of the change of all of field, and can contrast the data of random time section
Change, simultaneously for only needing for developer to write line code, throws away version needing the data followed the tracks of
In this Governance framework, there is logic follow the tracks of without writing big section more targetedly and review code,
Multiple history revisions of data object are referred in this version management.
Those skilled in the art will be understood that the mode of above-mentioned serialized data record is only for example, and other are existing
The mode of serialized data record that is that have or that be likely to occur from now on is such as applicable to the application, also should comprise
Within the application protection domain, and it is incorporated herein with way of reference at this.
Preferably, the key message in the described data object after serializing is protected by equipment 1 in step s 5
Saving as the data record of present period, wherein, described key message includes the identification of described data object
Information.Described key message refers to for being saved in the letter in the data record that can carry out historical period inquiry
Breath, can be used for identifying the information of data object, or some must to record time, modification time, amendment people etc.
Want information, and user needs the information of tracking.Such as shown in Fig. 7 " record key message UUID,
PK, UserID, Timstamp, Action ", business object that This move will be changed and subobject thereof
After being converted into a json character string, generate a UUID of this amendment record as PK major key, with
Time extract the major key ID of this business object, class of service, current time is stabbed, amendment people's information, increasing/
Delete/change the data such as labelling and be saved in background data base as a record, identify for unique at this UUID
Data object.Preserving key message makes data preservation have specific aim, also makes follow-up reviewing search more
Add efficiently.
Then, in trace back process, equipment 1 unserializing specifies the described number of historical period in step s3
According to record, determine the modification information of described target data objects according to the described data record after unserializing.
Connect literary composition, if data record is when stored by unserializing, then search and obtaining appointment historical period pair
After answering data record, for allowing users to intuitively to browse or related data contrast instrument can be to data number
Process according to record, need the data record being currently rendered as character string state is carried out unserializing,
I.e. as " being deserialized as java object " in Fig. 7, the business object major key ID reviewed as required exists
Colophon background data base is retrieved, finds corresponding a series of amendment record, and by JSON work
Tool antitone sequence chemical conversion java object.
Those skilled in the art will be understood that the mode of above-mentioned unserializing data record is only for example, other
The mode of unserializing data record that is existing or that be likely to occur from now on is such as applicable to the application, also should
Within being included in the application protection domain, and it is incorporated herein with way of reference at this.
Fig. 6 illustrates the step S2 schematic diagram according to the application a kind of preferred embodiment in terms of another.Institute
State step S2 and include step S21, step S22.
Wherein, according to described first, equipment 1 identifies that information searching specifies historical period in the step s 21
Data record；If equipment 1 finds described data record in step S22, then obtain described data note
Record, otherwise identifies data record described in acquisition of information according to described second.
Specifically, according to described first, equipment 1 identifies that information searching specifies historical period in the step s 21
Data record.Described first identification information refers to the unique corresponding certification identification letter of target data objects
Breath, including business major key, such as, the diploma numbering in student's diploma Statistics table, can be unique
Determine target data objects, and can the most accurately find target data objects.Therefore know according to first
Other information, the major key ID of such as business object retrieves the one or more of corresponding historical period in data base
The data record of version, such as, in the figure 7, " searching database " if existing, then obtains data record
After jump to next step.
Then, if equipment 1 finds described data record in step S22, then described data note is obtained
Record, otherwise identifies data record described in acquisition of information according to described second.Described second identification information refers to
Type that target data objects is corresponding or other wider range of scope identification information that can make a look up, bag
Include class of service or classification, such as, the affiliated institute in student's diploma Statistics table or class.?
First identifies when loss of learning maybe cannot inquire data record corresponding to target data objects, such as Fig. 7
In " searching database " there is not the data record of target data objects of needs, general this situation number
Situation about being deleted according to target data objects, now cannot obtain target data objects and first identify accurately
Information, such as business major key, then can be made a look up by the second identification information, such as class of service, from
And retrieve the data record of target data objects being deleted under this class of service, thus launch accordingly into
One step is reviewed.If the second identification information is still not found, then can directly terminate to review as shown in Figure 7.
Information is identified so that reviewing of deleted target data objects is also possibly realized, thus increases by second
Add the comprehensive of data management and improved the safety of data.
Those skilled in the art will be understood that and only identify the mode of information searching data record above by second
For citing, other sides by the second identification information searching data record that are existing or that be likely to occur from now on
Formula is such as applicable to the application, within also should being included in the application protection domain, and at this with way of reference
It is incorporated herein.
Obviously, those skilled in the art the application can be carried out various change and modification without deviating from
Spirit and scope.So, if these amendments of the application and modification belong to the application power
Profit requires and within the scope of equivalent technologies, then the application is also intended to comprise these changes and modification exists
In.
It should be noted that the application can be carried out in the assembly of hardware at software and/or software,
Such as, special IC (ASIC), general purpose computer can be used or any other is similar hard
Part equipment realizes.In one embodiment, the software program of the application can be performed by processor
To realize steps described above or function.Similarly, the software program of the application (includes the number being correlated with
According to structure) can be stored in computer readable recording medium storing program for performing, such as, and RAM memory, magnetic
Or CD-ROM driver or floppy disc and similar devices.It addition, some steps of the application or function can use
Hardware realizes, and such as, performs the circuit of each step or function as coordinating with processor.
It addition, the part of the application can be applied to computer program, such as computer program
Instruction, when it is computer-executed, by the operation of this computer, can call or provide basis
The present processes and/or technical scheme.And call the programmed instruction of the present processes, may be deposited
Store up fixing or movably in record medium, and/or by broadcast or other signal bearing medias
Data stream and be transmitted, and/or be stored in the computer equipment that runs according to described programmed instruction
In working storage.Here, include a device according to an embodiment of the application, this device bag
Include the memorizer for storing computer program instructions and for performing the processor of programmed instruction, its
In, when this computer program instructions is performed by this processor, trigger this plant running based on aforementioned
The method of multiple embodiments and/or technical scheme according to the application.
It is obvious to a person skilled in the art that the application is not limited to the thin of above-mentioned one exemplary embodiment
Joint, and in the case of without departing substantially from spirit herein or basic feature, it is possible to concrete with other
Form realizes the application.Therefore, no matter from the point of view of which point, embodiment all should be regarded as exemplary
, and be nonrestrictive, scope of the present application is limited by claims rather than described above
It is fixed, it is intended that all changes fallen in the implication of equivalency and scope of claim are included
In the application.Any reference in claim should not be considered as limit involved right want
Ask.Furthermore, it is to be understood that " an including " word is not excluded for other unit or step, odd number is not excluded for plural number.
In device claim, multiple unit or the device of statement can also pass through soft by a unit or device
Part or hardware realize.The first, the second word such as grade is used for representing title, and is not offered as any spy
Fixed order.
Claims (10)
1., for a method for data change management, wherein, the method includes:
Obtain and review instruction about target data objects, wherein, described in review instruction correspondence and specify history
Period；
The data record identifying acquisition of information appointment historical period according to described target data objects；
The modification information of described target data objects is determined according to described data record.
Method the most according to claim 1, wherein, described identification information includes the first identification information
Information is identified with second.
Method the most according to claim 2, wherein, the described knowledge according to described target data objects
Other acquisition of information specifies the data record of historical period to include:
Identify that information searching specifies the data record of historical period according to described first；
If finding described data record, then obtain described data record, otherwise identify according to described second
Data record described in acquisition of information.
Method the most according to claim 1, wherein, described method also includes:
Obtain the change multidate information of data object；
Serialize described data object and preserve the data record of present period；
Wherein, described determine that the modification information of described target data objects includes according to described data record:
Unserializing specifies the described data record of historical period, remembers according to the described data after unserializing
Record determines the modification information of described target data objects.
Method the most according to claim 4, wherein, the described data object of described serializing also preserves
The data record of present period includes:
Key message in described data object after serializing is saved as the data record of present period,
Wherein, described key message includes the identification information of described data object.
6., for a data traceability equipment for data change management, wherein, this equipment includes:
Review instruction acquisition device, review instruction for obtaining about target data objects, wherein, institute
State and review instruction correspondence appointment historical period；
Data record acquisition device, specifies for the identification acquisition of information according to described target data objects and goes through
The data record of history period；
Modification information determines device, for determining the change of described target data objects according to described data record
More information.
Equipment the most according to claim 6, wherein, described identification information includes the first identification information
Information is identified with second.
Equipment the most according to claim 7, wherein, described data record acquisition device includes:
According to described first, data record search unit, for identifying that information searching specifies the number of historical period
According to record；
Data record acquiring unit, if for finding described data record, then obtaining described data record,
Otherwise identify data record described in acquisition of information according to described second.
9. wanting the equipment described in 6 according to right, wherein, described equipment also includes:
Change dynamic acquisition device, for obtaining the change multidate information of data object；
Data record save set, for serializing described data object and preserving the data note of present period
Record；
Wherein, described modification information determine device for:
Unserializing specifies the described data record of historical period, remembers according to the described data after unserializing
Record determines the modification information of described target data objects.
10. wanting the equipment described in 9 according to right, wherein, described data record save set is used for:
Key message in described data object after serializing is saved as the data record of present period,
Wherein, described key message includes the identification information of described data object.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610307891.4A CN106021369A (en) | 2016-05-11 | 2016-05-11 | Method and equipment for data change management |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610307891.4A CN106021369A (en) | 2016-05-11 | 2016-05-11 | Method and equipment for data change management |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106021369A true CN106021369A (en) | 2016-10-12 |
Family
ID=57100391
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610307891.4A Pending CN106021369A (en) | 2016-05-11 | 2016-05-11 | Method and equipment for data change management |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106021369A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107748748A (en) * | 2017-07-06 | 2018-03-02 | 北京川流科技开发中心 | Water conservancy and hydropower technical standard text retrieval system |
| CN109255590A (en) * | 2018-09-08 | 2019-01-22 | 中建精诚工程咨询有限公司 | A kind of construction project cost auditing system |
| CN110990414A (en) * | 2019-10-31 | 2020-04-10 | 口碑(上海)信息技术有限公司 | Data processing method and device |
| CN111078828A (en) * | 2019-12-24 | 2020-04-28 | 北京海致星图科技有限公司 | Enterprise historical information extraction method and system |
| CN111782587A (en) * | 2020-06-30 | 2020-10-16 | 北京三快在线科技有限公司 | Snapshot information recording method, device, equipment and storage medium |
| CN111813765A (en) * | 2020-06-19 | 2020-10-23 | 北京金堤科技有限公司 | Abnormal data processing method and device, electronic equipment and computer readable medium |
| CN113780967A (en) * | 2020-11-16 | 2021-12-10 | 北京沃东天骏信息技术有限公司 | Information tracing method and device |
| CN114201615A (en) * | 2021-12-28 | 2022-03-18 | 上海市精神卫生中心（上海市心理咨询培训中心） | Scientific research data change review method based on data snapshot and server |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101256561A (en) * | 2007-03-02 | 2008-09-03 | 阿里巴巴集团控股有限公司 | Method, apparatus and system for storing and accessing database data |
| CN102339321A (en) * | 2011-11-09 | 2012-02-01 | 上海盛霄云计算技术有限公司 | Network file system with version control and method using same |
| CN103530413A (en) * | 2013-10-28 | 2014-01-22 | 北京国双科技有限公司 | Method and device for processing data |
| CN104090987A (en) * | 2014-07-28 | 2014-10-08 | 华中科技大学 | Historical data storage and indexing method |
| CN104468303A (en) * | 2013-09-13 | 2015-03-25 | 方正宽带网络服务股份有限公司 | Internetwork connecting device, server, terminal, data management system and data management method |
-
2016
- 2016-05-11 CN CN201610307891.4A patent/CN106021369A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101256561A (en) * | 2007-03-02 | 2008-09-03 | 阿里巴巴集团控股有限公司 | Method, apparatus and system for storing and accessing database data |
| CN102339321A (en) * | 2011-11-09 | 2012-02-01 | 上海盛霄云计算技术有限公司 | Network file system with version control and method using same |
| CN104468303A (en) * | 2013-09-13 | 2015-03-25 | 方正宽带网络服务股份有限公司 | Internetwork connecting device, server, terminal, data management system and data management method |
| CN103530413A (en) * | 2013-10-28 | 2014-01-22 | 北京国双科技有限公司 | Method and device for processing data |
| CN104090987A (en) * | 2014-07-28 | 2014-10-08 | 华中科技大学 | Historical data storage and indexing method |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107748748A (en) * | 2017-07-06 | 2018-03-02 | 北京川流科技开发中心 | Water conservancy and hydropower technical standard text retrieval system |
| CN109255590A (en) * | 2018-09-08 | 2019-01-22 | 中建精诚工程咨询有限公司 | A kind of construction project cost auditing system |
| CN110990414A (en) * | 2019-10-31 | 2020-04-10 | 口碑(上海)信息技术有限公司 | Data processing method and device |
| CN110990414B (en) * | 2019-10-31 | 2023-06-16 | 口碑(上海)信息技术有限公司 | Data processing method and device |
| CN111078828A (en) * | 2019-12-24 | 2020-04-28 | 北京海致星图科技有限公司 | Enterprise historical information extraction method and system |
| CN111813765A (en) * | 2020-06-19 | 2020-10-23 | 北京金堤科技有限公司 | Abnormal data processing method and device, electronic equipment and computer readable medium |
| CN111813765B (en) * | 2020-06-19 | 2024-04-12 | 北京金堤科技有限公司 | Method, device, electronic equipment and computer readable medium for processing abnormal data |
| CN111782587A (en) * | 2020-06-30 | 2020-10-16 | 北京三快在线科技有限公司 | Snapshot information recording method, device, equipment and storage medium |
| CN113780967A (en) * | 2020-11-16 | 2021-12-10 | 北京沃东天骏信息技术有限公司 | Information tracing method and device |
| CN113780967B (en) * | 2020-11-16 | 2024-07-16 | 北京沃东天骏信息技术有限公司 | Information tracing method and device |
| CN114201615A (en) * | 2021-12-28 | 2022-03-18 | 上海市精神卫生中心（上海市心理咨询培训中心） | Scientific research data change review method based on data snapshot and server |
| CN114201615B (en) * | 2021-12-28 | 2023-06-27 | 上海市精神卫生中心（上海市心理咨询培训中心） | Scientific research data change review method and server based on data snapshot |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106021369A (en) | Method and equipment for data change management | |
| CN105630475B (en) | A kind of data label organization system and method for organizing | |
| CN110008743A (en) | Data attribute identification method, device and equipment in a kind of piece of chain type account book | |
| CN113711221A (en) | Efficient chained record access | |
| US20220229854A1 (en) | Constructing ground truth when classifying data | |
| CN105447030A (en) | Index processing method and equipment | |
| CN111984659B (en) | Data updating method, device, computer equipment and storage medium | |
| CN107515807A (en) | A kind of method and device for storing monitoring data | |
| US20100242027A1 (en) | Identifying groups and subgroups | |
| CN114238085A (en) | Interface testing method and device, computer equipment and storage medium | |
| US20240004871A1 (en) | Systems and methods for targeted data discovery | |
| EP3260997A1 (en) | Method and system for enforcing user policy on database records | |
| CN105760383B (en) | The detection method and device of index change in a kind of ETL task | |
| CN110019357B (en) | Database query script generation method and device | |
| US20140379762A1 (en) | Content management system | |
| CN113849482A (en) | Data migration method and device and electronic equipment | |
| CN114117530A (en) | File leakage detection method and device | |
| JP2018028776A (en) | Software asset management device, software asset management method, and software asset management program | |
| CN111552703A (en) | Data processing method and device | |
| CN113821193A (en) | Information generation method and device and storage medium | |
| CN114036171B (en) | Application data management method, device, computer equipment and storage medium | |
| JP2020101898A (en) | Design drawing creation support method, design drawing creation support device, and design drawing creation support program | |
| CN114817275B (en) | Data reading and writing method, device and equipment of graph database and storage medium | |
| US11526624B2 (en) | Data processing systems and methods for automatically detecting target data transfers and target data processing | |
| CN114710392B (en) | Event information acquisition method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20161012 |