CN106528831A - Data pushing method and system - Google Patents
Data pushing method and system Download PDFInfo
- 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
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/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- 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
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.
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)
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)
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 |
-
2016
- 2016-11-22 CN CN201611032329.1A patent/CN106528831B/en active Active
Patent Citations (4)
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)
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 |