Embodiment
It is specifically real below in conjunction with the application to make the purpose, technical scheme and advantage of the application clearer
Apply example and technical scheme is clearly and completely described corresponding accompanying drawing.Obviously, it is described
Embodiment is only some embodiments of the present application, rather than whole embodiments.Based on the implementation in the application
Example, the every other implementation that those of ordinary skill in the art are obtained under the premise of creative work is not made
Example, belongs to the scope of the application protection.
In order to make it easy to understand, being used to below exemplified by electronic commerce affair, enter the problem of to being mentioned in background technology
Row explanation.
For example, for an electronic commerce affair, can be divided into ordering according to the attribute classification of the business
Multiple dimensions such as list, time, trade company, order dimension is exactly a kind of slowly varying dimension.Every ecommerce industry
Business can typically have order creation, order to pay neutralization order payment three kinds of states of completion, with order dimension
Speech:When business initializtion is order creation state, the dimension of an order dimension can be inserted into tables of data
Data record;, can be to the dimension when business will be state during order is paid by order creation Status Change
Data record correspondingly carries out first time change, after the completion of changing for the first time, and business is in shape during order is paid
State;When Status Change is that order pays completion status during business will be paid by order, first time can be become
Dimension data record after more carries out second and changed, and after the completion of second is changed, business is paid in order
Completion status.
It can be seen that, for the order dimension of an electronic commerce affair, only existed in any time data table
One the dimension data for corresponding to order dimension is recorded, and this dimension data record can reflect the newest of business
State, but the change procedure of order dimension can not be recorded.
In order to solve the problems of the prior art, in the embodiment of the present application, in each state of business
Every kind of state, when business will be changed to the state, can newly insert one and the state pair into tables of data
The dimension data record answered is (referred to as:The state dimension data record), rather than as prior art that
Sample is only changed on original dimension data record;And can be dimension data record increase mark letter
Breath, the label information can be used to indicate that whether the dimension data reflects whether the last state of business (reflects
The last state of the dimension data of the slowly varying dimension of the business), further, label information can also be used
Each dimension data record is made a distinction, it is thus possible to preserve slowly varying dimension in a tables of data in industry
The dimension data record of each state of business, and then recorded according to each dimension data, slowly varying dimension can be analyzed
Change procedure.
Moreover, the embodiment of the present application is also contemplated in actual applications, the state for changing business
Out of order and/or concurrent special screne may occur for service message, and special there is provided that can tackle these
The dimension data processing scheme of scene, so as to further improve the application scheme applicability and can
By property.
The scheme to the application is specifically described below.
The process for the dimension data processing method that Fig. 1 provides for the embodiment of the present application, the executive agent of the process
Can be terminal or server.The terminal includes but is not limited to:Personal computer, mobile phone, panel computer,
Intelligent watch, vehicle-mounted mobile platform etc.;The server includes but is not limited to:Personal computer, big-and-middle-sized meter
Calculation machine, computer cluster etc..Executive agent does not constitute the restriction to the application.For the ease of describing, this
Application embodiment is illustrated so that executive agent is server as an example.
In the embodiment of the present application, described dimension can be such as time change or service condition change
And the dimension changed, such as slowly varying dimension.
Process in Fig. 1 specifically may comprise steps of:
S101:Receive the service message of the state for changing business.
In the embodiment of the present application, the business can be electronic commerce affair, financial business, communication service
Etc. any type of business, correspondingly, server can be the server of the business.Business has at least two
The state of kind, the service message can be any for being by business initializtion (this falls within a kind of change)
A kind of state, or, for by business from a kind of Status Change be another state message.The application is real
Example is applied not limit the format and content of service message.
For example, for an electronic commerce affair, service message can be the message that request creates order, use
In this electronic commerce affair will be created, and this electronic commerce affair is initialized as order creation state;
Can also be the message for asking pay invoice, for by this electronic commerce affair from order creation Status Change
State in being paid for order;It can also be to determine that order pays the message completed, for by this ecommerce
Business Status Change from order payment is that order pays completion status.
Again for example, for finance (it is assumed that a transferring accounts) business, can be the message that request is transferred accounts, use
Withholdd the state that the side of being transferred to not yet collects money in this financial business is initialized as into the side of producing;Can also be true
Surely transfer accounts the message of completion, for this financial business have been withholdd the shape that the side of being transferred to not yet collects money from the side of producing
State, is changed to the side of producing and has withholdd the state that the side of being transferred to collected money.
S102:According to the service message, the dimension of state after the change of the business is inserted into tables of data
Data record, the dimension data record has corresponding label information, and the tables of data is used to preserve
The dimension data record of each state of the business.
In the embodiment of the present application, it can be carried in the service message for generating or changing dimension data
Parameter, can also carry for ask arbitrary equipment generate or change dimension data instruction.
In the introduction it was mentioned that the invention that being in tables of data when service condition is changed in the prior art
Dimension data record preserved, corresponding is changed, and reflection business is recorded with the dimension data after change
Last state, it can be seen that this scheme be substantially with change after state dimension data record replace
Fall the dimension data record of state before changing.
And in the embodiment of the present application, can be by being inserted into tables of data whenever the state of the business of change
After change state a dimension data record, realize the state of change business, like this, business it is each
The dimension data record of state is all able to be stored in tables of data.Wherein, the dimension data record of insertion can be with
It is what the service message based on reception was generated.
The electronic commerce affair used the example above is illustrated.It is assumed that certain electronic commerce affair is paid in order
Complete, it can be seen from explanation above, server at least received three for this electronic commerce affair
Business information, causes the state of this electronic commerce affair at least to change three times, correspondingly, into tables of data
At least inserted the three dimension datas record for belonging to order dimension.
The label information is no in the prior art, but what the scheme of the application was increased newly, in step
It is specifically described in S103.
S103:According to the tables of data after insertion dimension data record, to the business preserved in tables of data
Each state dimension data record label information be updated;Wherein, the label information is used to represent
Whether corresponding dimension data record reflects the last state of the business.
In the embodiment of the present application, due to the dimension for a business, it may preserve and belong in tables of data
The a plurality of dimension data record of the dimension, therefore, it can make a distinction a plurality of dimension data record,
In order to inquire about and analyze.
Specifically, every dimension data record can have correspondence markings information therewith respectively, specifically, often
Bar dimension data record can include or associate a label information, as with this dimension data record pair
The label information answered.For the ease of description, dimension data can be recorded to the label information for including or associating
Referred to as:The label information of dimension data record.The embodiment of the present application includes or associated mark to dimension data record
The mode of note information is not limited.For example, can be for being carried out in advance to the form that dimension data is recorded
Modification, increases an advance field, and label information is preserved with the scheduled field, and this scheme only need to be for number
Increase an attribute column (attribute of the attribute column is the scheduled field), advantage according to the dimension in table
It is implemented as small;Or, single file can also be used, the mark of each dimension data record association is recorded
Information, this scheme is that advantage is that influence to tables of data is smaller;Etc..
In the embodiment of the present application, label information can be used for distinguishing history dimension data record (business worked as
The dimension data record of each state before preceding state) and the newest dimension data record (current state of business
Dimension data record).In this case, the label information of dimension data record can have two kinds of values
(being referred to as the first value, second value):First value can represent that dimension data record is newest number of dimensions
According to record, that is, the dimension records the last state of reflection business;Second value can represent the dimension data
Record is history dimension data record, that is, dimension record does not reflect the last state of business.
Label information can be also used for further distinguishing each history dimension data record.In such case
Under, the quantity of the possible value of label information of dimension data record, number that can be with the possible state of business
Amount is identical, and each value can correspond to a kind of state.So as to for dimension of a business
Each dimension data record, the label information of each dimension data record is differed, and therefore, it can root
Each dimension data record is made a distinction one by one according to label information.Like this, divide after can improving
Analyse the efficiency of the change procedure of the dimension.
In the embodiment of the present application, whenever for certain business, new dimension data is inserted into tables of data
During record, it may be said that the state of bright this business is changed, therefore, it can to belong to this business,
Belong to the mark of same dimension, part or all of dimension data record with the new dimension data record of insertion
Information is correspondingly updated.In actual applications, the real-time of the operation of the renewal is higher, then marks
The real-time and reliability of information are also higher.
In the embodiment of the present application, performed for the label information of each dimension data record in step S103
Renewal operation, can not also perform in step s 103 entirely, a part therein can also be in step S102
In or step S102 before perform, the part therein can refer to business each history dimension data note
Record.
By the method in Fig. 1, in the change procedure of slowly varying dimension, same tables of data not only can be with
Newest dimension data record is preserved, and each history dimension data record can be preserved, so as to solve existing
The problem of in technology.In addition, in the technical scheme of the application, also there is the mark recorded based on dimension data
Remember information, history dimension data record can be distinguished by the label information and newest dimension data is recorded, from
And be conducive to analyzing the change procedure of slowly varying dimension.
In order to make it easy to understand, further illustrating to the step in Fig. 1 below.
It has been mentioned hereinbefore that dimension data record is included or the mode of connective marker information can have a variety of.This
Application embodiment is illustrated mainly for the mode of scheduled field.Specifically, the dimension data record
The scheduled field that label information can be recorded by the dimension data is preserved.
For example, can increase a property column for dimension, the attribute of the property column is the scheduled field,
It is assumed that entitled " tag " (for the ease of the scheduled field is referred to as into tag fields) of the scheduled field, with
And assume the data type of tag fields for integer.
Implication represented by the different values of tag fields can be defined in advance.Such as tag fields can
In 1 or 0, wherein, 1 as the first value, and 0 as second value, then when tag fields are equal to 1, can be with
Represent that corresponding dimension data records the last state of reflection business, can be with table when tag fields are equal to 0
Show that corresponding dimension data record does not reflect the last state of business.
Certainly, to also be made a distinction to each history dimension data record, tag fields can have more
Value.For example, for above-mentioned electronic commerce affair, tag fields can be equal to 0 or 1 or 2, its
In, when tag fields are equal to 0, it is the dimension of order creation state that can represent corresponding dimension data record
Degrees of data is recorded, when tag fields are equal to 1, and it is that order is paid that can represent corresponding dimension data record
The dimension data record of middle state, when tag fields are equal to 2, can represent corresponding dimension data record
It is the dimension data record that order pays completion status, then at any time, in tables of data tag field values are most
Big dimension data record can reflect the last state of business.
It should be noted that the tag fields in upper example are an examples of the scheduled field, 0,1 is predetermined
The example of the value of field, the embodiment of the present application to title, data type, value of the scheduled field etc. simultaneously
Do not limit.
In the embodiment of the present application, the operation of described insertion can be by the insertion (insert) of database
Instruction realizes that the operation of described renewal can be instructed by the renewal (update) of database to be realized.This
A little instructions can be specifically SQL (Structured Query Language, SQL) sentence,
It can also be the data base manipulation statement of other forms.
In the embodiment of the present application, for step S102 and step S103, its tool under different scenes
Body embodiment can also be different, mainly there is three kinds of scenes:The not out of order also not concurrent scene of service message,
The out of order scene of service message possibility, service message may the out of order and concurrent scenes of possibility.Enter separately below
Row explanation.
For the not out of order also not concurrent scene of service message, it is described as follows:
In such a scenario, whenever the service message for receiving the state for changing business, according to the business
Message, the dimension data record of state can reflect industry after change to be inserted into tables of data, the business
The last state of business.
It therefore, it can before dimension data record is inserted, by preserved in the tables of data and number of dimensions
The label information for belonging to each dimension data record of same dimension according to record is updated to second value, and then, inserting
Enter after dimension data record, the label information that the dimension data is recorded can be updated to the first value;Or,
Dimension data record can also be first inserted, afterwards, then the label information that the dimension data is recorded is updated to
First value, and preserved in the tables of data and dimension data is recorded to each dimension for belonging to same dimension
The label information of data record is updated to second value;Etc..Wherein, wherein, the first value represents corresponding dimension
Degrees of data records the last state of reflection business, and second value represents that corresponding dimension data record does not reflect business
Last state.
For the possible out of order scene of service message, it is described as follows:
In such a scenario, the dimension data record being newly inserted not necessarily reflects the last state of business.Cause
This, can further analyze each dimension data record in tables of data, to determine the newest of reflection business
The dimension data record of state, and then the label information that dimension data is recorded is updated again.
In actual applications, dimension data record can include customizing messages, and customizing messages reflects the dimension
Degrees of data records logical order of the corresponding service message in each service message.Based on this premise, for
Step S103, according to the tables of data after insertion dimension data record, to the industry preserved in tables of data
The label information of the dimension data record of each state of business is updated, and can specifically be included:According to the industry
Tables of data after the mark of business and insertion dimension data record, the business for determining to have preserved in tables of data
The dimension data record of each state;The customizing messages included is recorded according to each dimension data of determination, to described
The label information of each dimension data record is updated.
In the embodiment of the present application, business belonging to being recorded in dimension data record comprising the dimension data
Mark.For example, for an electronic commerce affair, its mark can be order number, or, other can be with
Information for uniquely determining this business;Similarly, for a financial business, it can hand over that it, which is identified,
Yi Hao.
Further, above-mentioned customizing messages can be service message creation time, or, for marking dimension
Degrees of data records the mark of logical order of the corresponding service message in each service message, such as sequence number.
This is illustrated to described logical order.
Logical order can refer to the order for creating and sending each service message, and this order is and service subscription
Logic matching.For example, for an electronic commerce affair, corresponding three business of its three kinds of states disappear
Ceasing to be:Request creates the message of order, asks the message of pay invoice, determines that order pays what is completed
Message.For from the service logic of electronic commerce affair, only after order is created, be only possible to start into
Row order is paid, only after payment is started, and is only possible to pay completion, and therefore, request creates order
Message of the logical order of message prior to asking pay invoice, asks the message of pay invoice prior to determining order
Pay the message completed.
But, in actual applications, due to reasons such as processing delay or network delays, it may result in and first create
The message that the message built and sent is created and sent after being later than on the contrary reaches server.Such case is above
Mention:Service message is out of order.
According to explanation above, when customizing messages is service message creation time, according to each dimension of determination
The customizing messages that data record is included, is updated, specifically to the label information of each dimension data record
It can include:The service message creation time included is recorded according to each dimension data of determination, in each dimension
In degrees of data record, the label information of the newest dimension data record of service message creation time is updated to the
One value, and the label information that other dimension datas are recorded are updated to second value, wherein, first value
The last state of the corresponding dimension data record reflection business is represented, the second value represents corresponding dimension
Degrees of data records the last state for not reflecting the business.
By the scheme in the preceding paragraph, label information is updated by being then based on service message creation time
, therefore, even if service message is out of order, each label information still is able to be updated correctly, after each renewal
Label information can correctly represent whether corresponding dimension data record reflects the last state of business.In reality
In the application of border, the renewal operation in the preceding paragraph can be realized in a update sentence, like this,
Each operation in this update sentence can by database bottom transaction guarantee atomicity, or it is that is, each
All operationss success is operated, otherwise respectively operation all operationss failure, so as to prevent that each label information from updating
Mistake.
For the scene that service message is possible out of order and may be concurrent, it is described as follows:
In actual applications, service message is not only possible out of order, and may be concurrent.It is described concurrently to refer to:
Server receives at least two business of same business in the same time or in shorter time interval
Message, so as to cause server respectively for the every service message, dimension at least two service messages
Data handling procedure may be performed parallel.In such a scenario, parallel execution dimension data processing procedure can
It can clash, and then cause to update mistake to label information.
The problem of being solved under this scene based on affairs, the affairs are db transactions.Carry out below
The application is specifically described for the counte-rplan of this scene.
Step S102 and step S103 can be performed in same affairs.Then according to the service message,
The dimension data record of state after the change of the business is inserted into tables of data, according to insertion dimension data note
Tables of data after record, the mark recorded to the dimension data of each state of the business preserved in tables of data
Information is updated, and can specifically be included:
According to the service message, create and perform affairs, each step included in the affairs is according to such as
What lower order was performed:
The dimension data record of state after the change of the business is inserted into tables of data;
The dimension of each state of the business preserved in tables of data after being recorded for insertion dimension data
Data record, by comprising service message creation time it is newest dimension data record label information be updated to
First value, first value represents that corresponding dimension data records the last state of reflection business;
The dimension of each state of the business preserved in tables of data after being recorded for insertion dimension data
Data record, by except comprising service message creation time it is newest dimension data record in addition to, other
The label information of dimension data record is updated to second value, and the second value represents corresponding dimension data record
The last state of business is not reflected.
The affairs are further illustrated to analyze.It can be seen that, altogether comprising three steps in the affairs,
In the specific implementation, each step can be realized with one or more SQL statement.Below with actually should
With under scene, some can be used for realizing that the SQL statement of the affairs is illustrated as an example.
, can be according to service message for first step in the affairs, extracting will be to each category of dimension
Property carry out the property value of assignment, and then each property value extracted constituted into a new dimension data recorded,
And with insert sentences by dimension data record insertion tables of data.
In order to make it easy to understand, the electronic order business used the example above, to the second step in the affairs and
Three steps are illustrated.
For second step, it can be realized using following SQL statement (being referred to as sentence 1):
" update tag=1from xxx order by biz_time desc where biz_order_no=order numbers
limit 1”;
Tag fields are the label information of dimension data record, and " xxx " is the title of tables of data, biz_time
Field is the field for record traffic message creation time, and biz_order_no fields are record order number
Field.
Order number in sentence 1 is specially the order number of the affiliated business of the service message received.Sentence 1
Function is that referred database carries out following operate:Each dimension data record of this business is all filtered out
Come, and recorded service message creation time descending is recorded according to dimension data to arrange, foremost will be come
A dimension data record label information be revised as the first value.
For the 3rd step, it can be realized using following SQL statement (being referred to as sentence 2):
" update tag=0from xxx order by biz_time desc where biz_order_no=order numbers
limit 3offset 1”;
" 3 " in sentence 2 represent that this business at most only has three state;Order number tool in sentence 2
Body is the order number of the affiliated business of the service message received.The function of sentence 1 be referred database carry out with
Lower operation:Each dimension data record of this business is all screened, and institute is recorded according to dimension data
The service message creation time descending arrangement of record, is recorded for three dimension datas for coming foremost, will
The mark letter of two other dimension data record in addition to coming a dimension data of foremost and recording
Breath is revised as the first value.
By affairs above, label information is updated based on service message creation time, passed through
Every dimension data of transaction guarantee, which records corresponding process step, completely to be performed, and be first will bag
The label information of the newest dimension data record of the service message creation time that contains is updated to the first value, then will remove
Beyond the newest dimension data record of the service message creation time that includes, other dimension datas record
Label information is updated to second value, therefore, even if there occurs the out of order and/or parallel situation of service message,
Still it can ensure for the newest dimension data record of service message creation time, dimension data record
Label information can be updated correctly to the first value.And in can ensureing at any time, for this business
Any dimension, have and the dimension, dimension data record that only one belongs to this business mark letter
Breath is in the first value.
For example it is assumed that the parallel business for receiving two states for being used for more new business disappears within a period of time
Breath, respectively service message A, service message B, and according to service logic order, service message A earlier than
Service message B is created, it is clear that the dimension data to be inserted according to service message B record should be reflection
The last state of business.
Then according to the scheme of the application, to be created based on service message A and perform affairs a (comprising above-mentioned three
Individual step, it is assumed that insertion dimension data record 1), to be created for service message B and perform affairs b (
Include above three step, it is assumed that to insert dimension data record 2).Characteristic based on affairs, affairs a
In three steps can perform in sequence, three in affairs b step can also be performed in sequence, simultaneously
Under row scene, the execution sequence of three steps in three steps and affairs b each other in affairs a is then
It is uncertain, but either which kind of execution sequence, when affairs a and affairs b are performed both by completing, dimension
The label information of degrees of data record 2 has been updated to the first value, and dimension data record 1 has been updated to the
Two-value, renewal result now is correct, meets the fact.
It should be noted that each SQL statement of the above is all the SQL used when implementing the scheme of the application
The example of sentence, does not constitute the restriction to the application.In actual applications, for different business, on
The parameter stated in SQL statement may also be different.
The dimension data processing method provided above for the embodiment of the present application, based on same thinking, the application
Embodiment additionally provides another dimension data processing method, as shown in Fig. 2 another dimension data
Processing method is:May out of order and the concurrent scene of possibility complete scheme for tackling service message.
The process of another dimension data processing method that Fig. 2 provides for the embodiment of the present application, the process is held
Row main body can be terminal or server.
Process in Fig. 2 specifically may comprise steps of:
S201:Receive the service message of the state for changing business.
S202:According to the service message, create and perform affairs, wherein, what is included in the affairs is each
Step is (common tri- steps of S202a~S202c) performed in the following order:
S202a:According to the service message, the dimension of state after the change of the business is inserted into tables of data
Degrees of data is recorded, and the dimension data record has corresponding label information, and the tables of data is used to protect
Deposit the dimension data record of each state of the business;
S202b:For each state of the business preserved in the tables of data after insertion dimension data record
Dimension data record, by comprising service message creation time it is newest dimension data record label information
The first value is updated to, first value represents the newest shape of the corresponding dimension data record reflection business
State;
S202c:For each state of the business preserved in the tables of data after insertion dimension data record
Dimension data record, by except comprising service message creation time it is newest dimension data record in addition to
, other dimension datas record label information be updated to second value, the second value represents corresponding dimension
Data record does not reflect the last state of the business.
By the method in Fig. 2, the effect of the method in Fig. 1 can be not only realized, can also be solved in industry
Under the out of order or concurrent scene of message of being engaged in, the problem of may causing to update mistake to label information.
The dimension data processing method provided above for the embodiment of the present application, based on same thinking, the application
Embodiment also provides corresponding dimension data processing unit, as shown in Figure 3, Figure 4.
The dimension data processing device structure diagram corresponding to Fig. 1 that Fig. 3 provides for the embodiment of the present application,
Specifically include:
Receiver module 301, the service message for receiving the state for being used to change business;
Module 302 is changed, for according to the service message, the change of the business to be inserted into tables of data
The dimension data of state is recorded afterwards, and the dimension data record has corresponding label information, the number
It is used for the dimension data record of each state for preserving the business according to table;
Update module 303, for according to the tables of data after insertion dimension data record, to having been protected in tables of data
The label information of the dimension data record of each state for the business deposited is updated;
Wherein, the label information is used to represent whether corresponding dimension data record reflects the business
Last state.
By the device in Fig. 3, in the change procedure of slowly varying dimension, same tables of data not only can be with
Newest dimension data record is preserved, and each history dimension data record can be preserved, so as to solve existing
The problem of in technology.In addition, in the technical scheme of the application, also there is the mark recorded based on dimension data
Remember information, history dimension data record can be distinguished by the label information and newest dimension data is recorded, from
And be conducive to analyzing the change procedure of slowly varying dimension.
Alternatively, the scheduled field that the label information of the dimension data record is recorded by the dimension data
Preserved.
Alternatively, the dimension data record includes customizing messages, and the customizing messages reflects the dimension
Logical order of the corresponding service message of data record in each service message;
Alternatively, the update module 303 specifically for:According to the mark of the business and insertion number of dimensions
According to the tables of data after record, the dimension data note of each state of the business preserved in tables of data is determined
Record;The customizing messages included is recorded according to each dimension data of determination, to the mark of each dimension data record
Note information is updated.
Alternatively, the customizing messages includes service message creation time;
Alternatively, the update module 303 specifically for:Record what is included according to each dimension data of determination
Service message creation time, in each dimension data record, by the dimension that service message creation time is newest
The label information of degrees of data record is updated to the first value, and the label information that other dimension datas are recorded is more
It is newly second value, wherein, first value represents the newest of the corresponding dimension data record reflection business
State, the second value represents that corresponding dimension data record does not reflect the last state of the business.
Alternatively, it is described change module 302 and the update module 303 specifically for:According to the business
Message, is created and performs affairs, and each step included in the affairs is performed in the following order:
The dimension data record of state after the change of the business is inserted into tables of data;
The dimension of each state of the business preserved in tables of data after being recorded for insertion dimension data
Data record, by comprising service message creation time it is newest dimension data record label information be updated to
First value, first value represents that corresponding dimension data records the last state of reflection business;
The dimension of each state of the business preserved in tables of data after being recorded for insertion dimension data
Data record, by except comprising service message creation time it is newest dimension data record in addition to, other
The label information of dimension data record is updated to second value, and the second value represents corresponding dimension data record
The last state of business is not reflected.
By Fig. 3 device, it can also solve under the out of order and/or concurrent scene of service message, may
The problem of causing to update mistake to label information.
Specific above-mentioned device as shown in Figure 3 can be on terminal, server.
The dimension data processing device structure diagram corresponding to Fig. 2 that Fig. 4 provides for the embodiment of the present application,
Specifically include:
Receiver module 401, the service message for receiving the state for being used to change business;
Processing module 402, for according to the service message, creating and performing affairs, wherein, the thing
Each step included in business is performed in the following order:
According to the service message, the dimension data note of state after the change of the business is inserted into tables of data
Record, the dimension data record has corresponding label information, and the tables of data is used to preserve the industry
The dimension data record of each state of business;
The dimension of each state of the business preserved in tables of data after being recorded for insertion dimension data
Data record, by comprising service message creation time it is newest dimension data record label information be updated to
First value, first value represents the last state of the corresponding dimension data record reflection business;
The dimension of each state of the business preserved in tables of data after being recorded for insertion dimension data
Data record, by except comprising service message creation time it is newest dimension data record in addition to, other
The label information of dimension data record is updated to second value, and the second value represents corresponding dimension data record
The last state of the business is not reflected.
Pass through the device in Fig. 4, it is possible to achieve the effect of the device in Fig. 3, mainly solve and disappear in business
Under the out of order and/or concurrent scene of breath, the problem of may causing to update mistake to label information.
Specific above-mentioned device as shown in Figure 4 can be on terminal, server.
It should be understood by those skilled in the art that, embodiments of the invention can be provided as method, system or meter
Calculation machine program product.Therefore, the present invention can be using complete hardware embodiment, complete software embodiment or knot
The form of embodiment in terms of conjunction software and hardware.Wherein wrapped one or more moreover, the present invention can be used
Containing computer usable program code computer-usable storage medium (include but is not limited to magnetic disk storage,
CD-ROM, optical memory etc.) on the form of computer program product implemented.
The present invention is with reference to the production of method according to embodiments of the present invention, equipment (system) and computer program
The flow chart and/or block diagram of product is described.It should be understood that can be realized by computer program instructions flow chart and
/ or each flow and/or square frame in block diagram and the flow in flow chart and/or block diagram and/
Or the combination of square frame.These computer program instructions can be provided to all-purpose computer, special-purpose computer, insertion
Formula processor or the processor of other programmable data processing devices are to produce a machine so that pass through and calculate
The instruction of the computing device of machine or other programmable data processing devices is produced for realizing in flow chart one
The device for the function of being specified in individual flow or multiple flows and/or one square frame of block diagram or multiple square frames.
These computer program instructions, which may be alternatively stored in, can guide computer or the processing of other programmable datas to set
In the standby computer-readable memory worked in a specific way so that be stored in the computer-readable memory
Instruction produce include the manufacture of command device, the command device realization in one flow or multiple of flow chart
The function of being specified in one square frame of flow and/or block diagram or multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing devices, made
Obtain and perform series of operation steps on computer or other programmable devices to produce computer implemented place
Reason, so that the instruction performed on computer or other programmable devices is provided for realizing in flow chart one
The step of function of being specified in flow or multiple flows and/or one square frame of block diagram or multiple square frames.
In a typical configuration, computing device includes one or more processors (CPU), input/defeated
Outgoing interface, network interface and internal memory.
Internal memory potentially includes the volatile memory in computer-readable medium, random access memory
And/or the form, such as read-only storage (ROM) or flash memory (flash such as Nonvolatile memory (RAM)
RAM).Internal memory is the example of computer-readable medium.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by appointing
What method or technique realizes information Store.Information can be computer-readable instruction, data structure, program
Module or other data.The example of the storage medium of computer includes, but are not limited to phase transition internal memory
(PRAM), static RAM (SRAM), dynamic random access memory (DRAM), its
The random access memory (RAM) of his type, read-only storage (ROM), electrically erasable are read-only
Memory (EEPROM), fast flash memory bank or other memory techniques, read-only optical disc read-only storage
(CD-ROM), digital versatile disc (DVD) or other optical storages, magnetic cassette tape, tape magnetic
Disk storage or other magnetic storage apparatus or any other non-transmission medium, can be calculated available for storage
The information that equipment is accessed.Defined according to herein, computer-readable medium does not include temporary computer-readable matchmaker
The data-signal and carrier wave of body (transitory media), such as modulation.
It should also be noted that, term " comprising ", "comprising" or its any other variant be intended to it is non-
It is exclusive to include, so that process, method, commodity or equipment including a series of key elements are not only wrapped
Include those key elements, but also other key elements including being not expressly set out, or also include for this process,
Method, commodity or the intrinsic key element of equipment.In the absence of more restrictions, by sentence " including
One ... " key element that limits, it is not excluded that in the process including the key element, method, commodity or set
Also there is other identical element in standby.
Embodiments herein is the foregoing is only, the application is not limited to.For this area skill
For art personnel, the application can have various modifications and variations.All institutes within spirit herein and principle
Any modifications, equivalent substitutions and improvements of work etc., should be included within the scope of claims hereof.