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

Multi-source heterogeneous database fusion system and data query method thereof

A multi-source heterogeneous and data fusion technology, which is applied in the field of database fusion systems, achieves the effects of optimizing overall performance, strong reliability, and good scalability and maintainability

Inactive Publication Date: 2014-08-27
NANJING UNIV OF POSTS & TELECOMM
View PDF3 Cites 99 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] The technical problem to be solved by the present invention is to propose a multi-source heterogeneous database fusion system to solve the problem of "information island" in heterogeneous database fusion and overcome the shortcomings of existing database fusion technology

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 database fusion system and data query method thereof
  • Multi-source heterogeneous database fusion system and data query method thereof
  • Multi-source heterogeneous database fusion system and data query method thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] A multi-source heterogeneous database fusion system and its data query method of the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0043] A multi-source heterogeneous database data fusion system architecture such as figure 1 As shown, there are three layers from bottom to top: database layer, data fusion layer and unified application layer.

[0044] The database layer consists of heterogeneous databases and their proxies. Specific types of heterogeneous databases include: Oracle, SQL Server, MySQL, which provide actual data storage and management functions, and can accept calls from the upper layer. The database agent uses Web Service to realize the visit of remote database. In most applications, the database server is placed behind a firewall to improve security, and cannot be accessed from the external network. After the database agent is added, remote data can be obtained, whic...

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 provides a multi-source heterogeneous database fusion system and a data query method thereof. The system comprises a database layer, a data fusion layer and a uniform application layer. The database layer is composed of heterogeneous databases and agencies of the heterogeneous databases. The data fusion layer is used for fusing information of all heterogeneous data sources, and is responsible for data access of the heterogeneous data sources and coordinating the information of all the data sources, and specifically comprises a metadata data base (DB), a metadata manager, a comprehensive wrapper, a mediator, an application layer access uniform interface and a heterogeneous database uniform interface. The uniform application layer is the user of the heterogeneous database fusion system and can have access to shared data resources of the heterogeneous databases by fusing middle layers. The multi-source heterogeneous database fusion system and the data query method of the multi-source heterogeneous database fusion system solve the problems in heterogeneous database fusion and overcome the defects of an existing database fusion technology. The system can conduct transparent query on all the heterogeneous databases on the condition that local databases are not affected, and the maintenance cost of the system is reduced.

Description

technical field [0001] The invention relates to a database fusion system, in particular to a multi-source heterogeneous database fusion system and a data query method thereof. Background technique [0002] In the process of informatization construction, many enterprise departments have established many isolated heterogeneous data sources according to their own business and functional needs. Due to the lack of unified information planning, the development time and source of each information management system are inconsistent. The development platforms, data structures, and database management systems are also different, resulting in the independence of each system, the inability to exchange and integrate information, and the gradual formation of "information islands" internally. In order to solve the above problems, it is urgent to propose a new method of multi-source heterogeneous database data fusion to realize information interaction and sharing, and provide a safe, reliab...

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/9535G06F16/256
Inventor 徐名海李龙凤梁霖吕冬冬
Owner NANJING UNIV OF POSTS & TELECOMM
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