CN108228736A - Data processing method, data processing system and computer readable storage medium - Google Patents
Data processing method, data processing system and computer readable storage medium Download PDFInfo
- Publication number
- CN108228736A CN108228736A CN201711326926.XA CN201711326926A CN108228736A CN 108228736 A CN108228736 A CN 108228736A CN 201711326926 A CN201711326926 A CN 201711326926A CN 108228736 A CN108228736 A CN 108228736A
- Authority
- CN
- China
- Prior art keywords
- data
- transformation rule
- screening conditions
- pending
- data processing
- 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/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a kind of data processing method, data processing system and computer readable storage mediums.Wherein, method includes：Obtain the pending data in data processing system, and it obtains to carry out the target transformation rule set of data processing, the target transformation rule set includes the first transformation rule, first transformation rule is associated with the first screening conditions set, and at least one screening conditions are included in the first screening conditions set.Judge whether the pending data meets the screening conditions in the first screening conditions set.If satisfied, the pending data is then converted by target data using first transformation rule.The embodiment of the present invention can be by obtaining untreated data, and the Credential data that untreated data conversion can be identified into EPR systems, so as to improve the accuracy of transformed data automatically.
Description
Technical field
It can the present invention relates to field of computer technology more particularly to data processing method, data processing system and computer
Read storage medium.
Background technology
ERP system is the abbreviation of Enterprise Resources Plan (Enterprise Resource Planning), and EPR systems include
：Multiple modules such as accounting, financial management, logistics management, purchasing management, for improving business events flow path, improving and look forward to
Industry core competitiveness has remarkable effect, therefore each large enterprises can all select ERP system to handle related data.If each large enterprises
Want with ERP system come when handling the related data, it is necessary to the related data be first converted into the voucher that ERP system can identify
After data, then it is passed to the EPR systems and is handled.For example, every the end of month, the Finance Department of major enterprise-like corporation all can be to finance
Data are settled accounts.And financial staff can first find out the systematic initial data of institute of company in settlement process, then
Untreated data are found from these initial data, and these untreated data conversions can be identified into EPR systems
After Credential data, then it is passed to the EPR systems.But when financial data amount is bigger, business personnel may not locate searching
During the data of reason or during change data, some untreated data are missed, so as to it can reduce conversion after
Data accuracy.
Invention content
An embodiment of the present invention provides a kind of data processing method, data processing system and computer readable storage medium,
Untreated data, and the Credential data that untreated data conversion can be identified into EPR systems can be obtained automatically, improved
The accuracy of transformed data.
In a first aspect, an embodiment of the present invention provides a kind of data processing method, this method includes：Obtain data processing system
Pending data in system and obtain target transformation rule set for carrying out data processing.The target transformation rule collection
Conjunction includes the first transformation rule, first transformation rule the first screening conditions set of association, in the first screening conditions set
Include at least one screening conditions.Judge whether the pending data meets the screening conditions in the first screening conditions set.
If satisfied, the pending data is then converted by target data using first transformation rule.
Optionally, the specific embodiment of the pending data in the acquisition data processing system is：It obtains at the data
The processing state of all data and data in reason system.Data of the processing state for untreated state are determined as pending number
According to.
Optionally, the specific embodiment for the data that processing state is untreated state being determined as to pending data is：
Obtain batch number of the processing state for the data of untreated state.It is untreated state to the processing state according to the batch number
Data are classified, and obtain at least one lot data set, and the batch number of the data in same lot data set is identical.From
The data in any one or more lot data set are chosen at least one lot data set as pending data.
Optionally, the number in any one or more lot data set is chosen from least one lot data set
It is according to the specific embodiment as pending data：It is chosen from least one lot data set any one or more
Lot data set.Whether the content for verifying the data in selected lot data set respectively is complete.The institute that will be included
There are the data in the complete lot data set of content of data to be determined as pending data.
Optionally, this method further includes：It is defeated when the content of the data in the selected lot data set is imperfect
Go out the first prompt message.When the pending data is converted into target data failure using first transformation rule, output the
Two prompt messages.
Optionally, the specific embodiment of target transformation rule set of the acquisition for carrying out data processing is:It obtains
The priority of at least one of data processing system transformation rule set and each transformation rule set.Choose priority
Highest first transformation rule set is as target transformation rule set.
Optionally, this method further includes：If not satisfied, it is then selected according to the priority of at least one transformation rule set
The second transformation rule set is taken as the target transformation rule set, which is at least one conversion rule
Then gather in addition to the first transformation rule set highest priority transformation rule set.
Optionally, the second transformation rule is further included in the target transformation rule set, second transformation rule association second
Screening conditions set includes at least one screening conditions in the second screening conditions set.Corresponding, this method further includes：If
The pending data is unsatisfactory for the screening conditions in the first screening conditions set, then judges whether the pending data meets this
Screening conditions in second screening conditions set.If the pending data meets the screening item in the second screening conditions set
The pending data is then converted into the target data by part using second transformation rule.
Optionally, this method further includes：Establishment instruction according to receiving creates transformation rule set and screening conditions collection
It closes.Addition instruction according to receiving is at least one transformation rule of transformation rule set addition and is the screening conditions
Set adds at least one screening conditions.According to the associated instructions received by the screening conditions set and at least one conversion
Rule is associated storage.
Second aspect, an embodiment of the present invention provides a kind of data processing system, which includes：It obtains single
Member converts rule available for obtaining the pending data in data processing system and obtaining for carrying out the target of data processing
Then gather.The target transformation rule set includes the first transformation rule, which is associated with the first screening conditions collection
It closes, at least one screening conditions is included in the first screening conditions set.Judging unit, available for judging that the pending data is
The no screening conditions met in the first screening conditions set.Converting unit, available for if satisfied, then using the first conversion rule
The pending data is then converted into target data.
Optionally, which is particularly used in：Obtain the place of all data and data in the data processing system
Reason state.Data of the processing state for untreated state are determined as pending data.
Optionally, which is particularly used in：Obtain batch number of the processing state for the data of untreated state.Root
Classify according to the batch number to data of the processing state for untreated state, obtain at least one lot data set, together
The batch number of data in one lot data set is identical.Chosen from least one lot data set any one or it is more
Data in a lot data set are as pending data.
Optionally, which is particularly used in：Chosen from least one lot data set any one or
Multiple lot data set.Whether the content for verifying the data in selected lot data set respectively is complete.It will be included
All data the complete lot data set of content in data be determined as pending data.
Optionally, which further includes output unit.The output unit can be used for when the selected batch
When the content of data in data acquisition system is imperfect, the first prompt message is exported；This is waited to locate when using first transformation rule
Reason data conversion into target data fail when, output the second prompt message.
Optionally, which is particularly used in：Obtain at least one of data processing system transformation rule collection
Conjunction and the priority of each transformation rule set.The the first transformation rule set for choosing highest priority converts rule as target
Then gather.
Optionally, which is particularly used in：If not satisfied, then according to the excellent of at least one transformation rule set
First grade chooses the second transformation rule set as the target transformation rule set, the second transformation rule set be this at least one
In a transformation rule set in addition to the first transformation rule set highest priority transformation rule set.
Optionally, the second transformation rule is further included in the target transformation rule set, second transformation rule association second
Screening conditions set includes at least one screening conditions in the second screening conditions set.Corresponding, which also can be used
In：If the pending data is unsatisfactory for the screening conditions in the first screening conditions set, whether the pending data is judged
Meet the screening conditions in the second screening conditions set.The converting unit can be additionally used in：If the pending data meet this
The pending data is then converted into the number of targets by the screening conditions in two screening conditions set using second transformation rule
According to.
Optionally, which further includes creating unit.The creating unit can be used for according to the establishment received
Instruction creates transformation rule set and screening conditions set.Addition instruction according to receiving is added to for the transformation rule set
Lack a transformation rule and add at least one screening conditions for the screening conditions set.According to the associated instructions received
The screening conditions set and at least one transformation rule are associated storage.
The third aspect, an embodiment of the present invention provides a kind of computer readable storage medium, which deposits
Computer program is contained, which includes program instruction, which makes the processor when being executed by a processor
The method for performing above-mentioned first aspect.
The embodiment of the present invention can first obtain the pending data in data processing system and obtain to carry out automatically
The target transformation rule set of data processing.Wherein, which includes the first transformation rule, this first turn
Rule association the first screening conditions set is changed, at least one screening conditions are included in the first screening conditions set.Then judge
Whether the pending data meets the screening conditions in the first screening conditions set.If satisfied, then using the first conversion rule
The pending data is then converted into target data.The embodiment of the present invention can be by obtaining untreated data automatically, and incites somebody to action
The Credential data that untreated data conversion can be identified into EPR systems, so as to improve the accuracy of transformed data.
Description of the drawings
To describe the technical solutions in the embodiments of the present invention more clearly, institute in being described below to the embodiment of the present invention
Attached drawing to be used is needed to be briefly described, it should be apparent that, the accompanying drawings in the following description is only some implementations of the application
Example, for this technology personnel, without creative efforts, acceptable content according to embodiments of the present invention
Other attached drawings are obtained with these attached drawings.
Fig. 1 is a kind of schematic flow diagram of data processing method provided in an embodiment of the present invention；
Fig. 2 is a kind of schematic flow diagram for data processing method that another embodiment of the present invention provides；
Fig. 3 is a kind of schematic flow diagram for data verification method that another embodiment of the present invention provides；
Fig. 4 is a kind of structure diagram of data processing system provided in an embodiment of the present invention.
Specific embodiment
Below in conjunction with the attached drawing in the embodiment of the present invention, the technical solution in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is part of the embodiment of the present invention, instead of all the embodiments.Based on this hair
Embodiment in bright, the every other implementation that those of ordinary skill in the art are obtained without making creative work
Example, shall fall within the protection scope of the present invention.
Fig. 1 is referred to, is a kind of schematic flow diagram of data processing method provided in an embodiment of the present invention.As shown in Figure 1
Data processing method may include：
S101 obtains the pending data in data processing system and acquisition and turns for carrying out the target of data processing
Change regular collection.
Wherein, which includes the first transformation rule, the first screening of first transformation rule association
Set of circumstances includes at least one screening conditions in the first screening conditions set.
Specifically, when obtaining the pending data in data processing system, can first obtain in the data processing system
The processing state of all data and data.Then data of the processing state for untreated state are determined as pending data.
The data processing system can be single data system, only store the data of a certain classification.It can also be composite number
According to system, a variety of different classes of data can be stored, certain data processing system, which can also be, does not store data, only carries out
The system for handling data function.If for example, the data processing system is single data system, which can be
Refer to purchasing system, reimbursement system or balance system.If the data processing system is purchasing system, the data processing system is only
Store procurement data.If the data processing system is reimbursement system, which only stores reimbursement data, with such
It pushes away.If the data processing system is complex data system, which can be divided into multiple subsystems, can wrap
Include purchase subsystem, reimbursement subsystem and debt-credit subsystem, and can respectively the purchase subsystem, reimbursement subsystem and
Corresponding data are stored in debt-credit subsystem.In addition to this, which, which can also be, only carries out processing data function
System, when needing to carry out data processing, the data processing system just from purchasing system, submit an expense account in system and balance system
It goes to extract the data in each system, so as to carry out data processing.And can will treated data feed back to respectively purchasing system,
Reimbursement system and balance system, for each system, by treated accordingly, data store.
Before data processing is carried out, which can also create a series of regular item according to operational order
Part.If the data processing system is single data system or the system for only carrying out processing data function, the data processing system
System can create transformation rule set and screening conditions set according to the establishment instruction received.It is instructed according to the addition received
For at least one transformation rule of transformation rule set addition and it is that the screening conditions set adds at least one screening item
Part.The screening conditions set and at least one transformation rule are associated storage according to the associated instructions received.It if should
Data processing system is complex data system, then the data processing system first can create instruction according to subsystem and create at least one
A subsystem.Then according to the establishment instruction received be respectively at least one subsystem create transformation rule set and
Screening conditions set.At least one transformation rule is added for the transformation rule set then according to the addition instruction received, with
And add at least one screening conditions for the screening conditions set.Finally according to associated instructions by the screening conditions set and this extremely
A few transformation rule is associated.It can be seen that each transformation rule and screening conditions in the data processing system
All can dynamically add, i.e., the data processing system be one be completely independent, flexibly free system.User can basis
The demand of data converted per a kind of needs carrys out manual add-on system, and adds corresponding transformation rule for each system.System
System can carry out matching check and correction to data automatically according to these transformation rules, not need to after these transformation rules are created
The matching for carrying out each rule according to all data is gone to proofread again, manpower can be greatlyd save, promotes the verification speed to data
Degree so as to save the time needed for data processing, reduces the error rate of artificial nucleus couple.
S102, data processing system judge whether the pending data meets the screening item in the first screening conditions set
Part.
Specifically, the first screening conditions set can include one or more of screening conditions.Judging that this is pending
When whether data meet the screening conditions in the first screening conditions set, if the first screening conditions set only includes a bar grizzl(e)y
Condition is selected, then can directly judge whether the pending data meets this screening conditions.If satisfied, it can then perform step
S103.If not satisfied, then terminate the process of entire data processing.If the first screening conditions set includes at least two screenings
Condition then needs to judge all the screening conditions whether pending data meets in the first screening conditions set successively.Only
When the pending data meets all screening conditions in the first screening conditions set, step S103 can be just performed, it is no
Then just terminate the process of entire data processing.
For example, include two screening conditions in the first screening conditions set.Wherein, first screening conditions is
The date transfer items to be of that month, Article 2 screening conditions are that guarantee side is company A.The pending data that data processing system is got
Partial information can be as shown in table 1.
Table 1
| Sequence number | Guarantee side | It transfers items the date | Processing state |
| 1 | Company A | 2017.10.05 | It is untreated |
| 2 | Company A | 2017.11.07 | It is untreated |
| 3 | B companies | 2017.11.25 | It is untreated |
As shown in Table 1, the pending data that data processing system is got has 3.Data processing system is judging to wait to locate
When whether reason data meet this two screening conditions, the of that month time can be first got as in November, 2017, then judge to treat
The date is transferred items whether between 2017.11.01~2017.11.30 and whether guarantee side is company A in processing data.Through
Judge, it may be determined that all screening conditions in pending data the first screening conditions set of satisfaction of Serial No. 2, and sequence
Number only meet wherein screening conditions in the first screening conditions set for 1 and 3 pending data.Therefore in step
In S103, the pending data of the Serial No. 2 is only converted by target data using the first transformation rule
It should be noted that above only illustrate, it is not exhaustive.
S103, if satisfied, then pending data is converted into number of targets by data processing system using first transformation rule
According to.
Specifically, can include needing the field information converted in pending data in first transformation rule, if satisfied,
The field information then converted according to the needs, by mapping, being worth the modes such as collection, to the field that needs to convert in pending data into
Row conversion.Data processing system collects by mapping, being worth when modes carry out data conversion, can be by searching for preset mapping
Relation pair answers table or preset value to collect information table to carry out data conversion.For example, the first transformation rule for " accounts receivable-loan-
Capital ", then data processing system when pending data is converted into target data, just only need will in pending data " should
The content of these three fields of receipt on account money, loan and capital " is corresponded to as data content to be converted, and in preset mapping relations
The corresponding information of these three field contents is searched in table or preset value collection information table, so as to fulfill the conversion of data, to obtain
Target data.
It should be noted that data conversion only citing is carried out by mapping, being worth the modes such as collection mentioned by above-mentioned, not
It is exhaustive.
It should also be noted that, the transformation rule in the target transformation rule set can be with more than one.When the target turns
When changing regular collection and including at least two transformation rules, which may be used the judgment mode of traversal to judge
Whether the pending data meets in the screening set associated by any one transformation rule in the target transformation rule set
Screening conditions.If detecting, the pending data meets the screening in the screening conditions set associated by a certain transformation rule
During condition, then pending data is converted by target data using this transformation rule.If detect the pending data not
Meet the screening conditions in the screening conditions set associated by all transformation rules in target conversion set, then terminate at data
The process of reason does not carry out conversion process to the pending data.For example, the can also be included in the target transformation rule set
Two transformation rules, second transformation rule are associated with the second screening conditions set, at least one are included in the second screening conditions set
A screening conditions.If the pending data is unsatisfactory for the screening conditions in the first screening conditions set, judge that this is pending
Whether data meet the screening conditions in the second screening conditions set.If the pending data meets the second screening conditions collection
The pending data is then converted into the target data by the screening conditions in conjunction using second transformation rule.If this is pending
Data are also unsatisfactory for the screening conditions in the second screening conditions set, then terminate the process of data processing.
The embodiment of the present invention is by obtaining the pending data in data processing system and obtaining to carry out at data
The target transformation rule set of reason.Then judge whether the pending data meets first screening conditions by data processing system
Screening conditions in set.If satisfied, then pending data is converted into mesh by data processing system using first transformation rule
Mark data.The embodiment of the present invention can be by obtaining untreated data, and by untreated data conversion into EPR systems automatically
The Credential data that can be identified, so as to improve the accuracy of transformed data.
Fig. 2 is referred to, is a kind of schematic flow diagram for data processing method that another embodiment of the present invention provides.Such as Fig. 2
Shown data processing method may include：
S201, data processing system obtain batch number of the processing state for the data of untreated state.
S202, data processing system classify to data of the processing state for untreated state according to the batch number,
Obtain at least one lot data set.
Wherein, the batch number of the data in same lot data set is identical.
It should be noted that the embodiment of the present invention divides data of the processing state for untreated state according to batch number
It is that the identical data of batch number are grouped into same lot data set during class.Of course it should be understood that the present invention is implemented
Example can also classify data of the processing state for untreated state according to the setting information of user.For example, user can
The data of several batches are grouped into same lot data set with setting.For example, user can be set every 3 batches
Secondary data are classified as in same lot data set.Data processing system is obtaining the number that processing state is untreated state
According to batch number for " after 001,005,009,006,002,004 ", can these batch numbers be first subjected to arrangement from small to large,
I.e. " 001,002,004,005,006,009 ".Then three batch numbers are taken according to this sequence, every time, and by taking-up this three
Data corresponding to a batch number are grouped into same lot data set.I.e. by aforesaid operations, two may finally be obtained
Lot data set, a lot data set include batch number for " 001,002,004 " all processing states is do not locate
The data of reason state, another lot data set then include batch number for " 005,006,009 " all processing states are
The data of untreated state.It should be noted that these batch numbers can also be carried out row from big to small by data processing system
Row or other arrangement modes.It should also be understood that data processing system classifies to obtain at least one lot data in progress data
During set, it can not also be classified according to the batch number of data, you can to take other mode classifications.Therefore, above-mentioned
It is citing, it is not exhaustive.
S203, data processing system choose any one or more lot datas from least one lot data set
Set.
Whether S204, the content that data processing system verifies the data in selected lot data set respectively are complete.
Specifically, when whether the content of the data in the selected lot data set of verification complete, it can be according to this
Transformation rule in data processing system is verified.The field information converted due to including needs in transformation rule, because
This can need the field contents converted to be in checking procedure by detecting in the data in selected lot data set
No is empty.If there are one the field contents converted is needed to illustrate that the content of the data is imperfect for sky in data.If in data
It is not all sky to need the field contents converted, then illustrates the content intact of the data.For example, transformation rule is " answers receipt on account
Money-loan-capital " illustrates that the field that needs are converted is " accounts receivable, loan and capital " these three fields, then require
The content of these three fields of the data in selected lot data set cannot be sky.Data processing system verifies institute respectively
When whether the data in the lot data set of selection complete, the mode of traversal may be used to be verified, verification it is specific
Flow may refer to flow chart shown in Fig. 3.As shown in figure 3, the data verification method can include：S301, data processing system
System obtains the data in some lot data set.S302, data processing system carry out parallel processing.Wherein, the parallel place
Reason refers to transformation rule all in data processing system acquisition system.S303, this selected batch of data processing system verification
Whether the content of the data in secondary data acquisition system is complete.If complete, step S304 is performed.If imperfect, return to step
S301 continues to obtain the data in some lot data set in remaining lot data set.S304, data processing system
Using the data in the lot data set as pending data.
It should be noted that the whether complete mode of the content of verification data is not limited only to carry out school according to transformation rule
Test, more than only illustrate, it is not exhaustive.
S205, data processing system is by the data in the complete lot data set of the content of all data included
It is determined as pending data.
Specifically, when the data that data processing system is chosen in a certain lot data set are verified, can incite somebody to action
All data in the lot data set are all verified.Only when the content of all data in the lot data set is equal
Be it is complete, just can be using the data in the lot data set as pending data.If have in the lot data set a certain
The content of data is not complete, then to all data processing without conversion in the lot data set.
In addition to this, when the content of the data in the selected lot data set is imperfect, data processing system
The first prompt message can be exported.
Specifically, the data processing system is when exporting the first prompt message, it can be by being popped up at data processing interface
The form of prompt window come prompt user or by incomplete data content portion mark it is red to prompt user.For example, turn
Rule is changed as " accounts receivable-loan-capital ", and data processing system verification to " capital " in the data of serial number 1102 this
The content of field is sky, then can pop up prompt window user to be prompted to check the data, the content of display window can
To be " data content of serial number 1102 is imperfect, and the content of capital field missing please be checked ".Certainly, data processing system
System can also be directly red by the capital field portions mark of the data of serial number 1102 or whole data mark is red, to prompt user
The content of the data is imperfect.It should be noted that output the first prompt message mode can there are many kinds of, here only lift
Example, it is not exhaustive.
It should also be noted that, the embodiment of the present invention is the complete lot data of the content of all data that will be included
Data in set are determined as pending data.In addition to this, in other inventive embodiments, data processing system can also be
Verify in some lot data set only have several datas content it is imperfect when, by this incomplete several
Data, which individually mark out, to be come, then using remaining data in the lot data set as pending data.
S206, data processing system obtain at least one of data processing system transformation rule set and each turn
Change the priority of regular collection.
S207, data processing system choose target transformation rule according to the priority of at least one transformation rule set
Set.
Wherein, which includes the first transformation rule, the first screening of first transformation rule association
Set of circumstances includes at least one screening conditions in the first screening conditions set.
Specifically, according to the priority of at least one transformation rule set come when choosing target transformation rule set, it is first
The first transformation rule set of highest priority is first chosen as target transformation rule set.It is preferential due to transformation rule set
Grade is that user is set according to actual needs, it can be said that the data corresponding to the higher transformation rule set of bright priority
It is more important.Therefore first will first meet using the first transformation rule set of highest priority as target transformation rule set
The pending data of the screening conditions in the screening conditions set associated by transformation rule in the first transformation rule set into
Row conversion process can preferably meet the actual demand of client.
It should be noted that step S206~S207 and step S201~S205 has no sequencing, you can first to determine
Pending data, then determine target transformation rule set.It can also first determine target transformation rule set, then determine pending number
According to.The action of determining pending data and target transformation rule set can also be carried out at the same time, be not limited thereto.
S208, data processing system judge whether the pending data meets the screening item in the first screening conditions set
Part.
It should be noted that the embodiment of the present invention can take the judgment mode of traversal.It it is found that first will be excellent by step S207
The first highest first transformation rule set of grade is as target transformation rule set.Corresponding, the first transformation rule is the first conversion
Arbitrary transformation rule in regular collection.If pending data meets associated by the transformation rule in the first transformation rule set
The screening conditions of each screening conditions set, then perform step S209.If pending data is unsatisfactory for the first transformation rule set
In transformation rule associated by each screening conditions set screening conditions, then perform step S207 again, it is at least one according to this
The priority of transformation rule set chooses target transformation rule set, i.e., is converted the second transformation rule set as the target
Regular collection.Wherein, which is that the first transformation rule collection is removed at least one transformation rule set
The transformation rule set of highest priority other than conjunction.Corresponding, the first transformation rule is arbitrary in the second transformation rule set
Transformation rule.If the pending data is unsatisfactory for each screening conditions associated by the transformation rule in the second transformation rule set
The screening conditions of set then perform step S207, target are chosen according to the priority of at least one transformation rule set again
Transformation rule set, i.e., using third transformation rule set as the target transformation rule set.Wherein, the third transformation rule collection
Conjunction be at least one transformation rule set in addition to the first transformation rule set and the second transformation rule set priority
Highest transformation rule set.And so on, if after having traversed all transformation rule set in the data processing system, detection
Screening in the screening conditions set associated by transformation rule being unsatisfactory in all transformation rule set to the pending data
Condition fails it may be considered that the pending data is converted into target data by the data processing system.When using this first turn
Change rule by the pending data be converted into target data failure when, data processing system can export the second prompt message.Tool
Body, the operation principle for exporting the second prompt message is similar with the operation principle of the first prompt message of output in step S205.
Therefore, details are not described herein.
S209, if satisfied, then the pending data is converted into target by data processing system using first transformation rule
Data.
It should be noted that the step S209 in the embodiment of the present invention may refer to the step in foregoing invention embodiment
S103, the embodiment of the present invention repeat no more.
It should also be noted that, the data processing system can also have the function of pattern conversion, i.e. the data processing system
System can be divided into manual mode and automatic mode.When the data processing system is under automatic mode, can be set according to user
Automatic translation time for putting is automatic to obtain data, and performs and the data of acquisition are verified, judges and conversion process etc.
A series of actions.Data processing system can also be turned operating mode by automatic mode after mode switch instruction is received
Change manual mode into.The convenient of system automation can be both let user experiencing in this way, user can also be facilitated to be switched at any time
Manual mode, to check the data in certain lot data set.Also, for data conversion treatment each time, no
It manages final result to be success or failure, data processing system can export prompt message user to be prompted to check data
Handling result.For example, data processing system can be informed data processed result to user by sending out the form of mail, so as to
User can be handled accordingly according to the data processed result in time.For example, if data conversion success, can pass through hair
Mail is to inform that user in time summarizes transformed data, summarizing for voucher detailed data to accomplish fluently solid data base
Plinth.If data conversion fails, it can inform that user checks the letters such as data content and transformation rule in time by sending out mail
Whether wrong content is ceased, so as to which the data of convert failed early are carried out conversion process again.
The embodiment of the present invention first obtains the batch number for the data that processing state is untreated state, and according to the batch number pair
The processing state is classified for the data of untreated state, obtains at least one lot data set.Then from this at least one
Any one or more lot data set are chosen in a lot data set, and verify selected lot data set respectively
In data content it is whether complete.Then by the number in the complete lot data set of the content of all data included
According to being determined as pending data.Obtain at least one of data processing system transformation rule set and each transformation rule
The priority of set, and target transformation rule set is chosen according to the priority of at least one transformation rule set.Then
Judge whether the pending data meets the screening conditions in the first screening conditions set.If satisfied, then data processing system
The pending data is converted by target data using first transformation rule.It can be seen that notebook data processing system be according to
User develops the thinking of verification of data and processing, design comparison hommization.It can make user in this way to the number
It is easier to understand according to the operation of processing system, so as to reduce the maloperation to the data processing system.
Fig. 4 is referred to, is a kind of structure diagram of data processing system provided in an embodiment of the present invention.As shown in figure 4,
The data processing system includes：
Acquiring unit 401, available for obtaining the pending data in data processing system and obtaining to carry out data
The target transformation rule set of processing.The target transformation rule set includes the first transformation rule, which closes
Join the first screening conditions set, at least one screening conditions are included in the first screening conditions set.
Judging unit 402, available for judging whether the pending data meets the screening in the first screening conditions set
Condition.
Converting unit 403, available for if satisfied, the pending data then is converted into target using first transformation rule
Data.
Optionally, which is particularly used in：Obtain all data in the data processing system and data
Processing state.Data of the processing state for untreated state are determined as pending data.
Optionally, which is particularly used in：Obtain batch of the processing state for the data of untreated state
Number.Classified according to the batch number to data of the processing state for untreated state, obtain at least one lot data collection
It closes, the batch number of the data in same lot data set is identical.It is chosen from least one lot data set any one
Data in a or multiple lot data set are as pending data.
Optionally, which is particularly used in：Any one is chosen from least one lot data set
Or multiple lot data set.Whether the content for verifying the data in selected lot data set respectively is complete.It will be wrapped
Data in the complete lot data set of the content of all data contained are determined as pending data.
Optionally, which further includes output unit 404.The output unit 404 can be used for when this is selected
Lot data set in data content it is imperfect when, export the first prompt message.The output unit 404 can also be used to work as
When the pending data being converted into target data failure using first transformation rule, the second prompt message is exported.
Optionally, which is particularly used in：Obtain at least one of data processing system transformation rule
The priority of set and each transformation rule set.The the first transformation rule set for choosing highest priority is converted as target
Regular collection.
Optionally, which is particularly used in：If not satisfied, then according at least one transformation rule set
Priority choose the second transformation rule set as the target transformation rule set, the second transformation rule set be this extremely
Lack the transformation rule set of the highest priority in addition to the first transformation rule set in a transformation rule set.
Optionally, the second transformation rule is further included in the target transformation rule set, second transformation rule association second
Screening conditions set includes at least one screening conditions in the second screening conditions set.Corresponding, the judging unit 402 is also
It can be used for：If the pending data is unsatisfactory for the screening conditions in the first screening conditions set, the pending data is judged
Whether screening conditions in the second screening conditions set are met.The converting unit 403 can be additionally used in：If the pending data expires
Screening conditions in foot the second screening conditions set, then be converted into the mesh using second transformation rule by the pending data
Mark data.
Optionally, which further includes creating unit 405.The creating unit 405 can be used for basis to receive
Establishment instruction create transformation rule set and screening conditions set.Addition instruction according to receiving is the transformation rule set
It adds at least one transformation rule and adds at least one screening conditions for the screening conditions set.According to the pass received
The screening conditions set and at least one transformation rule are associated storage by connection instruction.
In embodiments of the present invention, data processing system first passes through acquiring unit 401 to obtain in data processing system
It pending data and obtains to carry out the target transformation rule set of data processing.Then sentenced by judging unit 402
Whether the pending data of breaking meets the screening conditions in the first screening conditions set.If satisfied, then pass through converting unit 403
To use first transformation rule that the pending data is converted into target data.It can be seen that the data processing system can be with
By obtaining untreated data, and the Credential data that untreated data conversion can be identified into EPR systems automatically, so as to
Improve the accuracy of transformed data.
A kind of computer readable storage medium is additionally provided in another embodiment of the invention, the computer-readable storage
Media storage has computer program, which includes program instruction, this is realized when which is executed by processor
The described data school of realization method and Fig. 3 of Fig. 1 and the described data processing methods of Fig. 2 that inventive embodiments provide
The realization method of proved recipe method.The process when program instruction is executed by processor can refer to the correspondence in preceding method embodiment
Process, details are not described herein.
One of ordinary skill in the art will appreciate that realizing all or part of flow in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, which can be stored in a computer read/write memory medium,
The program is when being executed, it may include such as the flow of the embodiment of above-mentioned each method.
Above disclosed is only the section Example of the present invention, cannot limit the right of the present invention with this certainly
Range, one of ordinary skill in the art will appreciate that realizing all or part of flow of above-described embodiment, and according to right of the present invention
It is required that the equivalent variations made, still fall within and invent covered range.
Claims (10)
1. a kind of data processing method, which is characterized in that including：
The pending data in data processing system and acquisition are obtained for carrying out the target transformation rule collection of data processing
It closes, the target transformation rule set includes the first transformation rule, and first transformation rule is associated with the first screening conditions collection
It closes, at least one screening conditions is included in the first screening conditions set；
Judge whether the pending data meets the screening conditions in the first screening conditions set；
If satisfied, the pending data is then converted by target data using first transformation rule.
2. according to the method described in claim 1, it is characterized in that, it is described obtain data processing system in pending data,
Including：
Obtain the processing state of all data and data in the data processing system；
Data of the processing state for untreated state are determined as pending data.
3. according to the method described in claim 2, it is characterized in that, described determine data of the processing state for untreated state
For pending data, including：
Obtain batch number of the processing state for the data of untreated state；
Classified according to the batch number to data of the processing state for untreated state, obtain at least one batch number
According to set, the batch number of the data in same lot data set is identical；
The conduct of the data in any one or more lot data set is chosen from least one lot data set to treat
Handle data.
4. according to the method described in claim 3, it is characterized in that, described choose from least one lot data set
Data in any one or more lot data set as pending data, including：
Any one or more lot data set are chosen from least one lot data set；
Whether the content for verifying the data in selected lot data set respectively is complete；
Data in the complete lot data set of the content of all data included are determined as pending data.
5. according to the method described in claim 4, it is characterized in that, the method further includes：
When the content of the data in the selected lot data set is imperfect, the first prompt message is exported；
When the pending data is converted into target data failure using first transformation rule, output the second prompting letter
Breath.
6. according to the method described in claim 1, it is characterized in that, the acquisition converts rule for carrying out the target of data processing
Then gather, including:
Obtain the priority of at least one of described data processing system transformation rule set and each transformation rule set；
The first transformation rule set of highest priority is chosen as target transformation rule set.
7. according to the method described in claim 6, it is characterized in that, the method further includes：
If not satisfied, the second transformation rule set conduct is then chosen according to the priority of at least one transformation rule set
The target transformation rule set, the second transformation rule set are except described at least one transformation rule set
The transformation rule set of highest priority other than one transformation rule set.
8. according to the method described in claim 1, it is characterized in that, further include the second conversion in the target transformation rule set
Rule, second transformation rule are associated with the second screening conditions set, are included in the second screening conditions set at least one
Screening conditions；
The method further includes：
If the pending data is unsatisfactory for the screening conditions in the first screening conditions set, the pending number is judged
According to whether meeting screening conditions in the second screening conditions set；
If the pending data meets the screening conditions in the second screening conditions set, advised using the described second conversion
The pending data is then converted into the target data.
9. a kind of data processing system, which is characterized in that performed including being used for such as claim 1~8 any one claim
The unit of the method.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, the calculating
Machine program includes program instruction, and described program instruction makes the processor perform such as claim 1~8 when being executed by a processor
Data processing method described in any one.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711326926.XA CN108228736A (en) | 2017-12-12 | 2017-12-12 | Data processing method, data processing system and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711326926.XA CN108228736A (en) | 2017-12-12 | 2017-12-12 | Data processing method, data processing system and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108228736A true CN108228736A (en) | 2018-06-29 |
Family
ID=62649512
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711326926.XA Pending CN108228736A (en) | 2017-12-12 | 2017-12-12 | Data processing method, data processing system and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108228736A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108961026A (en) * | 2018-07-04 | 2018-12-07 | 中国建设银行股份有限公司 | Account calculates processing method, device and electronic equipment |
| CN109344170A (en) * | 2018-09-04 | 2019-02-15 | 阿里巴巴集团控股有限公司 | Stream data processing method, system, electronic equipment and readable storage medium storing program for executing |
| CN109597826A (en) * | 2018-09-04 | 2019-04-09 | 阿里巴巴集团控股有限公司 | Data processing method, device, electronic equipment and computer readable storage medium |
| CN109658043A (en) * | 2018-10-16 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Collection data processing method, device, equipment and storage medium |
| CN112258690A (en) * | 2020-10-23 | 2021-01-22 | 中车青岛四方机车车辆股份有限公司 | Data access method and device and data storage method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070150447A1 (en) * | 2005-12-23 | 2007-06-28 | Anish Shah | Techniques for generic data extraction |
| CN102567297A (en) * | 2011-12-28 | 2012-07-11 | 用友软件股份有限公司 | Data conversion device and data conversion method |
| CN105808375A (en) * | 2014-12-31 | 2016-07-27 | 航天信息软件技术有限公司 | Data import method and device |
-
2017
- 2017-12-12 CN CN201711326926.XA patent/CN108228736A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070150447A1 (en) * | 2005-12-23 | 2007-06-28 | Anish Shah | Techniques for generic data extraction |
| CN102567297A (en) * | 2011-12-28 | 2012-07-11 | 用友软件股份有限公司 | Data conversion device and data conversion method |
| CN105808375A (en) * | 2014-12-31 | 2016-07-27 | 航天信息软件技术有限公司 | Data import method and device |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108961026A (en) * | 2018-07-04 | 2018-12-07 | 中国建设银行股份有限公司 | Account calculates processing method, device and electronic equipment |
| CN109344170A (en) * | 2018-09-04 | 2019-02-15 | 阿里巴巴集团控股有限公司 | Stream data processing method, system, electronic equipment and readable storage medium storing program for executing |
| CN109597826A (en) * | 2018-09-04 | 2019-04-09 | 阿里巴巴集团控股有限公司 | Data processing method, device, electronic equipment and computer readable storage medium |
| CN109344170B (en) * | 2018-09-04 | 2022-04-12 | 创新先进技术有限公司 | Stream data processing method, system, electronic device and readable storage medium |
| CN109597826B (en) * | 2018-09-04 | 2023-02-21 | 创新先进技术有限公司 | Data processing method and device, electronic equipment and computer readable storage medium |
| CN109658043A (en) * | 2018-10-16 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Collection data processing method, device, equipment and storage medium |
| CN112258690A (en) * | 2020-10-23 | 2021-01-22 | 中车青岛四方机车车辆股份有限公司 | Data access method and device and data storage method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108228736A (en) | Data processing method, data processing system and computer readable storage medium | |
| US10560484B2 (en) | Managing access in one or more computing systems | |
| US20050080654A1 (en) | Integrated technology quality model | |
| CN108876306A (en) | A kind of online measures and procedures for the examination and approval, device and storage medium | |
| CN110175165A (en) | Transaction account checking method, device, computer equipment and storage medium | |
| CN103473076A (en) | Issuing method and issuing system for code version | |
| US8504452B2 (en) | Method and system for auditing internal controls | |
| CN109993651A (en) | Data calculate service order collection method of calibration, device, computer equipment and medium | |
| CN107025601A (en) | Verification of data method, device and equipment | |
| CN107249182A (en) | A kind of note transmission method and its device, terminal device | |
| CN110188033B (en) | Data detection device, method, computer device, and computer-readable storage medium | |
| US7831442B1 (en) | System and method for minimizing edits for medical insurance claims processing | |
| CN112419052B (en) | Transaction testing method, device, electronic equipment and readable storage medium | |
| CN112612882B (en) | Review report generation method, device, equipment and storage medium | |
| CN115619512A (en) | Account checking processing method, account checking processing device, computer readable medium and computer program product | |
| US20040107115A1 (en) | Transaction voucher management method and transaction voucher management program | |
| CN109656953A (en) | A kind of retail data automatic inspection system | |
| Lüders et al. | Openreq issue link map: A tool to visualize issue links in jira | |
| CN114742563A (en) | Automatic transaction wind control system | |
| US7987203B2 (en) | Method of processing data for a system model | |
| CN110347741B (en) | System for effectively improving output result data quality in big data processing process and control method thereof | |
| EP1895455A1 (en) | Systems and methods for testing internal control effectiveness | |
| US8694433B1 (en) | Image cashletter processing with reject repair deferral | |
| KR102538428B1 (en) | Automatic Data Cleaning Method and System for Asset Management of Power Facility | |
| Farzat | Test case selection method for emergency changes |
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 | ||
| CB02 | Change of applicant information |
Address after: 518000 Guangdong city of Shenzhen province Qianhai Shenzhen Hong Kong cooperation zone before Bay Road No. 1 building 201 room A (located in Shenzhen Qianhai business secretary Co. Ltd.) Applicant after: Shenzhen Rongyimai Information Technology Co., Ltd. Address before: 518000 Guangdong city of Shenzhen province Qianhai Shenzhen Hong Kong cooperation zone before Bay Road No. 1 building 201 room A (located in Shenzhen Qianhai business secretary Co. Ltd.) Applicant before: Maimaiti Mdt InfoTech Ltd, Shenzhen |
|
| CB02 | Change of applicant information | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180629 |
|
| RJ01 | Rejection of invention patent application after publication |