Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Public data pool generation method, device and equipment based on multiple systems and readable storage medium

A public data, multi-system technology, applied in the financial field, can solve the problems of improving retrieval efficiency, inability to obtain fast access, and long cross-system query time, and achieve the effect of solving long query time and maintaining timeliness and availability.

Pending Publication Date: 2020-09-08
CHINA CITIC BANK
View PDF4 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the past, in the decentralized system 10, data collection or integration was realized by manual methods or using scripting language, but the existing technical solutions cannot quickly obtain on-demand in massive data for systems with complex structures and diverse business data Relevant data, thus improving retrieval efficiency
At the same time, due to the different platforms between the systems, the types of databases used are often not the same, and the data required by users often comes from different platforms, and there are problems of long cross-system query time and cumbersome steps

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Public data pool generation method, device and equipment based on multiple systems and readable storage medium
  • Public data pool generation method, device and equipment based on multiple systems and readable storage medium
  • Public data pool generation method, device and equipment based on multiple systems and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0039] Example 1, as attached Figure 4 As shown, connect to the system 1 built with MySQL, the system 2 built with DB2, and the system 3 built with ORACLE through different access addresses to obtain the original data, and then the original data is sorted and cleaned, and then subjected to subject classification and analysis. The integration forms a hierarchical dimensional data model, and finally, a common data pool is formed through integration. This common data pool can be a database built through MySQL, and this database includes multiple subject class tables.

[0040] Users only need to access the public data pool through the interface to obtain data in system 1, system 2 and system 3, thereby reducing the difficulty of use for users and improving query efficiency.

Embodiment 2

[0041] Example 2, as attached figure 2 As shown, an apparatus for generating a public data pool based on multiple systems is characterized in that, the apparatus includes:

[0042] The raw data acquisition module is used to obtain raw data in each system;

[0043] The data cleaning module is used to organize and clean the original data to form simplified usable data;

[0044] The hierarchical dimensional data model generation module is used for subject classification and integration of available data according to metadata, and generates a hierarchical dimensional data model;

[0045] The public data pool generation module is used to integrate the hierarchical dimensional data model to generate a public data pool.

[0046] Further, the original data obtaining module is obtained after connecting with each system through different access addresses.

[0047]The described hierarchical dimension data model generation module is to establish the mapping relationship between the or...

Embodiment 3

[0048] Embodiment 3, the device for generating a public data pool based on multiple systems disclosed in the present invention includes a memory, a processor, and a computer program stored in the memory and running on the processor, characterized in that the processor executes the above steps of any method.

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a public data pool generation method, device and equipment based on multiple systems and a computer readable storage medium. The public data pool generation method based on themultiple systems comprises the steps of obtaining original data in each system; integrating and cleaning the original data to form simplified available data; performing topic classification and integration on the available data according to the metadata, and generating a hierarchical dimension data model; and integrating the hierarchical dimension data models to generate a public data pool.

Description

technical field [0001] The present invention relates to the technical field of data processing in the financial field, and in particular, to a method, apparatus, device and readable storage medium for generating a public data pool based on multiple systems. Background technique [0002] With the advent of the era of big data, business requirements for data are getting higher and higher, and because of business dispersion and diversification, various business data are stored in different systems. In the past, in the decentralized system 1, data collection or integration was achieved by manual methods or using scripting languages. However, the existing technical solutions cannot quickly obtain on-demand data from massive data for systems with complex structures and diverse business data. related data to improve retrieval efficiency. At the same time, due to the different platforms between systems, the types of databases used are often different, and the data required by users...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/215G06F16/2455G06F16/2457G06F16/28
CPCG06F16/215G06F16/2455G06F16/24573G06F16/2457G06F16/285
Inventor 闫伟张希婷冷炜高蕊赵天娇
Owner CHINA CITIC BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com