Unlock instant, AI-driven research and patent intelligence for your innovation.

Intelligent assessment method for INNER JOIN during SQL (structured query language) execution by distributed database

A database and execution technology, applied in the field of distributed database data storage, to ensure efficient execution and reduce the amount of data

Active Publication Date: 2016-04-20
TIANJIN NANKAI UNIV GENERAL DATA TECH
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

There are many products in the industry database that use greedy strategies or dynamic programming strategies, but these products cannot flexibly cope with changing application environments

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
  • Intelligent assessment method for INNER JOIN during SQL (structured query language) execution by distributed database
  • Intelligent assessment method for INNER JOIN during SQL (structured query language) execution by distributed database
  • Intelligent assessment method for INNER JOIN during SQL (structured query language) execution by distributed database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] The present invention will be described in detail below in conjunction with the accompanying drawings and embodiments.

[0039] figure 1 Shown is an example of a distributed database INNERJOIN in the present invention, there are 6 machines in the cluster, a total of 6 data fragments, each fragment has a backup fragment, these primary fragments and backup fragments are scattered to each machine in the database cluster.

[0040] figure 2 Shown is the overall workflow of the distributed database evaluation INNERJOIN in the present invention, and the specific steps are as follows:

[0041] Step S201, the database system receives the SQL sent by the user, and parses the SQL.

[0042] Step S202, judging whether the user has specified the method of evaluating INNERJOIN in the parsed SQL in the form of Hint or user session parameters, if specified, then execute step S203 sequentially, if not specified, then jump to step S204.

[0043] Step S203, execute the evaluation of INN...

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 relates to the field of data storage of a distributed database, in particular to an intelligent assessment method for INNER JOIN during SQL (structured query language) execution by a distributed database. According to the method, superior execution sequences of INNER JOIN are selected in a manner of combining three assessment methods including a greedy method, a dynamic planning method and a genetic algorithm, the data volume after INNER JOIN is reduced as far as possible, and high-efficiency execution of INNER JOIN is guaranteed. A user can assign any one assessment method, and the flexibility and the expandability of a system are improved.

Description

technical field [0001] The invention relates to the field of distributed database data storage, in particular to an intelligent evaluation method for INNERJOIN in distributed database SQL execution. Background technique [0002] In today's society, almost all industries use databases to store data. With the advent of the era of big data and cloud computing, the demand for data storage and computing in these industries is becoming more and more urgent. Therefore, the traditional stand-alone database system cannot meet the needs of users. Complete the calculation and storage of massive data. Therefore, distributed databases have become the darling of the industry. With the development and maturity of distributed technology, high-speed network transmission technology, and parallel computing technology, distributed databases have become mainstream products in the database industry. [0003] Distributed databases generally use multiple machines to store data, that is, user data ...

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/24544
Inventor 武新崔维力宋永智
Owner TIANJIN NANKAI UNIV GENERAL DATA TECH