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

Method and device for querying double-transcript parallel database

A database and data technology, applied in the database field, can solve the problems affecting data query efficiency, long data transfer time, long data transfer time, etc.

Active Publication Date: 2016-05-04
DAWNING INFORMATION IND BEIJING +1
View PDF5 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] When the cluster scale is large, the data transmission between nodes takes a long time. In the above method, the data is evenly distributed on the cluster nodes, which makes the data transfer time-consuming during data query and affects the efficiency of data query.

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 device for querying double-transcript parallel database
  • Method and device for querying double-transcript parallel database
  • Method and device for querying double-transcript parallel database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0083] In order to make the technical solutions and advantages of the present invention clearer, the exemplary embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all implementations. Exhaustive list of examples. And in the case of no conflict, the embodiments in this description and the features in the embodiments can be combined with each other.

[0084] The data in the double-copy parallel database is evenly distributed on the cluster nodes. When data is queried, the data is fragmented, and a parallel execution plan is generated according to the fragmentation, and multiple threads are started to execute query requests in parallel. When the cluster scale is large, the data transmission between nodes takes a long time. In the above method, the data is evenly distributed on the cluster nodes, which makes t...

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 method and a device for querying a double-transcript parallel database, and belongs to the technical field of databases. The method comprises the following steps: obtaining a query request and data storage unit information; forming a plurality of execution plans according to the query request and the data storage unit information; calculating resource occupation rates of the execution plans according to the resource utilization rates of execution nodes and the estimated data transmission quantity of the execution nodes in the execution plans; selecting one execution plan from the execution plans according to the resource occupation rate; and querying data according to the selected execution plan. The method provided by the invention is used for calculating the resource occupation rates of the execution plans according to the resource utilization rates of the execution nodes and the estimated data transmission quantity of the execution nodes in the execution plans and selecting one execution plan from the execution plans according to the resource occupation rate, and since the resource occupation condition influences the data transfer time consumption and the data query efficiency, the data transfer time consumption of the execution plan in the final query is short, and the data query efficiency is high.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a query method and device for double-copy parallel databases. Background technique [0002] In order to ensure data security and provide 24-hour uninterrupted data services, dual-copy parallel databases have become a common data storage method. Correspondingly, the efficiency of data query of dual-copy parallel databases has also become a focus of attention. Wherein, the parallel database is a database system established on the basis of MPP (Massively Parallel Processing, massively parallel processing system) and cluster parallel computing environment. The same data in the double-copy parallel database is stored in two parallel databases at the same time, and the same data in the two parallel databases are mutually backed up. [0003] At present, the data in the double-copy parallel database is evenly distributed on the cluster nodes. When data is queried, the data is fragment...

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/24532
Inventor 狄静舒
Owner DAWNING INFORMATION IND BEIJING
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