A method and system for uniformly processing heterogeneous data sources

A heterogeneous data source and data technology, which is applied in the field of unified processing of heterogeneous data sources, can solve the problems of high implementation cost, complex process, and technical difficulty, and achieve the effect of reducing implementation cost and technical difficulty and improving efficiency

Inactive Publication Date: 2019-05-17
CHENGDU SEFON SOFTWARE CO LTD
View PDF1 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, there are many types of databases on the market, such as Oracle, MySql, SqlServer, Hbase, Hive, etc., and each database has its own grammatical characteristics. Today, having entered the era of big data, there are many system data that need to be merged and operated. Currently It can only be operated by merging data extraction into the same database. The process is complicated, the technology is difficult, and the implementation cost is high; therefore, a method that can operate different data sources through a unified standard sql syntax is needed

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
  • A method and system for uniformly processing heterogeneous data sources
  • A method and system for uniformly processing heterogeneous data sources
  • A method and system for uniformly processing heterogeneous data sources

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. The components of the embodiments of the invention generally described and illustrated in the figures herein may be arranged and designed in a variety of different configurations.

[0039] Accordingly, the following detailed description of the embodiments of the invention provided in the accompanying drawings is not intended to limit the scope of the claimed invention, but merely represents selected embodiments of the invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art wi...

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 method and system for uniformly processing heterogeneous data sources. The method comprises the following steps of acquiring request end data; obtaining user information through the request end data and authenticating a user; analyzing the request end data, and determining a target database of the request end data; converting the request end data into a dialect corresponding to a target database; establishing a connection with the target database, executing the request end data through the converted dialect, and returning an execution result to the request end. The system comprises a data acquisition module, a data analysis module, an authority configuration module, a route analysis module, a grammar conversion module and an execution module. The method is based on MySql binary communication protocol communication. By converting the standard Sql statement into the target database dialect, the purpose of operating different types of databases and returning databy taking the unified Sql92 standard statement as an inlet is achieved, the implementation cost and the technical difficulty of cross-database heterogeneous data source unified processing are effectively reduced, and the efficiency of heterogeneous data source unified processing is improved.

Description

technical field [0001] The invention relates to the technical field of database data processing, in particular to a method and system for unified processing of heterogeneous data sources. Background technique [0002] At present, there are many types of databases on the market, such as Oracle, MySql, SqlServer, Hbase, Hive, etc., and each database has its own grammatical characteristics. Today, having entered the era of big data, there are many system data that need to be merged and operated. Currently It can only be operated by merging data extraction into the same database. The process is complicated, the technology is difficult, and the implementation cost is high. Therefore, a method that can operate different data sources through a unified standard SQL syntax is needed. Contents of the invention [0003] In order to solve the above problems, the present invention proposes a method and system for unified processing of heterogeneous data sources. Based on a set standard...

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/242G06F16/2452G06F21/62
Inventor 李森林王纯斌易祖建张永飞
Owner CHENGDU SEFON SOFTWARE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap