CN107798614A - The method and device of data processing - Google Patents
The method and device of data processing Download PDFInfo
- Publication number
- CN107798614A CN107798614A CN201710083493.3A CN201710083493A CN107798614A CN 107798614 A CN107798614 A CN 107798614A CN 201710083493 A CN201710083493 A CN 201710083493A CN 107798614 A CN107798614 A CN 107798614A
- Authority
- CN
- China
- Prior art keywords
- scheduler task
- data
- declaration form
- batch
- prophet
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
Abstract
The present invention is applied to field of computer technology, there is provided a kind of method and device of data processing, methods described include：Batch processing script is disposed in declaration form combined data storehouse, the batch processing script is write to obtain according to the data process method of PROPHET softwares；When handling declaration form combined data, the scheduler task of user's triggering is obtained；Batch processing script corresponding to the scheduler task is performed, table data in source corresponding to the scheduler task are read from the declaration form combined data storehouse, and the processing logic for simulating the PROPHET is changed and analyzed to the source table data.The present invention need not rely on outsourcing software PROPHET, and TXT files are exported manually without actuarial group, effectively simplify processing procedure of the actuarial group to MP declaration form combined data, reduce cost, improve the efficiency that actuarial group carries out monthly closing entry.
Description
Technical field
The invention belongs to field of computer technology, more particularly to a kind of method and device of data processing.
Background technology
DCS (Data Conversion are carried out to MP (Model Points) declaration form combined data in Life Actuarial Science group
System) during data screening, prior art is mainly realized using outsourcing software PROPHET.PROPHET is Bacon＆
The actuarial operating system of a set of synthesis of Woodrow companies exploitation, including life insurance, non-life and other parts, can be gold
Melt service trade and the series of services functions such as profit test, assets assessment, business model setting are provided, disclosure satisfy that including insurance
A large amount of technical requirements of financial service subsidiary including company.However, during using the PROPHET, actuarial
Group personnel need that the source table data in mechanism database, PALA storehouses are exported into TXT files beforehand through script file before screening, so
After reuse PROPHET read derived from TXT files carry out data processing, process is complicated, and the PROPHET is payware,
Cost is high.
The content of the invention
In consideration of it, the embodiments of the invention provide a kind of method and device of data processing, MP is protected with simplifying actuarial group
The processing procedure of single combined data, reduces cost.
First aspect, there is provided a kind of method of data processing, methods described include：
Batch processing script is disposed in declaration form combined data storehouse, the batch processing script is according to the data of PROPHET softwares
Processing logic writes to obtain；
When handling declaration form combined data, the scheduler task of user's triggering is obtained；
Batch processing script corresponding to the scheduler task is performed, the scheduling is read from the declaration form combined data storehouse and is appointed
Table data in source corresponding to business, and the processing logic for simulating the PROPHET is changed and analyzed to the source table data.
Further, the scheduler task for obtaining user's triggering includes：
When getting the operating instruction of user's input, it is synchronous that kettle is carried out to Notified body storehouse；
If during synchronous success, the scheduler task of specified quantity is inserted in planning chart Pala_batch_plan, for storage
Process scanning performs；
If during synchronization failure, ejecting prompt message, to prompt user not complete synchronous mechanism database and confirm the machine
Structure storehouse carries out benefit execution after completing synchronization.
Further, it is described to perform batch processing script corresponding to the scheduler task, from the declaration form combined data storehouse
Table data in source corresponding to the scheduler task are read, and the processing logic for simulating the PROPHET is carried out to the source table data
Conversion and analysis include：
The planning chart pala_batch_plan is scanned according to default time interval, obtains scheduler task at first；
The batch processing script according to corresponding to performing the scheduler task, the tune is read from the declaration form combined data storehouse
Table data in source corresponding to degree task, and the processing logic for simulating the PROPHET is changed and analyzed to the source table data；
According to the implementing result of scheduler task, status information corresponding to scheduler task in Update log table pol_ben_log.
Further, methods described also includes：
If scheduler task runs succeeded, instruction is checked according to what user inputted, shows the log sheet pol_ben_log
In renewal result.
Further, methods described also includes：
If scheduler task performs failure, benefit execution is carried out, it is synchronous to carry out kettle to current facility storehouse；
If during synchronous success, 1 scheduler task is inserted in the planning chart Pala_batch_plan, for storing
Journey scanning performs.
Second aspect, there is provided a kind of device of information modification, described device include：
Deployment module, in declaration form combined data storehouse dispose batch processing script, the batch processing script according to
The data process method of PROPHET softwares is write to obtain；
Acquisition module, for when handling declaration form combined data, obtaining the scheduler task of user's triggering；
Execution module, for performing batch processing script corresponding to the scheduler task, from the declaration form combined data storehouse
Table data in source corresponding to the scheduler task are read, and the processing logic for simulating the PROPHET is carried out to the source table data
Conversion and analysis.
Further, the acquisition module includes：
Synchronization unit, for when getting the operating instruction of user's input, it is synchronous to carry out kettle to Notified body storehouse；
Task inserts unit, if succeed for synchronization, specified quantity is inserted in planning chart Pala_batch_plan
Scheduler task, performed so that storing process scans；
Tip element, if during for synchronization failure, ejecting prompt message, to prompt user not complete synchronous mechanism database simultaneously
Benefit execution is carried out after confirming that the mechanism database completes synchronization.
Further, the execution module includes：
Scanning element, for scanning the planning chart pala_batch_plan according to default time interval, obtain at first
Scheduler task；
Execution unit, for the batch processing script according to corresponding to scheduler task execution, from the declaration form combined data
Table data in source corresponding to the scheduler task are read in storehouse, and simulate the processing logic of the PROPHET to the source table data
Changed and analyzed；
Updating block, for the implementing result according to scheduler task, scheduler task pair in Update log table pol_ben_log
The status information answered.
Further, the execution module also includes：
Unit is checked, if run succeeded for scheduler task, instruction is checked according to what user inputted, shows the daily record
Renewal result in table pol_ben_log.
Further, the execution module also includes：
Execution unit is mended, if perform failure for scheduler task, carries out benefit execution, kettle is carried out to current facility storehouse
It is synchronous；If during synchronous success, 1 scheduler task is inserted in the planning chart Pala_batch_plan, so that storing process is swept
Retouch execution.
Compared with prior art, the embodiment of the present invention is described by disposing batch processing script in declaration form combined data storehouse
Batch processing script is write to obtain according to the data process method of PROPHET softwares；When handling declaration form combined data, obtain
Take the scheduler task of family triggering；Batch processing script corresponding to the scheduler task is performed, from the declaration form combined data storehouse
Table data in source corresponding to the scheduler task are read, and the processing logic for simulating the PROPHET is carried out to the source table data
Conversion and analysis.By the embodiment of the present invention, actuarial group need not rely on outsourcing software PROPHET, without manual export TXT texts
Part, processing procedure of the actuarial group to MP declaration form combined data is effectively simplified, reduces cost, improved actuarial group and carry out the moon
The efficiency of knot.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments of invention, for those of ordinary skill in the art, on the premise of not paying creative work, can be with
Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 is the implementation process figure of the method for the data processing that first embodiment of the invention provides；
Fig. 2 is the composition structure chart of the device for the data processing that second embodiment of the invention provides.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
The embodiment of the present invention by declaration form combined data storehouse dispose batch processing script, the batch processing script according to
The data process method of PROPHET softwares is write to obtain；When handling declaration form combined data, the tune of user's triggering is obtained
Degree task；Batch processing script corresponding to the scheduler task is performed, the scheduling is read from the declaration form combined data storehouse and is appointed
Table data in source corresponding to business, and the processing logic for simulating the PROPHET is changed and analyzed to the source table data.Pass through
The embodiment of the present invention, actuarial group need not rely on outsourcing software PROPHET, without manual export TXT files, effectively simplify
Actuarial group reduces cost, improves the efficiency that actuarial group carries out monthly closing entry to the processing procedure of MP declaration form combined data.The present invention
Embodiment additionally provides the device of corresponding data processing, is described in detail individually below.
Fig. 1 is the implementation process of the method for the data processing that first embodiment of the invention provides.
In embodiments of the present invention, the method for the data processing is applied on terminal device, and the terminal device includes
But it is not limited to computer, server etc..Refering to Fig. 1, the method for the data processing includes：
In step S101, in declaration form combined data storehouse dispose batch processing script, the batch processing script according to
The data process method of PROPHET softwares is write to obtain.
Herein, the embodiment of the present invention deploys batch processing script, i.e. pkg scripts in declaration form combined data storehouse in advance.
The batch processing script is the functional development based on outsourcing software PROPHET, and its code is the inside according to PROPHET softwares
What data process method was encoded, the data conversion of PROPHET softwares and the function of analysis can be realized.Meanwhile the present invention
Embodiment additionally provides the display interface on foreground and Function Identification triggers the batch processing script for user.User is passing through unification
UM (employee number) Account Logon after, triggered in the display interface Function Identification i.e. can trigger the batch processing pin
This.
In step s 102, when handling declaration form combined data, the scheduler task of user's triggering is obtained.
The embodiment of the present invention obtains scheduler task according to triggering of the user on the display interface to the Function Identification,
And cache in the planning chart specified into declaration form combined data storehouse.The declaration form includes but is not limited to annuity ANN declaration forms, goat meter
Draw GOAT declaration forms, IRR product warrantieses, traditional dividend POL_BEN_MAIN declaration forms, longevity group's product LBS declaration forms, sharp clear increment of sharing out bonus
PUA declaration forms, throw by-product ULINK declaration forms, additional premium TOP declaration forms, short dangerous product SHORT declaration forms, omnipotent product UNIVERSAL
Declaration form, ensure continuation of insurance GUAR declaration forms, the special company's of throwing 885＆878 declaration forms.Exemplarily, the Function Identification can be " RUN " mark
Know, user is specifically included by triggering the " RUN " mark input operating instruction, the step S102：
When getting the operating instruction of user's input, it is synchronous that kettle is carried out to Notified body storehouse；
If during synchronous success, the scheduler task of specified quantity is inserted in planning chart Pala_batch_plan, for storage
Process scanning performs；
If during synchronization failure, ejecting prompt message, to prompt user not complete synchronous mechanism database and confirm the machine
Structure storehouse carries out benefit execution after completing synchronization.
Herein, 8 mechanism databases are provided with the declaration form combined data storehouse of the embodiment of the present invention, when user triggers " RUN " mark
After knowledge, then it is synchronous kettle to be carried out to 8 mechanism databases.If 8 mechanism databases synchronously succeed, in planning chart Pala_
8 scheduler tasks are inserted in batch_plan, are performed so that storing process scans；If synchronization failure, ejecting prompt message, with
Prompting user does not complete synchronous mechanism database and carries out benefit execution after confirming that the mechanism database completes synchronization.Exemplarily, institute
Stating prompt message can be：
Mechanism database：XX ..., XX, kettle synchronously do not complete, it is impossible to perform this operation, these mechanism databases of PLSCONFM
After kettle is synchronously completed, go to and check that results page mends execution.
The benefit, which performs, to be referred to carry out kettle synchronizations to the mechanism database of kettle synchronization failures again, if synchronous successful,
1 scheduler task is then inserted in planning chart Pala_batch_plan.
In step s 103, batch processing script corresponding to the scheduler task is performed, from the declaration form combined data storehouse
Table data in source corresponding to the scheduler task are read, and the processing logic for simulating the PROPHET is carried out to the source table data
Conversion and analysis.
In embodiments of the present invention, backstage storing process timing scan planning chart, the current scheduling in planning chart are appointed
Batch processing script corresponding to business execution, is gone forward side by side with the source table data in the data process method reading database according to PROPHET
Row DCS processing, that is, change and analyze and process.The step S103 is specifically included：
The planning chart pala_batch_plan is scanned according to default time interval, obtains scheduler task at first；
The batch processing script according to corresponding to performing the scheduler task, the tune is read from the declaration form combined data storehouse
Table data in source corresponding to degree task, and the processing logic for simulating the PROPHET is changed and analyzed to the source table data；
According to the implementing result of scheduler task, status information corresponding to scheduler task in Update log table pol_ben_log.
Herein, the default time interval can be 1 minute, i.e., every 1 minute run-down planning chart pala_
Batch_plan, the scheduler task cached at first is obtained according to the reading order of first in first out.Then according to the scheduler task
Batch processing script corresponding to execution, table data in source corresponding to the scheduler task are read from the declaration form combined data storehouse, and
The processing logic for simulating the PROPHET is changed and analyzed to the source table data.Prior art be need actuarial group from
The data of summary sheet are all exported into TXT files in declaration form combined data storehouse, then by the PROPHET softwares to described
TXT files carry out DCS analyses.And the embodiment of the present invention is directly converged by disposing batch processing script by batch processing script from declaration form
Data are obtained in total Database, TXT files are exported manually without actuarial group, so as to simplify actuarial group to MP declaration form combined data
Processing procedure, reduce human cost, be effectively improved actuarial group carry out monthly closing entry efficiency.
After scheduler task is performed, scheduler task pair in synchronized update log sheet of embodiment of the present invention pol_ben_log
The status information answered.Alternatively, the status information includes but is not limited to mechanism database, processing code (PROCESS_CODE), converged
Total time started, the end time of collecting, remark states.
Alternatively, the step S103 can also include：
If scheduler task runs succeeded, instruction is checked according to what user inputted, shows the log sheet pol_ben_log
In renewal result.
There is provided look facility mark for the embodiment of the present invention.User checks finger by triggering the look facility mark input
Order.The renewal result that terminal device will return in loaded and displayed pol_ben_log so that user can check handle into
Degree, improve the experience sense of user.
Alternatively, the step S103 can also include：
If scheduler task performs failure, benefit execution is carried out, it is synchronous to carry out kettle to current facility storehouse；
If during synchronous success, 1 scheduler task is inserted in the planning chart Pala_batch_plan, for storing
Journey scanning performs.
Herein, the scheduler task inserted is scheduler task corresponding to the mechanism database.
In summary, the embodiment of the present invention in declaration form combined data storehouse by disposing batch processing script, the batch processing
Script is write to obtain according to the data process method of PROPHET softwares；When handling declaration form combined data, user is obtained
The scheduler task of triggering；Batch processing script corresponding to the scheduler task is performed, institute is read from the declaration form combined data storehouse
State table data in source corresponding to scheduler task, and the processing logic for simulating the PROPHET source table data are changed and
Analysis.By the embodiment of the present invention, actuarial group need not rely on outsourcing software PROPHET, without manual export TXT files, have
Processing procedure of the actuarial group to MP declaration form combined data is simplified to effect, reduces cost, actuarial group is improved and carries out monthly closing entry
Efficiency.
It should be understood that in the above-described embodiments, the size of the sequence number of each step is not meant to the priority of execution sequence, each step
Rapid execution sequence should determine that the implementation process without tackling the embodiment of the present invention forms any limit with its function and internal logic
It is fixed.
Fig. 2 shows the composition structure of the device for the data processing that second embodiment of the invention provides, for convenience of description,
It illustrate only the part related to the embodiment of the present invention.
In embodiments of the present invention, the device of the data processing is used to realize the data described in above-mentioned Fig. 1 embodiments
The method of processing, can be the unit for being built in the software unit of terminal device, hardware cell or software and hardware combining.The end
End equipment includes but is not limited to computer, server etc..
Refering to Fig. 2, the device of the data processing includes：
Deployment module 21, in declaration form combined data storehouse dispose batch processing script, the batch processing script according to
The data process method of PROPHET softwares is write to obtain；
Acquisition module 22, for when handling declaration form combined data, obtaining the scheduler task of user's triggering；
Execution module 23, for performing batch processing script corresponding to the scheduler task, from the declaration form combined data storehouse
It is middle to read source table data corresponding to the scheduler task, and the processing logic for simulating the PROPHET is entered to the source table data
Row conversion and analysis.
Further, the acquisition module 22 includes：
Synchronization unit 221, for when getting the operating instruction of user's input, it is same to carry out kettle to Notified body storehouse
Step；
Task inserts unit 222, if during for synchronous success, being inserted in planning chart Pala_batch_plan and specifying number
The scheduler task of amount, performed so that storing process scans；
Tip element 223, if during for synchronization failure, ejecting prompt message, to prompt user not complete synchronous mechanism
Storehouse simultaneously carries out benefit execution after confirming that the mechanism database completes synchronization.
Further, the execution module 23 includes：
Scanning element 231, for scanning the planning chart pala_batch_plan according to default time interval, obtain
Scheduler task at first；
Execution unit 232, for the batch processing script according to corresponding to scheduler task execution, from the declaration form total amount
According to reading table data in source corresponding to the scheduler task in storehouse, and the processing logic of the PROPHET is simulated to the source table number
According to being changed and analyzed；
Updating block 233, for the implementing result according to scheduler task, dispatch and appoint in Update log table pol_ben_log
Status information corresponding to business.
Herein, the default time interval can be 1 minute, i.e., scanning element 231 was every 1 minute run-down meter
Table pala_batch_plan is drawn, the scheduler task cached at first is obtained according to the reading order of first in first out.Then execution unit
232 according to the scheduler task perform corresponding to batch processing script, read from the declaration form combined data storehouse it is described scheduling appoint
Table data in source corresponding to business, and the processing logic for simulating the PROPHET is changed and analyzed to the source table data.It is existing
Technology is to need actuarial group that the data of summary sheet are all exported into TXT files from database, then passes through the PROPHET
Software carries out DCS analyses to the TXT files.It is straight by batch processing script and the embodiment of the present invention is by disposing batch processing script
Connect and obtain data from declaration form combined data storehouse, TXT files are exported manually without actuarial group, MP is protected so as to simplify actuarial group
The processing procedure of single combined data, reduces human cost, is effectively improved the efficiency that actuarial group carries out monthly closing entry.Further
Ground, the processing logic that the embodiment of the present invention is simulated the PROPHET by the batch processing script turn to the source table data
Change and analyze, without relying on outsourcing software PROPHET, advantageously reduce actuarial cost.
After scheduler task is performed, the embodiment of the present invention passes through the synchronized update log sheet pol_ of updating block 233
Status information corresponding to scheduler task in ben_log.Alternatively, the status information includes but is not limited to mechanism database, processing generation
Code (PROCESS_CODE), collect time started, the end time of collecting, remark states.
Further, the execution module 23 also includes：
Unit 234 is checked, if run succeeded for scheduler task, instruction is checked according to what user inputted, described in display
Renewal result in log sheet pol_ben_log.
Further, the execution module 23 also includes：
Execution unit 235 is mended, if perform failure for scheduler task, carries out benefit execution, current facility storehouse is carried out
Kettle is synchronous；If during synchronous success, 1 scheduler task is inserted in the planning chart Pala_batch_plan, for storage
Process scanning performs.
It should be noted that the device in the embodiment of the present invention can be used for realizing whole skills in above method embodiment
Art scheme, the function of its each functional module can be implemented according to the method in above method embodiment, and it is implemented
Process can refer to the associated description in examples detailed above, and here is omitted.
In summary, the embodiment of the present invention in declaration form combined data storehouse by disposing batch processing script, the batch processing
Script is write to obtain according to the data process method of PROPHET softwares；When handling declaration form combined data, user is obtained
The scheduler task of triggering；Batch processing script corresponding to the scheduler task is performed, institute is read from the declaration form combined data storehouse
State table data in source corresponding to scheduler task, and the processing logic for simulating the PROPHET source table data are changed and
Analysis.By the embodiment of the present invention, actuarial group need not rely on outsourcing software PROPHET, without manual export TXT files, have
Processing procedure of the actuarial group to MP declaration form combined data is simplified to effect, reduces cost, actuarial group is improved and carries out monthly closing entry
Efficiency.
Those of ordinary skill in the art are it is to be appreciated that the list of each example described with reference to the embodiments described herein
Member and algorithm steps, it can be realized with the combination of electronic hardware or computer software and electronic hardware.These functions are actually
Performed with hardware or software mode, application-specific and design constraint depending on technical scheme.Professional and technical personnel
Described function can be realized using distinct methods to each specific application, but this realization is it is not considered that exceed
The scope of the present invention.
It is apparent to those skilled in the art that for convenience and simplicity of description, the device of foregoing description
With the specific work process of unit, the corresponding process in preceding method embodiment is may be referred to, will not be repeated here.
In several embodiments provided herein, it should be understood that disclosed method and device, it can be passed through
Its mode is realized.For example, device embodiment described above is only schematical, for example, the module, unit are drawn
Point, only a kind of division of logic function, there can be other dividing mode when actually realizing, such as multiple units or component can
To combine or be desirably integrated into another system, or some features can be ignored, or not perform.It is another, it is shown or beg for
The mutual coupling of opinion or direct-coupling or communication connection can be the INDIRECT COUPLINGs by some interfaces, device or unit
Or communication connection, can be electrical, mechanical or other forms.
The unit illustrated as separating component can be or may not be physically separate, show as unit
The part shown can be or may not be physical location, you can with positioned at a place, or can also be distributed to multiple
On NE.Some or all of unit therein can be selected to realize the mesh of this embodiment scheme according to the actual needs
's.
In addition, each functional unit, module in each embodiment of the present invention can be integrated in a processing unit,
Can be that unit, module are individually physically present, can also two or more units, module be integrated in a unit
In.
If the function is realized in the form of SFU software functional unit and is used as independent production marketing or in use, can be with
It is stored in a computer read/write memory medium.Based on such understanding, technical scheme is substantially in other words
The part to be contributed to prior art or the part of the technical scheme can be embodied in the form of software product, the meter
Calculation machine software product is stored in a storage medium, including some instructions are causing a computer equipment (can be
People's computer, server, or network equipment etc.) perform all or part of step of each embodiment methods described of the present invention.
And foregoing storage medium includes：USB flash disk, mobile hard disk, read-only storage (ROM, Read-Only Memory), arbitrary access are deposited
Reservoir (RAM, Random Access Memory), magnetic disc or CD etc. are various can be with the medium of store program codes.
The foregoing is only a specific embodiment of the invention, but protection scope of the present invention is not limited thereto, any
Those familiar with the art the invention discloses technical scope in, change or replacement can be readily occurred in, should all be contained
Cover within protection scope of the present invention.Therefore, protection scope of the present invention described should be defined by scope of the claims.
Claims (10)
- A kind of 1. method of data processing, it is characterised in that methods described includes：Batch processing script is disposed in declaration form combined data storehouse, the batch processing script is according to the data processings of PROPHET softwares Logic writes to obtain；When handling declaration form combined data, the scheduler task of user's triggering is obtained；Batch processing script corresponding to the scheduler task is performed, the scheduler task pair is read from the declaration form combined data storehouse The source table data answered, and the processing logic for simulating the PROPHET is changed and analyzed to the source table data.
- 2. the method for data processing as claimed in claim 1, it is characterised in that the scheduler task bag for obtaining user's triggering Include：When getting the operating instruction of user's input, it is synchronous that kettle is carried out to Notified body storehouse；If during synchronous success, the scheduler task of specified quantity is inserted in planning chart Pala_batch_plan, for storing process Scanning performs；If during synchronization failure, ejecting prompt message, to prompt user not complete synchronous mechanism database and confirm the mechanism database Benefit execution is carried out after completing synchronization.
- 3. the method for data processing as claimed in claim 2, it is characterised in that described perform is criticized corresponding to the scheduler task Script is handled, table data in source corresponding to the scheduler task are read from the declaration form combined data storehouse, and described in simulation PROPHET processing logic the source table data are changed and analyzed including：The planning chart pala_batch_plan is scanned according to default time interval, obtains scheduler task at first；The batch processing script according to corresponding to performing the scheduler task, the scheduling is read from the declaration form combined data storehouse and is appointed Table data in source corresponding to business, and the processing logic for simulating the PROPHET is changed and analyzed to the source table data；According to the implementing result of scheduler task, status information corresponding to scheduler task in Update log table pol_ben_log.
- 4. the method for data processing as claimed in claim 3, it is characterised in that methods described also includes：If scheduler task runs succeeded, instruction is checked according to what user inputted, is shown in the log sheet pol_ben_log Update result.
- 5. the method for data processing as claimed in claim 3, it is characterised in that methods described also includes：If scheduler task performs failure, benefit execution is carried out, it is synchronous to carry out kettle to current facility storehouse；If during synchronous success, 1 scheduler task is inserted in the planning chart Pala_batch_plan, so that storing process is swept Retouch execution.
- 6. a kind of device of data processing, it is characterised in that described device includes：Deployment module, for disposing batch processing script in declaration form combined data storehouse, the batch processing script is soft according to PROPHET The data process method of part is write to obtain；Acquisition module, for when handling declaration form combined data, obtaining the scheduler task of user's triggering；Execution module, for performing batch processing script corresponding to the scheduler task, read from the declaration form combined data storehouse Table data in source corresponding to the scheduler task, and the processing logic for simulating the PROPHET is changed to the source table data And analysis.
- 7. the device of data processing as claimed in claim 6, it is characterised in that the acquisition module includes：Synchronization unit, for when getting the operating instruction of user's input, it is synchronous to carry out kettle to Notified body storehouse；Task inserts unit, if succeed for synchronization, the scheduling of specified quantity is inserted in planning chart Pala_batch_plan Task, performed so that storing process scans；Tip element, if during for synchronization failure, ejecting prompt message, to prompt user not complete synchronous mechanism database and true Recognize after the mechanism database completes synchronization and carry out benefit execution.
- 8. the device of data processing as claimed in claim 7, it is characterised in that the execution module includes：Scanning element, for scanning the planning chart pala_batch_plan according to default time interval, obtain tune at first Degree task；Execution unit, for the batch processing script according to corresponding to scheduler task execution, from the declaration form combined data storehouse Table data in source corresponding to the scheduler task are read, and the processing logic for simulating the PROPHET is carried out to the source table data Conversion and analysis；Updating block, for the implementing result according to scheduler task, in Update log table pol_ben_log corresponding to scheduler task Status information.
- 9. the device of data processing as claimed in claim 8, it is characterised in that the execution module also includes：Unit is checked, if run succeeded for scheduler task, instruction is checked according to what user inputted, shows the log sheet Renewal result in pol_ben_log.
- 10. the device of data processing as claimed in claim 8, it is characterised in that the execution module also includes：Execution unit is mended, if perform failure for scheduler task, carries out benefit execution, it is same to carry out kettle to current facility storehouse Step；If during synchronous success, 1 scheduler task is inserted in the planning chart Pala_batch_plan, so that storing process scans Perform.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710083493.3A CN107798614B (en) | 2017-02-16 | 2017-02-16 | Data processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710083493.3A CN107798614B (en) | 2017-02-16 | 2017-02-16 | Data processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107798614A true CN107798614A (en) | 2018-03-13 |
| CN107798614B CN107798614B (en) | 2020-07-14 |
Family
ID=61531093
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710083493.3A Active CN107798614B (en) | 2017-02-16 | 2017-02-16 | Data processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107798614B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109544389A (en) * | 2018-11-29 | 2019-03-29 | 爱保科技（横琴）有限公司 | Intelligent analysis system based on declaration form |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080244594A1 (en) * | 2007-03-29 | 2008-10-02 | International Business Machines Corporation | Visual scripting of web services for task automation |
| CN101877158A (en) * | 2010-03-23 | 2010-11-03 | 苏州德融嘉信信用管理技术有限公司 | Front service platform of bank and operation processing method thereof |
| CN105808633A (en) * | 2016-01-08 | 2016-07-27 | 平安科技（深圳）有限公司 | Data archiving method and system |
-
2017
- 2017-02-16 CN CN201710083493.3A patent/CN107798614B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080244594A1 (en) * | 2007-03-29 | 2008-10-02 | International Business Machines Corporation | Visual scripting of web services for task automation |
| CN101877158A (en) * | 2010-03-23 | 2010-11-03 | 苏州德融嘉信信用管理技术有限公司 | Front service platform of bank and operation processing method thereof |
| CN105808633A (en) * | 2016-01-08 | 2016-07-27 | 平安科技（深圳）有限公司 | Data archiving method and system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109544389A (en) * | 2018-11-29 | 2019-03-29 | 爱保科技（横琴）有限公司 | Intelligent analysis system based on declaration form |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107798614B (en) | 2020-07-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Hofmeister et al. | Generalizing a model of software architecture design from five industrial approaches | |
| Garland et al. | Large-scale software architecture: a practical guide using UML | |
| CN107886439A (en) | Insurance products development approach, device, equipment and computer-readable recording medium | |
| CN106155686A (en) | Interface creating method, device and system | |
| CN108628741A (en) | Webpage test method, device, electronic equipment and medium | |
| CN110287097A (en) | Batch testing method, device and computer readable storage medium | |
| Van Der Aalst | Spreadsheets for business process management: Using process mining to deal with “events” rather than “numbers”? | |
| CN109685301A (en) | Method for managing resource, device, equipment and readable storage medium storing program for executing | |
| CN108090568A (en) | Recognize robot credit parser | |
| CN110471694A (en) | Annotation information processing method, device, computer equipment and storage medium | |
| CN110245278A (en) | Acquisition method, device, electronic equipment and the storage medium of web data | |
| CN109828906A (en) | UI automated testing method, device, electronic equipment and storage medium | |
| CN109359160A (en) | Method of data synchronization, device, computer equipment and storage medium | |
| CN110795697A (en) | Logic expression obtaining method and device, storage medium and electronic device | |
| CN104598570A (en) | Resource fetching method and device | |
| JP2009245383A (en) | Information processor and program analyzing method | |
| CN109828750A (en) | Auto-configuration data buries method, apparatus, electronic equipment and storage medium a little | |
| CN112100219A (en) | Report generation method, device, equipment and medium based on database query processing | |
| US20090169008A1 (en) | System and method for tracking testing of software modification projects from a wireless mobile device | |
| CN111931471A (en) | Form collection method and device, electronic equipment and storage medium | |
| CN116069300A (en) | Workflow control code generation method and device, electronic equipment and storage medium | |
| CN113312529A (en) | Data visualization method and device, computer equipment and storage medium | |
| CN101553794B (en) | Rehosting method which convert mainframe system into open system | |
| EP2637130A1 (en) | Collaborative system and method to mine inventions | |
| CN107798614A (en) | The method and device of data processing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |