CN108334614A - A kind of data-updating method, system and storage medium - Google Patents
A kind of data-updating method, system and storage medium Download PDFInfo
- Publication number
- CN108334614A CN108334614A CN201810121653.3A CN201810121653A CN108334614A CN 108334614 A CN108334614 A CN 108334614A CN 201810121653 A CN201810121653 A CN 201810121653A CN 108334614 A CN108334614 A CN 108334614A
- Authority
- CN
- China
- Prior art keywords
- data
- declaration form
- record
- information
- predetermined format
- 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
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Computing Systems (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Computer Security & Cryptography (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a kind of data-updating method, system and storage mediums, by obtaining in each universal life insurance declaration form account the changed declaration form account information compared with proxima luce (prox. luc) declaration form account value, declaration form account information is converted into predetermined format data, and will be in the corresponding declaration form record write-in credit of declaration form account information;Judge to be currently used in whether the timed task switch that control data upload starts, obtains predetermined format data if starting, and be packaged to obtain secondary conversion data to predetermined format data;The verification successful information whether current data more new system connect and receive with data platform is judged, if secondary conversion data are then uploaded to data platform;The interim table that historical data is uploaded for storing declaration form record is obtained, being calculated in credit according to the declaration form record upload historical data in interim table needs the declaration form resumed to record, and the declaration form that need to currently resume record is uploaded to data platform.It can realize the automatic breakpoint transmission of immediate updating data and data.
Description
Technical field
The present invention relates to fields of communication technology, and in particular to a kind of data-updating method, system and storage medium.
Background technology
Universal life insurance is that one kind is guaranteed the minimum the new insurance kind of investment, gives outside protection life support, can also allow as traditional life insurance
Client directly participates in the investment activity of fund in the investment in capital account established for insurer by insurance company, declaration form value and insurance public affairs
Take charge of the achievement hook of insurer's investment in capital account fund of independent work.Most of premium is used for buying the throwing set up by insurance company
Account unit is provided, is responsible for the transfer and investment decision of fund in account by investment expert, by fund input to various investment tools.
Since the data of universal life insurance may change daily, the requirement of letter data platform is protected in being according to Insurance Regulatory Commission's platform,
It needs that account value changed data are updated and are uploaded, currently existing scheme was all uploaded in the set time, so
And larger can not upload of data volume finishes the problem of being likely to result in Data duplication upload, causes data to upload mistake and reduces number
According to update efficiency.
Therefore, the existing technology needs to be improved and developed.
Invention content
Place in view of above-mentioned deficiencies of the prior art, the purpose of the present invention is to provide a kind of data-updating method, systems
And storage medium, the daily declaration form of energy immediate updating are worth changed declaration form account information and corresponding declaration form record, and
The automatic breakpoint transmission that data are realized using interim table, is avoided data occur uploading and repeats, and ensures the correctness of data and complete
Property.
In order to achieve the above object, this invention takes following technical schemes:
A kind of data-updating method comprising following steps:
The changed declaration form account information compared with proxima luce (prox. luc) declaration form account value is obtained in each universal life insurance declaration form account, it will
The declaration form account information is converted to predetermined format data, and an account is written in the corresponding declaration form record of the declaration form account information
In the table of family;
Judge to be currently used in whether the timed task switch that control data upload starts, if starting, obtains the predetermined format
Data, and the predetermined format data are packaged to obtain secondary conversion data;
Judge whether data update system connect with data platform, if so, receiving the check information of the data platform feedback;
Parse whether the check information being currently received is verification successful information, if so, the secondary conversion data are uploaded
To the data platform;
The interim table for uploading historical data for storing declaration form record is obtained, is uploaded and is gone through according to the declaration form record in the interim table
History data calculate the declaration form record for needing to resume in the credit, and the declaration form that need to currently resume record, which is uploaded to the data, puts down
Platform.
In the data-updating method, it is described obtain in each universal life insurance declaration form account with proxima luce (prox. luc) declaration form account value
Compared to changed declaration form account information, the declaration form account information is converted into predetermined format data, and by the declaration form
The corresponding declaration form of account information records the step being written in a credit:
Declaration form account value on the day of each universal life insurance declaration form account is compared with the declaration form account value of the previous day, is obtained
Changed declaration form account information;
Changed declaration form account information is converted into predetermined format data by pre-set record type rule;
According to the corresponding declaration form record of the changed declaration form account information of transformed predetermined format data acquisition, and will be described
In declaration form record one credit of write-in.
It is described to press pre-set record type rule by changed declaration form account in the data-updating method
Information is converted to the step of predetermined format data and includes:
The conversion configurations table with preset structure is obtained, according in the field of conversion configurations table described in record type rule setting
Hold;
The conversion configurations table is written into according to the field contents of conversion configurations table in the changed declaration form account information got
In, obtain predetermined format data.
It is described according to the changed declaration form account of transformed predetermined format data acquisition in the data-updating method
The corresponding declaration form record of family information, and the declaration form is recorded into the step in one credit of write-in and includes:
The corresponding declaration form record of changed declaration form account information is searched according to the field contents of the conversion configurations table, and will
In declaration form record one credit of write-in.
In the data-updating method, the judgement is currently used in whether the timed task switch that control data upload opens
It is dynamic, if starting, the predetermined format data are obtained, and be packaged to obtain secondary conversion data to the predetermined format data
The step of include:
Judge to be currently used in whether the timed task switch that control data upload starts, if starting, obtains the predetermined format
Data, and increase header and message on the head of the predetermined format data, obtain two times transfer data.
It is described to parse whether the check information being currently received is verification successful information in the data-updating method,
If so, the step of secondary conversion data are uploaded to the data platform includes:
The check information being currently received is parsed, judges the check information for verification successful information or verification failure information;
If verification successful information, then receives the first state code of data platform return and be uploaded to the secondary conversion data
The data platform, and sent at the end of upload and upload successful first notification information to specified contact number;
If verification failure information, then the second conditional code of data platform return is received, concurrently serves the second notice for passing failure
Information is to specified contact number.
In the data-updating method, second notification information includes the factor row of failed connection data platform
Table and/or the list of factors of verification failure.
It is described to obtain the interim table that historical data is uploaded for storing declaration form record, root in the data-updating method
Historical data is uploaded according to the declaration form record in the interim table and calculates the declaration form record for needing to resume in the credit, will currently be needed
The declaration form record the step of being uploaded to the data platform resumed includes:
The interim table for uploading historical data for storing declaration form record is obtained, declaration form record in the interim table is searched and uploads history
The maximum line number of data;
The maximum line number that historical data is uploaded according to the data volume of this upload and declaration form record searches this in the credit
The secondary beginning line number resumed and end line number;
To being assembled after starting the declaration form record addition vernier between line number and end line number in the credit, after assembling
Data be uploaded to the data platform.
A kind of data update system comprising:Processor, memory and communication bus;
The computer-readable program that can be executed by the processor is stored on the memory;
The communication bus realizes the connection communication between processor and memory;
The processor realizes the step in data-updating method as described above when executing the computer-readable program.
A kind of computer readable storage medium, which is characterized in that the computer-readable recording medium storage there are one or
The multiple programs of person, one or more of programs can be executed by one or more processor, to realize number as described above
According to the step in update method.
Compared to the prior art, in data-updating method provided by the invention, system and storage medium, the data update
Method is by the way that changed declaration form account is believed compared with proxima luce (prox. luc) declaration form account value in each universal life insurance declaration form account of acquisition
The declaration form account information is converted to predetermined format data, and the corresponding declaration form record of the declaration form account information is write by breath
Enter in a credit;Judge to be currently used in whether the timed task switch that control data upload starts later, if starting, obtain
The predetermined format data, and the predetermined format data are packaged to obtain secondary conversion data;Data are judged later more
Whether new system connect with data platform, if so, receiving the check information of the data platform feedback;Parsing is currently received
Check information whether be verification successful information, if so, the secondary conversion data are uploaded to the data platform;It obtains
The interim table that historical data is uploaded for storing declaration form record uploads historical data meter according to the declaration form record in the interim table
The declaration form record for needing to resume in the credit is calculated, the declaration form that need to currently resume record is uploaded to the data platform.Can be
The daily declaration forms of Shi Gengxin are worth changed declaration form account information and corresponding declaration form record, and realize number using interim table
According to automatic breakpoint transmission, avoid occur data upload repeat, ensure the correctness and integrality of data.
Description of the drawings
Fig. 1 is the flow chart of data-updating method provided by the invention;
Fig. 2 is the flow chart of step S10 in data-updating method provided by the invention;
Fig. 3 is the flow chart of step S12 in data-updating method provided by the invention;
Fig. 4 is the flow chart of step S40 in data-updating method provided by the invention;
Fig. 5 is the flow chart of step S50 in data-updating method provided by the invention;
Fig. 6 is the running environment schematic diagram of the preferred embodiment of date update program of the present invention;
Fig. 7 is the functional block diagram of the system preferred embodiment of installation data of the present invention more new procedures.
Specific implementation mode
The shortcomings of may repeating to cause to upload mistake in view of data update in the prior art, the purpose of the present invention is to provide
A kind of data-updating method, system and storage medium, can the daily declaration form of immediate updating be worth changed declaration form account information
And corresponding declaration form record, and using the automatic breakpoint transmission of interim table realization data, avoid generation data from uploading and repeat, protect
Demonstrate,prove the correctness and integrality of data.
To make the purpose of the present invention, technical solution and effect clearer, clear and definite, develop simultaneously embodiment pair referring to the drawings
The present invention is further described.It should be appreciated that described herein, specific examples are only used to explain the present invention, is not used to
Limit the present invention.
Referring to Fig. 1, data-updating method provided by the invention includes the following steps:
Changed declaration form account is believed compared with proxima luce (prox. luc) declaration form account value in S10, each universal life insurance declaration form account of acquisition
The declaration form account information is converted to predetermined format data, and the corresponding declaration form record of the declaration form account information is write by breath
Enter in a credit.
In the present embodiment, by detecting the declaration form account value of each universal life insurance declaration form account, obtain and proxima luce (prox. luc) declaration form
Account value compares changed declaration form account information, and changed declaration form account information progress format conversion is obtained
Predetermined format data require to match so as to the upload with data platform, and changed declaration form account information is corresponding
Declaration form records(Such as number of policy)It is written in a credit in case follow-up upload update.Specific data acquisition also referring to
Fig. 2 is the flow chart of step S10 in data-updating method provided by the invention.
As shown in Fig. 2, the step S10 includes:
S11, the declaration form account value on the day of each universal life insurance declaration form account is compared with the declaration form account value of the previous day,
Obtain changed declaration form account information;
S12, changed declaration form account information is converted into predetermined format data by pre-set record type rule;
S13, it is recorded according to the corresponding declaration form of the changed declaration form account information of transformed predetermined format data acquisition, and will
In declaration form record one credit of write-in.
In the present embodiment, by the declaration form account valence of declaration form account value and the previous day on the day of each universal life insurance declaration form account
Value is compared, and obtains changed declaration form account information, by this way, can handle to obtain in local data base every
Whether the declaration form account value of the universal life insurance declaration form account of a insurer is changed compared with the previous day, once it changes
It then needs to be uploaded to data platform in time, also be needed changed declaration form account before upload by pre-set record type rule
Family information is converted to predetermined format data, and the data to protect letter data platform in matching, which upload, to be required, i.e., protects letter data in
Record type rule is arranged in the data type that Platform Requirements upload, and extracts corresponding record in changed declaration form account information
The data of type obtain predetermined format data, realize the extraction and conversion of valid data, and obtain also according to predetermined format data
The corresponding declaration form record of changed declaration form account information is taken, and the declaration form is recorded in one credit of write-in, i.e., in number
When being uploaded according to update, last time changed declaration form account information is not only needed, while also obtaining changed declaration form account letter
Corresponding declaration form record is ceased for subsequently uploading, and ensures the integrality of data update.Specific predetermined format data acquisition is asked
It is the flow chart of step S12 in data-updating method provided by the invention together refering to Fig. 3.
As shown in figure 3, the step S12 includes:
S121, the conversion configurations table with preset structure is obtained, according to the word of conversion configurations table described in record type rule setting
Section content;
S122, the conversion is written into according to the field contents of conversion configurations table in the changed declaration form account information got matches
It sets in table, obtains predetermined format data.
In the present embodiment, when carrying out the conversion of predetermined format data, pass through a conversion configurations table with preset structure
It carries out, first obtains the conversion configurations table with preset structure, and according to conversion configurations table described in record type rule setting
Field contents, the field contents may include declaration form name on account, project name, number of deals, each in current transaction cycle
The interest rate of a project and income etc. are configured with specific reference to record type rule, are changed later by what is got
Declaration form account information be written in the conversion configurations table according to above-mentioned field contents, you can from changed declaration form account information
It is middle that predetermined format data needed for uploading are gone out according to record type Rule Extraction, it is effectively compressed data and uploads size, improve follow-up
Transfer efficiency in data.
Further, the step S13 includes:Changed guarantor is searched according to the field contents of the conversion configurations table
The corresponding declaration form record of single account information, and the declaration form is recorded in one credit of write-in.I.e. according to the conversion configurations table
After obtaining predetermined format data, the declaration form account information correspondence for sending variation can be searched according to the field contents in conversion configurations table
Declaration form record, for example, according in conversion configurations table name on account and project name can search its corresponding number of policy, will be right
The number of policy answered is written in a credit to wait for subsequently uploading, and ensures the integrality and correctness of data update.
S20, judge to be currently used in whether the timed task switch that control data upload starts, if starting, described in acquisition
Predetermined format data, and the predetermined format data are packaged to obtain secondary conversion data.
In the present embodiment, at the time point uploaded by a timed task switch control data, timed task switch can be
The included timed task switch of the databases such as job80, for controlling database, point timing uploads data at the appointed time daily,
The predetermined format data are then obtained when timed task switchs startup and obtain two times transfer data after being packaged, specifically
Ground is obtaining the predetermined format data switching the when of starting for controlling the timed task of data upload, and pre- fixes described
The head of formula data increases header and message, obtains two times transfer data, increases header on the head of the predetermined format data
And message, for subsequently upload when in protect letter platform to upload data verification, judge its whether be xml formats data,
To ensure the correctness of data.
S30, judge whether data update system connect with data platform, if so, receiving the data platform feedback
Check information;
Whether the check information that S40, parsing are currently received is verification successful information, if so, by the secondary conversion data
It is uploaded to the data platform.
In the present embodiment, when uploading the secondary conversion data, first judge current data more new system whether with middle guarantor
Letter data platform is successfully connected, if then receiving the check information of data platform feedback, parses the verification being currently received later
Information whether be verification successful information, i.e., in protect letter data platform by first to two times transfer data header and message carry out school
It tests, one verification successful information of feedback is indicated that current data format is correct if verifying successfully, at this time by two times transfer data
It is uploaded to the data platform.Specific upload procedure is in data-updating method provided by the invention also referring to Fig. 4
The flow chart of step S40.
As shown in figure 4, the step S40 includes:
The check information that S41, parsing are currently received judges that the check information is unsuccessfully believed for verification successful information or verification
Breath;
S42, if verification successful information, then receive data platform return first state code and will be in the secondary conversion data
The data platform is reached, and is sent at the end of upload and uploads successful first notification information to specified contact number;
S43, if verification failure information, then receive data platform return the second conditional code, concurrently serve pass failure second
Notification information is to specified contact number.
In the present embodiment, first judges currently whether be successfully connected with middle guarantor's letter data platform, data are received if having connected
Otherwise the check information of platform feedback directly receives the second conditional code that data platform returns, concurrently serves and pass the second of failure
Notification information then parses whether the check information being currently received is to verify successfully to believe when having connected to specified contact number
Breath, if having connected and receiving verification successful information, receive data platform return first state code and will be described secondary
Conversion data is uploaded to the data platform, and wherein first state code indicates that data update state is correct, to prompt staff
Current renewal process is smooth, and is sent at the end of upload and upload successful first notification information to specified contact number;And
If being not connected with or receiving verification failure information, at this time all without subsequent upload procedure, but receive data platform
The second conditional code returned, second conditional code indicate data update status error, and send the second notice for uploading failure
Information to specified contact number, wherein second notification information include failed connection data platform list of factors and/
Or the list of factors of verification failure.When it is implemented, the specified contact number is that mailbox, cell-phone number, QQ number, WeChat ID etc. are logical
Signal code, data upload successfully can then send the first notification information to specified contact number, and data upload failure then can be to specified
Contact number sends the second notification information, has end to upload This move in upload procedure as long as which guarantee data(On
It passes failure and uploading successfully can all cause end of data to upload), all can notified information, it is ensured that the entire mistake that data upload
As long as occurring interrupting in journey, all related personnel can be notified to take countermeasure immediately.
The present invention realizes the daily declaration form of immediate updating and is worth changed declaration form account information, and declaration form account information is
It is uploaded immediately when changing, ensures the real-time update of account value data, and in order to improve data updating efficiency, it changes
Declaration form account information corresponding declaration form record(Such as number of policy, transaction record, accumulation consumption record data)It is not then to send out
It is then uploaded immediately when changing, but selects to continue to upload the data that have not passed of last time when the database free time, i.e., the present invention also wraps
Include step:
S50, the interim table that historical data is uploaded for storing declaration form record is obtained, according on the declaration form record in the interim table
It passes historical data and calculates the declaration form record for needing to resume in the credit, the declaration form that need to currently resume record is uploaded to the number
According to platform.
In the present embodiment, the automatic breakpoint transmission of data is realized by an interim table, and declaration form is preserved by the interim table
Record uploads historical data, and low volume data is only stored in the interim table, and such as of that month declaration form record uploads historical data, i.e., temporarily
Data in table are removed once every month, are cleared up not in of that month data in history lists, according to described interim according to temporal information
Declaration form record in table uploads historical data and calculates the declaration form record for needing to resume in the credit, the declaration form that need to will currently resume
Record is uploaded to the data platform, can obtain the end position that last data upload by the interim table, and then in account
This position that need to be resumed is found in the table of family, and then realizes automatic breakpoint transmission, and the repetition for avoiding data uploads.Particularly
Journey is transmitted through please refer to fig. 5, it is the flow chart of step S50 in data-updating method provided by the invention.
As shown in figure 5, the step S50 includes:
S51, the interim table for uploading historical data for storing declaration form record is obtained, searches declaration form record in the interim table and uploads
The maximum line number of historical data;
S52, the maximum line number that historical data is uploaded according to data volume and the declaration form record of this upload are looked into the credit
It looks for this beginning line number resumed and terminates line number;
S53, it is assembled after adding vernier to the declaration form record started in the credit between line number and end line number, by group
Data after dress are uploaded to the data platform.
In the present embodiment, obtains and upload the interim table of historical data for storing declaration form record, and search wherein declaration form
Record uploads the maximum line number of historical data, and the maximum line number and its corresponding data are then the last stop bits for uploading data
It sets and its corresponding data, is opened later according to what the data volume of this upload and the maximum line number searched that this resumes in credit
The number of beginning and end line number are found the corresponding declaration form of the maximum line number in credit and are recorded, next of declaration form record
Corresponding line number is to start line number, end line number is can be obtained according to the data volume of this last time, later to the credit
It is middle to start line number and assembled after terminating the declaration form record addition vernier between line number, the data after assembling are uploaded to described
Data platform is convenient for follow-up data record queries, wherein data are inserted into upload procedure in order to prevent by adding vernier
It reports an error, then data are submitted every predetermined item, such as every 9000 datas after assembling(That is commit)Once.
Further, data are uploaded to the period residing for middle guarantor's letter data platform as each insurance company after assembling in order to prevent
Platform uploads the peak period of data, and a preset time is arranged, and no longer batch uploads data, such as acquiescence regulation after preset time
After 7 points of every night, no longer carries out batch processing and upload data.Preferably, it is current that credit data can be also obtained before upload
The mark whether uploaded(Data record)And whether data are in the mark that part body is run or full mechanism is run(Table is matched
It sets), which mechanism can be apparent from universal life insurance credit data by aforesaid operations has obtained these before resuming
Data.
As shown in fig. 6, being based on above-mentioned data-updating method, the present invention further correspondingly provides a kind of data update system, institute
It can be the computing devices such as mobile terminal, desktop PC, notebook, palm PC and server to state data update system.
The data update system includes processor 10, memory 20 and display 30.Fig. 6 illustrates only the part group of data update system
Part, it should be understood that being not required for implementing all components shown, more or less groups of the implementation that can be substituted
Part.
The memory 20 can be the internal storage unit of the data update system in some embodiments, such as count
According to the hard disk or memory of more new system.The memory 20 can also be the data update system in further embodiments
The plug-in type hard disk being equipped on External memory equipment, such as the data update system, intelligent memory card(Smart Media
Card, SMC), secure digital(Secure Digital, SD)Card, flash card(Flash Card)Deng.Further, described
Memory 20 can also both include institute's data update system internal storage unit and also including External memory equipment.The memory
20 for storing the application software and Various types of data for being installed on the data update system, such as the installation data more new system
Program code etc..The memory 20 can be also used for temporarily storing the data that has exported or will export.One
In embodiment, date update program 40 is stored on memory 20, the date update program 40 can performed by processor 10, from
And realize data-updating method in the application.
The processor 10 can be a central processing unit in some embodiments(Central Processing Unit,
CPU), microprocessor or other data processing chips, for running the program code stored in the memory 20 or processing number
According to, such as execute the data-updating method etc..
The display 30 can be light-emitting diode display, liquid crystal display, touch-control liquid crystal display in some embodiments
And OLED(Organic Light-Emitting Diode, Organic Light Emitting Diode)Touch device etc..The display 30 is used
In the information for being shown in the data update system and for showing visual user interface.The data update system
Component 10-30 is in communication with each other by system bus.
In one embodiment, following step is realized when processor 10 executes date update program 40 in the memory 20
Suddenly:
The changed declaration form account information compared with proxima luce (prox. luc) declaration form account value is obtained in each universal life insurance declaration form account, it will
The declaration form account information is converted to predetermined format data, and an account is written in the corresponding declaration form record of the declaration form account information
In the table of family;
Judge to be currently used in whether the timed task switch that control data upload starts, if starting, obtains the predetermined format
Data, and the predetermined format data are packaged to obtain secondary conversion data;
Judge whether data update system connect with data platform, if so, receiving the check information of the data platform feedback;
Parse whether the check information being currently received is verification successful information, if so, the secondary conversion data are uploaded
To the data platform;
The interim table for uploading historical data for storing declaration form record is obtained, is uploaded and is gone through according to the declaration form record in the interim table
History data calculate the declaration form record for needing to resume in the credit, and the declaration form that need to currently resume record, which is uploaded to the data, puts down
Platform.
It is described to obtain in each universal life insurance declaration form account the changed declaration form account compared with proxima luce (prox. luc) declaration form account value
The declaration form account information is converted to predetermined format data, and the corresponding declaration form of the declaration form account information is remembered by family information
Recording the step being written in a credit includes:
Declaration form account value on the day of each universal life insurance declaration form account is compared with the declaration form account value of the previous day, is obtained
Changed declaration form account information;
Changed declaration form account information is converted into predetermined format data by pre-set record type rule;
According to the corresponding declaration form record of the changed declaration form account information of transformed predetermined format data acquisition, and will be described
In declaration form record one credit of write-in.
It is described that changed declaration form account information is converted into predetermined format number by pre-set record type rule
According to the step of include:
The conversion configurations table with preset structure is obtained, according in the field of conversion configurations table described in record type rule setting
Hold;
The conversion configurations table is written into according to the field contents of conversion configurations table in the changed declaration form account information got
In, obtain predetermined format data.
It is described to be recorded according to the corresponding declaration form of the changed declaration form account information of transformed predetermined format data acquisition,
And the declaration form is recorded into the step in one credit of write-in and includes:
The corresponding declaration form record of changed declaration form account information is searched according to the field contents of the conversion configurations table, and will
In declaration form record one credit of write-in.
It is described to judge to be currently used in whether the timed task switch that control data upload starts, if starting, described in acquisition
Predetermined format data, and the step of obtaining secondary conversion data is packaged to the predetermined format data and includes:
Judge to be currently used in whether the timed task switch that control data upload starts, if starting, obtains the predetermined format
Data, and increase header and message on the head of the predetermined format data, obtain two times transfer data.
It is described to parse whether the check information being currently received is verification successful information, if so, by the secondary conversion
Data are uploaded to the step of data platform and include:
The check information being currently received is parsed, judges the check information for verification successful information or verification failure information;
If verification successful information, then receives the first state code of data platform return and be uploaded to the secondary conversion data
The data platform, and sent at the end of upload and upload successful first notification information to specified contact number;
If verification failure information, then the second conditional code of data platform return is received, concurrently serves the second notice for passing failure
Information is to specified contact number.
Second notification information includes the list of factors of failed connection data platform and/or the factor of verification failure
List.
It is described to obtain the interim table that historical data is uploaded for storing declaration form record, remembered according to the declaration form in the interim table
Record uploads historical data and calculates the declaration form record for needing to resume in the credit, and the declaration form that need to currently resume record is uploaded to institute
The step of stating data platform include:
The interim table for uploading historical data for storing declaration form record is obtained, declaration form record in the interim table is searched and uploads history
The maximum line number of data;
The maximum line number that historical data is uploaded according to the data volume of this upload and declaration form record searches this in the credit
The secondary beginning line number resumed and end line number;
To being assembled after starting the declaration form record addition vernier between line number and end line number in the credit, after assembling
Data be uploaded to the data platform.
Referring to Fig. 7, its functional block diagram for the system preferred embodiment of installation data of the present invention more new procedures.At this
In embodiment, the system of installation data more new procedures can be divided into one or more modules, one or more of moulds
Block is stored in the memory 20, and by one or more processors(The present embodiment is the processor 10)It is performed,
To complete the present invention.For example, in the figure 7, the system of installation data more new procedures, which can be divided into, to be obtained conversion module 21, sentences
Disconnected package module 22 judges link block 23, the first uploading module 24 and the second uploading module 25.The so-called module of the present invention is
The series of computation machine program instruction section for referring to complete specific function, than program more suitable for describing the date update program
Implementation procedure in the data update system.The function of the module 21-25 will specifically be introduced by being described below.
Conversion module 21 is obtained, for obtaining in each universal life insurance declaration form account the hair with proxima luce (prox. luc) declaration form account value compared with
The declaration form account information is converted to predetermined format data, and the declaration form account is believed by the declaration form account information for changing
It ceases in corresponding declaration form record one credit of write-in;
Judge package module 22, is currently used in whether the timed task switch that control data upload starts for judging, if starting,
The predetermined format data are then obtained, and the predetermined format data are packaged to obtain secondary conversion data;
Link block 23 is judged, for judging whether data update system connect with data platform, if so, receiving the data
The check information of platform feedback;
First uploading module 24, for parsing whether the check information being currently received is verification successful information, if so, by institute
It states secondary conversion data and is uploaded to the data platform;
Second uploading module 25, for obtaining the interim table for uploading historical data for storing declaration form record, according to described interim
Declaration form record in table uploads historical data and calculates the declaration form record for needing to resume in the credit, the declaration form that need to will currently resume
Record is uploaded to the data platform.
The acquisition conversion module 21 includes:
Comparing unit is used for the declaration form account value of declaration form account value and the previous day on the day of each universal life insurance declaration form account
It is compared, obtains changed declaration form account information;
Converting unit, for changed declaration form account information to be converted to pre- fix by pre-set record type rule
Formula data;
Declaration form records acquiring unit, for according to the changed declaration form account information pair of transformed predetermined format data acquisition
The declaration form record answered, and the declaration form is recorded in one credit of write-in.
The converting unit includes:
Subelement is obtained, for obtaining the conversion configurations table with preset structure, is converted according to described in record type rule setting
The field contents of allocation list;
Conversion subunit is written, in the field by the changed declaration form account information got according to conversion configurations table
Hold and be written in the conversion configurations table, obtains predetermined format data.
The declaration form record acquiring unit is specifically used for being changed according to the lookup of the field contents of the conversion configurations table
Declaration form account information corresponding declaration form record, and the declaration form is recorded in one credit of write-in.
It is described to judge that package module 22 is specifically used for whether judging to be currently used in the timed task switch for controlling data upload
Start, if starting, obtain the predetermined format data, and increase header and message on the head of the predetermined format data,
Obtain two times transfer data.
First uploading module 24 includes:
Resolution unit judges the check information for verification successful information or school for parsing the check information being currently received
Test failure information;
First execution unit, for if verification successful information, then receiving the first state code of data platform return and will be described
Secondary conversion data are uploaded to the data platform, and send at the end of upload and to upload successful first notification information to specified
Contact number;
Second execution unit, for if verification failure information, then receiving the second conditional code of data platform return, concurrently serving
The second notification information of failure is passed to specified contact number.
Second uploading module 25 includes:
Query unit is obtained, for obtaining the interim table for uploading historical data for storing declaration form record, searches the interim table
Middle declaration form record uploads the maximum line number of historical data;
Searching unit is uploaded, for uploading the maximum line number of historical data in institute according to data volume and the declaration form record of this upload
State the beginning line number and terminate line number for searching that this is resumed in credit;
Second uploading unit, after to starting line number in the credit and terminating the declaration form record addition vernier between line number
It is assembled, the data after assembling is uploaded to the data platform.
In conclusion in data-updating method provided by the invention, system and storage medium, the data-updating method is logical
It crosses and obtains in each universal life insurance declaration form account the changed declaration form account information compared with proxima luce (prox. luc) declaration form account value, by institute
It states declaration form account information and is converted to predetermined format data, and an account is written into the corresponding declaration form record of the declaration form account information
In table;Judge to be currently used in whether the timed task switch that control data upload starts later, if starting, obtain described predetermined
Formatted data, and the predetermined format data are packaged to obtain secondary conversion data;Judging data update system later is
It is no to be connect with data platform, if so, receiving the check information of the data platform feedback;The school being currently received is parsed later
Test whether information is verification successful information, if so, the secondary conversion data are uploaded to the data platform;Acquisition is used for
The interim table that declaration form record uploads historical data is stored, uploading historical data according to the declaration form record in the interim table calculates institute
The declaration form record for needing to resume in credit is stated, the declaration form that need to currently resume record is uploaded to the data platform.It can immediately more
New daily declaration form is worth changed declaration form account information and corresponding declaration form record, and realizes data using interim table
Automatic breakpoint transmission avoids that data upload repetition occurs, ensures the correctness and integrality of data.
Certainly, one of ordinary skill in the art will appreciate that realizing all or part of flow in above-described embodiment method,
It is that can instruct related hardware by computer program(Such as processor, controller etc.)It completes, the program can store
In a computer-readable storage medium, which may include the flow such as above-mentioned each method embodiment when being executed.Its
Described in storage medium can be memory, magnetic disc, CD etc..
It should be understood that the application of the present invention is not limited to the above for those of ordinary skills can
With improvement or transformation based on the above description, all these modifications and variations should all belong to the guarantor of appended claims of the present invention
Protect range.
Claims (10)
1. a kind of data-updating method, which is characterized in that include the following steps:
The changed declaration form account information compared with proxima luce (prox. luc) declaration form account value is obtained in each universal life insurance declaration form account, it will
The declaration form account information is converted to predetermined format data, and an account is written in the corresponding declaration form record of the declaration form account information
In the table of family;
Judge to be currently used in whether the timed task switch that control data upload starts, if starting, obtains the predetermined format
Data, and the predetermined format data are packaged to obtain secondary conversion data;
Judge whether data update system connect with data platform, if so, receiving the check information of the data platform feedback;
Parse whether the check information being currently received is verification successful information, if so, the secondary conversion data are uploaded
To the data platform;
The interim table for uploading historical data for storing declaration form record is obtained, is uploaded and is gone through according to the declaration form record in the interim table
History data calculate the declaration form record for needing to resume in the credit, and the declaration form that need to currently resume record, which is uploaded to the data, puts down
Platform.
2. data-updating method according to claim 1, which is characterized in that described to obtain in each universal life insurance declaration form account
The declaration form account information is converted to pre- fix by the changed declaration form account information compared with proxima luce (prox. luc) declaration form account value
Formula data, and include by the step in corresponding declaration form record one credit of write-in of the declaration form account information:
Declaration form account value on the day of each universal life insurance declaration form account is compared with the declaration form account value of the previous day, is obtained
Changed declaration form account information;
Changed declaration form account information is converted into predetermined format data by pre-set record type rule;
According to the corresponding declaration form record of the changed declaration form account information of transformed predetermined format data acquisition, and will be described
In declaration form record one credit of write-in.
3. data-updating method according to claim 2, which is characterized in that described by pre-set record type rule
The step of changed declaration form account information is converted to predetermined format data include:
The conversion configurations table with preset structure is obtained, according in the field of conversion configurations table described in record type rule setting
Hold;
The conversion configurations table is written into according to the field contents of conversion configurations table in the changed declaration form account information got
In, obtain predetermined format data.
4. data-updating method according to claim 3, which is characterized in that described according to transformed predetermined format data
The corresponding declaration form record of changed declaration form account information is obtained, and the declaration form is recorded into the step in one credit of write-in
Including:
The corresponding declaration form record of changed declaration form account information is searched according to the field contents of the conversion configurations table, and will
In declaration form record one credit of write-in.
5. data-updating method according to claim 1, which is characterized in that the judgement is currently used in control data and uploads
Timed task switch whether start, if starting, obtain the predetermined format data, and carry out to the predetermined format data
Encapsulating the step of obtaining secondary conversion data includes:
Judge to be currently used in whether the timed task switch that control data upload starts, if starting, obtains the predetermined format
Data, and increase header and message on the head of the predetermined format data, obtain two times transfer data.
6. data-updating method according to claim 1, which is characterized in that described to parse the check information being currently received
Whether it is verification successful information, if so, the step of secondary conversion data are uploaded to the data platform includes:
The check information being currently received is parsed, judges the check information for verification successful information or verification failure information;
If verification successful information, then receives the first state code of data platform return and be uploaded to the secondary conversion data
The data platform, and sent at the end of upload and upload successful first notification information to specified contact number;
If verification failure information, then the second conditional code of data platform return is received, concurrently serves the second notice for passing failure
Information is to specified contact number.
7. data-updating method according to claim 6, which is characterized in that second notification information includes failed
Connect the list of factors of data platform and/or the list of factors of verification failure.
8. data-updating method according to claim 1, which is characterized in that described obtain uploads for storing declaration form record
The interim table of historical data, being uploaded in the historical data calculating credit according to the declaration form record in the interim table needs to resume
Declaration form record, by the declaration form that need to currently resume record be uploaded to the data platform the step of include:
The interim table for uploading historical data for storing declaration form record is obtained, declaration form record in the interim table is searched and uploads history
The maximum line number of data;
The maximum line number that historical data is uploaded according to the data volume of this upload and declaration form record searches this in the credit
The secondary beginning line number resumed and end line number;
To being assembled after starting the declaration form record addition vernier between line number and end line number in the credit, after assembling
Data be uploaded to the data platform.
9. a kind of data update system, which is characterized in that including:Processor, memory and communication bus;
The computer-readable program that can be executed by the processor is stored on the memory;
The communication bus realizes the connection communication between processor and memory;
The processor realizes the data update as described in claim 1-8 any one when executing the computer-readable program
Step in method.
10. a kind of computer readable storage medium, which is characterized in that the computer-readable recording medium storage there are one or
Multiple programs, one or more of programs can be executed by one or more processor, to realize that claim 1-8 such as appoints
The step in data-updating method described in meaning one.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810121653.3A CN108334614B (en) | 2018-02-07 | 2018-02-07 | Data updating method, system and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810121653.3A CN108334614B (en) | 2018-02-07 | 2018-02-07 | Data updating method, system and storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108334614A true CN108334614A (en) | 2018-07-27 |
CN108334614B CN108334614B (en) | 2020-11-24 |
Family
ID=62927043
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810121653.3A Active CN108334614B (en) | 2018-02-07 | 2018-02-07 | Data updating method, system and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108334614B (en) |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109284297A (en) * | 2018-10-29 | 2019-01-29 | 中译语通科技股份有限公司 | A kind of database intelligent updating method and system |
CN109377383A (en) * | 2018-08-31 | 2019-02-22 | 平安科技(深圳)有限公司 | Product data synchronous method, device, computer equipment and storage medium |
CN109542598A (en) * | 2018-11-08 | 2019-03-29 | 泰康保险集团股份有限公司 | Timing task management method and device |
CN110502257A (en) * | 2019-06-28 | 2019-11-26 | 国网浙江省电力有限公司湖州供电公司 | A kind of control of supervisory control of substation information and checking method |
CN111078684A (en) * | 2019-11-08 | 2020-04-28 | 泰康保险集团股份有限公司 | Policy fault compensation method, policy fault compensation device, policy fault compensation medium and policy fault compensation equipment |
CN111143295A (en) * | 2019-11-14 | 2020-05-12 | 泰康保险集团股份有限公司 | Policy information processing method, apparatus, device and storage medium |
CN111367982A (en) * | 2020-03-09 | 2020-07-03 | 深圳市万物云科技有限公司 | Method and device for importing TRIRIGA basic data, computer equipment and storage medium |
CN114118956A (en) * | 2021-11-22 | 2022-03-01 | 城云科技(中国)有限公司 | Data newly-added mail reminding method, device and application |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7933866B2 (en) * | 2007-09-06 | 2011-04-26 | International Business Machines Corporation | Systems, methods and software programs for data synchronization |
CN102096772A (en) * | 2011-01-30 | 2011-06-15 | 北京恒华伟业科技股份有限公司 | Smart client system of power transmission and transformation project |
CN102129478A (en) * | 2011-04-26 | 2011-07-20 | 广州从兴电子开发有限公司 | Database synchronization method and system thereof |
CN102929946A (en) * | 2012-09-27 | 2013-02-13 | 山东中创软件工程股份有限公司 | Data synchronization method, device and system |
CN106503974A (en) * | 2017-01-04 | 2017-03-15 | 泰康保险集团股份有限公司 | Transaction data processing method and device |
-
2018
- 2018-02-07 CN CN201810121653.3A patent/CN108334614B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7933866B2 (en) * | 2007-09-06 | 2011-04-26 | International Business Machines Corporation | Systems, methods and software programs for data synchronization |
CN102096772A (en) * | 2011-01-30 | 2011-06-15 | 北京恒华伟业科技股份有限公司 | Smart client system of power transmission and transformation project |
CN102129478A (en) * | 2011-04-26 | 2011-07-20 | 广州从兴电子开发有限公司 | Database synchronization method and system thereof |
CN102929946A (en) * | 2012-09-27 | 2013-02-13 | 山东中创软件工程股份有限公司 | Data synchronization method, device and system |
CN106503974A (en) * | 2017-01-04 | 2017-03-15 | 泰康保险集团股份有限公司 | Transaction data processing method and device |
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109377383A (en) * | 2018-08-31 | 2019-02-22 | 平安科技(深圳)有限公司 | Product data synchronous method, device, computer equipment and storage medium |
CN109284297A (en) * | 2018-10-29 | 2019-01-29 | 中译语通科技股份有限公司 | A kind of database intelligent updating method and system |
CN109542598A (en) * | 2018-11-08 | 2019-03-29 | 泰康保险集团股份有限公司 | Timing task management method and device |
CN110502257A (en) * | 2019-06-28 | 2019-11-26 | 国网浙江省电力有限公司湖州供电公司 | A kind of control of supervisory control of substation information and checking method |
CN111078684A (en) * | 2019-11-08 | 2020-04-28 | 泰康保险集团股份有限公司 | Policy fault compensation method, policy fault compensation device, policy fault compensation medium and policy fault compensation equipment |
CN111078684B (en) * | 2019-11-08 | 2023-07-18 | 泰康保险集团股份有限公司 | Policy fault compensation method, device, medium and equipment |
CN111143295A (en) * | 2019-11-14 | 2020-05-12 | 泰康保险集团股份有限公司 | Policy information processing method, apparatus, device and storage medium |
CN111143295B (en) * | 2019-11-14 | 2024-01-30 | 泰康保险集团股份有限公司 | Policy information processing method, device, equipment and storage medium |
CN111367982A (en) * | 2020-03-09 | 2020-07-03 | 深圳市万物云科技有限公司 | Method and device for importing TRIRIGA basic data, computer equipment and storage medium |
CN111367982B (en) * | 2020-03-09 | 2023-08-25 | 深圳市万物云科技有限公司 | Method, device, computer equipment and storage medium for importing TRRIGA basic data |
CN114118956A (en) * | 2021-11-22 | 2022-03-01 | 城云科技(中国)有限公司 | Data newly-added mail reminding method, device and application |
Also Published As
Publication number | Publication date |
---|---|
CN108334614B (en) | 2020-11-24 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108334614A (en) | A kind of data-updating method, system and storage medium | |
CN109285076A (en) | Intelligent core protects processing method, server and storage medium | |
US7818561B2 (en) | Sending service data to an RFID tag while an attached computer system is powered off | |
US8424016B2 (en) | Techniques to manage critical region interrupts | |
CN108563445B (en) | Application program code detection method and server | |
CN110764942A (en) | Multi-type data checking method, device, computer system and readable storage medium | |
WO2020000720A1 (en) | Server, packet processing method, program, and computer-readable storage medium | |
US9612617B1 (en) | Wearable computing device for managing and storing data | |
CN109146095A (en) | The treating method and apparatus of multiservice system problem | |
CN108197309A (en) | A kind of method, system and the readable storage medium storing program for executing of the storage of server assets information | |
CN109614426A (en) | Switching method, device and electronic equipment between multiple database | |
CN109918385A (en) | Tripartite's account checking method, electronic device and readable storage medium storing program for executing | |
CN113379391A (en) | Work order processing method and device, electronic equipment and computer readable storage medium | |
CN112596801B (en) | Transaction processing method, device, equipment, storage medium and database | |
US20090106459A1 (en) | Configuration identification tool and methods | |
CN108471433A (en) | A kind of synchronization message verification method of reseptance, system and the storage medium of configurationization | |
CN110019485A (en) | A kind of product data storage method, terminal device and storage medium | |
CN108230165A (en) | A kind of computational methods of account value, storage medium and terminal device | |
US11748354B2 (en) | Data shape confidence | |
CN114970476A (en) | Data processing method, system, electronic device and storage medium | |
CN110705241B (en) | Method, system, electronic device and storage medium for managing industrial labels | |
WO2021043091A1 (en) | Intelligent import method and apparatus for template table, and electronic device and computer readable storage medium | |
CN112686759A (en) | Account checking monitoring method, device, equipment and medium | |
CN111562974A (en) | Method, device and equipment for acquiring offline data and storage medium | |
TWM596902U (en) | Personnel data conversion system |
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 |