CN106528831A - Data pushing method and system - Google Patents

Data pushing method and system Download PDF

Info

Publication number
CN106528831A
CN106528831A CN201611032329.1A CN201611032329A CN106528831A CN 106528831 A CN106528831 A CN 106528831A CN 201611032329 A CN201611032329 A CN 201611032329A CN 106528831 A CN106528831 A CN 106528831A
Authority
CN
China
Prior art keywords
data
csc
product
converted
product library
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
Application number
CN201611032329.1A
Other languages
Chinese (zh)
Other versions
CN106528831B (en
Inventor
赵长春
鲁丽
徐磊
冯莱
宝龙
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Taikang Insurance Group Co Ltd
Original Assignee
Taikang Insurance Group Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Taikang Insurance Group Co Ltd filed Critical Taikang Insurance Group Co Ltd
Priority to CN201611032329.1A priority Critical patent/CN106528831B/en
Publication of CN106528831A publication Critical patent/CN106528831A/en
Application granted granted Critical
Publication of CN106528831B publication Critical patent/CN106528831B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention provides a data pushing method and system. The method comprises the following steps of: after a product library receives imported data, the data is converted into a preset data format and stored in the database of the product library; the product library converts the data in the database into data of a CSC (Computer Science Corporation) data format, and meanwhile, the data which is converted into the CSC data format is pushed to a CSC database; and the product library sends a trigger command to the CSC, after the CSC receives the trigger command, the data is read on batch from the CSC database, and the read data is converted into the data of a storage field format of a tariff. Therefore, the automatic pushing of the data can be realized, format conversion storage is automatically carried out, a product department does not need labors to carry out rate or current price data conversion, meanwhile, development personnel do not need to manually upload the data, data processing efficiency is improved, and manpower resources are saved.

Description

Data push method and system
Technical field
The present invention relates to communication technical field, more particularly to a kind of data push method and system.
Background technology
The core data of insurance products includes product rate and product present price, for per a insurance products, be required for by Product rate and product present price are stored in a danger core business system (Computer Science Corporation, below letter Claim:CSC in), the calculating of calculating and surrender present price in order to premium present price.
Existing product rate and product present price storing process are:The staff of product department needs will be per money insurance products Product rate and product present price be transformed in Excel file from Word format file by hand, then by Excel file directly to IT Developer, the files passe function of then being defined by IBMAS400 systems by developer is according to predefined data mould Excel file is uploaded to panel formula the volatile data base in IBMAS400 systems, then specifically changes work(by performing CSC Data in volatile data base can be transformed in actual Fee Schedule, the work of the staff and developer of product department is all very Complexity, artificial workload are very big.
The content of the invention
The present invention provides a kind of data push method and system, is deposited with the core data for solving insurance products in prior art Artificial workload big problem during storage.
In a first aspect, the present invention provides a kind of data push method, including:
After product library receives the data of importing, convert the data to default data form and be stored in the product In the data base in product storehouse;
Data in the data base are converted to a number for danger core business system CSC data form by the product library According to while being converted into the data-pushing of CSC data forms in CSC data bases;
The product library sends trigger command to the CSC;
After the CSC receives the trigger command, data are read in batches from the CSC data bases, the number that will be read According to the data storage of the storage field format for being converted to Fee Schedule in Fee Schedule.
Optionally, the form of the data of the importing is word forms or excel forms.
Optionally, the data in the data base are converted to a danger core business system CSC data lattice by the product library The data of formula, including:
Data in the data base are converted to the product library number of CSC data forms according to the mapping table for prestoring According to the mapping table is the corresponding relation between the data of the product rate and product present price and CSC data forms of every money product.
Optionally, the data of reading are converted to the data of the storage field format of Fee Schedule and expense is stored for the CSC In rate table, including:
The CSC obtains the corresponding process subprogram of different pieces of information, the correspondence for prestoring according to the corresponding relation for prestoring Relation is different product rate form and processes the corresponding relation between subprogram;
The CSC processes the number that the data of reading are converted to the storage field format of Fee Schedule for subprogram by what is obtained According to and store in Fee Schedule.
Optionally, it is described read data in batches from the CSC data bases after, also include:
Data not processed in the CSC data bases are determined according to the process mark that the data for reading are carried.
Second aspect, the present invention provide a kind of data delivery system, including:
Product library and danger core business system CSC;
The product library is used for:
After receiving the data of importing, convert the data to default data form and be stored in the product library In data base;
Data in the data base are converted to into a data for danger core business system CSC data form, while will turn The data-pushing of CSC data forms is changed to in CSC data bases;
Trigger command is sent to the CSC;
The CSC is used for:After receiving the trigger command, data are read in batches from the CSC data bases, will read Data be converted to Fee Schedule storage field format data and storage in Fee Schedule.
Optionally, the form of the data of the importing is word forms or excel forms.
Optionally, the product library specifically for:
The data in the data base are converted to according to the mapping table for prestoring for the data of CSC data forms, the mapping Table is the corresponding relation between the data of the product rate and product present price and CSC data forms of every money product.
Optionally, the CSC specifically for:
The corresponding process subprogram of different pieces of information is obtained according to the corresponding relation for prestoring, the corresponding relation for prestoring is not for With the corresponding relation between product rate form and process subprogram;
The data of reading are converted to into the data for storing field format of Fee Schedule and are deposited by the subprogram that processes for obtaining Store up in Fee Schedule.
Optionally, the CSC is additionally operable to:
After reading data in batches from the CSC data bases, determined according to the process mark that the data for reading are carried Not processed data in the CSC data bases.
Data push method and system that the present invention is provided, are converted to the data of importing needed for product library by product library The data of data form are simultaneously stored in the data base of product library, are then entered automatically row format and are converted to rear CSC data forms Data, while pushing the data of CSC data forms to CSC data bases, then triggering CSC carries out data conversion batch processing, and CSC connects After receiving triggering command, batch reads data, and the data of reading are converted to the data of the storage field format needed for Fee Schedule And store in Fee Schedule.So as to being capable of achieving the automatic push of data and entering automatically row format conversion storage, product department need not The conversion of rate or present price data is manually carried out, while carrying out the upload of data also without developer by hand, number is improve According to the efficiency for processing, human resourcess are saved.
Description of the drawings
In order to be illustrated more clearly that technical scheme of the invention or of the prior art, below will be to embodiment or prior art Needed for description, accompanying drawing to be used is briefly described, it should be apparent that, drawings in the following description are the one of the present invention A little embodiments, for those of ordinary skill in the art, without having to pay creative labor, can be with according to this A little accompanying drawings obtain other accompanying drawings.
Fig. 1 is the flow chart of data push method embodiment of the present invention;
Fig. 2 is the interaction diagrams of data push method embodiment of the present invention two;
Fig. 3 is the process schematic of batch processing in data push method embodiment two of the present invention;
Fig. 4 is the structural representation of data delivery system embodiment of the present invention.
Specific embodiment
To make the object, technical solutions and advantages of the present invention clearer, below in conjunction with the accompanying drawing in the present invention, to this Technical scheme in invention is clearly and completely described, it is clear that described embodiment is a part of embodiment of the invention, Rather than the embodiment of whole.Based on the embodiment in the present invention, those of ordinary skill in the art are not making creative labor The every other embodiment obtained under the premise of dynamic, belongs to the scope of protection of the invention.
Fig. 1 is the flow chart of data push method embodiment of the present invention, as shown in figure 1, the method for the present embodiment can be with Including:
After S101, product library receive the data of importing, convert data to default data form and be stored in product In the data base in storehouse.
Wherein, the form of the data of importing is word forms or excel forms, the data of importing be insurance products rate or The corresponding data of insurance products present price, default data form are the self-defining data form of product library.Product library is front end system System product library, supports being introduced directly into for the data forms such as word, excel.Specifically, product library converts data to default number According to form and it is stored in the data base of product library such as MYSQL database.
The data in data base are converted to the data of CSC data forms for S102, product library, while being converted into CSC numbers According to the data-pushing of form in CSC data bases.
Wherein, CSC data forms are common business-oriented language (Common Business Oriented Language, referred to as:COBOL the data) encrypted.Data in data base are converted to product library the data of CSC data forms, Specially:Data in data base are converted to product library the data of CSC data forms according to the mapping table for prestoring, and mapping table is The corresponding relation between product rate and the data of product present price and CSC data forms per money product.While conversion, product Storehouse is converted into the data-pushing of CSC data forms in CSC data bases, and CSC is responsible for reading data from CSC data bases.
S103, product library send trigger command to CSC.
Product library sends trigger command to CSC, i.e., exactly triggering calls the processing unit of CSC to carry out batch processing.
After S104, CSC receive trigger command, read data from CSC data bases in batches, the data of reading are converted to The data of the storage field format of Fee Schedule are simultaneously stored in Fee Schedule.
Wherein, CSC the data of reading is converted to the data of the storage field format of Fee Schedule and is stored in Fee Schedule, Specially:CSC first obtains the corresponding process subprogram of different pieces of information according to the corresponding relation for prestoring, and the corresponding relation for prestoring is Corresponding relation between different product rate form and process subprogram, the different sub- journey of process of different rate form correspondences Sequence.Then CSC by obtain process subprogram by the data of reading be converted to Fee Schedule storage field format data simultaneously Store in Fee Schedule.
Further, after reading data in batches from CSC data bases in S104, also include:
Data not processed in CSC data bases are determined according to the process mark that the data for reading are carried.Be exactly into Row data filtering, filters out not processed data i.e. new data, new data is changed, and is converted to the storage word of Fee Schedule The data of paragraph format are simultaneously stored in Fee Schedule.
Further, CSC by read data conversion and storage in Fee Schedule after, product library can be also sent to CSC Query statement is to inquire about transformation result, and records transformation result.
The data of importing are converted to product library desired data by product library by the data push method that the present embodiment is provided The data of form are simultaneously stored in the data base of product library, then enter automatically the data that row format is converted to rear CSC data forms, The data of CSC data forms are pushed simultaneously to CSC data bases, and then triggering CSC carries out data conversion batch processing, and CSC is received After triggering command, batch reads data, the data of reading is converted to the data of the storage field format needed for Fee Schedule and is deposited Store up in Fee Schedule.So as to being capable of achieving the automatic push of data and entering automatically row format conversion storage, product department need not be artificial The conversion of rate or present price data is carried out, while carrying out the upload of data also without developer by hand, is improve at data The efficiency of reason, saves human resourcess.
A specific embodiment is adopted below, and the technical scheme of embodiment of the method shown in Fig. 1 is described in detail.
Fig. 2 is the interaction diagrams of data push method embodiment of the present invention two, as shown in Fig. 2 the method for the present embodiment Can include:
After S201, product library receive the data of importing, convert data to default data form and be stored in product In the data base in storehouse.
The data in data base are converted to the data of CSC data forms for S202, product library.
S203, product library are converted into the data-pushing of CSC data forms in CSC data bases.
S204, product library call importing batch processing.
It is exactly that product library sends trigger command to CSC.
After S205, CSC receive trigger command, data batch processing is carried out.
Specifically, Fig. 3 is the process schematic of batch processing in data push method embodiment two of the present invention, such as Fig. 3 institutes Show, tables of data one and tables of data two are two tables in CSC data bases, product library is responsible for propelling data to the two tables, CSC is negative Duty reads data from the two tables, a deposit data in two tables, the corresponding Chinese description of deposit data, correspondingly, takes Rate table also includes two, Fee Schedule one and Fee Schedule two.CSC reads data from tables of data one and tables of data two in batches, will read The data for taking are converted to the data of the storage field format of Fee Schedule and store in Fee Schedule one and Fee Schedule two.Data turn The conversion process process for the treatment of progress and the corresponding Chinese description of data is changed while carrying out.
Specifically, CSC first obtains the sub- journey of the corresponding process of different pieces of information from allocation list according to the corresponding relation for prestoring Sequence, stores each and processes subprogram and the mapping table for prestoring in allocation list, the corresponding relation for prestoring is different product rate Corresponding relation between form and process subprogram, the different process subprogram of different rate form correspondences.Then CSC passes through The data of reading are converted to the data for storing field format of Fee Schedule and store Fee Schedule one by the subprogram that processes of acquisition In Fee Schedule two.
S206, product library poll CSC results.
That is product library sends query statement to CSC to inquire about batch processing result, and batch processing result is stored in a danger of CSC and looks into In inquiry, individual danger inquiry is serviced for the webservice of CSC, provides functional interface for product library.
S207, record CSC results.
Fig. 4 is the structural representation of data delivery system embodiment of the present invention, as shown in figure 4, the device of the present embodiment Can include:Product library 11 and CSC12, wherein, product library 11 is used for:After receiving the data of importing, convert data to pre- If data form and be stored in the data base of product library.Data in data base are converted to into a danger core business system The data of CSC data forms, while being converted into the data-pushing of CSC data forms in CSC data bases.Send to CSC and touch Say the word.
CSC12 is used for:After receiving trigger command, data are read from CSC data bases in batches, the data conversion that will be read For Fee Schedule storage field format data and storage in Fee Schedule.
Wherein, the form of the data of importing is word forms or excel forms.
Further, product library 11 specifically for:
The data in data base are converted to according to the mapping table for prestoring for the data of CSC data forms, mapping table is every money Corresponding relation between the data of the product rate and product present price and CSC data forms of product.
CSC12 specifically for:CSC obtains the corresponding process subprogram of different pieces of information according to the corresponding relation for prestoring, and prestores Corresponding relation be different product rate form and process subprogram between corresponding relation;
The data of reading are converted to the data of the storage field format of Fee Schedule simultaneously by the process subprogram for obtaining for CSC Store in Fee Schedule.
Further, CSC is additionally operable to:After reading data in batches from CSC data bases, carried according to the data for reading Process mark and determine not processed data in CSC data bases.
The device of the present embodiment, can be used for performing the technical scheme of embodiment of the method shown in Fig. 3, and which realizes principle class Seemingly, here is omitted.
The data of importing are converted to product library desired data lattice by product library by the data delivery system that the present invention is provided The data of formula are simultaneously stored in the data base of product library, then enter automatically the data that row format is converted to rear CSC data forms, together When push CSC data forms data arrive CSC data bases, then triggering CSC carry out data conversion batch processing, CSC receives tactile After sending instructions, batch reads data, the data of reading is converted to the data of the storage field format needed for Fee Schedule and is stored To in Fee Schedule.So as to being capable of achieving the automatic push of data and entering automatically row format conversion storage, product department manually need not enter The conversion of row rate or present price data, while carrying out the upload of data also without developer by hand, improves data processing Efficiency, save human resourcess.
One of ordinary skill in the art will appreciate that:Realize that all or part of step of above-mentioned each method embodiment can be led to Cross the related hardware of programmed instruction to complete.Aforesaid program can be stored in a computer read/write memory medium.The journey Sequence upon execution, performs the step of including above-mentioned each method embodiment;And aforesaid storage medium includes:ROM, RAM, magnetic disc or Person's CD etc. is various can be with the medium of store program codes.
Finally it should be noted that:Various embodiments above only to illustrate technical scheme, rather than a limitation;To the greatest extent Pipe has been described in detail to the present invention with reference to foregoing embodiments, it will be understood by those within the art that:Its according to So the technical scheme described in foregoing embodiments can be modified, or which part or all technical characteristic are entered Row equivalent;And these modifications or replacement, do not make the essence of appropriate technical solution depart from various embodiments of the present invention technology The scope of scheme.

Claims (10)

1. a kind of data push method, it is characterised in that include:
After product library receives the data of importing, convert the data to default data form and be stored in the product library Data base in;
Data in the data base are converted to a data for danger core business system CSC data form by the product library, together When be converted into the data-pushing of CSC data forms in CSC data bases;
The product library sends trigger command to the CSC;
After the CSC receives the trigger command, data are read in batches from the CSC data bases, the data for reading are turned It is changed to the data of the storage field format of Fee Schedule and stores in Fee Schedule.
2. method according to claim 1, it is characterised in that the form of the data of the importing be word forms or Excel forms.
3. method according to claim 1, it is characterised in that the data in the data base are converted to by the product library The data of individual dangerous core business system CSC data form, including:
Data in the data base are converted to the product library data of CSC data forms, institute according to the mapping table for prestoring State the corresponding relation between the data of product rate and product present price and CSC data forms that mapping table is every money product.
4. method according to claim 1, it is characterised in that the data of reading are converted to depositing for Fee Schedule by the CSC The data of storage field format are simultaneously stored in Fee Schedule, including:
The CSC obtains the corresponding process subprogram of different pieces of information, the corresponding relation for prestoring according to the corresponding relation for prestoring For the corresponding relation between different product rate form and process subprogram;
The data of reading are converted to the data of the storage field format of Fee Schedule simultaneously by the process subprogram for obtaining for the CSC Store in Fee Schedule.
5. method according to claim 4, it is characterised in that it is described read from the CSC data bases in batches data it Afterwards, also include:
Data not processed in the CSC data bases are determined according to the process mark that the data for reading are carried.
6. a kind of data delivery system, it is characterised in that include:
Product library and danger core business system CSC;
The product library is used for:
After receiving the data of importing, convert the data to default data form and be stored in the data of the product library In storehouse;
Data in the data base are converted to into a data for danger core business system CSC data form, while being converted into The data-pushing of CSC data forms is in CSC data bases;
Trigger command is sent to the CSC;
The CSC is used for:After receiving the trigger command, data are read in batches from the CSC data bases, the number that will be read According to the data storage of the storage field format for being converted to Fee Schedule in Fee Schedule.
7. system according to claim 6, it is characterised in that the form of the data of the importing be word forms or Excel forms.
8. system according to claim 6, it is characterised in that the product library specifically for:
The data in the data base are converted to according to the mapping table for prestoring for the data of CSC data forms, the mapping table is The corresponding relation between product rate and the data of product present price and CSC data forms per money product.
9. system according to claim 6, it is characterised in that the CSC specifically for:
The corresponding process subprogram of different pieces of information is obtained according to the corresponding relation for prestoring, the corresponding relation for prestoring is different products Corresponding relation between product rate form and process subprogram;
The data storage that the data of reading are converted to the storage field format of Fee Schedule by the process subprogram for obtaining are arrived In Fee Schedule.
10. system according to claim 9, it is characterised in that the CSC is additionally operable to:
After reading data in batches from the CSC data bases, according to the process mark of the data carrying read is determined Not processed data in CSC data bases.
CN201611032329.1A 2016-11-22 2016-11-22 Data pushing method and system Active CN106528831B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201611032329.1A CN106528831B (en) 2016-11-22 2016-11-22 Data pushing method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201611032329.1A CN106528831B (en) 2016-11-22 2016-11-22 Data pushing method and system

Publications (2)

Publication Number Publication Date
CN106528831A true CN106528831A (en) 2017-03-22
CN106528831B CN106528831B (en) 2020-03-13

Family

ID=58356183

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201611032329.1A Active CN106528831B (en) 2016-11-22 2016-11-22 Data pushing method and system

Country Status (1)

Country Link
CN (1) CN106528831B (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107465601A (en) * 2017-08-18 2017-12-12 武汉斗鱼网络科技有限公司 Pushed information processing method and processing device
CN108984759A (en) * 2018-07-19 2018-12-11 北京中电普华信息技术有限公司 A kind of data transfer device, device and electronic equipment
WO2019000984A1 (en) * 2017-06-26 2019-01-03 平安科技(深圳)有限公司 Data matching method and apparatus, server, and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103136173A (en) * 2011-11-29 2013-06-05 北京建龙重工集团有限公司 Method converting mass word or excel format form documents into webpages
CN103226545A (en) * 2013-04-19 2013-07-31 中国建设银行股份有限公司 Data format conversion system, and method and system for batch loans information import
CN104503992A (en) * 2014-12-04 2015-04-08 明博教育科技有限公司 Question bank construction method
CN105354314A (en) * 2015-11-10 2016-02-24 中国建设银行股份有限公司 Data migration method and device

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103136173A (en) * 2011-11-29 2013-06-05 北京建龙重工集团有限公司 Method converting mass word or excel format form documents into webpages
CN103226545A (en) * 2013-04-19 2013-07-31 中国建设银行股份有限公司 Data format conversion system, and method and system for batch loans information import
CN104503992A (en) * 2014-12-04 2015-04-08 明博教育科技有限公司 Question bank construction method
CN105354314A (en) * 2015-11-10 2016-02-24 中国建设银行股份有限公司 Data migration method and device

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2019000984A1 (en) * 2017-06-26 2019-01-03 平安科技(深圳)有限公司 Data matching method and apparatus, server, and storage medium
CN107465601A (en) * 2017-08-18 2017-12-12 武汉斗鱼网络科技有限公司 Pushed information processing method and processing device
CN107465601B (en) * 2017-08-18 2020-09-04 武汉斗鱼网络科技有限公司 Push information processing method and device
CN108984759A (en) * 2018-07-19 2018-12-11 北京中电普华信息技术有限公司 A kind of data transfer device, device and electronic equipment

Also Published As

Publication number Publication date
CN106528831B (en) 2020-03-13

Similar Documents

Publication Publication Date Title
CN108536761B (en) Report data query method and server
CN105205117B (en) A kind of tables of data moving method and device
CN106844682B (en) Method for interchanging data, apparatus and system
CN101571861B (en) Method and device for converting data table
CN106528831A (en) Data pushing method and system
CN104317928A (en) Service ETL (extraction-transformation-loading) method and service ETL system both based on distributed database
CN101697216A (en) Importing method of product data management data and enterprise resource planning system
CN107918621A (en) Daily record data processing method, device and operation system
CN107526806A (en) The conversion method and device of data
CN104657164B (en) Software upgrading treating method and apparatus
CN110233741A (en) Service charging method, device, equipment and storage medium
CN103051768A (en) Method and system for updating contact ways in address book
CN103605663A (en) General database checking and metadata loading method
CN107798120B (en) Data conversion method and device
CN102541997A (en) Database execution method and system for automatic database partitioning
CN110930204A (en) Invoice issuing method and system
CN103577583A (en) Method for efficiently calculating number of users through large data
CN101702207A (en) Attendance calculating method and device
CN112348568A (en) Centralized management platform and method for account number of advertisement putting platform
CN104486444A (en) Heterogeneous API conversion system for cloud management platforms
CN105630997A (en) Data parallel processing method, device and equipment
CN105095224A (en) Method, apparatus and system for carrying out OLAP analysis in mobile communication network
CN104360899B (en) A kind of process management system and management method
CN106649590A (en) Method and apparatus of processing storage space of database
CN105847329A (en) Stock data server based management device and method

Legal Events

Date Code Title Description
C06 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