CN107766456A - Data parsing converting system and method based on file interaction between supplementary pension system - Google Patents

Data parsing converting system and method based on file interaction between supplementary pension system Download PDF

Info

Publication number
CN107766456A
CN107766456A CN201710887910.XA CN201710887910A CN107766456A CN 107766456 A CN107766456 A CN 107766456A CN 201710887910 A CN201710887910 A CN 201710887910A CN 107766456 A CN107766456 A CN 107766456A
Authority
CN
China
Prior art keywords
flow
module
file
data
interaction
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201710887910.XA
Other languages
Chinese (zh)
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.)
Shandong Inspur Genersoft Information Technology Co Ltd
Original Assignee
Shandong Inspur Genersoft Information Technology 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 Shandong Inspur Genersoft Information Technology Co Ltd filed Critical Shandong Inspur Genersoft Information Technology Co Ltd
Priority to CN201710887910.XA priority Critical patent/CN107766456A/en
Publication of CN107766456A publication Critical patent/CN107766456A/en
Pending legal-status Critical Current

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Data parsing converting system and method, the system of the present invention offer based on file interaction between supplementary pension system include three parts:Data conversion flow elements, document analysis Rule section, message interaction part, wherein:Data conversion flow elements, it is responsible for the data conversion flow of defining interface, different data conversion flows is defined according to different interface rules;The specification verification of document analysis Rule section, the document analysis rule of responsible defining interface, including interface document, dictionary conversion, document analysis, data conversion;Message interaction part, data conversion module and the message transfer mechanism of operation system are defined, the initiation and interaction of business are carried out by message.The present invention greatly improves the efficiency and accuracy that domestic annuity operating agency handles service order of being commissioned, change for interface requirements can accomplish fast reaction, the problem of being parsed for interaction when changing part can accomplish fast positioning and initiate again, be obviously improved the stability and agility of system operation.

Description

Data parsing converting system and method based on file interaction between supplementary pension system
Technical field
The present invention relates to data parsing switch technology field, and in particular to one kind is based on file interaction between supplementary pension system Data parsing converting system and method.
Background technology
With the increasing business operation amount of supplementary pension, the transmission instructed by Email and feedback are Actual effect and the requirement of accuracy of business processing can not be met again, each system file interaction is direct-connected between industry becomes enterprise's year The trend of each mechanism instruction interaction of gold, but each train of mechanism file interaction is regular and each accessible file format of system is each not Identical, this just brings problem to the file interaction of each train of mechanism part.
The content of the invention
In order to solve the above technical problems, the present invention proposes a kind of data of file interaction between system based on supplementary pension Parse converting system and method, one can the data conversion module of adaptive configuration be commissioned to handle account management system with difference The file interaction of mechanism, accomplish to be suitable for the data conversion of configuration for different pieces of information file, support different interface documents to hand over Mutually rule, has good autgmentability.
The technical scheme is that:
Data based on file interaction between supplementary pension system parse converting system, and the system includes three parts:Data turn Change of current journey, document analysis rule, message interaction, wherein:
Data conversion flow, it is responsible for the data conversion flow of defining interface, different data is defined according to different interface rules Flow path switch;
Document analysis rule, it is responsible for the document analysis rule of defining interface, includes specification verification, the dictionary turn of interface document Change, document analysis, data conversion;
Message interaction, data conversion module and the message transfer mechanism of operation system are defined, the initiation of business is carried out by message And interaction.
The database table of the data conversion flow includes:Three flow template table, flow instance table, module scheme table portions Point, wherein:
Flow template table includes flow template service code, flow order, module I D, module scheme ID, remarks;
Flow instance table includes:It is flow ID, flow template service code, flow order, module I D, module scheme ID, state, standby Note, update date;
Module scheme table includes:Module I D, corresponding scheme ID, module title, module scheme title, module scheme class name, module Scheme class.path, remarks, update date.
The database table of the document analysis rule includes:Data file transition template table, content data file table, its In:
Data file transition template table includes:Scheme ID, transform class, class of service, sequence number, data item numbering, data item name Title, DB corresponding fields, type, length, whether must fill out, remarks, renewal time;
Content data file table includes:ID, flow ID, scheme ID, class of service, sequence number, value 1, value 2 ..., remarks.
The database table of the message interaction includes:ID, flow ID, service request sequence number, message classification, incoming message Content, outgoing message content, feedback result, abnormality code, unexpected message, remarks, renewal time.
Data based on file interaction between supplementary pension system parse conversion method, and methods described is commissioned according to supplementary pension The actual interactive instruction situation of system and account management system, data parsing transfer process is independently formed into a module, makes this Module turns into the bridge of interaction between two systems, by formulating flow definition table initially various process steps and method, passes through system Determine document analysis and define table initially various analysis conditions, dictionary switch condition, verification condition, in file interaction according to corresponding Flow definition table constructional flow example table, and table resolution file content is defined according to document analysis, the conversion according to setting afterwards Flow carries out file conversion, reaches the requirement that account management system imports list.
It is as follows that methods described implementation process includes content:
Timer is set, sets two timers altogether, FTP scanning timers and flow perform timer;The FTP scannings are fixed When device call getFTPFile () method scanning FTP catalogues, start flow example;The flow performs timer and called afterwards It is the procedure links being not carried out that beginProcess () method, which performs state,;
Setting process template, 8 procedure links are set according to the interface specification, be that FTP obtains file module, decryption solution respectively Compression module, document analysis modular converter, message sending module, message receiving module, feedback file generation module, ciphered compressed Module, feedback file sending module;
Different interface specifications can be realized with self-defined procedure links, modules by reflex mechanism, customized personalization Module can carry out Expansion development, and the intermodule degree of coupling is low, can arbitrarily select to be combined;
Set the configuration information of each module:Set the configuration information of the FTP in timer module table, setting decryption decompression module Key and key effective date in table, set the field mapping relations, verification condition, dictionary mapping of data file transition module table Relation, setting message is sent and the address information of file push, the field mapping relations of setting feedback file generation, dictionary mapping Relation, the configuration information for the FTP that setting feedback file is sent;
Some file on the FTP scannings timer timing scan front end processor server, has file biography in this document presss from both sides It is defeated when coming, then obtain file and can voluntarily be selected according to flow template start flow example, inter-agency file.
The flow performs timer, and state has the flow instance for being not carried out link in querying flow example table, then Initiated since the link being not carried out.
Each mutual files correspond to a set of flow instance in methods described;
Asynchronous execution between flow instance, each module link in flow instance inside synchronously perform.
Methods described also includes:
In message receiving module, during more new state performs, stop follow-up process module link, accomplish flow instance " hang-up " Effect, after latency services system execution business, then the state of the link is updated to be finished;
Follow-up process performs timer by flow and initiated again, since intermediate link feedback file generation module, until anti- Feedback file push finishes, and whole flow process example terminates.
Beneficial effects of the present invention are:
By the present invention, the interactive requirements that annuity operating agency can be directed to different trustees flexibly set document analysis to change Flow and rule, efficiency and accuracy that domestic annuity operating agency handles service order of being commissioned are greatly improved, is needed for interface The change asked can accomplish fast reaction, and part can accomplish fast positioning and send out again the problem of during for interaction parsing conversion Rise, be obviously improved the stability and agility of system operation.
Brief description of the drawings
Fig. 1 is data conversion module overall flow figure;
Fig. 2 is flow template table;
Fig. 3 is flow instance table;
Fig. 4 is module scheme table;
Fig. 5 is data file transition template table;
Fig. 6 is content data file table;
Fig. 7 is message interaction database table.
Embodiment
With reference to Figure of description, more detailed elaboration is carried out to present disclosure:
Data based on file interaction between supplementary pension system parse converting system, it is characterised in that the system includes three Part:Data conversion flow elements, document analysis Rule section, message interaction part, wherein:
Data conversion flow elements, it is responsible for the data conversion flow of defining interface, is defined according to different interface rules different Data conversion flow;
Document analysis Rule section, it is responsible for the document analysis rule of defining interface, includes specification verification, the dictionary of interface document Conversion, document analysis, data conversion;
Message interaction part, data conversion module and the message transfer mechanism of operation system are defined, business is carried out by message Initiate and interactive.
The database table of the data conversion flow includes:Three flow template table, flow instance table, module scheme table portions Point, wherein:
As shown in Fig. 2 flow template table includes flow template service code, flow order, module I D, module scheme ID, remarks;
As Fig. 3 shows, flow instance table includes:Flow ID, flow template service code, flow order, module I D, module scheme ID, state, remarks, update date;
As Fig. 4 shows, module scheme table includes:Module I D, corresponding scheme ID, module title, module scheme title, module scheme class Name, module scheme class.path, remarks, update date.
The database table of the document analysis rule includes:Data file transition template table, content data file table, its In:
As Fig. 5 shows, data file transition template table includes:Scheme ID, transform class, class of service, sequence number, data item numbering, Data item title, DB corresponding fields, type, length, whether must fill out, remarks, renewal time;
As Fig. 6 shows, content data file table includes:ID, flow ID, scheme ID, class of service, sequence number, value 1, value 2 ..., it is standby Note.
As Fig. 7 shows, the database table of the message interaction includes:ID, flow ID, service request sequence number, message classification, Incoming message content, outgoing message content, feedback result, abnormality code, unexpected message, remarks, renewal time.
As Fig. 1 shows, the data based on file interaction between supplementary pension system parse conversion method, and methods described is according to enterprise The actual interactive instruction situation of annuity trusted systems and account management system, data parsing transfer process is independently formed into a mould Block, the module is set to turn into the bridge of interaction between two systems, by formulating flow definition table initially various process steps and method, Define table initially various analysis conditions, dictionary switch condition, verification condition by formulating document analysis, in file interaction according to Corresponding flow definition table constructional flow example table, and table resolution file content is defined according to document analysis, afterwards according to setting Flow path switch carry out file conversion, reach account management system import list requirement.
It is as follows that methods described implementation process includes content:
Timer is set, sets two timers altogether, FTP scanning timers and flow perform timer;The FTP scannings are fixed When device call getFTPFile () method scanning FTP catalogues, start flow example;The flow performs timer and called afterwards It is the procedure links being not carried out that beginProcess () method, which performs state,;
Setting process template, 8 procedure links are set according to the interface specification, be that FTP obtains file module, decryption solution respectively Compression module, document analysis modular converter, message sending module, message receiving module, feedback file generation module, ciphered compressed Module, feedback file sending module;
Different interface specifications can be realized with self-defined procedure links, modules by reflex mechanism, customized personalization Module can carry out Expansion development, and the intermodule degree of coupling is low, can arbitrarily select to be combined;
Set the configuration information of each module:Set the configuration information of the FTP in timer module table, setting decryption decompression module Key and key effective date in table, set the field mapping relations, verification condition, dictionary mapping of data file transition module table Relation, setting message is sent and the address information of file push, the field mapping relations of setting feedback file generation, dictionary mapping Relation, the configuration information for the FTP that setting feedback file is sent;
Some file on the FTP scannings timer timing scan front end processor server, has file biography in this document presss from both sides It is defeated then to obtain file and voluntarily be selected according to flow template start flow example, inter-agency file when coming, than Such as Shenzhen Stock Exchange can be used to lead to data interchange platform.
The flow performs timer, and state has the flow instance for being not carried out link in querying flow example table, then Initiated since the link being not carried out.
Each mutual files correspond to a set of flow instance in methods described;
Asynchronous execution between flow instance, each module link in flow instance inside synchronously perform.
Methods described also includes:
In message receiving module, during more new state performs, stop follow-up process module link, accomplish flow instance " hang-up " Effect, after latency services system execution business, then the state of the link is updated to be finished;
Follow-up process performs timer by flow and initiated again, since intermediate link feedback file generation module, until anti- Feedback file push finishes, and whole flow process example terminates.
The preferred implementation method of the present invention is the foregoing is only, but is not limited to this, it will be understood by those skilled in the art that this Invention implementation method can have various change.Within the spirit and principles of the invention, any modification for being made, equally replace Change, improve, should be included in the scope of the protection.

Claims (10)

1. the data based on file interaction between supplementary pension system parse converting system, it is characterised in that the system includes three Individual part:Data conversion flow elements, document analysis Rule section, message interaction part, wherein:
Data conversion flow elements, it is responsible for the data conversion flow of defining interface, is defined according to different interface rules different Data conversion flow;
Document analysis Rule section, it is responsible for the document analysis rule of defining interface, includes specification verification, the dictionary of interface document Conversion, document analysis, data conversion;
Message interaction part, data conversion module and the message transfer mechanism of operation system are defined, business is carried out by message Initiate and interactive.
2. the data parsing converting system of file interaction, its feature between the system according to claim 1 based on supplementary pension It is, the database table of the data conversion flow includes:Three flow template table, flow instance table, module scheme table parts, Wherein:
Flow template table includes flow template service code, flow order, module I D, module scheme ID, remarks;
Flow instance table includes:It is flow ID, flow template service code, flow order, module I D, module scheme ID, state, standby Note, update date;
Module scheme table includes:Module I D, corresponding scheme ID, module title, module scheme title, module scheme class name, module Scheme class.path, remarks, update date.
3. the data parsing converting system of file interaction, its feature between the system according to claim 1 based on supplementary pension It is, the database table of the document analysis rule includes:Data file transition template table, content data file table, wherein:
Data file transition template table includes:Scheme ID, transform class, class of service, sequence number, data item numbering, data item name Title, DB corresponding fields, type, length, whether must fill out, remarks, renewal time;
Content data file table includes:ID, flow ID, scheme ID, class of service, sequence number, value 1, value 2 ..., remarks.
4. the data parsing converting system of file interaction, its feature between the system according to claim 1 based on supplementary pension It is, the database table of the message interaction includes:ID, flow ID, service request sequence number, message classification, in incoming message Appearance, outgoing message content, feedback result, abnormality code, unexpected message, remarks, renewal time.
5. the data based on file interaction between supplementary pension system based on any of the above-described claim parse conversion method, it is special Sign is, methods described is according to the actual interactive instruction situations of supplementary pension trusted systems and account management system, by data solution Analysis transfer process independently forms a module, the module is turned into the bridge of interaction between two systems, by formulating flow definition Table initially various process steps and method, by formulate document analysis define table initially various analysis conditions, dictionary switch condition, Verification condition, in file interaction according to corresponding flow definition table constructional flow example table, and table is defined according to document analysis Resolution file content, the flow path switch progress file conversion according to setting, reaches account management system and imports wanting for list afterwards Ask.
6. the data parsing conversion method of file interaction, its feature between the system according to claim 5 based on supplementary pension It is, it is as follows that methods described implementation process includes content:
Timer is set, sets two timers altogether, FTP scanning timers and flow perform timer;
Setting process template, 8 procedure links are set according to the interface specification, be that FTP obtains file module, decryption solution respectively Compression module, document analysis modular converter, message sending module, message receiving module, feedback file generation module, ciphered compressed Module, feedback file sending module;
Set the configuration information of each module:Set the configuration information of the FTP in timer module table, setting decryption decompression module Key and key effective date in table, set the field mapping relations, verification condition, dictionary mapping of data file transition module table Relation, setting message is sent and the address information of file push, the field mapping relations of setting feedback file generation, dictionary mapping Relation, the configuration information for the FTP that setting feedback file is sent.
7. the data parsing conversion method of file interaction, its feature between the system according to claim 6 based on supplementary pension It is some file on the FTP scannings timer timing scan front end processor server, there is file biography in this document presss from both sides It is defeated when coming, then obtain file and can voluntarily be selected according to flow template start flow example, inter-agency file.
8. the data parsing conversion method of file interaction, its feature between the system according to claim 6 based on supplementary pension It is, the flow performs timer, and state has the flow instance for being not carried out link in querying flow example table, then never The link of execution starts to initiate.
9. conversion method is parsed according to any described data based on file interaction between supplementary pension system of claim 5-8, Characterized in that, each mutual files correspond to a set of flow instance in methods described;
Asynchronous execution between flow instance, each module link in flow instance inside synchronously perform.
10. the data parsing conversion method of file interaction, its feature between the system according to claim 9 based on supplementary pension It is, methods described also includes:
In message receiving module, during more new state performs, stop follow-up process module link, accomplish flow instance " hang-up " Effect, after latency services system execution business, then the state of the link is updated to be finished;
Follow-up process performs timer by flow and initiated again, since intermediate link feedback file generation module, until anti- Feedback file push finishes, and whole flow process example terminates.
CN201710887910.XA 2017-09-27 2017-09-27 Data parsing converting system and method based on file interaction between supplementary pension system Pending CN107766456A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710887910.XA CN107766456A (en) 2017-09-27 2017-09-27 Data parsing converting system and method based on file interaction between supplementary pension system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710887910.XA CN107766456A (en) 2017-09-27 2017-09-27 Data parsing converting system and method based on file interaction between supplementary pension system

Publications (1)

Publication Number Publication Date
CN107766456A true CN107766456A (en) 2018-03-06

Family

ID=61266122

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710887910.XA Pending CN107766456A (en) 2017-09-27 2017-09-27 Data parsing converting system and method based on file interaction between supplementary pension system

Country Status (1)

Country Link
CN (1) CN107766456A (en)

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106600149A (en) * 2016-12-16 2017-04-26 东软集团股份有限公司 Process analysis method and apparatus
CN108595391A (en) * 2018-04-28 2018-09-28 中国建设银行股份有限公司 A kind of data information conversion method and device
CN108984757A (en) * 2018-07-18 2018-12-11 上海汉得信息技术股份有限公司 A kind of data lead-in method and equipment
CN109189843A (en) * 2018-08-02 2019-01-11 浪潮通用软件有限公司 Take the method that button receives file request and resolution response based on supplementary pension system account pipe
CN109344123A (en) * 2018-10-23 2019-02-15 山东浪潮云信息技术有限公司 A kind of data interactive method based on catalogue file
CN109657222A (en) * 2018-12-14 2019-04-19 泰康保险集团股份有限公司 For generating the method and system of report
CN112511591A (en) * 2020-10-30 2021-03-16 福建亿能达信息技术股份有限公司 Method, device, equipment and medium for realizing hospital interface data interaction

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6677963B1 (en) * 1999-11-16 2004-01-13 Verizon Laboratories Inc. Computer-executable method for improving understanding of business data by interactive rule manipulation
CN101309178A (en) * 2008-07-03 2008-11-19 中兴通讯股份有限公司 Parsing method and apparatus for automatic exchanging optical network systematic log information
CN105407163A (en) * 2015-11-30 2016-03-16 中国建设银行股份有限公司 Data processing system and method for anti-money laundering processing
US9335911B1 (en) * 2014-12-29 2016-05-10 Palantir Technologies Inc. Interactive user interface for dynamic data analysis exploration and query processing
CN106850758A (en) * 2016-12-30 2017-06-13 广州慧扬信息系统科技有限公司 It is applied to the method for interchanging data of hospital information system

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6677963B1 (en) * 1999-11-16 2004-01-13 Verizon Laboratories Inc. Computer-executable method for improving understanding of business data by interactive rule manipulation
CN101309178A (en) * 2008-07-03 2008-11-19 中兴通讯股份有限公司 Parsing method and apparatus for automatic exchanging optical network systematic log information
US9335911B1 (en) * 2014-12-29 2016-05-10 Palantir Technologies Inc. Interactive user interface for dynamic data analysis exploration and query processing
CN105407163A (en) * 2015-11-30 2016-03-16 中国建设银行股份有限公司 Data processing system and method for anti-money laundering processing
CN106850758A (en) * 2016-12-30 2017-06-13 广州慧扬信息系统科技有限公司 It is applied to the method for interchanging data of hospital information system

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
赵华伟: ""数据交换与共享平台及其中间件的研究与实现"", 《中国优秀硕士学位论文全文数据库-信息科技辑》 *

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106600149A (en) * 2016-12-16 2017-04-26 东软集团股份有限公司 Process analysis method and apparatus
CN106600149B (en) * 2016-12-16 2020-03-06 东软集团股份有限公司 Process analysis method and device
CN108595391A (en) * 2018-04-28 2018-09-28 中国建设银行股份有限公司 A kind of data information conversion method and device
CN108984757A (en) * 2018-07-18 2018-12-11 上海汉得信息技术股份有限公司 A kind of data lead-in method and equipment
CN109189843A (en) * 2018-08-02 2019-01-11 浪潮通用软件有限公司 Take the method that button receives file request and resolution response based on supplementary pension system account pipe
CN109344123A (en) * 2018-10-23 2019-02-15 山东浪潮云信息技术有限公司 A kind of data interactive method based on catalogue file
CN109657222A (en) * 2018-12-14 2019-04-19 泰康保险集团股份有限公司 For generating the method and system of report
CN112511591A (en) * 2020-10-30 2021-03-16 福建亿能达信息技术股份有限公司 Method, device, equipment and medium for realizing hospital interface data interaction
CN112511591B (en) * 2020-10-30 2024-04-05 福建亿能达信息技术股份有限公司 Method, device, equipment and medium for realizing hospital interface data interaction

Similar Documents

Publication Publication Date Title
CN107766456A (en) Data parsing converting system and method based on file interaction between supplementary pension system
CN102546442B (en) Communication protocol conversion technology
NO20040856D0 (en) Automated system and method for preparing patent and assessment of technique
CN103716308B (en) Multiprotocol platform communication method and multiprotocol platform
CN108337236A (en) A kind of gRPC call methods and device based on Protobuf and HTTP/1.1
RU2007135827A (en) EXCHANGE OF INFORMATION BY A SET OF NETWORK ELEMENTS
CN109660377A (en) Unified configuring management method, service server and operation and maintenance management platform
CN110247901A (en) The cross-platform method for exempting from close sign-on access, system and equipment
Sirbu et al. Standards setting for computer communication: The case of X. 25
CN106095424B (en) The treating method and apparatus for calling of trading in application component
CN111343201A (en) Analysis method, device and system for rapidly adapting to protocol change
CN101303706A (en) Method and system for sharing data between modeling tool and simulation tool
JPH07141337A (en) Data communication network system
Rasmussen WDB---A Web Interface to Sybase
CN107231347B (en) A kind of method and system of data streaming services
ATE395957T1 (en) ENTERTAINMENT SYSTEM AND DATA COMMUNICATION NETWORK SYSTEM
JPS63156284A (en) Automatic translation terminal equipment
KR101547346B1 (en) Synchronous/asynchronous communication for business integration, interoperation of dynamic professional management system
CN101764713A (en) Engine method of rule configuration for peripheral interfaces of convergent billing system
CN101706744A (en) Instruction analyzing device supporting multi-instruction set and instruction analyzing method thereof
CN114124588A (en) Interface data interaction device, method and system
JP2004206185A (en) Translation word determination system, translation word determination server, and method and program for determining translation word
US20060155804A1 (en) Method for establishing and conducting communication between a data source and a user
CN101600268A (en) A kind of system timing method and device
JP2020184098A (en) Interface apparatus and program

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
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20180306