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

Database operation method and device, equipment and storage medium

An operation method, database technology, applied in the database field to achieve the effect of ensuring the possibility

Active Publication Date: 2021-08-24
ALIBABA GRP HLDG LTD
View PDF12 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present application provides a database operation method, device, device, and storage medium to solve the problem of how to maintain the availability of the storage information of the row group for the input data of the non-leaf nodes in the prior art

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 operation method and device, equipment and storage medium
  • Database operation method and device, equipment and storage medium
  • Database operation method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to make the purposes, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of this application.

[0028] Terms used in the embodiments of the present application are only for the purpose of describing specific embodiments, and are not intended to limit the present application. The singular forms "a", "said" and "the" used in the embodiments of this application and the appended claims are also intended to include plural forms, unless the context clearly in...

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 provides a database operation method and device, equipment and a storage medium, and the method comprises the steps that input data of a first operator corresponding to a database query statement is obtained, wherein the input data relates to a target physical table in a database, and the storage information of the row group corresponding to the target physical table in the database is available for the first operator; based on the input data and a preset row group attribute maintaining strategy, the expression of the first operator is executed to obtain output data of the first operator, the output data are block data taking a row as a unit, and the same block in the output data corresponds to the same row group of the target physical table. According to the invention, the availability of the storage information of the row group to the non-leaf nodes can be maintained.

Description

technical field [0001] The present application relates to the technical field of databases, and in particular to a database operation method, device, equipment and storage medium. Background technique [0002] With the development of big data, traditional row-based databases are gradually unable to meet the needs in terms of query performance and maintenance costs, so column-based databases appear. Column-based databases are databases that store data in a column-based storage architecture. [0003] At present, in order to give full play to the advantages of columnar storage, it is proposed to further organize data in the unit of "row group" based on the columnar storage structure, and perform independent compression and information statistics on the data in each row group, so that Get the storage information of the row group, which can be used for expression optimization. For the leaf nodes in the query tree obtained by analyzing the query statement, the input data is the d...

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/242G06F16/22
CPCG06F16/2433G06F16/2282
Inventor 缪哲语吴迪阮羽彬乔智李猛梁宇坤
Owner ALIBABA GRP HLDG LTD