Table data query method, table data query device and table data query system for distributed database
The technology of a query method and a query device, which is applied in the field of databases, can solve the problems of reducing the data processing efficiency of distributed database tables, etc.
Active Publication Date: 2021-09-21
BEIJING OCEANBASE TECH CO LTD
View PDF4 Cites 4 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
When the driven table is distributed on different storage nodes or storage devices, the rescanning process of the driven table will involve operations such as resource release, scheduling restart, etc. These operations are often accompanied by message waiting, synchronization, and network transmission operations, thereby greatly reducing distributed Database table data processing 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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0040] The subject matter described herein will now be discussed with reference to example implementations. It should be understood that the discussion of these implementations is only to enable those skilled in the art to better understand and realize the subject matter described herein, and is not intended to limit the protection scope, applicability or examples set forth in the claims. Changes may be made in the function and arrangement of elements discussed without departing from the scope of the disclosure. Various examples may omit, substitute, or add various procedures or components as needed. For example, the methods described may be performed in an order different from that described, and various steps may be added, omitted, or combined. Additionally, features described with respect to some examples may also be combined in other examples.
[0041] As used herein, the term "comprising" and its variants represent open terms meaning "including but not limited to". The...
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
Login to View More Abstract
The embodiment of the invention provides a table data query method, a table data query device and a table data query system for a distributed database. In response to the table data processing node executing the first execution sub-plan and reading the row data of the driving table, the table data query device generates a data rescanning instruction or a data scanning instruction according to whether the read row data is cached in a cache device of the table data processing node, and sends the data re-scanning instruction or the data scanning instruction to the driven table scanning scheduling device of the table data processing node. The driven table scanning scheduling device obtains a driven table data query result according to the data re-scanning instruction or the data scanning instruction, and returns the driven table data query result to the table data query device.
Description
technical field [0001] The embodiments of this specification generally relate to the database field, and in particular, relate to a table data query method, a table data query device, a table data processing node, and a distributed database system for distributed databases. Background technique [0002] In some table data processing scenarios of distributed databases, such as nested loop joins (Nested LoopJoin) or subplan filter execution (Subplan filter) conditional push-down scenarios, multiple rescans are required for each row of data in the driving table ( Rescan) the data in the driven table. When the driven table is distributed on different storage nodes or storage devices, the rescanning process of the driven table will involve operations such as resource release, scheduling restart, etc. These operations are often accompanied by message waiting, synchronization, and network transmission operations, thereby greatly reducing distributed Database table data processing ...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22G06F16/2455G06F16/2458G06F16/27
CPCG06F16/2282G06F16/24552G06F16/2471G06F16/27G06F16/24561G06F16/00G06F16/24542
Inventor 唐铭豆余璜潘毅
Owner BEIJING OCEANBASE TECH CO LTD