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

Methods and systems for external connection of tables of database

An external connection and database technology, applied in the database field, can solve the problems of inability to directly use the broadcast appearance and reduce the execution efficiency, so as to reduce the amount of transmission and calculation, improve the efficiency of execution, and reduce the amount of network transmission.

Active Publication Date: 2019-08-27
BEIJING OCEANBASE TECH CO LTD
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For the outer join operation, due to semantic requirements (in addition to returning matching rows, but also returning rows that do not match the outer table), the execution plan of the broadcast outer table cannot be directly used. In some scenarios, a large amount of data redistribution may be introduced, which reduces the execution efficiency.

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
  • Methods and systems for external connection of tables of database
  • Methods and systems for external connection of tables of database
  • Methods and systems for external connection of tables of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The detailed features and advantages of the present invention are described in detail below in the specific embodiments, the content of which is sufficient to enable any person skilled in the art to understand the technical content of the present invention and implement it accordingly, and according to the specification, claims and drawings disclosed in this specification , those skilled in the art can easily understand the related objects and advantages of the present invention.

[0031] In the following, some terms used in this application are first introduced, and then referred to figure 1 and figure 2 Introduce some implementation methods of distributed outer joins, and then refer to image 3 Introduce the execution mode of the distributed outer join according to the embodiment of the present invention, finally refer to Figure 4 A method for outer-joining a first table of a database to a second table according to an embodiment of the present invention is introdu...

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 application relates to a method for connecting a first table of a database to a second table, the method comprising broadcasting said first table to each node of said second table; and performingan external connection operation on one or more nodes of the second table, and performing an internal connection operation on other nodes of the second table. An associated system and storage medium are also provided. According to the scheme, the execution efficiency is improved under the condition that the execution correctness is ensured.

Description

technical field [0001] The present invention relates to databases, and in particular to methods and systems for outer joins of tables of databases. Background technique [0002] The join operation is a common logic operation for the database, and it is also one of the most time-consuming operations. The execution efficiency of connection operations often has a decisive impact on the execution time of the entire request. In a distributed database, in addition to considering factors such as data statistics, connection order, and access path, the optimizer also needs to generate an execution plan with the least execution cost in a distributed environment based on the physical distribution information of the data. [0003] An "outer join" operation is a type of "join" operation. For the outer join operation, due to semantic requirements (in addition to returning matching rows, but also returning rows that do not match the outer table), the execution plan of the broadcast outer...

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): G06F16/25G06F16/22
CPCG06F16/2282G06F16/25
Inventor 陈萌萌
Owner BEIJING OCEANBASE TECH CO LTD
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More