Unified query system of mixed heterogeneous data sources and a distributed query method

A heterogeneous data source and query system technology, which is applied in the field of information collection technology and database, can solve problems such as too much hard coding, inconsistent data, and restrictions on the development of enterprise-level applications, so as to improve security, achieve high performance, and solve problems The effect of wasting resources

Inactive Publication Date: 2017-12-19
INFORMATION & COMM BRANCH OF STATE GRID JIANGSU ELECTRIC POWER
View PDF8 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For these two problems, the existing solutions have certain deficiencies, such as no unified standard for data representation, too m

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
  • Unified query system of mixed heterogeneous data sources and a distributed query method
  • Unified query system of mixed heterogeneous data sources and a distributed query method
  • Unified query system of mixed heterogeneous data sources and a distributed query method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The specific implementation manners of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0028] The present invention designs a unified query system for mixed heterogeneous data sources, such as figure 1 As shown, including request receiving module, database mapping module and data integration module; for example figure 2 As shown, the database mapping module performs information interaction with the request receiving module and the data integration module respectively; wherein, the database mapping module is respectively connected and communicated with preset relational databases, and the database mapping module targets all physical tables in relational databases according to preset Logical relationships, constructing corresponding logical virtual tables, and establishing logical virtual databases; here, each preset relational database connected to the database mapping module, including one of Oracle datab...

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 unified query system of mixed heterogeneous data sources and a distributed query method. The system supporting cross-domain and cross-source heterogeneous-data realizes unified data accessing and querying, and realizes a distributed data accessing and processing platform of accessing the various data sources in a high-performance manner. According to the designed scheme, unified accessing of various databases and massive data storage in backgrounds is realized, direct connection between applications and the databases/storage is disconnected, and the security of underlying data is improved to a certain extent; and multiple tables of the physical databases/storage are also abstracted as one or more logical databases according to business needs, and a unified data service is provided for application development. The system also provides abstraction of big-data analysis services, greatly reduces data transferring, copying and conversion work carried out by an enterprise, and solves problems of resource waste, low efficiency, data security and the like due to a large amount of data copying in carrying out application development by the enterprise.

Description

technical field [0001] The invention relates to a unified query system and a distributed query method for mixed heterogeneous data sources, and belongs to the fields of information collection technology and database technology. Background technique [0002] With the rapid development of IT technology, the process of social informatization is gradually accelerating. On the one hand, social informatization has brought great convenience and speed to people, but on the other hand, it has also brought some problems and challenges. Among them, "information islands" and data access are two prominent issues. The difficulty of solving the "information island" problem lies in how to enable users to operate heterogeneous data in a transparent manner at low cost and high efficiency; the difficulty of solving the data access problem lies in how to improve the access efficiency and security performance of data resources. For these two problems, the existing solutions have certain defici...

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): G06F17/30
CPCG06F16/2471G06F16/25G06F16/27G06F16/284
Inventor 王继业曾楠郝悍勇陈志刚谭晶
Owner INFORMATION & COMM BRANCH OF STATE GRID JIANGSU ELECTRIC POWER
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