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

Database table equivalent connection optimization method and device, server and storage medium

An optimization method and database technology, applied in the computer field, can solve problems such as reducing performance, and achieve the effect of improving performance and improving execution efficiency

Active Publication Date: 2020-06-30
SHANGHAI DAMENG DATABASE
View PDF3 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Embodiments of the present invention provide an optimization method, device, server, and storage medium for equivalent joins of database tables, which can solve the problem of performance degradation due to additional I / O overhead and CPU overhead for thread summary data or distribution data

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
  • Database table equivalent connection optimization method and device, server and storage medium
  • Database table equivalent connection optimization method and device, server and storage medium
  • Database table equivalent connection optimization method and device, server and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, but not to limit the present invention. In addition, it should be noted that, for the convenience of description, only some structures related to the present invention are shown in the drawings but not all structures.

[0024] As an example for ease of understanding, the words that may appear in the embodiments of the present invention are explained below.

[0025] Database tables are divided into non-partitioned tables and partitioned tables. Among them, the partition table puts records with different partition columns into different partitions by judging the partition columns. Partitioning is completely transparent to the application.

[0026] Homogeneous partition tables refer to two partition tables with exactly the same st...

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 embodiment of the invention discloses a database table equivalent connection optimization method and device, a server and a storage medium. The method comprises the steps: analyzing a query statement, and obtaining a query condition, a table name of a database table and fields involved in the query condition of the database table; matching the query condition, the table name and the field witha preset optimization condition, and judging whether to perform optimization operation of equivalent connection or not according to a matching result; if the equivalent connection optimization operation is carried out, generating a connection plan node according to the data scanning plan node, and generating an optimized execution plan according to the data scanning plan node and the connection plan node, wherein the execution plan is used for carrying out equivalent connection calculation on the database table in parallel to obtain an equivalent connection calculation result. According to the embodiment of the invention, the problem that the performance is reduced due to additional increase of I / O overhead and CPU overhead of thread summarizing data or distributing data in related technologies is solved, the execution efficiency is improved, and the performance is improved.

Description

technical field [0001] The embodiments of the present invention relate to computer technology, and in particular to an optimization method, device, server and storage medium for equivalent connection of database tables. Background technique [0002] A relational database is a database created on the basis of a relational model. When storing tables in a relational database, because the computer memory adopts a one-dimensional structure for sequential addressing, it is possible to enter the data of each row in the table one by one (that is, row storage) , or the method of batch importing the data of each column in the table (that is, column storage). [0003] After the tables in the relational database are stored, various join operations can be performed on the tables based on relational algebra, for example: performing an equivalence join on two database tables, that is, querying data in two database tables that meet the equivalence condition for a specific field. When multi...

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): G06F16/242G06F16/28
CPCG06F16/2433G06F16/284Y02D10/00
Inventor 朱仲颖万伟韩朱忠
Owner SHANGHAI DAMENG DATABASE