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

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

Example Embodiment

[0030] The detailed features and advantages of the present invention will be described in detail below in the specific embodiments. The content 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 objectives and advantages of the present invention.

[0031] In the following, first introduce some terms used in this application, and then refer to figure 1 with figure 2 Introduce some implementation methods of distributed external connections, and then refer to image 3 Introduce the execution mode of the distributed external connection according to the embodiment of the present invention, and finally refer to Figure 4 A method for externally connecting a first table of a database to a second table according to an embodiment of the present inventio...

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
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap