Method and system for connecting tables in a plurality of heterogeneous distributed databases

A distributed, database technology, applied in electrical digital data processing, digital data information retrieval, special data processing applications, etc., can solve problems such as high costs, and achieve the effect of improving performance, reducing costs, and reducing communication costs

Inactive Publication Date: 2012-07-11
IBM CORP
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the existing technology, it is often costly to perform join operations between tables in two or more heterogeneous databases

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 and system for connecting tables in a plurality of heterogeneous distributed databases
  • Method and system for connecting tables in a plurality of heterogeneous distributed databases
  • Method and system for connecting tables in a plurality of heterogeneous distributed databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] Exemplary embodiments of the present invention will be described below with reference to the accompanying drawings. In the interest of clarity and conciseness, not all features of an actual implementation are described in this specification. It should be appreciated, however, that in developing any such practical embodiment, many implementation-specific decisions must be made in order to achieve the developer's specific goals, such as compliance with system and business-related constraints, where these Restrictions vary from implementation to implementation. Furthermore, it should also be understood that such development, while potentially complex and time-consuming, would nevertheless be a routine undertaking for those skilled in the art having the benefit of this disclosure.

[0026] In addition, it should be noted that in order to avoid confusing the present invention with unnecessary details, only the device structure and / or processing steps closely related to the ...

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 utility model provides a method and a system for connecting tables in a plurality of heterogeneous distributed databases. The method comprises the following steps: responding to received data inquiry commands that relate to data from at least two remote data sources, generating a subcommand for a first data source according to the data inquiry commands, retrieving matched data in the first data source in a mode of block fetch according to the subcommand, sending at least relative columns in retrieval block data to a second data source, inserting the relative columns into a temporary tablefor implementing joint operation with a table in the second data source, and receiving a connected result set from the second data source, wherein the relative columns relate to the columns relative to the joint operation. The employment of the method and the system can reduce the disc input / output (I / O) cost in remote data sources and the communication cost between federative database servers and remote data sources.

Description

technical field [0001] The present invention relates generally to database information management systems, and in particular to a method and system for joining tables in multiple heterogeneous distributed databases. Background technique [0002] In large modern enterprises, it will be unavoidable that different departments of an organization use different database management systems (DBMS) to store and retrieve their critical data. And only by combining information from these systems can the agency realize the full value of the data. [0003] In finance, for example, mergers and acquisitions are almost constant. The newly created institution will inherit the original institution's databases, many of which are relational but from different manufacturers. They may have one or more database management systems. Each database can have a different application for computing important information. After the merger, the new agency needs to be able to access all customer informati...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F17/30498G06F16/2456
Inventor 李明李海峰孙云峰赵胜
Owner IBM CORP
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