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

Method for operating multiple heterogeneous databases, middleware device and system

A database and heterogeneous technology, applied in the database field, can solve problems such as high cost of creation and high cost of warehouse modification, achieve the effect of resolving schema conflicts and realizing transparent access

Inactive Publication Date: 2014-07-23
CHINA TELECOM CORP LTD
View PDF5 Cites 38 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Its creation cost is high, and when a new data source is added or an existing data source changes, the cost of modifying the warehouse is relatively high

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
  • Method for operating multiple heterogeneous databases, middleware device and system
  • Method for operating multiple heterogeneous databases, middleware device and system
  • Method for operating multiple heterogeneous databases, middleware device and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The present invention will be described more fully hereinafter with reference to the accompanying drawings, in which exemplary embodiments of the invention are illustrated. The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0025] A heterogeneous database system is a collection of related multiple database systems. A heterogeneous database is each database of a heterogeneous database system, which has its own application characteristics, integrity control and security control. Heterogeneous databases can run ...

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 for operating multiple heterogeneous databases, a middleware device and a system. The method for operating the multiple heterogeneous databases comprises the steps that a global view for the multiple heterogeneous databases is generated; an SQL grammar analysis device generates a global task according to an SQL statement and submits the global task to a task scheduling device; the task scheduling device breaks the global task into subtasks for the heterogeneous databases and dispatches the subtasks to a task execution agent device; operation is executed by a task execution agent unit in the heterogeneous databases corresponding to the subtasks. According to the method, the middleware device and the system, access to the heterogeneous databases can be achieved through the global view based on a mediator model, the distributivity and heterogeneity difference of the databases are shielded, a uniform data view is provided, the problem of mode confliction among the heterogeneous databases is solved, and transparent access to the heterogeneous databases is achieved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method, a middleware device and a system for operating multiple heterogeneous databases. Background technique [0002] Under the current general trend of informatization, there are a large number of application systems based on various business processes and heterogeneous databases in the process of enterprise informatization. A specific business of an enterprise only needs to access the corresponding database system, but with the improvement of enterprise informatization, enterprise applications and decision-making often need to comprehensively utilize data between various systems, and their respective information "islands" hinder enterprise information process of transformation. Therefore, the need to achieve transparent access to heterogeneous databases and eliminate enterprise information "islands" is becoming more and more urgent. [0003] For large enterprises such as...

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/24553G06F16/25
Inventor 付雷曹敏张正风徐博斌
Owner CHINA TELECOM CORP LTD
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