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

Parallel query method for distributed database

A database and distributed technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as difficulty in adapting to the query speed requirements of large data volumes, and achieve good query performance, cost reduction, and high reliability Effect

Inactive Publication Date: 2010-12-29
南京中新赛克科技有限责任公司
View PDF3 Cites 33 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The purpose of the present invention is to solve the problem that existing query methods are difficult to adapt to the query speed requirements of large data volumes, and to invent a parallel query method for distributed databases that can quickly realize query and return query results in time

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
  • Parallel query method for distributed database
  • Parallel query method for distributed database
  • Parallel query method for distributed database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] The present invention will be further described below in conjunction with the drawings and embodiments.

[0034] Such as Figure 2-4 Shown.

[0035] A parallel query method for distributed databases, which includes the following steps:

[0036] First, set up the query proxy module (proxy) so that the query proxy module directly receives query commands from external modules;

[0037] Secondly, set up multiple query core modules (qcs) associated with the query agent module, please refer to the query system architecture composed of the two figure 2 , The data query core module (Qcs) provides multi-dimensional granular queries of data by decomposing tasks, and improves the overall response speed. The query core module (qcs) uses multi-thread technology and multiple concurrent query databases (dbms) to give full play to the high level of commercial databases. Throughput and high concurrency, it can coordinate and control multiple threads at the same time, and query process man...

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 parallel query method for a distributed database. In the method, due to the introduction of the design of proxy and qcs modules, a query system is able to support a high-concurrency distributed database and meets requirements of a large-sized application system. Meanwhile, based on a concept of 'dividing and ruling' query tasks, the qcs module initiates query concurrently, granularity data which can be queried quickly are fed back first, and thus, the overall query performance of the system is improved obviously and the needs for quick query of a majority of application systems are met.

Description

Technical field [0001] The invention relates to a database query method in the field of business application software, in particular to a method for quickly querying distributed databases based on parallel processing means, and specifically to a parallel query method for distributed databases. Background technique [0002] At present, for large-scale business application systems, most of the data volume is above 100T. For such a large data volume environment, how to provide fast queries to end users will become more and more important. [0003] The traditional query mode is figure 1 Shown. A complex query at the application layer requires multiple interactions with the database. If there are multiple DBMS (database servers), the application needs to traverse multiple database servers in order to finally display the data to the user. Without considering database optimization and SQL (Structured Query Language) optimization, this query mode has the following shortcomings: [0004] 1....

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
Inventor 王春
Owner 南京中新赛克科技有限责任公司
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