CN109446223B - Data integration method among multiple systems - Google Patents
Data integration method among multiple systems Download PDFInfo
- Publication number
- CN109446223B CN109446223B CN201811092951.0A CN201811092951A CN109446223B CN 109446223 B CN109446223 B CN 109446223B CN 201811092951 A CN201811092951 A CN 201811092951A CN 109446223 B CN109446223 B CN 109446223B
- Authority
- CN
- China
- Prior art keywords
- interface
- data
- user information
- calling
- synchronization
- 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.)
- Active
Links
Images
Landscapes
- Telephonic Communication Services (AREA)
Abstract
In a plurality of systems, a set of data access and integration management application system is mainly configured among the systems, and a timing synchronization task is configured on the data access and integration management application system, wherein the timing synchronization task is configured with an interface calling address, a conversion rule and a synchronization task execution period which need to perform data synchronization, a data interface does not need to be developed on each software system, and the interface and the data which need to be exposed by the system are exposed to an external system for use in a configuration mode; when data on a software system is changed or more system data needs to be added for synchronization, the dynamic synchronization and integration of the data are realized only in a configuration mode without development.
Description
Technical Field
The invention belongs to the field of data integration among systems, relates to a data integration method among software systems, and particularly relates to a data integration method among multiple systems.
Background
Currently, for most data integration methods, two systems store their own user information, such as two software systems a and B, respectively, and it is assumed that there are two users with cell phone numbers of 15011111111 and 15022222222 in the user information of the system a. Suppose that there are two users with cell phone numbers 15011111111 and 15033333333 in the user information of the B system. When the user information between two systems needs to be synchronized, namely the user information of A is merged into B, and the user information of B is merged into A, so that the user information of the two systems is stored and synchronized to provide service for the user. The traditional data integration method is generally solved by the following solutions:
1. the system A provides a user information synchronization interface for the system B, and the system B provides a user information synchronization interface for the system A, so that bidirectional data synchronization is realized. In the synchronization process of the A and the B, because the same user exists, namely the user with the mobile phone number of 15011111111, the two systems need to respectively develop corresponding information copying and covering rules.
2. And the system C provides a data integration interface for the systems A and B, the systems A and B call the interface synchronization data of the system C, and finally, the system C provides a user information query interface for the systems A and B. The C system needs to develop corresponding information copy and overlay rules for the same user, such as the user with cell phone number 15011111111.
The above two schemes have the following technical disadvantages:
scheme 1: under the condition of multiple systems, the synchronous development amount of the user information is multiplied, and each system needs to develop a corresponding interface. For example, two software systems C and D are newly developed, which also store their own user information, and at this time, the systems C and D need to develop their respective user information synchronization interfaces for other system calls, and at the same time, the systems a and B can develop user information synchronization interfaces for calling the systems C and D to perform data synchronization.
Scheme 2: the expansion is inconvenient. Assuming that the user information fields are added or deleted in the system A or the system B, the interface of the system C needs to be developed and modified, and additionally, the information synchronization of the system needs to be added, such as the user information synchronization of the system D and the system E, and corresponding interface development and modification are also carried out.
Disclosure of Invention
Aiming at the defects of the prior art, the invention aims to provide a new type data integration method between multiple systems, and the technical problems to be solved by the invention are as follows: the invention provides a uniform data access solution without developing data interfaces on each software system, and the interfaces and data required to be exposed by the system are exposed to an external system for use in a configuration mode; when data on a software system is changed (fields are added or deleted), or more system data are required to be added for synchronization, development is not needed, and dynamic synchronization and integration of the data are realized only in a configuration mode. In order to solve the technical problems:
in one aspect, the present invention provides a method for integrating data between multiple systems, where the multiple systems are all configured with information synchronization interfaces, and the method is characterized in that: configuring a set of data access and integration management application systems among the systems, and configuring a timing synchronization task in the data access and integration management application systems, wherein the timing synchronization task configures an interface calling address, a conversion rule and a synchronization task execution period which need to perform data synchronization; in the process of the synchronous task execution cycle, the method comprises the following steps: calling any system interface based on the interface calling address to obtain the system user information; performing data conversion according to the conversion rule; calling an interface of a system needing synchronous information to synchronize the user information subjected to data conversion; and completing data integration among multiple systems.
Further, the multiple systems include a first system and a second system, and during the synchronous task execution cycle, the method specifically includes: calling the first system interface based on the interface calling address to obtain the first system user information; performing data conversion on the first system user information according to the conversion rule; calling an interface of the second system needing synchronous information to synchronize the first system user information after data conversion; and completing data integration synchronization between the first system and the second system.
Further, the interface calling address is a calling address of both interfaces.
Further, the conversion rule is an interface field conversion rule.
On the other hand, the invention also provides a method for integrating data among multiple systems, which is characterized by comprising the following steps: configuring a set of data access and integration management application system and a plurality of sets of front-end systems; configuring a timing synchronization task on the data access and integration management application system, wherein the timing synchronization task configures an interface calling address, a conversion rule and a synchronization task execution period which need to perform data synchronization; the plurality of sets of front-end systems are all configured to realize user database access and synchronous interface access; the data access and integration management application system comprises the following steps in the process of the synchronous task execution cycle: calling a front system interface corresponding to any system in the multiple systems to obtain user information, and inquiring user information of a system database through the front system; performing data conversion according to the conversion rule; calling a front system interface corresponding to another system in the multiple systems to synchronize the user information subjected to the data conversion; the front system corresponding to the other system calls the front system interface to synchronize the user information.
Further, the multiple systems comprise a first system and a second system which correspondingly comprise a first front-end system and a second front-end system; in the process of the synchronous task execution cycle, the method specifically includes: calling the first front system interface of the first system to obtain user information, and inquiring system database user information through the first front system; performing data conversion on the user information according to the conversion rule; calling the second front system interface of the second system to synchronize the user information subjected to the data conversion; and the second front-end system of the second system calls the second front-end system interface to synchronize the user information so as to complete the data integration synchronization between the first system and the second system.
Further, the interface calling address is a calling address of both interfaces.
Further, the conversion rule is an interface field conversion rule.
A non-volatile storage medium comprising one or more computer instructions which, when executed, implement the method described above.
Compared with the prior art, the invention has at least the following beneficial effects or advantages:
the method for integrating data among multiple systems provided by the invention can realize data synchronization and integration among multiple systems through a visual configuration tool under the condition that the current business system is not required to be developed and modified and the development of developers is not required, supports dynamic expansion and simultaneously supports automatic conversion of multiple types of databases into interface service.
Drawings
The present invention will be described in further detail with reference to the accompanying drawings;
fig. 1 is a flowchart of a method for integrating data between multiple systems according to an embodiment.
Fig. 2 is a flowchart of a data integration method between multiple systems according to a second embodiment.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The invention aims to provide a uniform data access solution without developing data interfaces on each software system, and the interfaces and data required to be exposed by the system are exposed to an external system for use in a configuration mode; when data on a software system is changed (fields are added or deleted), or more system data are required to be added for synchronization, development is not needed, and dynamic synchronization and integration of the data are realized only in a configuration mode.
Implementation mode one
The invention provides a method for integrating data among multiple systems, wherein the multiple systems are all provided with information synchronization interfaces, a set of data access and integration management application system is arranged among the systems, and a timing synchronization task is configured in the data access and integration management application system and is provided with an interface calling address, a conversion rule and a synchronization task execution period which need to be subjected to data synchronization; in the process of the synchronous task execution cycle, the method comprises the following steps: calling any system interface based on the interface calling address to obtain the system user information; performing data conversion according to the conversion rule; calling an interface of a system needing synchronous information to synchronize the user information subjected to data conversion; and completing data integration among multiple systems.
As shown in fig. 1, the multiple systems include a first system a and a second system B, and during the synchronous task execution cycle, the method specifically includes: calling the first system A interface based on the interface calling address to obtain the first system A user information; performing data conversion on the first system A user information according to the conversion rule; calling an interface of the second system B needing synchronization information to synchronize the user information of the first system A after data conversion; and completing data integration synchronization between the first system A and the second system B. The interface calling address is the calling address of the interfaces of the two parties. The conversion rule is an interface field conversion rule. Especially for integrating and synchronizing the overlapped user information among multiple systems. If the system A and the system B have the same user information, the information integration synchronization can be quickly realized by the method.
Second embodiment
Providing another method for integrating data among multiple systems, and configuring a set of data access and integration management application system and a plurality of sets of front-end systems; configuring a timing synchronization task on the data access and integration management application system, wherein the timing synchronization task configures an interface calling address, a conversion rule and a synchronization task execution period which need to perform data synchronization; the plurality of sets of front-end systems are all configured to realize user database access and synchronous interface access; the data access and integration management application system comprises the following steps in the process of the synchronous task execution cycle: calling a front system interface corresponding to any system in the multiple systems to obtain user information, and inquiring user information of a system database through the front system; performing data conversion according to the conversion rule; calling a front system interface corresponding to another system in the multiple systems to synchronize the user information subjected to the data conversion; the front system corresponding to the other system calls the front system interface to synchronize the user information.
As shown in fig. 2, the multiple systems include a first system a and a second system B, which correspondingly include a first front-end system and a second front-end system; in the process of the synchronous task execution cycle, the method specifically includes: calling the first front system interface of the first system A to obtain user information, and inquiring system database user information through the first front system; performing data conversion on the user information according to the conversion rule; calling the second front system interface of the second system B to synchronize the user information subjected to the data conversion; and the second front system of the second system B calls the second front system interface to synchronize the user information so as to complete the data integration and synchronization between the first system A and the second system B. The interface calling address is the calling address of the interfaces of the two parties. The conversion rule is an interface field conversion rule. Especially for integrating and synchronizing the overlapped user information among multiple systems. If the system A and the system B have the same user information, the information integration synchronization can be quickly realized by the method.
A non-volatile storage medium comprising one or more computer instructions which, when executed, implement the method of one or both of the above embodiments.
In summary, the method for integrating data among multiple systems provided by the invention can synchronize and integrate data among multiple systems without development and modification of the current business system and development of developers, and can realize data synchronization through a visual configuration tool, support dynamic expansion, and simultaneously support automatic conversion of multiple types of databases into interface services.
The above examples are merely illustrative of the present invention and should not be construed as limiting the scope of the invention, which is intended to be covered by the claims and any design similar or equivalent to the scope of the invention.
Claims (4)
1. A method for integrating data among multiple systems, wherein all the multiple systems are provided with information synchronization interfaces, is characterized in that: configuring a set of data access and integration management application systems among the systems, and configuring a timing synchronization task in the data access and integration management application systems, wherein the timing synchronization task configures an interface calling address, a conversion rule and a synchronization task execution period which need to perform data synchronization; in the process of the synchronous task execution cycle, the method comprises the following steps: calling any system interface based on the interface calling address to obtain the system user information; performing data conversion according to the conversion rule; calling an interface of a system needing synchronous information to synchronize the user information subjected to data conversion; completing data integration and synchronization among multiple systems;
the interface calling address is a calling address of both interfaces;
the conversion rule is an interface field conversion rule;
the multiple systems include a first system and a second system, and in the process of the synchronous task execution cycle, the method specifically includes: calling the first system interface based on the interface calling address to obtain the first system user information; performing data conversion on the first system user information according to the conversion rule; calling an interface of the second system needing synchronous information to synchronize the first system user information after data conversion; and completing data integration synchronization between the first system and the second system.
2. A non-volatile storage medium comprising one or more computer instructions which, when executed, implement the method of claim 1.
3. A method for integrating data among multiple systems is characterized in that: configuring a set of data access and integration management application system and a plurality of sets of front-end systems; configuring a timing synchronization task on the data access and integration management application system, wherein the timing synchronization task configures an interface calling address, a conversion rule and a synchronization task execution period which need to perform data synchronization; the plurality of sets of front-end systems are all configured to realize user database access and synchronous interface access; the data access and integration management application system comprises the following steps in the process of the synchronous task execution cycle: calling a front system interface corresponding to any system in the multiple systems to obtain user information, and inquiring user information of a system database through the front system; performing data conversion according to the conversion rule; calling a front system interface corresponding to another system in the multiple systems to synchronize the user information subjected to the data conversion; the front system corresponding to the other system calls the front system interface to synchronize the user information;
the interface calling address is a calling address of both interfaces;
the conversion rule is an interface field conversion rule;
the multi-system comprises a first system and a second system, and correspondingly comprises a first front-end system and a second front-end system; in the process of the synchronous task execution cycle, the method specifically includes: calling the first front system interface of the first system to obtain user information, and inquiring system database user information through the first front system; performing data conversion on the user information according to the conversion rule; calling the second front system interface of the second system to synchronize the user information subjected to the data conversion; and the second front-end system of the second system calls the second front-end system interface to synchronize the user information so as to complete the data integration synchronization between the first system and the second system.
4. A non-volatile storage medium comprising one or more computer instructions which, when executed, implement the method of claim 3.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811092951.0A CN109446223B (en) | 2018-09-19 | 2018-09-19 | Data integration method among multiple systems |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811092951.0A CN109446223B (en) | 2018-09-19 | 2018-09-19 | Data integration method among multiple systems |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109446223A CN109446223A (en) | 2019-03-08 |
CN109446223B true CN109446223B (en) | 2021-08-24 |
Family
ID=65533061
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811092951.0A Active CN109446223B (en) | 2018-09-19 | 2018-09-19 | Data integration method among multiple systems |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109446223B (en) |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102289340A (en) * | 2010-06-21 | 2011-12-21 | 中国电信股份有限公司 | Data auditing platform and method |
CN103139251A (en) * | 2011-11-29 | 2013-06-05 | 神州数码信息***有限公司 | Method of city-level data sharing exchange platform technology |
CN104991817A (en) * | 2015-06-25 | 2015-10-21 | 国网山东省电力公司 | Configurable integration method and system for information system |
CN106127657A (en) * | 2016-07-06 | 2016-11-16 | 成都丰窝科技有限公司 | A kind of municipal government hot line platform for data arrangement |
Family Cites Families (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20060123229A1 (en) * | 2004-07-23 | 2006-06-08 | Holloway Robert L | Database integration platform for security systems |
US8645502B2 (en) * | 2011-11-03 | 2014-02-04 | Business Objects Software Limited | Dynamic interface to read database through remote procedure call |
-
2018
- 2018-09-19 CN CN201811092951.0A patent/CN109446223B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102289340A (en) * | 2010-06-21 | 2011-12-21 | 中国电信股份有限公司 | Data auditing platform and method |
CN103139251A (en) * | 2011-11-29 | 2013-06-05 | 神州数码信息***有限公司 | Method of city-level data sharing exchange platform technology |
CN104991817A (en) * | 2015-06-25 | 2015-10-21 | 国网山东省电力公司 | Configurable integration method and system for information system |
CN106127657A (en) * | 2016-07-06 | 2016-11-16 | 成都丰窝科技有限公司 | A kind of municipal government hot line platform for data arrangement |
Non-Patent Citations (2)
Title |
---|
分布式企业服务总线平台数据集成研究与应用;范菁 等;《计算机科学》;20140228;第41卷(第2期);第206-214页 * |
基于SOA的金融异构信息***整合平台的设计与实现;赖吉健;《中国优秀硕士学位论文全文数据库 信息科技辑》;20140115;第2014年卷(第01期);第I138-845页 * |
Also Published As
Publication number | Publication date |
---|---|
CN109446223A (en) | 2019-03-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102148850B (en) | Cluster system and service processing method thereof | |
CN110990432B (en) | Device and method for synchronizing distributed cache clusters across machine room | |
CN102609479B (en) | A kind of memory database node clone method | |
US20230025449A1 (en) | Method and apparatus for dynamically adding consensus node in blockchain | |
CN101944114A (en) | Data synchronization method between memory database and physical database | |
CN109002462B (en) | Method and system for realizing distributed transaction | |
CN101876984A (en) | Data management system and data relation query method and device thereof | |
CN112364049B (en) | Data synchronization script generation method, system, terminal and storage medium | |
CN102937955A (en) | Main memory database achieving method based on My structured query language (SQL) double storage engines | |
CN103167171B (en) | Selection method and mobile terminal of contact mode | |
EP2954424A1 (en) | Method, device, and system for peer-to-peer data replication and method, device, and system for master node switching | |
CN110188114A (en) | A kind of optimization method of data manipulation, device, system, equipment and storage medium | |
CN105573757B (en) | The language update method and device of android system | |
CN109614271A (en) | Control method, device, equipment and the storage medium of multiple company-data consistency | |
CN104462342B (en) | database snapshot synchronization processing method and device | |
CN113992695B (en) | Method for service cooperation between network element devices and network element device | |
CN109857596A (en) | Time consistency backup method, equipment, system, device and storage medium | |
CN109446223B (en) | Data integration method among multiple systems | |
CN112328406A (en) | Micro-service distributed transaction system based on TCC (transmission control center) and service processing method | |
CN105723365A (en) | Method for optimizing index, master database node and subscriber database node | |
CN116701413A (en) | Main data processing method and device | |
CN112181724A (en) | Big data disaster tolerance method and device and electronic equipment | |
CN110569231B (en) | Data migration method, device, equipment and medium | |
CN101567943A (en) | Colorful ring back tone system with separated data management and call management and implementing method | |
CN109639704B (en) | A kind of master-slave mode server system application method, system, server and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |