Query optimization method based on unified view of distributed heterogeneous database

A query optimization and database technology, applied in the field of database applications, can solve the problems of low query efficiency and high resource occupation of unified view, and achieve the effect of saving resource occupation and improving efficiency

Active Publication Date: 2011-08-24
BEIJING TONGTECH CO LTD
View PDF4 Cites 63 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0011] The purpose of the present invention is to provide a query optimization method based on the unified view of distributed and heterogeneous databases, so as to solve the problem of low query efficiency and high resource occupation of the unified view in the prior art

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
  • Query optimization method based on unified view of distributed heterogeneous database
  • Query optimization method based on unified view of distributed heterogeneous database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053] The query optimization method based on the unified view of distributed and heterogeneous databases proposed by the present invention is described as follows in conjunction with the accompanying drawings and embodiments.

[0054] The method of the present invention optimizes the existing query method based on the unified view of distributed and heterogeneous databases, and mainly optimizes the following three steps in the existing steps:

[0055] 1. The system effectively decomposes the query SQL statement according to the actual physical table of the database;

[0056] 2. Query the decomposed SQL statements one by one corresponding to the physical table and return the result data;

[0057] 3. The resulting data is combined and properly cached.

[0058]How to decompose SQL in the stage of SQL statement decomposing, fully considering the association of multiple tables in the same physical database, to minimize the number of visits; in the stage of querying SQL statements...

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 query optimization method based on a unified view of a distributed heterogeneous database. The method comprises the following steps of: configuring the unified view for the distributed heterogeneous database for external access; effectively decomposing SQL query statements of the unified view according to a physical table of a database to be queried so as to maximally reduce the number of accesses; querying corresponding physical table by the decomposed SQL query statements and returning back resultant data, wherein a cache region is firstly queried, if the cache region contains corresponding resultant data, the result is directly obtained, and priorities are set for the SQL query statements so as to obtain an optimal result set as much as possible in each time while querying the physical table; and combining the resultant data returned after querying the physical table, and storing the combined resultant data and the corresponding SQL query statements into the cache region. The query optimization method based on the unified view of the distributed heterogeneous database improves efficiency for querying the unified view of the distributed heterogeneous database and reduces usage of resource.

Description

technical field [0001] The invention relates to the technical field of database application, in particular to a query optimization method based on a unified view of distributed and heterogeneous databases in a computer network. Background technique [0002] The current enterprise informatization data has been gradually formed, but due to the inconsistency in the time and execution of informatization, the data is scattered in the network, the data form is inconsistent, and these scattered data are often related to each other. If these data are isolated It is just a simple storage. The current situation is that the stored information is basically complete, and applications often require convenient, efficient, and reliable unified access to relatively independent but related data. [0003] To solve the above problems, the unified view is a general solution. The unified view is a single view provided by multiple databases, which forms a mapping with the tables and fields in each...

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): G06F17/30
Inventor 刘川张海齐邓鹏飞
Owner BEIJING TONGTECH 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