A cross-data center data dictionary sharing method for financial institutions

By creating a data dictionary sharing management system and message queue middleware in the data center of financial institutions, the problem of cumbersome offline operations and poor timeliness of data dictionary sharing among financial institutions is solved, and real-time sharing and automated management of data dictionaries is realized. , improves the efficiency of data sharing applications.

CN114518967BActive Publication Date: 2024-11-12BANK OF CHINA FINANCIAL TECH CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202210104914.7
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-01-28
Publication Date
2024-11-12
Estimated Expiration
2042-01-28

AI Technical Summary

Technical Problem

Data dictionary sharing between financial institutions is complicated offline operations and poor timeliness, which cannot achieve real-time updates, and data analysis and automation work cannot ensure business consistency, resulting in inefficient data sharing.

Method used

Create a data dictionary sharing management system in the data center of financial institutions, and deploy message queue middleware in the DMZ area. Establish application and authorization channels through the reverse proxy server, and use message middleware to realize synchronous reading and writing of data dictionaries. The application module is displayed as a visual system.

Benefits of technology

Real-time sharing and automated management of data dictionaries are realized, the convenience and coherence of data processing and exchange are improved, and the efficiency of data sharing applications is significantly improved.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114518967B_ABST
    Figure CN114518967B_ABST
Patent Text Reader

Abstract

The present invention relates to a data dictionary sharing method for a financial institution across data centers, characterized in that a data dictionary sharing management system is created for the data centers of each financial institution, and a message queue middleware is deployed in each DMZ area to create a message channel for the transmission of the data dictionaries of the data centers of each financial institution, and the message queue middleware reads and writes the shared data dictionary through a synchronization module. Compared with the prior art, the present invention has the advantages of effectively improving the efficiency of data dictionary sharing application work, and more convenient and intelligent management.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a data dictionary sharing method across data centers for financial institutions. Background Art

[0002] In the application management module of an enterprise, the key work of the data center is the collection, storage, sharing and release of core data. Core data and collection interfaces are the core assets of an enterprise and constitute the core business of the data center. Data integration and application integration are increasing, and the core position of the data center in information construction is becoming increasingly apparent, providing more data services for the business, but also facing technical and management issues. Banks, insurance and other financial industries generally have self-built data centers and privatize the software systems in their own data centers. Even the consumer finance, banks, insurance companies and other subsidiaries of financial groups also need to deploy their software systems in their own data centers. At present, with the increasing requirements for the flow of data elements, financial institutions need to realize business empowerment through safe and compliant data sharing. The first prerequisite for data sharing is that institutions with sharing intentions can discover each other's data dictionaries that can be shared. Since each data table is deployed in its own data center, subject to its strict network management constraints, each software system cannot directly access the other party's data dictionary. Instead, the demander needs to propose business requirements, and after the two parties communicate the scope of the requirements, the data dictionary description document is sent offline, and the two parties need to negotiate many times. The operation is cumbersome, and offline manual operations take a long time, and the timeliness cannot be met; and once the data model changes, the offline operation is not updated in time, and the demander cannot obtain the update in real time; in addition, the second half of the data dictionary sharing requires subsequent data analysis, joint modeling and other automated work, and offline manual operations cannot guarantee business continuity at all. Therefore, it is necessary to establish a mechanism to achieve the synchronous visibility of the data table (data dictionary) to be shared in the intranet system of each sharing party. Summary of the invention

[0003] The purpose of the present invention is to provide a data dictionary sharing method across data centers for financial institutions in order to overcome the defects of the above-mentioned prior art.

[0004] The purpose of the present invention can be achieved by the following technical solutions:

[0005] A data dictionary sharing method across data centers for financial institutions is disclosed. A data dictionary sharing management system is created for the data centers of each financial institution, and a message queue middleware is deployed in each DMZ area to create a message channel for the transmission of data dictionaries of the data centers of each financial institution. The message queue middleware reads and writes the shared data dictionary through a synchronization module.

[0006] In the present invention, the data dictionary sharing management system includes:

[0007] Database, which realizes the access between the data dictionary of the data center of the financial institution and the data fields of the data center of the external financial institution;

[0008] The reverse proxy server wirelessly interacts with the data center of an external financial institution to establish an application and authorization channel between the data of both parties;

[0009] Application management module, which realizes the application and approval of data dictionaries and the display of local data dictionaries;

[0010] Message middleware server, which provides a data dictionary transmission channel based on message middleware;

[0011] The synchronization module executes the data dictionary reading and writing program, and sends and receives the data dictionary transmitted by the message middleware server;

[0012] Application module: realizes the display of the shared data dictionary, and the application module is a visualization system.

[0013] Among them, in the data dictionary sharing management system, the database, application management module, synchronization module and application module are deployed in the intranet area, and the reverse proxy server and message middleware server are deployed in the DMZ area.

[0014] Furthermore, the database includes:

[0015] The first data platform sets up the data dictionary of the financial institution’s data center;

[0016] The second data platform stores the data dictionary of the data center of the external financial institution.

[0017] Furthermore, the application management module includes:

[0018] The sharing application unit sends an application to the data center of an external financial institution to share its data dictionary;

[0019] The sharing approval unit approves the sharing applications received from the applicants, authorizes the approved requests, and synchronizes the data dictionary through the message middleware;

[0020] The read-write unit writes the synchronized data dictionary into the data platform of the applicant for storing the external data dictionary;

[0021] Display unit: displays the data dictionary of the data center of this financial institution.

[0022] Furthermore, the specific steps of the method of the present invention to realize cross-data center data dictionary sharing include:

[0023] 1) Establish application and authorization channels between data centers of various financial institutions through reverse proxy servers, and apply and authorize data dictionaries online in real time between data centers of different financial institutions;

[0024] 2) Local data passes through the synchronization module and reads the data dictionary into the synchronization module;

[0025] 3) Both parties establish a message channel through the message middleware, and the message middleware reads and writes the data dictionary through the synchronization module to realize the sending and receiving of the data dictionary;

[0026] 4) The data dictionary of the other party received through the message is written into the local database through the read-write unit;

[0027] 5) Display the shared data dictionary through the application module for subsequent application.

[0028] The data dictionary sharing method across data centers for financial institutions provided by the present invention has at least the following beneficial effects compared with the prior art:

[0029] 1) The present invention establishes a data dictionary sharing mechanism, increases the convenience and consistency of data processing and data exchange, and thereby makes the management of shared data dictionaries between data centers of various financial institutions more convenient and intelligent, which can significantly improve the level of data management; and realizes the online, process-based and automated sharing of cross-institutional data dictionaries, which can improve the efficiency of data dictionary sharing applications.

[0030] 2) Deploy a message discovery program on the other party, monitor the message queue, and write the information into the local database. At this point, through the visual system query database, you can get the shared data dictionary and realize real-time sharing of the data dictionary. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] Figure 1 The schematic diagram of the data dictionary sharing method across data centers of a financial institution is shown in the embodiment, taking data sharing between two institutions as an example. DETAILED DESCRIPTION

[0032] The present invention is described in detail below in conjunction with the accompanying drawings and specific embodiments. Obviously, the described embodiments are part of the embodiments of the present invention, rather than all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative work should belong to the scope of protection of the present invention.

[0033] In order to more clearly and completely illustrate the technical solution of the present invention, this embodiment first explains the professional terms commonly used in the art:

[0034] Data dictionary: information about the data table, describing the table name and the names of the data items;

[0035] DMZ (Demilitarized Zone): The middle area of ​​the data center intranet that accepts external network access. The financial industry generally adopts this network architecture. Data is not allowed to be written to the local file system, and databases and business systems are not allowed to be deployed in this area. It can only be used for data exchange at the network level, and has different network management strategies than the intranet.

[0036] An embodiment of the present invention provides a data dictionary sharing method across data centers for financial institutions. The method is applied in a data dictionary (such as data models, data tables, etc.) sharing scenario between data centers of different financial institutions. It can provide a set of intelligent, real-time and convenient data dictionary sharing solutions for multiple data centers without changing the deployment of each data center.

[0037] This embodiment takes a shared data dictionary between two parties, that is, a shared data dictionary between a data center of an institution A and a data center of an institution B, as an example to illustrate the method of the present invention.

[0038] For the data center of institution A and the data center of institution B, in the present invention, each data center is provided with its own database, application management module, synchronization module, reverse proxy server, message middleware server and application module, and the database includes a data platform with the data dictionary of the institution and a data platform for storing external data dictionaries. The application management module, two data platforms, application module and synchronization module are deployed in the intranet area, and the reverse proxy server and message middleware server are deployed in the DMZ area, as shown in FIG. Figure 1 shown.

[0039] The application management module of each institution's data center is connected to its own application module, the data platform for storing external data dictionaries, and the reverse proxy server respectively; the data platform with the institution's data dictionary and the data platform for storing external data dictionaries are connected to the synchronization module respectively, the synchronization module is connected to the message middleware server, and the reverse proxy servers of the two data centers are wirelessly connected. The message middleware servers of the two data centers are wirelessly connected to enable the data dictionary between data center A and data center B to be transmitted through the message middleware service.

[0040] The application management module of each institution's data center is used to: realize the application and approval of data dictionaries and display local data dictionaries. This module is implemented through the reverse proxy service of the DMZ area during the application approval stage; and is implemented by reading the database when displaying the data dictionary.

[0041] The function of the database in each institution's data center is to include the access to the local data dictionary and external data fields (i.e., the reading of data fields of the data platform that owns the institution's data dictionary and the reading of data fields of the data platform used to store external data dictionaries), which is controlled by the read-write program.

[0042] The reverse proxy servers in each institution's data center are used to establish application and authorization channels between the two systems, that is, to provide a wireless channel for sending sharing applications to other data centers, or to receive sharing applications from other data centers for approval and authorization;

[0043] The role of the message middleware server in each institution's data center is to use the message middleware as a transmission channel for the data dictionaries of all parties. Specifically, it includes the functions of sending and receiving messages. The message middleware of both parties is deployed in the DMZ area to establish a message queue connection; the reading and writing of the data dictionary is controlled by the synchronization module.

[0044] By deploying message queue middleware in each DMZ area, using message queue to create a channel, and establishing message channels with the applicants respectively. When acting as a sharing party, the data dictionary is sent to the message channel, and the message middleware will automatically synchronize the data dictionary information to the other party's local message queue.

[0045] At the same time, the synchronization module deploys a message discovery program on the other side, monitors the message queue, and writes the information into the local database. At this point, through the visual system query database, the shared data dictionary can be obtained, and the data dictionary can be shared in real time.

[0046] The function of the synchronization module in each institution's data center is to include the functions of reading the local data dictionary and writing the partner's data dictionary. It is an application that connects the message middleware and the database.

[0047] The function of the application module of each institution's data center is to display the data dictionary shared by partners and carry out subsequent applications. This application module is a visualization system.

[0048] Furthermore, the application management module at least includes:

[0049] The sharing application unit is used to apply to other data centers to share their data dictionaries; the application information includes data center information, application notes, etc.

[0050] The shared approval unit is used to approve the applications received from the applicants. After approval, authorization is granted. After authorization, the data dictionary is synchronized through the message middleware.

[0051] The read-write unit is used to write the data dictionary of the other party received by the applicant through the message into the local database, that is, into the data platform of the applicant for storing external data dictionaries; the synchronized data dictionary is only visible in the database of the applicant;

[0052] Display unit: displays the local data dictionary.

[0053] Based on the above design, the process of implementing data dictionary sharing across data centers within a financial institution in the present invention mainly includes the following steps:

[0054] 1. Preparation

[0055] This phase mainly involves setting up the environment. Specifically:

[0056] It is necessary to build a message middleware server in the DMZ area. For different data centers that need to share data, it is necessary to establish a connection between the message middleware on both sides.

[0057] 2. Implementation

[0058] Real-time data dictionary sharing based on the built environment. Specific steps include:

[0059] Step 1: Establish application and authorization channels (shared application unit, shared approval unit) between the two systems (data centers) through reverse proxy, so that different systems can apply for and authorize data dictionaries online in real time.

[0060] Step 2: Local data passes through the synchronization module and reads the data dictionary into the synchronization module.

[0061] Step 3: Both parties establish a message channel through the message middleware. The message middleware reads and writes the data dictionary through the synchronization module to realize the sending and receiving of the data dictionary.

[0062] Step 4: The data dictionary of the other party received through the message is written into the local database through the read-write unit.

[0063] Step 5: In the application module, the data dictionary shared by partners can be displayed for subsequent application.

[0064] Furthermore, assuming that three parties want to share data, deploy message queue middleware in their respective DMZ areas, create two channels for each message queue, and establish message channels with the other two parties. The sharing party sends the data dictionary to these two channels, and the message middleware will automatically synchronize the data dictionary information to the other party's local message queue. At the same time, the synchronization module deploys a message discovery program (discovery) on the other party, monitors the message queue, and writes the information to the local database. At this point, through the visual system query database, you can learn about the shared data dictionary and realize real-time sharing of the data dictionary. If you need to share data with more parties, the technical principle is the same as above, and the specific implementation process will not be repeated here.

[0065] The technical solution of the present invention establishes a data dictionary sharing mechanism, increases the convenience and consistency of data processing and data exchange, and thereby makes the management of shared data dictionaries between data centers of various financial institutions more convenient and intelligent, which can significantly improve the level of data management; and realizes the online, process-based and automated sharing of cross-institutional data dictionaries, which can effectively improve the efficiency of data application work.

[0066] The above is only a specific embodiment of the present invention, but the protection scope of the present invention is not limited thereto. Any person familiar with the technical field can easily think of various equivalent modifications or substitutions within the technical scope disclosed by the present invention, and these modifications or substitutions should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention shall be based on the protection scope of the claims.

Claims

1. A data dictionary sharing method across data centers for financial institutions, It is characterized in that Create a data dictionary sharing management system for the data centers of each financial institution, and deploy message queue middleware in each DMZ area to create a message channel for the transmission of data dictionaries of the data centers of each financial institution. The message queue middleware reads and writes the shared data dictionary through the synchronization module; The data dictionary sharing management system comprises: Database, which realizes the access between the data dictionary of the data center of the financial institution and the data fields of the data center of the external financial institution; The reverse proxy server wirelessly interacts with the data center of an external financial institution to establish an application and authorization channel between the data of both parties; Application management module, which realizes the application and approval of data dictionaries and the display of local data dictionaries; Message middleware server, which provides a data dictionary transmission channel based on message middleware; The synchronization module executes the data dictionary reading and writing program, and sends and receives the data dictionary transmitted by the message middleware server; Application module: realizes the display of shared data dictionary, and the application module is a visualization system; The specific steps of the method for implementing cross-data center data dictionary sharing include: 1) Establish application and authorization channels between data centers of various financial institutions through reverse proxy servers, and apply and authorize data dictionaries online in real time between data centers of different financial institutions; 2) Local data passes through the synchronization module and reads the data dictionary into the synchronization module; 3) Both parties establish a message channel through the message middleware, and the message middleware reads and writes the data dictionary through the synchronization module to realize the sending and receiving of the data dictionary; 4) The data dictionary of the other party received through the message is written into the local database through the read-write unit; 5) Display the shared data dictionary through the application module for subsequent application.

2. The data dictionary sharing method for a financial institution across data centers according to claim 1, It is characterized in that In the data dictionary sharing management system, the database, application management module, synchronization module and application module are deployed in the intranet area, and the reverse proxy server and message middleware server are deployed in the DMZ area.

3. The data dictionary sharing method for a financial institution across data centers according to claim 2, It is characterized in that The database includes: The first data platform sets up the data dictionary of the financial institution’s data center; The second data platform stores the data dictionary of the data center of the external financial institution.

4. The data dictionary sharing method for a financial institution across data centers according to claim 2, It is characterized in that The application management module includes: The sharing application unit sends an application to the data center of an external financial institution to share its data dictionary; The sharing approval unit approves the sharing applications received from the applicants, authorizes the approved requests, and synchronizes the data dictionary through the message middleware; The read-write unit writes the synchronized data dictionary into the data platform of the applicant for storing the external data dictionary; Display unit: displays the data dictionary of the data center of this financial institution.

Citation Information

Patent Citations

  • Heterogeneous database real-time synchronization method based on message middleware

    CN107341223A

  • Message-bus-based advanced meter information system with applications for cleaning, estimating and validating meter data

    US20080074284A1