CN110083596A - A kind of method of data history tracking and the tracking of data change histories - Google Patents
A kind of method of data history tracking and the tracking of data change histories Download PDFInfo
- Publication number
- CN110083596A CN110083596A CN201811623790.3A CN201811623790A CN110083596A CN 110083596 A CN110083596 A CN 110083596A CN 201811623790 A CN201811623790 A CN 201811623790A CN 110083596 A CN110083596 A CN 110083596A
- Authority
- CN
- China
- Prior art keywords
- data
- identifier
- activity
- deleted
- new
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
- G06F16/113—Details of archiving
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
- G06F16/162—Delete operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/86—Event-based monitoring
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention is a kind of data and data variation recording and tracking mechanism, method and system.The present invention has introduced " activity ", the concepts such as " activity management reference value " according to the event that has occurred or will occur.For recording and automatically tracking movable (people and thing) relevant to the event.Therefore, it is similar to block chain, the present invention is also a kind of automated trust mechanism.Pass through the concept and record data relevant to event introduced to these and the specific combination for recording personal data, it can answer and the event and record the relevant following Railway Project of event people: what who when? where why acknowledged data can be by logic Modification or deletion, but cannot be by physical removal, i.e. record trace can not be by physical removal.Therefore comprehensive record tracking can be carried out to event and record.Ephemeral data can be left no trace by physical removal.So allowing error correction.
Description
Technical field
This application involves a kind of method that computer field more particularly to data and its variation track, mechanism and system, with
Just automatic to establish commercial affairs trust.
Background technique
It is well known that block chain may can be used to track the data on block chain in block.Block chain is counted by more
The computers such as distributed common classification account data storage, point-to-point transmission, common recognition mechanism, the Encryption Algorithm for calculating interconnection plane to support
The new application mode of technology.
In block chain, each transaction is all when being occurred by the identifier (identifier) and transaction of the transaction
Timestamp confirm.Each block on block chain represents one group of transaction having confirmed that.The link and peace of these blocks
It is by being ensured and being completed by being connected to the network multiple computers together entirely.These computers follow identical agreement,
Use identical cryptography.Each block includes one " work (amount) proves " (Proof of Work), such as Hash or hash.
Work proves, simple to understand to be exactly a prove.Work proves to describe a kind of system.The system needs a large amount of but feasible
Effort, to prevent the malice to computing capability from using.Proof of work mechanism is many encryption goods including bit coin
The foundation stone of coin.
This " work proves " is almost always asymmetric.Whether verifying hash is effective hash of previous block without meter
Calculate intensive or high-intensitive calculating.But hashed as generating one, it needs computation-intensive.For example, in bit coin, often
A hash, which needs network " work " to execute calculating, could generate a hash at least 10 minutes.Therefore, one includes a chain
The new block needs of many blocks of existing (generation) do a large amount of " work ", that is, calculating could generate.The mining of block chain refers to
Be to collect the multiple transaction broadcasted recently and be deposited into " work " done in a new block.Common recognition mechanism is used to true
It is scheduled on the authenticity of the data in new block.Each computer in block chain network stores one of the block chain
Copy or copy.Each computer verifying on the network includes the hash of the previous block in new block and confirms the validity
Afterwards, the new block is just added in its copy by the computer.
Currently, block chain is difficult to the technology barrier gone beyond in the presence of many.These technology barriers include 51% attack, Bu Neng great
Scale, in addition it is also more much smaller than the processing capacity of existing legacy system, and reaction speed is too slow, and (bit coin network needs average
At least 10 minutes complete single transaction), it can be sayed without privacy and trade secret, unsustainable high energy consumption be (bit coin
Energy consumption is about 4000 times of legacy system).
Therefore, it is necessary to which finding better or substitution blocks chain a method carrys out tracking data.
Summary of the invention
The present invention provides a kind of tracking data deletion (as deleted the data for storing and in the database or being displayed on the screen)
Method, comprising:
One new activity identifier (movable ID) of distribution is deleted for the data;
Searched from one or more existing activity identifier sequences and find one it is existing, it is related to data to be deleted
One activity identifier of connection;
Generate a new data identifier (such as activity management refers to (AMR)) comprising: the New activity identifier
With the existing activity identifier;With
The newly-generated data identifier is associated with the data to be deleted, so as to track to the number
According to deletion.
The present invention also provides the tracking systems that a kind of tracking data is deleted, comprising:
One activity identifier distributor is configurable for distributing a new activity mark for the deletion data
Symbol;
One activity identifier locator is configurable for being sought from the sequence of one or more existing identifiers
It looks for and finds
An existing activity identifier associated with the data to be deleted;
One data identification generator is configurable for generating a data identifier.The newly-generated data
Identifier includes the new activity identifier and the existing activity identifier;With
One data identifier correlator is configurable for described deleting the newly-generated data identifier
Data it is associated, so as to track the deletion to the data.
The present invention also provides the method for a kind of deletion of tracking data and/or data insertion, (i.e. data are deleted, data insertion
Or data modification (being inserted into new data while deleting legacy data)), comprising:
Receive the request and execute at least one of data insertion request request (that is, receiving wherein for executing that data are deleted
One request receives the two requests simultaneously);
According to the requirement of request, an activity identifier is distributed in the data deletion and the data insertion operation
At least one operation, for being stored in an activity index (such as one movable table);With
Store a data identifier (such as an activity management refer to (AMR)), including handle deleted with the data and
At least one of described data insertion operation operates the relevant activity identifier and the related institute for being inserted into and/or deleting
It states data correlation and is stored in a data directory (a such as tables of data) together.The data directory is independently of the activity
Except index (such as described movable table).
The present invention also provides a kind of tracking systems, at least one of tracking data deletion and data insertion operation
Operation, comprising:
One request receiver is configurable for receiving in the execution data deletion and the data insertion operation
The request of at least one operation;One activity identifier distributor is configurable for distributing to an activity identifier and hold
The row data are deleted and at least one of data insertion operation operation, and the activity identifier is stored in one
In activity index;With
One data identifier correlator is configurable for one data identifier of storage, including handle and the data
It deletes and at least one of the data insertion operation operates the relevant activity identifier and is associated with simultaneously one with related data
It rises and is stored in a data directory.Except the data directory is independently of the activity index.
Brief description
It will be embodiment description now to can more clearly determine the present invention.The description is by way of example
It describes with reference to the accompanying drawings, in which:
Fig. 1 is the physical structure of the embodiment of a tracking system and the schematic diagram of functional unit;
Fig. 2 is using the system of schematic diagram 1, and the tracking data of progress is deleted and at least one of data insertion operation behaviour
The flow chart of the embodiment of the method for work;
Fig. 3 is the flow chart of the sub-step of one of step of the method for Fig. 2;
Fig. 4 is the flow chart of the sub-step of the another one step of the method for Fig. 2;
Fig. 5 is the flow chart of several additional steps of the method for Fig. 2;
Fig. 6 is the flow chart of several substitution additional steps of the method for Fig. 2;
Fig. 7 includes the schematic diagram an of menu screen and the schematic diagram of a data entry screen;
Fig. 8 includes the update schematic diagram of the data entry screen of Fig. 7, and one implemented by a tracking system embodiment
The schematic diagram of a activity table and a name table;
Fig. 9 includes the update schematic diagram of the data entry screen of Fig. 8, the schematic diagram of the movable table of Fig. 8 and by one with
The schematic diagram for the address table that track system embodiment is implemented;
Figure 10 includes the update schematic diagram of the data entry screen of Fig. 9, the movable table update schematic diagram of Fig. 9 and Fig. 9's
Address form updates schematic diagram and the name table update schematic diagram of Fig. 8;
Figure 11 includes the update schematic diagram of the data entry screen of Figure 10, the schematic diagram of the name table of Figure 10 and Figure 10's
Movable table updates schematic diagram and the address table of Figure 10 updates schematic diagram;
Figure 12 includes the update schematic diagram of the data entry screen of Figure 11, and the address table of Figure 11 updates schematic diagram, Yi Jitu
The 11 movable schematic diagrames of table and the schematic diagram of Figure 11 name table;
Figure 13 includes the update schematic diagram of the data entry screen of Figure 12, Figure 12 activity table update schematic diagram and Figure 12's
Address table updates the schematic diagram of schematic diagram and the name table of Figure 12;
Figure 14 includes that the data entry screen of Figure 13 updates the movable table update schematic diagram of schematic diagram and Figure 13, Figure 13's
Name table schematic diagram and Figure 13 address form schematic diagram, and the telephone meter implemented by a tracking system embodiment
Schematic diagram;
Figure 15 includes that Figure 14 data entry screen updates schematic diagram and telephone meter update schematic diagram, and the movable table of Figure 14 shows
It is intended to,
The name table schematic diagram of Figure 14 and the address form schematic diagram of Figure 14;
Figure 16 includes the update schematic diagram of the data entry screen of Figure 15, the name table schematic diagram of Figure 15 and the ground of Figure 15
Location table schematic diagram, the movable table of Figure 15 updates schematic diagram and the telephone meter of Figure 15 updates schematic diagram;
Figure 17 includes the schematic diagram that the data entry screen of Figure 16 updates, the movable table update schematic diagram and Figure 16 of Figure 16
Phone table update schematic diagram and Figure 16 name table schematic diagram and Figure 16 address form schematic diagram;
Figure 18 A includes that the data entry screen of Figure 17 updates schematic diagram, and the telephone meter of Figure 17 updates schematic diagram and Figure 17
Movable table schematic diagram, the name table schematic diagram of Figure 17 and the address form schematic diagram of Figure 17;
Figure 18 B includes that the data entry screen of Figure 18 A updates schematic diagram, and the address table of Figure 18 A updates schematic diagram and figure
The movable table schematic diagram of 18A, Figure 18 A name table schematic diagram and Figure 18 A phone table schematic diagram;
Figure 18 C includes that Figure 18 B data entr screen updates schematic diagram, and the name table of Figure 18 B updates schematic diagram and Figure 18 B
Movable table schematic diagram, Figure 18 B address form schematic diagram and Figure 18 B phone table schematic diagram;
Figure 18 D includes that the data entry screen of Figure 18 C updates schematic diagram, and the address table of Figure 18 C updates schematic diagram and figure
The movable table schematic diagram of 18C, 18C name table schematic diagram and 18C phone table schematic diagram;
Figure 19 includes the frame organigram of a tracking system embodiment;
Figure 20 includes by a tracking system embodiment come the schematic diagram for the complicated weblication implemented;
Figure 21 includes by a tracking system embodiment come the schematic diagram for three tables implemented;
Figure 22 includes the update schematic diagram of three tables of Figure 21;
Figure 23 includes the update schematic diagram of three tables of Figure 22;
Figure 24 includes the update schematic diagram of three tables of Figure 23;
Figure 25 includes the update schematic diagram of three tables of Figure 24;
Figure 26 includes the update schematic diagram of three tables of Figure 25;
Figure 27 includes the update schematic diagram of three tables of Figure 26;With
Figure 28 includes the update schematic diagram of three tables of Figure 27.
Specific embodiment
With reference to attached drawing, this document discloses a tracking systems, delete for tracking the insertion of (or tracking) data and data
At least one of operation operation, i.e. data are deleted, data insertion or data modification.Data modification means to delete in legacy data
While be inserted into new data.
In the advantageous embodiment for the tracking system that a tracking data is deleted, the tracking system is configured as point
It (is stored in database 500 or shows for example, deleting to the data delete operation with a new activity identifier (movable ID)
Show the data on screen 910), one with the data correlation to be deleted is found from the sequence of one or more existing identifiers
A existing activity identifier generates a data identifier (such as activity management refers to (AMR)).The newly-generated data identifier
Including the New activity identifier and the existing activity identifier.Then by the data identifier and the data phase to be deleted
Association deletes function to enable the tracking system tracking data.
In the advantageous embodiment of a tracking system, in the tracking system tracking data insertion and data delete operation
At least one operation.The tracking system is configured as in the request for receiving request execution data deletion and execution data insertion
At least one request (that is, receive one of them or receive the two requests simultaneously).After receiving the request, the system is number
An activity identifier is distributed at least one of data insertion operation operation according to deleting, and the activity identifier is stored
In an activity index 530 (such as movable tables), while by a data identifier (such as AMR) and relevant it will be deleted
The data removed and/or be inserted into are stored together in data directory 580.Wherein, the data identifier include with will be deleted and/
Or the associated activity identifier of at least one data in the data of insertion;The data directory 580 is independently of described
Database table except activity index 530.
Fig. 1 is the physical structure of the embodiment of a tracking system and the schematic diagram of functional unit.It includes computing device
800 and database 500, they are communicated with multiple user calculating equipments 600 (for example, passing through the wireless zone of such as Wi-Fi form
The network of net etc and the communication standard of mobile network such as LTE or UMTS).Each standard includes display 630 and uses
It is inserted into sending, the input unit 680 of the request of data is deleted or modified.
It will be appreciated by those skilled in the art that the calculating equipment 800 and database 500 can in one single or
Implement in multiple and different equipment.Especially one in the art skilled person will be understood that and calculate equipment 800 and database
500 can be and implement on any suitable platform, including but not limited to Java, JavaScript, Typescript,
Kotlin, C, C++, Oracle, Net, PHP, SAP ABAP etc..
In addition, it will be appreciated by those skilled in the art that being possibly less than (including no user uses equipment 600) or being more than
Three users are communicated using equipment 600 with the tracking system.In this respect, it will be understood to those of skill in the art that each use
Family using equipment 600 communicated with the tracking system can by the web browser on web application or equipment 600 it
Any suitable software of class, the foreground[backgrounds such as Angular and Restful Web combination are supported.And the tracking system
System may merge completely (for example, Weblogic security framework on Weblogic server) with some form of security framework
To manage each user in the access right of system.
The database 500 includes an activity index 530 and multiple data directories 580.Those skilled in the art will manage
Solution, database 500 all can be initially empty before no any data insertion (therefore any data are deleted or data modification)
, i.e., no any activity index 530 and any data directory 580.
In the database 500, each data directory 580 be used to store a certain types of data.Inhomogeneity
The data of type are stored in different data directories 580.For example, the reality for the tracking system being discussed in further detail below
It applies in example, in data directory 580 a data directory is for storing name data, and another data directory is for storing ground
Location data.In this respect, data may be categorized into different types in different ways.In one example, data can be with base
Classify in the field of insertion data.For example, a type of data can be in the database for storing user's details
Name, another type of data can be contact number.In another example, can according to the property of data to data into
Row classification.For example, a type of data may be numerical data, another type of data may be alphabet data.
The activity index 530 is for one activity identifier sequence of storage.Each is stored in activity index 530
Activity identifier corresponds to an activity relevant to database 500, for example, when data are inserted into database 500 (that is,
Activity is data insertion), when deleting data from database 500 (wherein activity is that data are deleted), or work as legacy data quilt
(activity is modification or deletes two behaviour comprising data insertion and data simultaneously when deleting and being inserted into new data to database 500
Make).Therefore, each activity identifier corresponds to data and deletes and at least one of data insertion operation operation.It but, can be with
Registration one activity with or without activity ID;And the activity may be deleted or be deleted not with any insertion at once
Operation is associated.The activity can be used to be associated with following insertion, deletion or delete operation.
Therefore, it when data are inserted into database 500, will be deposited corresponding to the activity identifier for being inserted into the data
Storage is in activity index 530.After the activity identifier is associated with corresponding insertion data, it is collectively stored in correspond to and inserts
In the data directory 580 of the type of the data entered.
Receive any one or more users by using 600 request data of equipment insertion and data delete at least
After one request, calculating equipment 800 includes that multiple functional components (or component) will track corresponding data and insert according to request
Enter and/or data are deleted.Meter can be stored in by the execution of the processor 830 of calculating equipment 800 by imagining the usually functional unit
Program code and data on the memory 880 of equipment 800 are calculated to implement.However, it will be understood by those skilled in the art that this is not
Unique embodiment.For example, one or more of functional units can be implemented with different alternative.
As shown in Figure 1, the processor 830 for calculating equipment 800 is configurable for implementing each functional unit: a request connects
Receive device 831, an activity identifier distributor 833 and a data identifier correlator 839.
The request receiver 831, which is configured as receiving, executes data insertion request, data removal request or data modification
Request.Data modification include data delete, then followed by be data insertion.That is, the request receiver 831 is arranged to connect
Accept the request of at least one of row data removal request and data insertion request.In the described embodiment, it calculates and sets in user
On menu screen 900 on standby 600 display 630, user selects request insertion, is deleted or modified in data manipulation wherein
One operation.The request is sent from user calculating equipment 600, is supplied to and is calculated equipment 800.But it is contemplated that described ask
Asking can come from directly using selection made by calculating equipment 800.
In addition, the request receiver 831 is configured as receiving confirmation or cancels data insertion, data are deleted or data are repaired
The request changed.That is, the request receiver 831 is configured as receiving confirmation or cancels the data insertion of its initial request execution,
Data are deleted or data modification.At this it is contemplated that the alternate embodiment of the tracking system not have to be configured to confirm
Or cancel data insertion, data are deleted or data modification, and therefore the request of the alternate embodiment of the tracing system receives
Device 831 may be without configuring the function of receiving confirmation and cancellation request.
The activity identifier distributor 833 is configured as distributing to an activity identifier into data deletion and data are inserted
Enter at least one of operation operation, and the activity identifier is stored in the activity index 530.That is, in response to
The request receiver 831 receives the request for executing data insertion, and the activity identifier distributor 833 automatically determines one newly
Activity identifier, and distribute the New activity identifier be the data insertion activity identifier so that the New activity
Identifier can be used for identifying the data insertion operation.
In order to by the New activity identifier (the New activity mark distributed by the activity identifier distributor 833
Know symbol) it is stored in the activity index 530, the processor 830 for calculating equipment 800 implements an activity identifier correlator
The functional unit of 836 forms.The new activity identifier is stored in the movable rope by the activity identifier correlator 836
Draw in 530.Specifically, the activity identifier correlator 836 is by the new activity identifier, with the movable activity
The associated active state identifier of state, and the user identifier of corresponding user are stored in the activity index
In 530.In the database 500, if there is no the activity index 530, the activity identifier correlator 836 will be given birth to
At an activity index (such as activity index 530), for storing new activity identifier.It is contemplated that in tracking system
In alternate embodiment, the activity identifier correlator 836, which can be, is arranged to only be associated with the new activity identifier, and
There is no the active state identifier or the user identifier, or only there is the active state identifier and the user
One in identifier, or the data being used together, such as a campaign definitions are accorded with other identifier.
In addition to receiver 831 receives execution data insertion in response to the request, data are deleted or the request of data modification
(i.e. legacy data deletion is followed by new data insertion) and stores except the new activity identifier, the activity identifier association
Device 836 also be used to modify the active state identifier associated with the New activity identifier in activity index automatically, with
Just the request or cancel the data deletion for confirming that the data are deleted and/or are inserted into are received in response to the tracing system
And/or the request of insertion.If the database 500 is empty (i.e. without activity index 530 and any data directory 580),
The activity identifier correlator 836 is configured as firstly generating an activity index 530, then identifies the new activity
Symbol is stored in the activity index 530 generated.
Turning now to the data identifier correlator 839.The data identifier correlator 839 is configured as storage one
A data identifier.The data identifier include an activity identifier and to the related data phase that delete and/or be inserted into
Association.The data identifier correlator 839 will store up the data identifier and the related data that delete and/or be inserted into
It is stored in a data directory 580.Except the data directory 580 is independently of the activity index 530.If the database
There is no the data directory 580 in 500, the data identifier correlator 839 will generate one and be used to store the data mark
Know the data directory 580 of symbol and related data.Otherwise, basis will be deleted or be inserted by the data identifier correlator 839
The type of data is positioned for the data directory 580 of storing data, so as to by the data identifier and related data
It is stored in the relevant data directory 580 together.
As will be described in further detail below, the data identifier can be by a data identification generator
838 generate.The data identifier can not only only include the activity identifier, so as to which tracking data is deleted
And/or insertion.For example, when receiving the request for executing data deletion, a number of the generation of data identifier generator 838
Status identifier is deleted according to the data that identifier further includes the state consistency deleted with corresponding data.Another example is that
When receiving the request for executing data insertion, the data identifier that the data identifier generator 838 generates also is wrapped
Include one data insert state identifier of state consistency with corresponding data insertion.
The request insertion of execution data is received in addition to responding the request receiver 831, data are deleted or data modification (is deleted
Except being inserted into data after data), the data identifier generated by the data identifier generator 838 is stored in a number
Except in index 580, the data identifier correlator 839, which is also arranged as, can modify the Data Identification stored
Symbol, to respond the subsequent request of the received confirmation of the receiver 831 or cancellation data insertion, deletion or change.
More specifically, the data identifier correlator 839 is also arranged as automatically modification and is stored in the data
In index 580, the data state identifier described in the data insert state or data deletion state in the data identifier,
Confirmation is received with receiver 831 described in respond request or cancels data insertion or data removal request.For example, the Data Identification
Symbol correlator 839 modifies the data identifier associated with the data to be deleted automatically to respond the request receiver 831
It receives and cancels the request that data are deleted.Equally, the automatic modification of the data identifier correlator 839 and the data phase to be deleted
The data of the associated data identifier delete status identifier, so that respond request receiver 831 receives confirmation number
According to the request of deletion.
In this respect, the processor 830 for calculating equipment 800 is also arranged to implement with an activity identifier distributor
833, the form function component of an activity identifier locator 835 and a data identification generator 838, to enable
State the deletion of tracking system tracking data and/or insertions function.
The request receiver 831 receives execute the request that data are deleted after, the activity identifier distributor 833 is by cloth
A new activity identifier can be distributed automatically by, which being set to, gives the deletion data operation (that is, not needing user's prompt).
The activity identifier locator 835 be arranged to from the existing identifier of an one or more of sequence into
Row is found and is positioned and an existing activity identifier of the data correlation to be deleted.Specifically, the activity identifier is fixed
Position device 835 positions the existing activity identifier, be by the type of the data to be deleted of determination first, then positioning with it is described
The relevant specific data directory 580 (that is, data directory 580 associated with the data type to be deleted) of data type.It
Afterwards, the data to be deleted are found from the specific data directory 580.As described above, when originally data are being inserted into data
When in library 500, in the data and all stored data directory 580 of relative activity identifier.Therefore, described
Activity identifier locator 835 passes through the data for being positioned to delete from database 500, while also positioning the existing activity
Identifier.Existing activity identifier data associated with the data in the form of data identifier are collectively stored in
In database 500.This is because when the data are initially inserted into database 500, relevant activity identifier also with
The form of data identifier is stored in the database 500.
The data identifier generator 838 is configurable for generating a data identifier;One of them includes institute
State New activity identifier, the existing activity identifier and a data state identifier represent data according to deletion state,
To correspond to the deletion state of the data.It is contemplated that the data identifier is raw in the alternative embodiment of the tracking system
Grow up to be a useful person 838 be also possible to be arranged to generate include the new activity identifier and the existing activity identifier a number
According to identifier, without a data state identifier for such as representing data deletion state.
As described above, the data identifier correlator 839 is generated for being associated with by the data identifier generator 838
The data identifier and data to be deleted.For tracking data deletion, the data identifier correlator 839 will be repaired
Change the data identifier relevant to the data to be deleted and is collectively stored in and the data with the data to be deleted
In the relevant specific data directory 580 of type.Wherein, modifying the data identifier is by modifying the existing dependency number
According to identifier, the data can be represented by, which being converted into, has been deleted the data identifier of state to realize.
Also be used to that the tracking system be enable to delete initially by the above-mentioned functional unit that the processor 800 is implemented
Follow-up data insertion (that is, tracking data variation or modification) is tracked after data.
More specifically, the data identifier generator 838 automatically generates another new data identifier.It is described new
Data identifier includes the new activity identifier (that is, using New activity identifier identical with primary data delete operation)
A data insert state identifier with data insert state is corresponded to, is subsequently received to respond the receiver 831
The request of new data insertion.
Then, the data identifier correlator 839 is automatically new the additional data identifier and the volume
They together, and are collectively stored in specific data directory relevant to the data type by the data correlation being newly inserted into outside
In 580, so as to track the data insertion.In the described embodiment, the additional New Data Flag symbol is newly inserted with additional
Entering data is associated, and is collectively stored in the identical data index 580 of deleted data.
Moreover, if the request receiver 831 receives what confirmation data were deleted after the additional new data insertion
When request, while confirming that mentioned-above data are deleted, the activity identifier correlator 836 automatically modification with it is described another
One New Data Flag accords with the associated data insert state identifier, to confirm the insertion of the new data.Alternatively,
If the request receiver 831 receives the request cancelling data and deleting after the additional new data insertion, cancelling
While mentioned-above data are deleted, the activity identifier correlator 836 will be automatically deleted the additional new insertion data
And additional New Data Flag symbol associated there.
Fig. 2 is the flow chart of one embodiment of the tracking data method.The flow chart is described using described in Fig. 1
System be how to carry out data deletion and/or data are inserted into.It is further detailed with reference to Fig. 3 to 5 as will be described below
Illustrate, some steps of Fig. 2 method may include multiple sub-steps.Moreover, the method for Fig. 2 may relate to it is some optional additional
Step, the additional step being such as described in further detail with reference to Fig. 6 and 7.
In step 720, the request that the computation processor 830 in the calculating equipment 800 of the tracking system is implemented
The reception execution data insertion of receiver 831, data deletion or data modification (including data are deleted, followed by data insertion)
Request.For example, in one embodiment, in the tracking system being discussed in further detail below, the request receiver
831 can receive request in the form of selection, with insertion, be deleted or modified in many different types of data some/certain
A little data.
The activity identifier that processor 830 in step 720, the calculating equipment 800 of the tracking system is implemented
Distributor 833 distributes a new activity identifier and is inserted into data, and data are deleted or the operation of data modification.For example, institute
(this will be discussed in further detail below) is stated in one embodiment of tracking system, is received in the request receiver 831
After the selection to be inserted into, the activity identifier distributor 833 can distribute a new activity identifier automatically to carry out
Data insertion.The request for executing data and deleting, the activity identifier distribution are received in response to the request receiver 831
Device 833 automatically determines a new activity identifier, and the activity identifier is distributed to the data delete operation.Simultaneously
The New activity identifier is fused in a data identifier of data to be deleted, so as to use the new activity
Identifier identification will by or the data that have been deleted.In response to the request receiver 831 receive execute data modification (including
Data delete, followed by data be inserted into) request, the activity identifier distributor 833 data deletion before distribute automatically
The new activity identifier gives the data modification operation, to allow the new activity identifier can be used to identify because of data
New insertion data described in modification bring and described data are deleted.
In step 730, calculate the activity identifier correlator 836 storage that the processor 830 in equipment 800 is implemented by
What activity identifier distributor 833 described in the activity index 530 of the database 500 of tracing system in step 720 distributed
The new activity identifier.It will be such as described in further detail referring to Fig. 4, the new activity identifier can be with phase
Other data (such as user identifier) closed store together simultaneously.For example, tracking system (this in one embodiment
Will be discussed in further detail below), it is assigned in a new activity identifier, a user identifier, a moving type
After state identifier and a campaign definitions are determined, the activity identifier correlator 836 is distributed associated with each other these
New activity identifier, user identifier, active state identifier and campaign definitions are all stored in activity index 530 together.Such as
Fruit database 500 is empty (that is, without activity index 530 and any data directory 580), the activity identifier correlator
After 836 are configured as firstly generating activity index 530, then the related datas such as the New activity identifier are stored into and have just been generated
In the activity index 530.
In step 750, calculates the data identifier generator 838 that the processor 830 in equipment 800 is implemented and generate one
A data identifier is to track corresponding data insertion, and data are deleted or data modification operation.Such as below with reference to attached
It is that figure is described in further detail as shown in figure 4, ought the request receiver 831 in step 720 receive be execute data
When deletion or the request of data modification, the data identifier of generation may include that the new activity identifier and one are existing
Some activity identifiers.Such as below with reference to attached drawing be described in further detail as shown in figure 4, the new data identifier of generation
It may include other data, such as a data state identifier.For example, in the tracking system that will be discussed further
In embodiment, the data identifier generator 838 generates a data identifier.When the request receiver 831 receives
When executing the request that data are deleted, the New Data Flag symbol of the generation includes the New activity identifier, an existing activity
Identifier and a data state identifier for representing data deletion state.
When the request receiver 831 receives the request for executing data insertion, the data identifier generator 838
Generate a data identifier.The data identifier of the generation includes that the New activity identifier is inserted into Data Data is represented
One data insert state identifier of state.Data modification is executed (after deleting legacy data when the request receiver 831 receives
At once be inserted into new data) request when, the data identifier generator 838 generates two data identifiers.One of number
It include the New activity identifier according to identifier, a data of state are deleted in an existing activity identifier and representative by data
Status identifier.Another data identifier includes the New activity identifier and represents the corresponding new data insert state of data
A data insert state identifier.
In step 760, the data identifier correlator 839 for calculating the implementation of processor 830 in equipment 800 will be by institute
The data identifier for stating the generation of data identifier generator 838 is stored in a data directory 580 of database 500.
When the request receiver 831 in step 720, which receives, executes data deletion or the request of data modification, the data
Identifier correlator 839 is associated with the data to be deleted by the data identifier and is stored together.
For example, (will be discussed in further detail below) in the embodiment of the tracking system, when the request receives
Device 831 receive execute data delete request after, the data identifier correlator 839 by deleted data its originally
After being modified when being inserted by relevant original data identifier that the data identifier generator 838 generates with it is described
Deleted data are stored in together in the data directory 580.
When the request receiver 831 in step 720 receives the request for executing data insertion, the data mark
Knowledge symbol correlator 839 is associated with the data to be inserted by the data identifier and is stored together.For example, will be below
In the embodiment for the tracking system being described in further detail, data insertion is executed when the request receiver 831 receives
After request, the data identifier correlator 839 is by the data identifier generator 838 new data mark generated
Knowing symbol and the data to be inserted into is associated and they is collectively stored in the data directory 580.
When the request receiver 831 in step 720 receives the request for executing data modification, the data mark
Know symbol correlator 839 to delete the primary data identifier that is generated by the data identifier generator 838 with corresponding
It is collectively stored in specific data directory 580 after data are associated.Then the data identifier correlator 839 is subsequent
Spy is collectively stored in after the data identifier generated by the data identifier generator 838 and corresponding insertion data are associated
In fixed data directory 580.If the request that the request receiver 831 receives is request insertion data and database
500 any data directories 580 (for example, when database 500 is empty) or without be used to store the data to be inserted into
The relevant specific data index 580 of the data type, the data identifier correlator 839, which will generate one and be used to store, to be wanted
The relevant data directory 580 of the data of insertion.
As described above, some steps of Fig. 2 include many sub-steps.
Fig. 3 is the flow chart of the sub-step (that is, the described new activity identifier of storage) of step 730 in the method for Fig. 2.?
Step 730, the New activity identifier of the storage of activity identifier correlator 836 distribution.The New activity identifier is
It is distributed by the activity identifier distributor 833 in the activity index 530 in step 720.This may include two
Sub-steps.In sub-step 733, the activity identifier correlator 836 determines three identifiers.Three identifiers with
Data insertion, data are deleted or data modification is corresponding.Three identifiers are an active state identifier, an activity
Definition and a user identifier.In sub-step 735, the activity identifier correlator 836 the New activity identifier,
The active state identifier, the campaign definitions and the user identifier are associated with each other, and they are collectively stored in
In the activity index 530.
Fig. 4 is the flow chart (that is, generating the data identifier) of the sub-step of the step 750 in Fig. 2.The flow chart
The execution sub-step described when the request receiver 831 in step 720 receives data removal request is (described to ask
Asking, which can be that data deletion is individually performed or executes data in modification data, deletes).In step 750, the Data Identification
It accords with generator 838 and generates the data identifier corresponding with data deletion.
It is described in order to enable the data identifier generator 838 to generate during deleting data in step 753
Data identifier, the activity identifier locator 835 are positioned and are wanted from the existing existing identifier nucleotide sequence of one or more
The associated activity identifier of the data of deletion.Firstly, the activity identifier locator 835 determines number to be deleted
According to type.Then, the activity identifier locator 835 positions the certain number associated with the data type to be deleted
According to index 580.Then, the activity identifier locator 835 is from the specific data directory 580 (that is, with the number to be deleted
According to associated data directory 580) in positioning described in the data to be deleted.Once located the data to be deleted, therewith
Associated, the existing activity identifier generated when the data are initially inserted into the data directory 580 just obtains
It positions and determines.
It located in the activity identifier locator 835 being stored therein relevant to data that are being deleted described existing
After having activity identifier, the data identifier generator 838 will generate the new data identifier.The new data
Identifier and being positioned with data phase that is being deleted by the New activity identifier by the activity identifier locator 835
The existing activity identifier closed, a data state identifier (represent the data deletion state for corresponding to deletion state
Identifier) it is composed.Wherein the New activity identifier is by the activity identifier distributor 833 in step 720
Distribution.
After step 760, the method for Fig. 2 may include that the request receiver 831 receives the insertion of request confirmation data,
Data insertion is cancelled in data deletion or data modification or request, and data are deleted or data modification.
Fig. 5 is the flow chart of multiple additional steps of the method for Fig. 2.The flow chart describes the request receiver
831 receive confirmation data insertion, and data are deleted or the request of confirmation data modification.
When the request receiver 831 in step 783 receives confirmation data insertion, data are deleted or confirmation data
When the request of modification, the activity identifier correlator 836 confirms the data insertion, and data are deleted or data modification.It is described
Confirmation be by modify be stored in (in step 785) it is described activity index 530 in active state identifier (i.e. in step
733 generations) come what is completed.For example, in the embodiment for the tracking system being discussed in further detail below, the activity
Identifier correlator 836 confirms that data are inserted by modifying the active state identifier, by the active state identifier
The state of " activity is completed " (or " completion ") is revised as by " activity has begun " (or " ").To reach the mesh of confirmation
's.
In addition, the data identifier correlator 839 can also confirm that data are inserted into, data deletion (or it is single
Data are deleted or the data in modification data are deleted).When the request receiver 831 in step 783 receives confirmation
Data insertion, data delete request or as Data Data modification in deletion request when, this confirmation is by repairing
Change and (is generated at step 755, the data that correspond to being stored in database 500 in step 785 are inserted into, and are deleted or modified
Data directory 580 in) data state identifier in data identifier completes.For example, being in the tracking
In the embodiment of system (this will be discussed in further detail below), when the request receiver 831 receives confirmation data insertion, institute
The confirmation that data identifier correlator 839 is inserted into data is stated, it can be by removing the data in the data identifier
Status identifier is completed;Or it is completed by the data state identifier in modification data identifier.Modify data
It to be that interim data state identifier is revised as showing to live from instruction activity that status identifier refers under the specific condition
It is dynamic be identified or finally determining data state identifier (for example, when request is to execute confirmation data to delete, the deletion
Its own data of data are deleted or the data in data modification are deleted).
Fig. 6 is the flow chart of multiple substitution additional steps of the method for Fig. 2.The flow chart is described when the request connects
It receives device 831 and receives and cancel data insertion, data are deleted or substitution additional step when data modification request.
In step 793, cancel data insertion when the request receiver 831 receives, data are deleted or data modification
Request when, the activity identifier correlator 836 cancels data insertion, and data are deleted or data modification.The cancellation
It is by modifying the activity-identifier relevant to the data being stored in the activity index 530 in step 795
In the active state identifier complete.For example, (will be further detailed below in one embodiment of tracing system
Thin description), the activity identifier correlator 836 cancel the data insertion be by modify the active state identifier come
Implement.By the state of the active state identifier since " " status modifier be " cancellation " state.Institute is indicated that in this way
The activity stated has been cancelled.
In addition, received in the request receiver 831 in step 795 and cancel data insertion, data deletion (or
Data either in data modification itself is deleted as data to delete) request when, the data identifier correlator 839 takes
The data that disappear insertion, data delete operation.It is described to cancel be stored in the data directory 580 generally by modification and dependency number
Implement according to the data state identifier in the corresponding data identifier.For example, described in will describe with
It is detailed further below in the embodiment of track system, cancels asking for data insertion when the request receiver 831 receives
It asks, the data identifier for the insertion that the data identifier correlator 839 is stored in the data directory 580 with regard to deletion
With data associated with the insertion data identifier.
When the request receiver 831 is to cancel data to delete (either data deletion itself, is also possible to data and repairs
Data in changing are deleted) request when, the data identifier correlator 839 will cancel data and delete.The cancellation is to pass through
By the number of generation relevant to the data of deletion, described according to identifier, (including the new activity identifier, the data are deleted
Status identifier and the existing activity identifier) be revised as only include the existing activity identifier the Data Identification
Symbol.
According to the description of system, other aspects of the method for Fig. 2 to Fig. 6 be will be apparent above.The technology of this field
Personnel also will be understood that the method may be implemented in program code.Said program code can provide in many ways, example
Such as on tangibly computer-readable medium, such as hard disk or memory (for example, the partial memory that can be replaced) or work
For data-signal (for example, by being sent from server).
Similarly, it is to be understood that data and database 500 in the memory 880 of calculating equipment 800 can be in office
It provides on what physical data carriers appropriate, such as by the way that portable device (such as usb driver) is written in they, they is deposited
Storage is in memory (including sending the identifier to the equipment with memory) etc..
The example of one embodiment of the tracking system
Fig. 7 to 18D describes the embodiment of the tracking system.Fig. 7 to 13 illustrates the tracking system how in dish
It is inserted into single-screen 900, data (as a result, being recorded in database 500) is deleted or modified and carry out subsequent tracking afterwards.Even exist
The data of insertion are deleted how (as a result, being recorded in database 500) carries out subsequent tracking from menu screen 900.Figure
14 to 18D describe the deletion how tracking system enables the data be inserted into or modified to be left no trace.Therefore,
These diagrams describe how the tracking system allows user that can selectively track.The tracking system allows data
There is traceable source property.
Fig. 7 includes that user (such as client) calculates the signal of menu screen 900 shown on the display 630 of equipment 600
Figure.The user input equipment 680 that allows user to be able to use in user calculating equipment 600 selects: 1) being inserted into new data simultaneously
It is stored in database 500;2) available data (modifying the data being stored in database 500) is modified;And it 3) deletes in number
According to the available data in library 500.As shown in Figure 90 0, menu screen 900 includes three buttons that selection is carried out for user: " insertion
Data " 903, " modification data " 908 and " deleting data " 909.
The figure further includes that the schematic diagram of the data entry screen 910 of user allows user that can do data insertion, is deleted
Remove or modify operation.It is shown in after user is selected using one of three buttons on display 630 and is seen to user.Such as screen
Shown in curtain 910, it can be inputted by user, modify or delete three kinds of different types of data: " name " 100, " address " 200 He
" phone " 300.
When the data entry screen 910 on display 630 is shown to user, user uses user input equipment 680
Insertion, modification or any data deleted can be interim.User selects " to confirm " by using user input equipment 680
Button confirmation (or determination) insertion, after modification or the data deleted, the data are exactly permanent." confirmation " button
In the data entry screen 910 shown on display 630.Moreover, data entry screen 910 includes any for user's cancellation
The " Cancel " button of data, so that user cancels the insertion to any data, modification or delete operation.
Although not described in Fig. 7, but it is contemplated that when menu screen 900 is displayed on display 630, separately
One or more screens can be to be shown on display 630 after user is selected using user input equipment 680.Example
Such as, it is contemplated that subsequent scouting screen can be displayed on display 630.It is searched from database so that user can search for
Relevant available data.On the menu screen 900 on display 630, the modification selection modification of data button 908 is used in user
After the deletion available data of data button 909 is deleted in available data or use, user is allowed to search using described search screen
Data that are modified or deleting.
Fig. 8 includes the update schematic diagram of the data entry screen 910 in Fig. 7 and indexes 530 and data corresponding to activity
Index the schematic diagram of two tables of 580A.Menu screen in the embodiment of the tracking system, on display 630
900 are shown to user, and user is made a choice in user input equipment 680 come after being inserted into data, then when on display 630
When data entry screen 910 is shown in front of the user, and user inputs the name " surname of user A in user input equipment 680
Name " is after 100, and the data variation that the tracking system just passes through record user, which generates, (or to be had updated, if in the past
If generating) activity index the two tables of 530 and data directory 580A.
It in the tracking system, is inputted for response data, calculates the activity that the processor 830 of equipment 800 is implemented
Identifier correlator 836 and the data identifier correlator 839 will be generated or updated described in two in the database 500
Then table 530 and 580A are inserted into the data of input in this each table in the form of a tuple or record.Firstly, when display
After the display in front of the user of data entry screen 910 on device 630, user inputs name " user using user input equipment 680
The name of A ".To respond name input or insertion operation, in the database 500, the activity identifier correlator 836
To generate (or update) have recorded one or more movable " movable tables " 530 record it is described have occurred and that it is described new
Activity.In the movable table 530, the activity of the implementation of processor 830 in the calculating equipment 800 of the tracking system
Identifier assignor 833 distributes an activity identifier (movable ID) " 1 ".The activity identifier correlator 836 is described
New activity and the activity identifier (movable ID) " 1 " through occurring are associated together and are stored in " movable table " 530.Wherein institute
Activity identifier is stated, movable ID " 1 " indicates that the activity is first activity having occurred and that.In addition, the activity identifier
Correlator 836 is associated together the activity with definition or description " CDC/UPD " and is stored in the movable table 530.Its
In, the definition or description " CDC/UPD " determined by the activity identifier correlator 836 shows that the activity is related to a data
Cluster " client's details cluster " and an insertion, update (or modification) or delete operation.
The activity is associated together by the activity identifier correlator 836 with the movable User ID " A " is operated
And it is stored in the movable table 530.Shown by the User ID " A " that the activity identifier correlator 836 determines described
Activity is executed by the specific user, and the active state identifier determined by the activity identifier correlator 836
" STA " shows that this activity has begun, but confirmation or final determining is not yet received, and is consequently belonging to occasional nature.In the reality
It applies in example, the active state identifier can be used for identifying a movable active state.For example, being in " STA " moving type
The activity of state is the activity of activated state, may be reused and (i.e. for tracking multiple data insertions, is deleted or modified).Or
Identify that an activity is not re-usable nonactive active state, therefore the activity can not re-use.For example,
Fig. 7 to Figure 18 D is described below and active and inactive active state will be discussed in further detail.
Other than movable table 530, when data entry screen 910 is shown on display 630, used by user
After user input apparatus 680 inputs " name of user A ", it is described that the data identifier correlator 839 will generate (or update)
The data of input " name of user A " are simultaneously recorded in name table 580A by name table 580A.The data identifier correlator
839 data " name of user A " inputted and its relevant described data identifier are associated together and are stored in institute together
It states in name table 580A.The data identifier is the activity management ginseng generated by the data identifier generator 838
Examine (AMR) " 1P ".The data identifier generator 838 is real by the processor 830 of the calculating equipment 800 of the tracking system
It applies.When an activity is related to being inserted into new data (not being the modification to available data), AMR includes and the activity phase
The activity identifier (movable ID) closed.
Therefore, in AMR " 1P ", the integer " 1 " before " P " indicates that the AMR is associated with activity 1.In AMR " 1P "
Character " P " indicates that the data tuple associated with AMR of insertion is interim.It is any as being described more fully
The interim data be inserted into or modified can seamless slash deletion.It equally, can also after cancelling the interim data be inserted into or modified
Not retain any trace.
Fig. 9 includes the update schematic diagram of the data entry screen 910 of Fig. 8, the movable table of (not the updating) of Fig. 8
The schematic diagram of 530 schematic diagram and an address table 580B.When the data entry screen 910 on display 630 is aobvious
When showing, after the same user inputs " address of user A " 200 using user input apparatus 680, the data identifier association
Device 839 is associated together the data identifier relevant with its of data " address of user A " 200 of input and stores together
In the address table 580B.
In the data input of response address " address of user A ", the identical activity having been turned on (in beginning state)
ID " 1 " is reused.This is because: 1) address also complies with the definition of " CDC/UPD " as the name being previously inserted into,
It " client's details cluster " related data and to be inserted into, update the operation of (or modification) or deletion record;2) it has been turned on
Activity is the activity in activated state, be may be reused to relevant more to same campaign definitions (such as " CDC/UPD ")
A tables of data carries out data insertion, deletes and/or modification operates.In addition, when user A inputs ground on data entry screen 910
Behind location " address of user A ", if address table 580B is not present, the data identifier correlator 839 will generate one
Address table 580B.If the address table 580B has existed, the data identifier correlator 839 will update describedly
Location table 580B.The data identifier correlator 839 is " address of user A " and its relevant activity management reference
(AMR) " 1P " is associated together and is stored in the address table 580B together.The activity management shows with reference to (AMR) " 1P "
" address of user A " is interim and described " address of user A " and the activity identifier (movable ID) " 1 " phase
Association.
Figure 10 includes the activity of the update schematic diagram and Fig. 9 of the data entry screen 910 on display 630
The update schematic diagram of table 530, the update schematic diagram for updating schematic diagram and the name table 580A of Fig. 8 of the address table 580B of Fig. 9.Figure
10 describe user's (i.e. User ID " A ") selects the situation after ACK button on data entry screen 910.
As shown, AMR in name table 580A and address 580B table by the data identifier correlator 839 pass through by
The data identifier is updated to " 1 " from " 1P ", to indicate that the ephemeral data being previously inserted into figs. 8 and 9 has been forever now
It has recorded long, therefore traceable.Therefore, the work in the now corresponding movable table 530 of the AMR in each table 580
Dynamic identifier (movable ID) " 1 " is identical.However, being described more fully, the data of even now insertion are present
It has been permanent and traceable, but whenever user still can delete in future or update described in (that is, modification)
Data.In addition, the active state of the movable ID " 1 " in the activity table 530 is updated to by the activity identifier correlator 836
" COM " is to indicate that (i.e. confirmation is determined with final) has been completed in the activity.Therefore the activity ID " 1 " cannot be made again
With being no longer available for the insertion of subsequent data, operation be deleted or modified.
Figure 11 includes the update schematic diagram of the data entry screen 910 of Figure 10, the schematic diagram of the name table 580A of Figure 10, with
And the update schematic diagram for updating schematic diagram and the address form 580B of Figure 10 of the movable table 530 of Figure 10.
As shown, another data delete button 909 is shown in another display 630 for calculating equipment 600
On upper menu screen 900.User input equipment 680 is on the display 630 of another user for calculating equipment 600.When another
After user (User ID " B ") has selected the data delete button 909 using the user input equipment 680, in the calculating
Data entry screen 910 on 600 display 630 of equipment is shown to User ID " B ", so that User ID " B " had been deleted previously really
Recognize address " address of user A " 200.The activity when user " B " deletion " address of user A " 200, in database 500
Table 530 and the address form 580B are updated, to record the data delete operation.
When another user (User ID " B ") deletes " address of user A " on data entry screen 910, deleted for response
Except the delete operation of address " address of user A ", the activity identifier correlator 836 generates a New activity and is recorded
In the movable table 530.As shown in the movable table 530, because activity ID " 1 " is completed and therefore can not be made again
With the activity identifier distributor 833 generates a New activity, is used for the delete operation.Then the activity identifier
Correlator 836 is associated with the New activity and a new activity-identifier, movable ID " 2 " and be collectively stored in update in institute
It states in movable table 530.The new activity-identifier, movable ID " 2 " indicate that the activity is second activity occurred.
As shown in figure 8, the activity identifier correlator 836 is the New activity and campaign definitions or describes " CDC/
UPD " associates and is stored in the movable table 530 together.The campaign definitions indicate that the activity is related to data set
Group's " client's details cluster ".The activity can be used for being inserted into, modification or delete operation.Since the New activity is by difference
User executes, and the New activity and the different User ID " B " are associated and together by the activity identifier correlator 836
It is stored in movable table 530.The User ID " B " shows that the New activity is performed by a different user.It is described
Activity identifier correlator 836 is associated with active state " STA " the activity and is stored in movable table 530 together.
The movable active state " STA " shows that the activity has begun, but not yet confirmation or final determining, therefore is related to
All " client's details cluster " related datas insertions relevant to movable ID " 2 ", updating (or modification) or deleting all is
Interim.
Other than updating the movable table 530, the data identifier correlator 839 updates the address table simultaneously
Lattice 580B is recorded to " being used by user by the address that is inputted and had been acknowledged on data entry screen 910 by user before this
The deletion of the address of family A " record.Meanwhile the data identifier generator 838 generates a new AMR " 2X1 " come described in replacing
Existing data identifier " 1 ".The data identifier correlator 839 is related to AMR " 2X1 " address " address of user A "
Join and is collectively stored in address table 580B.AMR " 2X1 " shows " user that the address had previously been identified in movable ID " 1 "
It is temporarily deleted by an activity ID " 2 " now the address of A ".Integer " 2 " in the AMR " 2X1 " indicates the activity ID " 2 "
It is deletion activity.Character " X " in the AMR " 2X1 " indicates that described delete is interim.Integer in the AMR " 2X1 "
" 1 " indicates that the data temporarily deleted are previously to be identified in the activity ID " 1 ".
Figure 12 includes the update schematic diagram of the data entry screen 910 of Figure 11, the update signal of the address table 580B of Figure 11
The chart of the name table 580A of figure and 530 schematic diagram of Figure 11 activity table and Figure 11.
As shown, when another user is added or is inserted into a new address " user A using the data entry screen 910
New address " 201 when, the activity identifier correlator 836 will update the movable table 530.Meanwhile the Data Identification
Symbol correlator 839 will also update the address form 580B.But, there is no generate a new activity for the movable table 530.
This is because the identical activity ID " 2 " (temporarily delete pervious address " address of user A " (but not yet confirmation or
It is final to determine)) it is still within active state " STA ".The activity (movable ID " 2 ") is still active.Therefore, movable " 2 "
It can be not only used for tracking data deletion now, can be also used for data insertion and/or modification (or update).
The data identifier correlator 839 updates the address table 580B.A new tuple is inserted into address table 580B
(i.e. " the new address of user A ") Lai Jilu, and the address being shown on data entry screen 910 be now " user A newly
Location ".Specifically, " the new address of user A " is associated with simultaneously by the data identifier correlator 839 with a new AMR " 2P "
And it is collectively stored in the address table 580B.Wherein the integer " 2 " in " 2P " indicates that the AMR is associated with activity ID " 2 ";
I.e. " the new address of user A " is inserted by movable ID " 2 ".Character " P " in " 2P " indicates data " new addressed users A
" insertion be interim.
Figure 13 includes the update schematic diagram of the data entry screen 910 of Figure 12, the schematic diagram of the name table 580A of Figure 12 and
The schematic diagram that the address table 580B of schematic diagram and Figure 12 that the movable table 530 of Figure 12 updates updates.As shown, the activity table
Lattice 530 and the address form 580B have updated, to indicate that another user (User ID " B ") has been acknowledged or completes and scheming
In 11 and Figure 12 movable (movable ID " 2 ").In the address table 580B, the associated AMR " 2P " is inserted into address date
It is updated or is changed into " 2 " by the data identifier correlator 839, (i.e. " user A's is new to indicate the address date insertion
Address ") it has been identified now, therefore by persistence.The record again cannot by any user by it from the address table
It deletes, and leaves no trace in 580B.
In addition, the AMR " 2X1 " relevant to the address date deletion in the address table 580B is by the Data Identification
Symbol correlator 839 is updated or is changed into AMR " 2D1 ", to indicate that the present address date delete operation has been acknowledged.Describedly
It is permanently deleted location (i.e. " address of user A ").Therefore the delete operation cannot be by any user from the address
It cancels and leaves no trace in table 580B.The activity ID " 2 " is completed now, and active state is " COM ", therefore becomes non-live
Character state can not be recycled and reused for being further inserted into the present embodiment again, operation is deleted or modified.
Although the address date of Figure 11 is deleted and the insertion of the address date of Figure 12 is illustrated as in user on menu screen 900
After data button is deleted in selection first, two individually operations of insertion data button are then selected on menu screen 900,
It is contemplated that address date delete and address date be inserted into the two operations can be by selecting one on menu screen 900
This single operation of data button is modified to complete.
Figure 14 includes the update schematic diagram of the data entry screen 910 of Figure 13, the ground of name the table 580A and Figure 13 of Figure 13
The schematic diagram of location table 580B and the schematic diagram of a telephone meter 580C.As shown, movable table 530 has updated, telephone meter 580C
It is generated (if being not present in advance) or is also updated, " used with record by another user (User ID " B ") input phone
Data insertion after the phone of family A " 300.It is inputted in response to the data, the activity table 530 is closed by the activity identifier
Join device 836 to update to indicate to have occurred a new activity.The activity identifier distributor 833 distributes a new activity mark
Know symbol, movable ID " 3 " indicates that third activity has occurred that.The activity identifier correlator 836 by the New activity with
Activity identifier, movable ID " 3 " associate and are collectively stored in the movable table 530 of update.The activity identifier closes
Connection device 836 determine the movable state " STA ", the active state is got up with the activity association and by it together with store
In movable table.Active state " STA " indicates that the activity is the activity of a beginning and is interim.
In addition to updating the movable table 530, the data identifier correlator 839 adds phone " phone of user A "
Add or be inserted into and stores/be recorded in the telephone meter 580C.The data identifier generator 838 generates a new AMR " 3P ".Institute
Data identifier correlator 839 is stated to associate AMR " 3P " and phone " phone of user A " and be collectively stored in the electricity
In words in table 580C.The AMR " 3P " indicates that the insertion of the data " phone of user A " is related to activity ID " 3 "
Join and is interim.
Figure 15 includes the update schematic diagram of the data entry screen 910 of Figure 14, and Figure 14 is movable table 530, the surname of Figure 14
The update schematic diagram of the telephone meter 580C of the schematic diagram and Figure 14 of the address form 580B of name table 580A and Figure 14.
As shown, when the data temporarily inputted " phone of user A " are revised as " the new electricity of user A by User ID " B "
When words ", the data identifier correlator 839 is by the telephone meter 580C previously by phone " the user A of User ID " B " insertion
Phone " 300 data update and are stored as " the new phone of user A ".Because " phone of user A " 300 being previously inserted into is
Interim, the phone data " phone of user " 300 being previously inserted into is by the data identifier correlator 839 from the electricity
It talks about in table 580 and deletes without retaining trace.It is replaced with new data " the new phone of user A " simultaneously and is stored in the electricity
It talks about in table 580C.
Figure 16 includes the update schematic diagram of the data entry screen 910 of Figure 15, the name table 580A schematic diagram and figure of Figure 15
15 address table 580B schematic diagram, the movable table 530 of Figure 15 update the update schematic diagram of schematic diagram and the telephone meter 580C of Figure 15.
As shown, when other user cancels the ephemeral data insertion of phone data " the new phone of user A ", the work
Dynamic identifier correlator 836 updates the movable table 530, while the data identifier correlator 839 updates the telephone meter
580C.Although the activity ID " 3 " is retained in the movable table 530 to reflect that another user once initiated activity ID " 3 ",
Did data insertion, modification or deletion.For the operation that is cancelled for responding activity ID " 3 ", the data identifier correlator 839
The entry or tuple " new telephone subscriber A " of the AMR " 3P and associated phone data are deleted from the telephone meter 580C
It removes, just looks like that the data never recorded in the telephone meter 580C equally.Now, at the activity ID " 3 "
In cancellation state " CAN ", therefore the activity becomes inactive.So in the described embodiment, the activity ID " 3 "
It is no longer available for subsequent insertion, operation is deleted or modified.
Figure 17 includes the update schematic diagram of the data entry screen 910 of Figure 16, the name table 580A schematic diagram and figure of Figure 16
16 address table 580B schematic diagram, the update for updating schematic diagram and the phone table 580C of Figure 16 of the movable table 530 of Figure 16
Schematic diagram.
As shown, when User ID " B " carries out data insertion and input phone " use by the data entry screen 910
When the phone of family A " 300, the activity identifier correlator 836 updates the movable table 530, while the data identifier closes
Connection device 839 updates the telephone meter 580C, to record the addition or insertion of the phone data.In the process, the activity
Identifier assignor 833 generates a new movable ID " 4 ", to indicate that the activity is the 4th activity having occurred and that.Institute
Activity identifier correlator 836 is stated by the New activity is associated with New activity ID " 4 " and institute that be collectively stored in update
It states in movable table 530.As shown in figure 8, the activity identifier correlator 836 determines the definition or description of the New activity
Be it is " CDC/UPD " and associated with the New activity, be then collectively stored in the movable table 530 of update.Wherein, institute
It states activity identifier correlator 836 to determine the definition of the New activity or be described as " CDC/UPD ", to indicate that the activity is related to
Data cluster " client's details cluster ".The activity identifier correlator 836 by it is described activity and active state " STA " phase
It is associated with and is stored in together in the movable table 530 of update.Wherein, described in the activity identifier correlator 836 determines
The current active state of activity is " STA ", to indicate that the data insertion is interim.In addition, when user passes through user data
When phone " phone of user A " that entr screen 910 inputs, the data identifier correlator 839 is by the addition of the data
Or insertion is stored/is recorded in " telephone meter " 580C of update.The data identifier correlator 839 is by phone " user A
Phone " be associated with and be collectively stored in the telephone meter 580C of update with a new AMR " 4P ".Wherein, the data
Identification generator 838 generates the new AMR " 4P ", to indicate the phone " phone of user A " and the activity ID
" 4 " are associated and indicate that the data insertion is interim.
Figure 18 A includes the update schematic diagram of the data entry screen 910 of Figure 17, Figure 17 activity table 530, Figure 17 name table
The update schematic diagram of the phone table 580C of lattice 580A schematic diagram and Figure 17 address form 580B schematic diagram and Figure 17.
As shown, the data identifier correlator 839 has updated the telephone meter 580C, to indicate that ephemeral data is inserted
The phone " phone of user A " 300 entered is deleted.As described above, even if the activity ID " 4 " is previously used to data insertion,
The activity ID " 4 " is associated with the active state " STA " and deposits together by the activity identifier correlator 836
In the movable table, the activity still can be inserted into future for data for storage, updated (or being altered or modified) or deleted.
Figure 18 B includes the update schematic diagram of Figure 18 A data entry screen 910, the movable table of Figure 18 A, the name table of Figure 18 A
The update schematic diagram of the address table of the schematic diagram and Figure 18 A of the telephone meter of schematic diagram and Figure 18 A.As shown, the data mark
Know symbol correlator 839 and update the address table 580B, the AMR " 2 " is revised as " 4X2 "." 2 " in " 4X2 " indicate
" the new address of user A " in the activity ID " 2 " (as shown in figure 12) is faced by user " B " by data entry screen 910
When be inserted into and confirm (as shown in figure 13)." 4 " in " 4X2 " are the movable ID for deleting " the new address of user A ".It is described
" X " in " 4X2 " indicates that the data deletion is interim.Because activity ID " 4 " is not yet completed, the activity can be used for
Track ephemeral data is deleted.
Figure 18 C includes the update schematic diagram of data entry screen 910, and the representation of activity of Figure 18 B is intended to, the address of Figure 18 B
Indicate to be intended to the update schematic diagram of the name table with the schematic diagram of the telephone meter of Figure 18 B and Figure 18 B.As shown, described
In name table 580A, " 1 " in AMR " 4X1 " indicates that name data " name of user A " is faced by user " A " by activity ID " 1 "
When be inserted into (as shown in Figure 8), then by user " A " confirmation insertion data (as shown in Figure 10).In the AMR " 4X1 "
" 4X " indicates that user " B " temporarily deletes name data " the user A acknowledged by the activity ID " 1 " by the activity ID " 4 "
Name ".Name data " the surname of user A that the data identifier correlator 839 is temporarily deleted by AMR " 4X1 " and
Name " is associated and is stored in the name table 580A together.User " B " is temporarily inserted into new surname by the activity ID " 4 "
Name data " the new name of user A ".The new name number that the data identifier correlator 839 is inserted by an AMR " 4P " and just
It is associated according to " the new name of user A " and is stored in the name table 580A together.The deletion and modification of data all pass through
Screen 910 is completed.
Figure 18 D includes the update schematic diagram of the data entry screen of Figure 18 C, and the representation of activity of Figure 18 C is intended to, Figure 18 C's
Name indicates to be intended to update schematic diagram with the address table of the schematic diagram of the telephone meter of Figure 18 C and Figure 18 C.As shown, when using
When family " B " inverts the interim deletion of address date, the data identifier correlator 839 by the address table 580B with
The associated AMR " 4X2 " of address date " the new address of user A " temporarily deleted is updated to AMR " 2 ".The number
According to state return to the state being identified of Figure 17.This is indicated in Figure 18 B to having confirmed that the interim delete operation of address exists
By " reverse " in Figure 18 D." reverse " operation has been cancelled completely to the interim delete operation of the address date without retaining
Trace, as never occurring the interim delete operation in Figure 18 B.
In the described embodiment, it is to delete reversion button using data by another user " B " that data, which are deleted reversion or reversed,
(not shown) is completed.However, it is contemplated that data delete other mechanism that can use such as keyboard shortcut etc by user
It is completed to invert.One it would be recognized by those skilled in the art that this reversion and the cancellation by cancelling (activity) button are not
With, because reversing the piecemeal activity that can be only directed to certain data reversals without cancelling entire movable operation.Therefore, in institute
It states in embodiment, data delete reversion button and are different from cancelling (activity) button.The activity will be cancelled by cancelling (activity) button
All deletion and insertion data, data delete reversion button then only invert or cancel the activity ID some or certain it is more
A interim delete operation.For example, user " B " is inverted the interim deletion of address " the new address of user A ", as described interim
Never there is no excessively for delete operation.But user " B " the new name of user A " that is temporarily inserted into remain in it is described
In name table.
As described above, being only in the activity of activated state (i.e. in the embodiment of the tracking system of Fig. 7 to 18D
Active state is not the activity of " CAN " or " COM " or " DEL ") just it may be reused, it is inserted into, deletes for further data
Remove or modify data table related.In inactive state activity (namely those active states be " CAN " or " COM " or
" DEL's ") it cannot be recycled and reused for being further inserted into data, the data in data table related are deleted or modified.
Modification within the scope of the present invention can easily be realized by those skilled in the art.It should therefore be understood that this hair
The bright embodiment without being limited thereto described above by example.
It only include name, address and telephone number, it is contemplated that the tracking although the storing data that above example is related to
The alternate embodiment of system may relate to additional and/or alternate data.In this respect, it is contemplated that the tracking system can pass through
The event or life event of data, especially user, for example, the life event as user has occurred and that, are occurring to drive
Or when will occur, the event or life event can be recorded or be handled for the user by the system.
For example, a job hunter for enjoying welfare to the full has just found a part-time job.As this of job hunter
Kind of life event or situation variation as a result, according to the date that the income situation of the job hunter starts with this work, enjoy
The welfare received may reduce or cancel on a certain specific date.One embodiment of the tracking system can be used for accurately with
The such data variation of track.Equally, the tax bureau, bank, the mechanisms such as insurance company will have to data historical trace and data modification
The similar demand of historical trace function.
As described above, each user calculating equipment 600 can with tracking information system by way of web application ditch
It is logical.In this respect, such web application can be very simple, a such as simple web page, for showing and/or updating
One database table, or be also possible to very complicated as welfare payment system.Such complication system may have it is hundreds of or
Thousands of webpages, while there is the complication system (as shown in figure 19) in thousands of data library.In this respect, it is contemplated that for complexity
Web application, each webpage or one group of relevant webpage, service logic associated there and database table, possible quilt
It is considered as independent, a relatively simple sub- web application system.Therefore, complexity complicated as welfare payment system
Web application system may be made of hundreds of independent simple sub- web application systems.
Every sub- web application system may only comprising one or a small group webpage and it is relative one or
A small group service database table and business logic.As described above, this simple sub- web application system can be referred to as
Cluster or cluster.These clusters can be used the tracking system and be interacted by certain mechanism.The concept of one cluster
It may expand to and support other clusters but may the not no component of the front-end user interface of their own or database table.But
It is, it is contemplated that a cluster should usually have the database table of own permanently to record data.Those do not have it is associated before
The component of end and both database tables should be comparatively simple and should be included in some specific cluster, unless these groups
Part is shared by many clusters.
In this regard, it is contemplated that the concept of the cluster or cluster can be conducive to simplify large-scale complicated system, preferably
Software management, easy to maintain and business and/or systematic knowledge encapsulate.Specifically, can be conducive to will be large-scale for the tracking system
Complication system is reduced to multiple simple and separate cluster set, allow flexibly with large-scale system development and easy to maintain.
For example, Figure 20 is described when the complicated web application system implemented by the embodiment of the tracking system
System, such as welfare system.As shown, hundreds of independent clusters can be with zero or various ways effect interactively with each other.And it is every
A cluster is such as used as " NSS " cluster of job hunter, " PEN " of pensioner, " RFL " of referral and family
" FAM " can be a small and relatively simple web application subsystem.Phase interaction between welfare system cluster
Coordinated with that can be concentrated by the tracking system.The quantity of cluster can increase or reduce according to business demand in system.
One activity can be taken an operation or sequence of operations by the triggering of some event or life event.Also
Have, an operation may include a series of sub-operation.As this sequence of operations or sub-operation as a result, activity can be with
Insertion and/or the data or unstructured data for updating and/or deleting one or more database tables.For example, one is just met
The family for connecing an ewborn infant is all a life event to the family and the ewborn infant, i.e. an ewborn infant thing
Part.The life event, ewborn infant event may trigger immediately sequence of operations:
1. registering the birth certificate (operation 1) of born baby
2. buying milk and clothes (operation 2)
3. registering baby in welfare system to obtain fringe benefit (operation 3)
System which operation interested depending on you and you how wish in systems by interested operative combination
Together, such sequence of operations can be combined to form an activity or one group of activity.Each operation can
It can lead to a business transaction.For example, the operation for changing address, which may cause existing address in systems and will be terminated it, to be had
It imitates the date or logic is deleted, and may there is new address to be considered as individual address input.Thing relevant to event or life
Sequence of operations in part may result in a series of relevant business transactions.
By taking welfare system as an example, the system may be to " purchase milk and clothes " and " registration born baby goes out
The operation of raw proof " is not interested.The uniquely interesting operation of system may be operation 3, that is, register baby in welfare system
Youngster is to obtain fringe benefit.
Operation 3 is completed, system may need to take a series of sub-operations:
1.1 create child's record for the baby
1.2 link child record and his/her parent record
1.3 record its birth certificate
1.4 as the parent due to caused by maternity leave, etc. takes in if there is the variation of any other situation (changing), record
These variations
For operation 3, New activity may tracking system described in automatic trigger carry out above-mentioned sub-operation.When described
When activity starts, this activity can be given a unique or unique identification number assignment.The identifier is known as activity mark
Knowledge or activity ID.The activity ID can be the integer since 1 and may for the client in the system
It is unique.For on one point, it is contemplated that the use of integer may be preferred convenience, but the activity ID, for the specific visitor
Family or for whole system, it may be possible to any unique identifier.For for many single offering customers services
System, in order to avoid movable ID is increased too fast, the method for unique activity ID for each client may be more preferable
Selection.The activity of statistical information is collected for a series of clients that statistics bureau uses, the uniqueness of movable ID can be with entire
System is background.The activity of the beginning may by activity management with reference to (AMR) value and activation record (insertion, update or
Delete) all data it is associated.
One activity may have a life cycle.One main activity life cycle may include continually changing
Active state is created to the order status that (from birth to death) is completed in activity, such as " REG " (registration), " STA " from activity
(having been turned on), " CRF " (customer requirement finally determines), " SUB " (has been filed on), and " COM " (complete/is finally determined/confirm),
" DEL " (deletion) etc. completes cycle of activity.One movable life cycle may by these active states certain states or
More state compositions, will specifically depend on its business demand.Once activity reaches active state " COM " or " DEL ", preferably
" DEL ", the activity life cycle may be completed just.Certainly, the activity also may be completed just.
For example, the activity that an active state is " REG " can be created.One active state is that the activity of " REG " may
Be not it is active, may update not with any insertion or to delete data associated.When a New activity creates, the work
The active state of dynamic ID perhaps also perhaps will not can be assigned to " REG ".When activity is inserted into and/or is updated and/or is deleted
When data, its active state may be changed to " STA " from " REG " by the activity.
Alternatively, the activity that an active state is " STA " can be created.One active state is that the activity of " STA " can be with
It is known as coming into play or in the activity for starting the activity of state or having been turned on.The activity having been turned on may be in activated state
And data may be inserted into and/or updated and/or delete in the database table that it is allowed to.When creating an activity,
One New activity ID may be assigned to the activity.Meanwhile active state " STA " may also be assigned to the activity.
It may be entirely interim by activity insertion and/or update and/or the data deleted that active state is " STA ".
One movable active state can be developed from one of active state of following two active state to be reached
The active state of " SUB ":
A) from the active state of " STA " to active state " SUB ", for example, by Entry-level System operator's final updating
After data and submission activity, when needing that the activity of the submission is isolated and is checked by the officer of system operator;
B) from active state " CRF " to active state " SUB ", such as user had approved to the work by an Entry-level System operating staff
Dynamic data insertion, after modification or delete operation, and needs the activity by the officer of system operator to the submission
When being isolated and being checked.
One activity may also have " SUB " active state, that is, the activity submitted.For example, an once movable activity
State is the active state of " SUB ", and client and primary staff cannot be inserted into data and/or update and/or delete
Make further change.It is all to be inserted into active state is " SUB " movable associated data and/or update and/or delete
Except operation may all be provisional.If the officer is unsatisfied with its interim insertion and/or updates and/or delete, institute
It states officer and is rejected by the interim insertion and/or update and/or deletion.Then the activity just reverts to the work of " STA "
Dynamic state.In this way, the client or primary employee further can be updated and be resubmited.Certainly, the advanced duty
The reason of member preferably writes explanatory note in the activity to explain its refusal.
One movable active state may develop the moving type for reaching " COM " from one of following two active states
State:
A) it when activity is submitted and executes completion in the case where not needing to put in isolation and under investigation, is drilled from the active state of " STA "
Change to the active state of " COM "
B) when the high level operational personnel approval action state is the activity of " SUB ", activity becomes from active state " SUB "
For active state " COM "
Once activity reaches the active state of " COM ", it is all in transitory state data (insertion and/or update and/or
Delete) it just has confirmed that and finally determines.Active state is that the activity of " COM " is referred to as final activity or completed activity.But
It is that the active state of one movable " COM " may further develop into " DEL ".
When an activity is completed and has deleted, it is living that the activity may develop into " DEL " from the active state of " COM "
Dynamic state.When an activity is in the active state of " DEL ", all data as performed by the activity all be will still be at
The state for confirming and finally determining.One active state is the also referred to as final activity of activity of " DEL ".Active state " DEL " is pure
Essence is introduced to improve system performance (reaction speed).When one activity complete when, as complete it is described it is movable after
Fruit may also need to occur and complete certain processes (operation).These processes may be very time-consuming, and may be by later
Stage completes as the consistency operation program of processing low priority.These operation sequences may be: send emails to
Each side is closed, pdf document is generated and add and is attached to Email, is subsequently sent to relevant mail each side, examination is set up and lives
It moves.
The state of CRF can be introduced to support customer self-service service, while protecting system business sincere.When a client mentions
Turn over a finished item move update themselves system record when, the activity may develop into active state from the active state of " STA "
"CRF".At this moment, the ephemeral data of client's input is needed by system operator (system owners) Lai Jianding.For example, once
Activity is in the active state of " CRF ", then client cannot do any further modification to his/her record.In moving type
The data that the activity of state " CRF " is inserted into and/or updates and/or delete may be interim.If Systems Operator is to described
Interim insertion and/or update and/or deletion are dissatisfied, and the Systems Operator can refuse the interim insertion and/or update
And/or it deletes.Then the activity may be restored to the active state of " STA ", so that the client further updates and again
It submits.
The Systems Operator should generally write out about movable textual description to explain its Reason For Denial.If needed
It wants, more active states can be introduced.
As complete an activity may trigger client described in system evaluation right and responsibility and welfare payment, because
This, it may be necessary to employee carries out necessary manual intervention.So when customer has updated client oneself by certain activities the case where
Afterwards, the client oneself may not be allowed to confirm and complete the activity.On the contrary, client can file a request to welfare institution,
It asks and completes the activity confirmation.Once client pleases oneself to the data update of oneself and clicks " submission " button, moving type
State will become " CRF ".The staff that supervisory activity is submitted, it will the active state that processing client submits is the activity of " CRF ",
And assessment result is supervised or adjusted as needed and completes it.If the activity that client uses is allowed to be completed by client oneself,
So in client's finally confirmation activity, this movable active state can directly be changed to " COM " from " STA ", without passing through
Cross active state " CRF ".
Therefore, the life cycle of main activities may be:
a)“REG”→“STA”→“CRF”→“SUB”→“COM”→“DEL”
b)
c)
d)“STA”→“COM”→“DEL”
In this respect, symbolIndicate left and right side active state may two-way differentiation (from left side to right side or from
Right side to left side).
Symbol → expression left and right side active state can only unidirectionally be developed from left side to right side.
In an activity life cycle, certain active states in life cycle may iteration it is one or many:
a)“STA”→“CRF”→“SUB”→“STA”→“CRF”→“SUB”
b)
c)
In one embodiment, the activity with " COM " or " DEL " active state is inactive, therefore cannot be repeated
It uses.
One is in the activity of activity life cycle early stage, for instance in the work of the active state of " REG " or " STA "
It is dynamic to be cancelled (activity is cancelled).When an activity is cancelled, entirely by the interim AMR and association of the activity creation
Data can physically restore its legacy data state.Data mode in database table may be restored in the work
State before dynamic creation just looks like the activity always without being temporarily inserted into and/or updating and/or delete any data one
Sample.
It is the activity of " STA " for an active state, possible there are two cancel the movable option:
A) it can choose the active state of " CAN ".In this case, the activity reaches movable " CAN " state and (takes
Disappear);That is " STA " → " CAN ".In this way, the movable activity life cycle just completes.Or
B) it can choose the active state of " REG ".In this case, the movable active state becomes " REG ";I.e.
"STA"→"REG".The activity may be reused or cancel in future.Therefore, can with iteration active state " REG " and
“STA”()。
State is that an activity of " REG " may be cancelled.Once cancelling, activity will reach the moving type of " CAN "
State;That is " REG " → " CAN ".
In one embodiment, it is inactive that active state, which is the activity of " CAN ", therefore cannot be reused.
In one embodiment, the active state of " DEL " or " CAN " are the final stage of its activity life cycle, and will
State described in permanent retention (cannot be developed further).Any active state other than " DEL " or " CAN " active state is all
It is only the transitory state kept within the period of needs, will finally develops and arrive next active state.One activity is once built
It is vertical, it will to retain to required a period of time, (complete until the movable activity life cycle is completed to reach
The active state of " COM ", then " DEL " or cancel to reach the active state of " CAN ").
The activity in following some date maturation that active state is " AUT " can be created.In this case, because
It is the activity until some following mature date, the activity not will do it any operation, therefore, in the activity
It is optional that an activity ID whether is assigned in creation.It arrives when the following mature date, becomes the tracking system date
When, the activity is handled automatic starting and according to operation flow predetermined.Here it is so-called examination streams
Journey.The activity is known as examination activity.
According to service conditions, movable property and the cluster for creating it, it is understood that there may be activity relevant to the activity is fixed
Justice.Campaign definitions are by cluster name (activity classification code), "/" and activity code composition.Campaign definitions may will limit described
Activity can be inserted into which certain database table or data group and/or update and/or delete the permission of data.The work
Dynamic code is defined as further determining that the operation that an activity can be taken;For example, when an activity passes through combination definition collection
Group entitled " FinTech ", when activity code is " ADD " (FinTech/ADD), the activity can only just create/add described
The bank account of client.As soon as the activity can only do bank and deposit if an activity is defined as " FinTech/Deposit "
Money.One activity is created by campaign definitions.
In order to which a new born baby to be registered in welfare system, nature of business determines the activity by welfare
The cluster (client's details cluster) for being known as " CDC " in system is responsible for creation.Therefore, activity may be defined as " CDC/
UPD"." CDC " refers to cluster " CDC ", and " UPD ", which refers to, carries out record update.When system starts new " CDC/UPD " activity
When, it will check last movable ID (the highest integer under relative clients/tissue background);And by the highest
Integer increase by 1 mode and obtain a new movable ID to distribute to the New activity.For example, if having created 100
Activity, then the movable ID for newly created activity distribution will be 101.Therefore, the New activity will be 101 " CDC/UPD " of activity.
The baby of the birth new for one creates new user logging for baby, and activity is incremented by since minimum initial value 1;For example,
1 " CDC/UPD " of activity.The campaign definitions of " NSS/UPD " are another examples, and " NSS " is the system cluster of job hunter.
In one embodiment, when an activity will start, a system flow will be checked whether there is in activity
Active state is that the activity that the same campaign of " REG " or " STA " or " CRF " or " SUB " defines is present in the client/tissue
In.If it does, preferably reusing the existing activity, rather than the new work defined with same campaign is created again
It is dynamic.If movable active state is " REG ", when executing insertion, updates or when delete operation, the active state will become
"STA".If movable active state is " CRF " or " SUB ", activity can not start automatically, meanwhile, insertion and/or update
And/or delete operation can not also execute, until confirmation " CRF " or the activity of the state of " SUB ", to reach the moving type of " COM "
State;Or be rejected, the active state reverts to " STA ".In rare cases, same definition movable, active state
Multiple activities for " REG " or " STA " or " CRF " or " SUB " may coexist.This Coexistence Situation is only in strong business demand
In the case where be likely to occur.
In one embodiment, when an activity creation (start or register), the activity will keep its relevant information:
This activity be it is what kind of, who start/register this activity, this activity is when to start/register.The activity is also
Will be comprising all required information, such as who finally used the activity for being inserted into the operation etc. that/update/deletes data.
Generation particular event is aprowl tracked using timestamp, such as when creation activity, last time updates hair by using this activity
The time etc. that raw time and this activity are completed.
Can recorde free text notes associated with the activity with indicate why the activity should occur with
And why should be inserted by this activity, update or delete data.Free text note taking can also be with the activity phase
Association, with tracking why data modification, it is necessary to occur or it is any important and to this relevant content of activity.Until the work
It is dynamic that (or terminating either to cancel with the active state of " CAN " with the active state of " COM " or " DEL ") is completed, that is, exist
Before the activity end, the free text notes, which can permit, to be updated.Once activity is completed or is cancelled, free text annotation
It can only preferably read, but can not modify.
As described above, the activity identifier (or activity management reference) of AMR form can be used in the tracking system, also known as
Data identifier.In one embodiment, AMR is the character string that there is length to be defined as 15 characters at present.If desired,
When activity creation, the length can easily be extended to accommodate more activities.AMR, including as described AMR value a part
One or more activities, be assigned to by it is described activity insertion and/or update and/or delete data and be associated.It is right
In the AMR, any symbol can be used to indicate each part of AMR.In the present invention, integer is used for activity ID.Character
" P " is used to indicate that the data tuple of insertion to be interim.Character " X " is for indicating that deleting data tuple is interim and logic
's.Character " D " is for indicating that the data of the tuple are logically deleted and the delete operation has been identified.Confirmation is by living
The data that dynamic ID is temporarily inserted into are by removing " P " in AMR relevant to the ephemeral data come what is completed.Once a work
Dynamic to start, AMR can be used for updating database table, for example, activity 1 updates the table of entitled customer table.Customer table can save
Customer information such as personal identity card (or " objectId "), surname, name, title, gender, date of birth etc..Which is determined
Activity has updated the record of a line in database table, another is known as AMR literary name section and is also introduced into addition in customer table
In gauge outfit.Therefore, the table schema of customer table becomes: AMR, personal ID, surname, name, title, gender and date of birth.
When the activity 1 that one is " CDC/UPD " is that a baby creates record, AMR " 1P " can record in the table, Yi Jiqi
His data etc. in relation to name, and associate with these data.Activity 1 may also update other data forms, such as address
The table etc. of table etc.
Therefore, the record of the AMR of each table updated for this activity can be used to track all related to the activity
Record, and update content and mode.
By taking customer table as an example, performed in the database client table in " 1 " expression activity " 1 " in AMR " 1P "
Insertion operation.Wherein " P " indicate this insertion operation be it is interim, activity 1 be in state STA, CRF or SUB.
In this respect, an AMR may be associated with one of following four state:
Interim insert state or transitory state:
One AMR with interim insert state (PVL) is known as interim insertion AMR or interim AMR.It is related to interim AMR
Insertion data be provisional, referred to as ephemeral data or interim insertion data or draft version data.Interim AMR allows to face
When be inserted into, update or delete.Before data record is finally confirmed final version, allow to draft version data (ephemeral data) into
Row modification, is deleted without retaining trace.Therefore the flexibility of data record is improved.When a line record has been turned on work by one
It is dynamic when being inserted into table, in the column section for the AMR that an AMR (such as 1P) will be recorded in the table (table column).
Once activity associated with these ephemeral datas is cancelled or " deletion " or issues to selected ephemeral data
" revocation " order, all ephemeral datas for being connected to " deletion " instruction will be deleted by physics, just look like that these data are never temporarily inserted
Entered the same.
When updating ephemeral data, old ephemeral data will be covered by physics without retaining trace;That is, old ephemeral data
To physically it be replaced by new ephemeral data, but, AMRs relevant to the ephemeral data will keep complete constant.
It is interim to delete state: there is the interim AMR for deleting state to be referred to as interim and delete AMR.It is closed with the AMR temporarily deleted
The data of connection, which are temporarily deleted and are referred to as interim, deletes data.The data mark that the AMR temporarily deleted will have confirmed that in the past
It is denoted as temporarily and logic deletion, while it is complete for indicating data itself.
Acknowledgement state or confirmation insert state:
The AMR of acknowledgement state is known as confirming AMR or confirmation insertion AMR.Insertion data relevant to the AMR of confirmation are by (most
Confirm eventually) and be referred to as and confirms data or confirmation insertion data.When the activity of temporary recording data in the table is completed
When, for example, active state is changed to COM from STA, all ephemeral datas of this activation record are had confirmed that.The 1P's
In the case of, when activity 1 is completed, the AMR will become 1.Once confirmation, by the software frame, data will never
Physics is deleted, and only logic is deleted, to be accurately tracked by data history and data change histories.
Confirm deletion state:
It is known as confirming in the AMR for having confirmed that the state of being deleted and deletes AMR.Data quilt relevant to confirmation deletion AMR
Referred to as data are deleted in confirmation.AMR is deleted in confirmation will confirm that data markers delete state for confirmation logic, and data itself are then intact
It is lossless.This means that deleting even if confirmation data are confirmed by logic, the confirmation data can be also permanently kept in database.
Confirmation data are never deleted by physics covering or physics, but delete AMR by confirmation to mark the data in logic
On it is deleted.
In one embodiment, for " the business driving of the duplicate AMR data group of interim insert state/committed state
Device " may be described as that the data edited, the data of mistake can be distinguished, and finally confirm (therefore can send out
Cloth) data.
In one embodiment, only finally determining data can just issue-for example, any mail sent to client
The information from final confirmation data is only used only.In this respect, " data mode " component in AMR field can require thus
Technical support is provided.
If the event or life event that are related to have multiple clients (such as in the new born baby of one family or bank
Financial transaction between account/transfer accounts), one " packet activity " or " set meal activity " or " package activity " can be used as movable
Subset introduces.Set meal activity allows for multiple relative clients while carrying out data insertion and/or parallel update and/or deleting.
Parallel insertion to all relative clients and/or update and/or delete should preferentially select atomicity (i.e. these operate while sending out
It is raw), or according to certain sequentially to ensure its data integrity.In relationship between client using set meal activity be in order to
It responds an event or a life event and establishes.Set meal activity is one group of work related with an event or life event
It is dynamic.When client (such as requestee) starts package activity payment payee, the requestee will be automatically in the activity of this set meal
Start " main activity ".When payment transaction occurs, the main activity will deduct the gold that should be deducted from the bank account of requestee
Volume, and " the secondary activity " or " dependent activity " or " from activity " of automatic trigger payee, to allow, the payee's is described time
The correct amount of money is added in the bank account of payee by activity.Certainly, wherein the finance of bank account may be needed to deduct
Transfer services take.By the integrality for ensuring entire data in monetary process, thus it is ensured that avoid " dual payment ".Pass through
Data history retrospect and the retrospect of data change histories, the guarantee will further be strengthened.These business are atomicities
Or ensure the integrality of data by other means, to avoid " dual payment ".This packet it is movable it is total activity and its
A series of AMR generated will be together in series caused by operation relevant to this payment event in all business transactions.
One set meal activity may include:
A) main activity: main activity can be a client/tissue insertion and/or update and/or deletion data.The client
Referred to as host and guest family.
B) one or more dependent activities: each client relevant to host and guest family is known as subordinate client.Each subordinate client
There is a dependent activity, as equity activity of the main activity in the subordinate client.
C) operation that dependent activity will be completed in host and guest family according to main activity, mirror image takes completion in its subordinate client
Identical operation.
D) the main activity and all relevant dependent activities are linked by a set meal ID
E) a set meal ID is combined and is constituted with "/" and main activity ID by main Customer ID.One Customer ID is a client/group
Knit unique identifier in systems.
In one embodiment, the main activity in a set meal activity has the identical behavior of an activity.
In one embodiment, in addition to dependent activity only mirror image its accordingly lead movable operation other than, set meal activity in from
Activity has behavior identical with an activity.If a dependent activity not its main activity operations of mirror image operation, institute
Stating dependent activity will be unable to independently execute insertion, update or delete operation.
As described above, executing database manipulation, such as create, update or delete, can be carried out in two steps:
A) step 1: temporarily creation and/or update and/or deletion data.Resulting ephemeral data can pass through cancellation
Correlated activation carrys out physics and deletes (reversion) change.Can also by related edit function in this activity (using revocation function) come
Physics deletes (reversion) and changes these ephemeral datas.
B) step 2: once user pleases oneself to the data recorded in system, user can choose completion and start (to open
Open) activity.Once activity is completed, all ephemeral datas (including temporarily deleting data) relevant to this activity will be identified.
Creation/insertion data:
Pass through the movable interim insertion data having been turned on: being inserted by the activity that active state is " STA " interim
Data can be marked with interim AMR.Interim AMR value combines composition with character " P " by that will be inserted into movable activity ID.?
The ephemeral data that the activity of starting temporarily inserts is marked with interim AMR.When the information of the baby is had been turned on described
Activity 1 in the case where when create, the AMR " 1P " is associated with the data of record and is inserted into database table together
In customer table.
Activity time stamp, interim AMR and effective date (DOE) or synchronization parameters and insertion data combine realization number
According to historical tracking, to record the event for occurring or having occurred and that.
Because the event that the past occurs causes to record or be inserted into extra data, such as, several days or some months are even several years ago
The event of generation.This record behavior will effectively change data history.When the event that record occurs in the past, the activity time
Stamp, interim AMR and effective date (DOE) or synchronization parameters are combined to realize that data variation (change) is gone through with insertion data
The Records of the Historian records trackability.
By finally determining that completing an activity confirms interim insertion data: by the active state of arrival " COM " come
Final to determine the activity of completing, followed by " DEL ", the ephemeral data of the activity insertion will be identified and ephemeral data will
As confirmation data (acknowledgement state).Ephemeral data in this context, the activity are an insertion activities.The data of confirmation can
Labeled as confirmation AMR.The AMR value of confirmation is movable by the insertion by removing the character " P " in the interim AMR
Movable ID (1) forms (AMR of confirmation is 1).For example, removing " P " from the interim AMR of the 1P, lead to 1 to confirm AMR.
The confirmation AMR value (1) replaces the interim AMR (1P), and ephemeral data is made to become confirmation data.When movable final determination is (complete
At) when, AMR is confirmed by label: being revised as 1 from 1P, that is, 1P → 1, to confirm the data of insertion for confirmation data.
Completing (final version) described movable timestamp and the confirmation AMR realizes data history tracking, and Lai Jilu is
The event for occurring or just occurring.When the event that record occurs in the past, activity time stamp of finalizing a text confirms AMR and effective date
(DOE) or synchronization parameters and insertion data combine realize data history records variation (change) trackability.
It reads:
One movable " reading " behavior is identical as the reading in the case where the frame described without this document.
It deletes:
The data having confirmed that are deleted come interim and logic by the activity having been turned on: there is the active state of " STA " and have
One activity of activity identifier (movable ID), depending on the campaign definitions of their own, can be allows logic deletion relevant
Certain existing/old confirmation data identified by confirmation AMR.It is (true by confirmation AMR that one confirmation inserts associated data
The data recognized) activity be insertion activity.Doing the activity deleted is deletion activity.When a deletion activity is deleted and one
When the relevant confirmation data of insertion activity, the deletion activity delete operation will be with the insertion activity association.This association is
By reflecting existing/legacy data by the AMR that the insertion activity confirms with new AMR value replacement to be lived by the deletion
It is dynamic to delete.The new AMR (AMR temporarily deleted) deletes movable activity ID+ character " X "+insertion activity by described
Movable ID form.Character " X " in the new AMR indicate the data of the insertion activity confirmation now logically by
The deletion activity temporarily deletes.The data of the confirmation have had changed into interim deletion data now.The new AMR quilt
It is construed to the deletion activity temporarily and logically deletes the data that the insertion activity is inserted into and is confirmed.Pass through the insertion
The time to reflect more kainogenesis is stabbed in association and the activity time between the movable and described deletion activity (interim AMR),
To realize data variation (change) history traceability.
For example, the record of a baby needs to delete and (is intended merely to demonstration delete operation) rather than updates.One beginning
Activity 8 " CDC/UPD " temporarily and delete in logic AMR be 1 a line record.The AMR will from 1 become 8X1 (1 →
8X1).This is interpreted, and " data for the activity confirmation insertion for being 1 by insertion activity ID by deletion activity ID have been 8 now
Activity deleted by interim with logic."
The data having confirmed that are confirmed and logically deleted by confirming the activity having been turned on: when the activity of beginning is complete
Cheng Hou, the data temporarily deleted relevant to the interim deletion AMR, by by the character " X " in the AMR temporarily deleted
" D " is changed into confirm the data of deletion.The interim deletion AMR is changed to confirmation now and deletes AMR.What confirmation was deleted
AMR is constructed by the deletion activity identifier+character " D "+insertion activity identifier.Word in the AMR
Symbol " D " indicates that the confirmation data that confirmation is inserted by the insertion activity are confirmed on the deletion inactive logic now and deletes.
The confirmation deletes AMR and clearly illustrates the interactive relation between the deletion activity and the insertion activity.Data variation is gone through
History trackability is the cross-correlation (AMR is deleted in confirmation AMR and confirmation) by insertion activity and between deleting, and with it is final living
Dynamic timestamp reflects together to be updated time of origin to complete and realize.Once activity 8 is completed, the AMR of the 8X1 becomes 8D1
(8X1→8D1)。
It cancels and data is temporarily deleted:, can be with for ephemeral data relevant to described interim deletion AMR (such as 8X1)
The interim deletion of the data will be cancelled, the acknowledgement state before restoring it the interim deletion.Cancelling can be by passing through
Cancel the activity or cancels the mode of the interim delete operation to complete.After the completion of cancelling, the number temporarily deleted
According to and its state of the AMR temporarily deleted be restored to its reset condition before the interim deletion occurs, seemingly institute
Interim delete is stated never to occur equally;For example, the AMR 8X1 reverts to the AMR 1.
Pass through the movable physically permanent delet ephemeral data having been turned on: when deleting the activity having been turned on, it had previously been inserted
When the interim AMR and correlation ephemeral data (tuple) that enter, the ephemeral data and relevant interim AMR will be deleted by physics
It removes;For example, the ephemeral data (tuple) will be deleted by physics, just as being never temporarily inserted into the tuple.
It updates:
By starting activity come physical update ephemeral data: when a starting activity updates and the preceding interim AMR being first inserted into
When associated ephemeral data (tuple), the ephemeral data will carry out practical update/modification;For example, the tuple of ephemeral data
It will be covered or be replaced by new data physics, and interim AMR value will retain completely.
In from the example above, after baby is already recorded in and is identified confirmation in system, can also in systems into
The some others activities for the baby of row.The family may have been received by the qualified notice for taking baby's subsidy.
After some months, household determines to change the name of baby.For example, in this case, system will start another work
It is dynamic;Had in inspection system 7 for the baby completed activity (do not start to (or registration, CRF,
SUB) the activity of " CDC/UPD ") after, an activity 8 for being defined as " CDC/UPD " just will create.Activity 8 is by the name to baby
Word record is modified.
Temporarily and the data that have confirmed that of logical renewal by the activity that has been turned on: an active state for being in " STA " and
It can permit interim and logically update/modify and is certain depending on the campaign definitions of the activity oneself for the activity of movable ID
Existing/old confirmation data related with the AMR of confirmation.It executes the activity updated and is known as more New activity.The update is referred to as
Interim and logical renewal.The associated data tuple of AMR is had confirmed that for the template activity modification/update having been turned on, is needed to be implemented
Two steps, modification/update will lead to two tuple datas (two groups of data) under transitory state:
A) as indicated, the existing data having confirmed that are deleted temporarily and logically by the activity that has been turned on, it will be described true
The state for recognizing data becomes interim deletion state.
B) simultaneously, updated new data is associated with an interim AMR and as new insertion tuple (nonce
According to).The new data has transitory state;Come into play interim insertion data as described above.
Two data tuples in the transitory state are referred to as interim more new data together.One more New activity is simultaneously
Serve as insertion activity and deletion activity.The two AMR in the two data tuples clearly demonstrate the deletion activity
With the interaction between the insertion activity.By doing so, the retrospect of data variation history is by insertion activity and deletion
Cross-correlation between movable (two interim AMR), effective date (DOE) or equivalent parameters while, are updated to reflect that update hair
The activity time of raw time stabs realization of coming together.
The name of baby is updated/modifies, the confirmation record that the AMR is 1 will be deleted by temporary logical, and with 8X1's
AMR is recorded in the customer table of database to indicate that the data have been deleted by temporary logical.Number 1 is in creation baby
The movable ID of creation record/row when record, as previously described.Number 8 is deletion activity ID (referred to as deletion activity), from patrolling
Collect the upper deletion record (row)." X " in the AMR " 8X1 " indicate the data by with STA, CRF or SUB state
Movable 8 logics are deleted;And indicate that described delete is interim.Meanwhile described movable 8 temporarily insertion and by institute in customer table
State another row of new data records in the table.The new record (row, i.e., the data being newly inserted into) will be with AMR value 8P
It is associated.Meanwhile in this case, existing data record (row) will obtain logic and it is interim delete, the AMR state from
1 becomes 8X1 (1 → 8X1).It is inserted into/creates another newline simultaneously, wherein including the data information and additional 8P that update
AMR.The 8X1 indicates that described movable 8 is interim and logic deletes activity 1 and creates and confirm data.Therefore, 8X1 keeps data
The trace of change histories.
Pass through the activity confirmation that confirmation starts and logically update the data of confirmation: when come into play be completed when, face
The data of Shi Gengxin will become the data of confirmation update.The update is referred to as confirmation and logical renewal.In the work for completing to start
When dynamic, there are two allow interim the step of more new data reaches acknowledgement state:
A) confirmed by allowing the data temporarily deleted to reach the deletion state of confirmation and logic deletes above-mentioned data (member
Group) confirmation data.
B) simultaneously, confirmation is as described above is inserted into data (tuple) temporarily to reach acknowledgement state.
Two data tuples after completion activity are known as confirming more new data.One more New activity be both insertion activity simultaneously
It is also deletion activity.Confirm that the AMR in two tuples clearly demonstrates the interactive relation between deletion activity and insertion activity
It is associated with with two data tuples.By doing so, the trackability of data modification historical record may be implemented;I.e. by inserting
Enter the cross-correlation (the two confirmation AMR) between activity and deletion activity, the effective date (DOE) or with final activity together more
The equivalent parameters of new data, timestamp is to reflect that the time etc. of more kainogenesis comes together to realize that data modification (variation) history is remembered
The trackability of record.
Once described movable 8 complete, ephemeral data will be confirmed.In this case, the AMR 8P is changed to 8
(8P → 8), the AMR 8X1 are changed to 8D1 (8X1 → 8D1).
The interim data for updating (modification) of revocation: the data temporarily updated can be cancelled or restore.Described cancel may be
As cancellation activity or cancel caused by operation.When cancelling operation generation, the data and its relevant AMR temporarily updated will be restored
Reset condition to before its more kainogenesis, seemingly the interim update never occurred the same.This destruction operation passes through execution
Following two steps are completed:
A) insertion ephemeral data is deleted by the movable physics started as described above.
B) data temporarily deleted are cancelled as described above.
In the case where cancelling the activity 8 started, associated all ephemeral datas record deletes physics,
And the data mode of customer table is reverted into the reset condition before its interim update, as movable 8 never updated customer tables
Equally.
In one embodiment, the data of reading database table do not need starting activity.It only needs the account of user
In relevant permission is awarded can read.
It is also contemplated that AMR and these AMR related datas may be created in first time in the embodiment of the tracking system
When (aprowl be inserted into and/or update and/or delete when), be directly identified and determine without transitory state.At this
In the case of kind, activity is without the early stage Jing Guo activity life cycle;And in creation, active state is directly " COM ".
Figure 21 to 26, which is shown, is related to tracking data insertion, change or the movable further example for updating and deleting.It is all
The client or tissue serviced such as the staff of the tracking system or operator and system operates carrying out.In this side
Face, it is contemplated that staff with Internet access and can update the records of different clients.And it is right, client can only then update his/her
Record.
Activity can be inserted into one or more groups of data/tuples to interim in one or more database tables or confirmation.It is raw
Imitating date (DOE) indicates the effective date of the inserted or updated data.
Interim insertion data: being finally YPK using the User ID of the user for the activity 20 having been turned in Figure 21.User
YPK is temporarily inserted into 2 tuples using the activity 20 having been turned in address table, and temporarily inserts other two in telephone meter
A tuple.As shown in the figure shown in the movable last time operating time stamp effort scale, the insertion time is 2015-03-08 11:48:
23.Grid column in table is example.
Confirmation insertion data: after ten days, when user YPK completes described movable 20, it is by changing the AMR " 20P "
AMR " 20 ", to confirm the data being temporarily inserted into address and telephone meter.As shown in figure 22, movable the last time operates
Timestamp becomes 2015-03-1813:45:28.The active state becomes COM.
One activity logically (interim or confirmation ground) may be updated or be deleted in one or more tables of database
Except data/tuple of one or more confirmation.Data/tuple of different confirmations is with active state with identical or different
The activity of " COM " or " DEL " is related.
Interim and logic deletes data: in Figure 23, activity 21 is interim with deleting in address form in logic
Work Telephone in home address and phone table.Interim delete is to be completed by user ZWC in 2015-03-28 11:45:28
's.
Confirm and logic delete data: two days later, when user's UBY completion activity 21, it is interim in address and telephone meter and
The data that logic is deleted are confirmed by the way that the AMR 21X20 is changed to AMR 21D20.As shown in figure 24, the work
Dynamic last time timestamp is 2015-03-3012:45:28 and active state has become COM.
Interim and logical renewal data: in Figure 25, activity 22 is interim and has updated the work in address form in logic
Address and home phone number and mobile phone in phone table.The interim update is by user YPK in 2015-04-10 12:
35:39 is completed.As update as a result, data relevant to interim AMR 22P are the data temporarily updated, and and AMR
The relevant data of 22X20 or AMR 22X18 are then old confirmation data, and are deleted by interim and logic.
Confirm simultaneously logical renewal data: after a few houres, when user YPK finally confirmation activity 22, the address and phone
Interim and logical renewal data are confirmed by the way that the AMR 22P is changed to AMR 22 in table, and AMR 22X20 is changed to
AMR 22D20 and AMR 22X18 is changed to AMR 22D18 to confirm deletion.As shown in figure 26, the movable last time operation
Timestamp becomes 2015-04-10 14:25:51 and the active state becomes COM.
Figure 27 and 28 shows some examples of reverse turn operation.In these examples, by cancellation activity or some is cancelled
It operates to invert interim insertion, updates or delete data relevant to the activity.
For example, as shown in figure 27, User ID YPK using the activity 23 having been turned on, temporarily " spend in address form by insertion
The address of vacation " family type temporarily updates home phone number and interim deletion phone number in phone table.As activity arranges
Shown in the movable final time stamp of table table, these operations were completed in 15:25:53 on April 15 in 2015.Active state is STA.
As shown in figure 28, when activity 23 2015-04-16 11:25:53 by User ID YPK cancel when, activity 23 work
The state of moving is as CAN (cancellation), all temporarily insertions, before the data of deletion or update are resumed (reduction) as movable 23 operation
State.All interim insertions relevant to the activity are deleted or were updated as never occurring.Therefore,
The data in address table and telephone meter in Figure 28 be with it is identical in Figure 26.
It should be understood that no matter Australia or any other country, it is mentioned herein to any of the prior art
Reference is not construed as limiting the invention.Do not mean that yet recognize the prior art formed or formed in this field it is common often
A part of knowledge.
In following claims and preceding description of the invention, in addition to due to representation language or necessary containing at those
The place of justice, context need word "comprising" with comprising meaning use, that is, statement provides the presence of the function, but not
Exclude the presence of other function in the existing or additional various implementations of function in various embodiments of the present invention.In addition,
The not stringent differentiation in this document of the meaning of word "one" and "an", is usually interchangeable in context.
Claims (54)
1. a kind of method that tracking data is deleted, comprising:
One new activity identifier of distribution is deleted for data;
It is searched from one or more existing identifier nucleotide sequences and finds an existing activity mark relevant to data to be deleted
Symbol;
Generate includes the New activity identifier and an existing movable data identifier;
With the data identifier is associated with the data to be deleted, so as to track the data data delete.
2. the method as described in claim 1, wherein the existing activity identifier includes the data that delete data from one
It is found in index.
3. according to the method described in claim 2, wherein the sequence of the existing activity identifier is stored in an activity index
In;The data directory and the activity index are stored in the same database.
4. method as claimed in claim 3, wherein the existing activity identifier and to be deleted in the data directory
Data it is associated.
5. method as claimed in claim 4, wherein the data identifier is associated with the data to be deleted, pass through by
The data identifier is associated with data to be deleted and is collectively stored in the data directory.
6. method as claimed in claim 5, wherein the data identifier is associated with the data to be deleted and together
It is stored in the data directory, passes through and modify the existing activity identifier associated with the data to be deleted and incite somebody to action
It is stored together with the data to be deleted after being converted to the data identifier.
7. method according to any one of claim 1 to 6, wherein after receiving the request for executing data deletion, institute
New activity identifier is stated to respond the request and automatically determines and automatically generates.
8. the method as described in any one of claims 1 to 7, wherein the newly-generated data identifier further comprises pair
One data of the state that data described in Ying Yu are deleted delete status identifier.
9. method according to claim 8 further includes in response to receiving confirmation data removal request, automatic modification is described
The deletion status identifier in data directory in the corresponding data identifier.
10. method according to any one of claim 1 to 9, wherein each existing activity identifier corresponds to data
It deletes and at least one of data insertion operation operation.
11. method according to any one of claim 1 to 10 further includes cancelling asking for data deletion in response to receiving
It asks, deletion of the automatic revocation to the data to be deleted.
12. method according to any one of claim 1 to 10, wherein the existing sequence identifier is stored in one
In a activity index, and the method also includes storing the New activity identifier in the activity index.
13. method as claimed in claim 12, wherein the new activity identifier and one active state identifier close
Join and is stored in the activity index together.
14. method as claimed in claim 13 further includes when the request or cancellation data that receive confirmation data deletion are deleted
When request, the active state identifier in the New activity identifier is modified automatically in the activity index.
15. further including being associated with the New activity identifier and corresponding to according to claim 1 to method described in any one of 14
The user identifier of one user.
16. method as claimed in claim 15, wherein the New activity identifier and the relative user identifier
It is associated.
17. further including receiving an insertion in response to the method newly according to claim 1 to method described in any one of 16
The request of data automatically generates another new data identifier.The New Data Flag symbol includes the new activity mark
It accords with and the status identifier of a data of the data insert state that corresponds to insertion.
18. method as claimed in claim 17 further includes automatically that the other new data is relative described in addition new
Data identifier associates, and stores together, to track the data insertion.
19. method as claimed in claim 18 further includes requiring data described in 1 to 16 to delete in response to receiving confirmation
While request, automatic modification and the new data insert state being inserted into the associated data identifier of data
Identifier to confirm that the other new data insertion.
20. method as claimed in claim 18 further includes in response to receiving the request cancelled or cancel the data insertion, certainly
It is dynamic to delete the new data and its associated other new data insertion identifier.
21. a kind of tracking system deleted for tracking data, comprising:
One activity identifier distributor is configurable for deleting one new activity identifier of distribution for data;
One activity identifier locator is configurable for being positioned from one or more existing sequences, to look for
To an existing activity identifier associated with data to be deleted;
One data identification generator is configurable for generating a data identifier, including the new activity
Identifier and the existing activity identifier;With
One data identifier correlator is arranged to be used for the data identifier is relative by deleted data
It associates, to start the tracking deleted the data.
22. a tracking system according to claim 21, wherein the existing activity identifier is from comprising to be deleted
It is found in one data directory of the data removed.
23. a tracking system as claimed in claim 22, further include storing data the data directory and storage described in
One database of one activity index of existing activity identifier sequence.
24. a tracking system as claimed in claim 23, wherein the existing activity identifier be in the data rope
Data to be deleted described in drawing are associated.
25. a tracking system according to claim 24, wherein the data identifier correlator, by the number
The mode being collectively stored according to identifier to the data to be deleted in the relevant data directory in the database,
The data identifier is associated with the data to be deleted.
26. a tracking system according to claim 25, wherein the data identifier correlator passes through described in modification
Existing, activity identifier associated with the data to be deleted is converted into the data identifier mode, with
The data to be deleted in the data directory are associated, and are stored in the data directory together.
27. a tracking system according to any one of claim 21 to 26, wherein the activity identifier distributor
The new activity identifier is automatically determined, receives the request for executing data and deleting to respond the tracking system.
28. a tracking system according to any one of claim 21 to 27, wherein the data identifier generator
Generating the data identifier further comprises that a data delete status identifier, to correspond to the shape that a data are deleted
State.
29. a tracking system as claimed in claim 28, wherein the data identifier correlator is configured as being used for
Automatically the data modified in the data identifier delete status identifier, receive confirmation institute to respond the tracking system
State the request of data deletion.
30. a tracking system according to any one of claim 21 to 29, wherein each existing activity identifier pair
It should be deleted and at least one of data insertion operation operation in data.
31. a tracking system according to any one of claim 21 to 30, wherein the data identifier correlator
It is configurable for before the data identifier associated with data to be deleted is reduced into the deletion of its data automatically
State receives the request cancelling the data and deleting to respond the track system.
32. a tracking system according to any one of claim 21 to 30, wherein existing succession of identifiers is stored
In an activity index, and the tracking system further include: an activity identifier correlator is configurable for institute
New activity identifier is stated to be stored in the activity index.
33. a tracking system according to claim 32, wherein the activity identifier correlator is configurable for
The new activity identifier is associated with an active state identifier in the activity, and it is stored in the work together
In dynamic index.
34. a tracking system according to claim 33, wherein the activity identifier correlator is configurable for
To the New activity relevant active state identifier of the automatic modification in the activity index, so as in response to described
Tracking system receives confirmation data and deletes or cancel the request that data are deleted.
35. a tracking system according to any one of claim 21 to 34, the activity identifier correlator is matched
It is set to for a new activity identifier user identifier corresponding with a user is associated.
36. a tracking system as claimed in claim 35, wherein New activity identifier user's mark associated therewith
It is associated to know symbol.
37. a tracking system according to any one of claim 21 to 36, wherein the data identifier generator
It is configurable for automatically generating another new data identifier, so as in response to the request for receiving insertion new data.
Another described new data identifier includes the New activity identifier and a data corresponding to data insert state
Status identifier.
38. a tracking system as claimed in claim 37, wherein the data identifier correlator is configurable for certainly
It is dynamic that the other New Data Flag symbol is associated with the new insertion data, so as to track the data insertion.It is this
Association is implemented by the way that the new data and the relative other New Data Flag symbol to be stored together.
39. a tracking system according to claim 38, wherein while confirming the deletion data, the work
Dynamic identifier correlator is configurable for modifying the data insert state mark associated with the data identifier automatically
Know and accord with the insertion to confirm that the new data, is requiring number described in 21 to 36 to respond tracking system reception confirmation
According to removal request.
40. a tracking system according to claim 38, wherein the activity identifier correlator is configurable for
It is automatically deleted the new data and another New Data Flag symbol relevant to the new data, to respond the tracking
System receives the request cancelled or cancel data insertion.
41. a kind of tracking data is deleted and the method for at least one of data insertion operation operation, comprising:
It receives to execute data removal request and execute data and is inserted at least one of request request;
One activity identifier is distributed at least one of the data are deleted and the data are inserted into operation, and is stored in
In one activity index;With a data identifier will containing the activity identifier and data to be deleted and to be inserted
At least one data in the data entered are associated, and are collectively stored in a data directory.Wherein, the data directory is
Except the activity index.
42. method as claimed in claim 41, wherein when receiving the execution data removal request, the Data Identification
Symbol is generated as including that a data delete status identifier to correspond to a deletion state of the data.
43. method as claimed in claim 42 further includes the data identifier that modification is stored in the data directory
In the data delete status identifier, deleted to delete or cancel the data in response to receiving the confirmation data
Any of request.
44. the method according to any one of claim 41 to 43, wherein execute asking for the data insertion when receiving
When asking, the data identifier is generated as including data insert state mark corresponding with a data insert state
Symbol.
45. further including according to the method for claim 44, in response to receiving confirmation or cancelling any in data insertion
The data insert state in the data identifier being stored in the data directory is modified in a request.
46. the method according to any one of claim 41 to 45 further includes generating for storing the data identifier
The data directory.
47. the method according to any one of claim 41 to 46 further includes that positioning (finding out) stores the Data Identification
The data directory of symbol.
48. deleting a tracking system at least one of data insertion operation for tracking data, comprising:
One request receiver is configurable for receiving at least one executed in the request that data are deleted and execution data are inserted into
A request;
One activity identifier distributor is configurable for distributing to an activity identifier data and deletes and described
The operation of at least one of data insertion operation, and be stored in an activity index;With
One data identifier correlator is arranged to be used for one data identifier of storage.The data identifier includes institute
It is associated at least one data in data to be deleted and the data to be inserted into state the movable activity identifier,
And it is stored in a data directory together.
The data directory is independently of except the activity index.
49. a tracking system according to claim 48, further includes, a data identification generator is configured as
For generating the data identifier.Wherein, when receiving the execution data removal request, the data identifier is by described
Data identifier generator generates.The data identifier includes that a data delete status identifier, to correspond to the number
The state deleted according to a data of deletion.
50. a tracking system as claimed in claim 49, including the data identifier correlator are configurable for repairing
Change data in the data identifier being stored in the data directory and delete status identifier, with respond it is described with
Track system receives a confirmation or cancels the request that data are deleted.
51. a tracking system according to any one of claim 48 to 50, further includes, a data identifier is generated
Device is configurable for generating the data identifier.When reception executes the data insertion request, the data identifier
Generator will generate the data identifier.Wherein the data identifier includes a data insert state identifier, with right
The state of the data insertion of data is inserted into described in Ying Yu.
52. a tracking system according to claim 51, wherein the data identifier correlator is configurable for
The data insert state identifier in the data identifier being stored in the data directory is modified, to respond this
Tracking system receives a confirmation or cancels data insertion request.
53. a tracking system according to any one of claim 48 to 52, wherein the data identifier correlator
It is configurable for generating the data directory, so that the data identifier to be stored in the data directory.
54. a tracking system according to any one of claim 48 to 53, wherein the data identifier correlator
It is configurable for positioning (finding) described data directory, to store the data identifier and its related data.
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
AU2018901705A AU2018901705A0 (en) | 2018-05-16 | A method of tracing or tracking changes in data | |
AU2018901705 | 2018-05-16 |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110083596A true CN110083596A (en) | 2019-08-02 |
Family
ID=67412921
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811623790.3A Pending CN110083596A (en) | 2018-05-16 | 2018-12-28 | A kind of method of data history tracking and the tracking of data change histories |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN110083596A (en) |
AU (2) | AU2019203420A1 (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113222344A (en) * | 2021-04-15 | 2021-08-06 | 卓尔智联(武汉)研究院有限公司 | Block chain data processing method and device and storage medium |
CN114065086A (en) * | 2021-10-09 | 2022-02-18 | 德明尚品科技集团有限公司 | Block chain-based internet browsing history data management method and system |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1497467A (en) * | 2002-10-17 | 2004-05-19 | �Ҵ���˾ | Method and device for synchronous presentation deleting data in data base |
CN1610901A (en) * | 2001-11-01 | 2005-04-27 | 弗里塞恩公司 | Methodn and system for verifying a remote database |
CN101727355A (en) * | 2008-10-31 | 2010-06-09 | 国际商业机器公司 | Handling method and system for memory access events |
CN101965558A (en) * | 2008-02-29 | 2011-02-02 | 三菱电机株式会社 | Event history memory device, event history tracking device, event history memory method, event history memory program and data structure |
CN104317963A (en) * | 2014-11-14 | 2015-01-28 | 中国建设银行股份有限公司 | Method and device for processing data |
CN104798070A (en) * | 2012-09-28 | 2015-07-22 | 甲骨文国际公司 | Techniques for activity tracking, data classification, and in database archiving |
CN105940412A (en) * | 2014-02-06 | 2016-09-14 | 谷歌公司 | Methods and systems for deleting requested information |
-
2018
- 2018-12-28 CN CN201811623790.3A patent/CN110083596A/en active Pending
-
2019
- 2019-05-15 AU AU2019203420A patent/AU2019203420A1/en not_active Abandoned
-
2024
- 2024-10-25 AU AU2024227624A patent/AU2024227624A1/en active Pending
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1610901A (en) * | 2001-11-01 | 2005-04-27 | 弗里塞恩公司 | Methodn and system for verifying a remote database |
CN1497467A (en) * | 2002-10-17 | 2004-05-19 | �Ҵ���˾ | Method and device for synchronous presentation deleting data in data base |
CN101965558A (en) * | 2008-02-29 | 2011-02-02 | 三菱电机株式会社 | Event history memory device, event history tracking device, event history memory method, event history memory program and data structure |
CN101727355A (en) * | 2008-10-31 | 2010-06-09 | 国际商业机器公司 | Handling method and system for memory access events |
CN104798070A (en) * | 2012-09-28 | 2015-07-22 | 甲骨文国际公司 | Techniques for activity tracking, data classification, and in database archiving |
CN105940412A (en) * | 2014-02-06 | 2016-09-14 | 谷歌公司 | Methods and systems for deleting requested information |
CN104317963A (en) * | 2014-11-14 | 2015-01-28 | 中国建设银行股份有限公司 | Method and device for processing data |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113222344A (en) * | 2021-04-15 | 2021-08-06 | 卓尔智联(武汉)研究院有限公司 | Block chain data processing method and device and storage medium |
CN114065086A (en) * | 2021-10-09 | 2022-02-18 | 德明尚品科技集团有限公司 | Block chain-based internet browsing history data management method and system |
CN114065086B (en) * | 2021-10-09 | 2022-11-11 | 广州市良策网络技术有限公司 | Block chain-based internet browsing history data management method and system |
Also Published As
Publication number | Publication date |
---|---|
AU2019203420A1 (en) | 2019-12-05 |
AU2024227624A1 (en) | 2024-11-21 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11556672B2 (en) | Data processing systems for verification of consent and notice processing and related methods | |
US11354434B2 (en) | Data processing systems for verification of consent and notice processing and related methods | |
US11461500B2 (en) | Data processing systems for cookie compliance testing with website scanning and related methods | |
US20220215124A1 (en) | Specifying characteristics of a permissible query on an output of a data pipeline | |
US11328093B1 (en) | Protecting sensitive data | |
CN109360077A (en) | Information processing method, device, gateway server and medium in invoice reimbursement | |
AU2024227624A1 (en) | A method of tracing or tracking changes in data | |
CN103473256A (en) | Defining content retention rules using a domain-specific language | |
Brummitt et al. | Contagious disruptions and complexity traps in economic development | |
CN104699790B (en) | A kind of bank data relation establishing method and device | |
CN113537915A (en) | Project evaluation system, method and storage medium | |
US20230385248A1 (en) | System, Method, and Computer Program Products for Modeling Complex Hierarchical Metadata with Multi-Generational Terms | |
US8626773B2 (en) | Aligning records for visual comparison | |
Kuiler | Data governance | |
Huang | Data cleansing | |
CN107533559A (en) | Data structure, the model for filling data structure and the method being programmed using data structure to processing unit | |
CN117519543A (en) | Document data input method, device, computer equipment and storage medium | |
CN115878655A (en) | Data operation method and device, computer equipment and storage medium | |
Deb Nath et al. | Prediction model of success or failure for small business in north East India | |
Bhusan | Big data and Hadoop: Learn by example | |
Ma | Data-information-knowledge-action model | |
JP2012164177A (en) | Program automatic generation system | |
Dzhakishev | Nosql databases in the enterprise | |
Agrawal | Data Virtualization | |
Chen | Digital ecosystem |
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 | ||
WD01 | Invention patent application deemed withdrawn after publication | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20190802 |