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

Multi-source heterogeneous data governance method and device

A multi-source heterogeneous data and data source technology, applied in structured data retrieval, electronic digital data processing, database management systems, etc., can solve the problem of low data governance work efficiency, and meet the needs of multi-source heterogeneous data governance , The effect of simplifying process steps and reducing operation and maintenance costs and time

Pending Publication Date: 2021-03-30
京信数据科技有限公司
View PDF0 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The above-mentioned whole process needs to configure data source connection components for different databases, and configure multiple extraction tasks according to the types of databases involved. At the same time, it is necessary to use intermediate database tables for temporary data storage, and finally write the data in the intermediate database tables to the target table. , to complete this process requires multiple steps and execution tasks to complete, and the overall data governance work efficiency is low

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
  • Multi-source heterogeneous data governance method and device
  • Multi-source heterogeneous data governance method and device
  • Multi-source heterogeneous data governance method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0060] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of the example embodiments to those skilled in the art. The same reference numerals denote the same or similar parts in the drawings, and thus their repeated descriptions will be omitted.

[0061] Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided in order to give a thorough understanding of embodiments of the present disclosure. However, those skilled in the art will appreciate that the technical solutions of the present disclosure may be practiced without one o...

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 relates to a multi-source heterogeneous data governance method and device. The method comprises the following steps: S1, constructing a query engine for uniformly connecting different types of databases and carrying out associated query by a standardized SQL grammar; S2, receiving a query instruction, connecting to a service of a query engine according to the received connection information of the data source, performing data query according to the received SQL statement, and returning a query result; and S3, receiving a processing instruction, correspondingly processing the query result according to the received processing instruction, and outputting a processing result. The multi-source heterogeneous data governance requirements are met, the process steps of data governanceare greatly simplified, and the operation and maintenance cost and time of governance tasks are reduced.

Description

technical field [0001] The invention relates to the field of multi-source heterogeneous data processing, in particular to a multi-source heterogeneous data governance method and device. Background technique [0002] At present, in the pullable component governance platform provided by big data, the input, output, conversion, field splitting, encryption, standard conversion and other functions required in the governance process are all carried out in a visual and pullable way, and the governance task is configured in the form of " "What you see is what you get" approach. At present, the main big data governance products only provide a single data source to connect to the database, and perform data governance tasks such as data query, conversion, and processing for the database tables in the configured single database. If it involves simultaneous query analysis and data governance of data in multiple database tables, multiple data governance tasks need to be configured, trans...

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
IPC IPC(8): G06F16/242G06F16/25G06F8/30
CPCG06F16/2433G06F16/254G06F8/315
Inventor 王济平黎刚汤克云周健雄杨劲业
Owner 京信数据科技有限公司
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