Parallel computing system and method for carrying out load balance according to query contents

A parallel computing and load balancing technology, applied in computing, special data processing applications, instruments, etc., can solve the problems of slow query or statistical speed of large databases, improve concurrent access capabilities, reduce investment costs, and increase query or statistical speed Effect

A parallel computing and load balancing technology, applied in computing, special data processing applications, instruments, etc., can solve the problems of slow query or statistical speed of large databases, improve concurrent access capabilities, reduce investment costs, and increase query or statistical speed Effect

CN101916280AInactive Publication Date: 2010-12-15上海云数信息科技有限公司
3 Cites 26 Cited by

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Parallel computing system and method for carrying out load balance according to query contents
  • Parallel computing system and method for carrying out load balance according to query contents
  • Parallel computing system and method for carrying out load balance according to query contents

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The main idea of ​​the present invention is to divide and distribute massive data in the source database to multiple node databases, and perform parallel computing with multiple independent node servers, so that the ability of multi-computer and multi-core simultaneous computing can be fully utilized. In addition, the present invention performs load balancing on the query content, and allocates query and statistical tasks according to the index information of each node server, which can greatly improve the statistical or query efficiency of the database with a large amount of data.

[0028] The data query or statistics of the present invention is established under the SQL command, and is especially suitable for BI (Business Intelligence, business intelligence) system. The present invention will be described in detail below in conjunction with the accompanying drawings.

[0029] See figure 2 , which is an architecture diagram of the parallel computing system of the pre...

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 parallel computing system and a method for carrying out the load balance according to query contents. The method comprises the following steps of: (1) configuring a plurality of node databases; (2) partitioning mass data in a main database according to a certain rule, and distributing the data to each node database; (3) forming index information representing the data contents distributed to each node database according to the division rule; (4) analyzing query or statistical parameters and combining the index information to distribute query or statistical assignment of each node database; and (5) carrying out parallel query or statistics on each node database. The invention can largely improve the query or statistical speed of large-scale databases.

Description

technical field [0001] The invention relates to a database query or statistical method, in particular to a parallel computing system and a load balancing method according to query content. Background technique [0002] With the development and popularization of computer technology, large-scale databases have rapidly entered various industries such as telecommunications and finance. SQL (Structured Query Language, Structured Query Language) is a set of operation commands specially established for databases, and it is a database language. The main function of SQL is to establish relationships with various databases and enable communication between different types of databases. According to ANSI (American National Standards Institute), SQL is used as a standard language for relational database management systems. When using SQL, you only need to issue the "what to do" command without thinking about "how to do it". SQL statements can be used to perform various operations on t...

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
15 Dec 2010
Publication
CN101916280A
IPC
G06F17/30
Inventors
李晓华