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

Data processing method, device and storage medium

A data processing and data table technology, applied in the field of data processing, can solve problems such as affecting query speed, and achieve the effect of reducing connection query time and improving connection query efficiency.

Active Publication Date: 2022-02-18
ALIBABA CLOUD COMPUTING LTD +1
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The connection operation provided by the existing query engine only supports two-way connection, and a large number of intermediate connection results are generated during the connection query process, which greatly affects the query speed

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
  • Data processing method, device and storage medium
  • Data processing method, device and storage medium
  • Data processing method, device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] In order to make the purpose, technical solution and advantages of the present application clearer, the technical solution of the present application will be clearly and completely described below in conjunction with specific embodiments of the present application and corresponding drawings. Apparently, the described embodiments are only some of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0021] To solve the technical problem of low efficiency of the existing connection query, in some embodiments of the present application, for multiple data tables to be queried, indexes of multiple data tables can be generated according to the primary and foreign key relationships between multiple data tables; Afterwards, according to the primary and ...

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

Embodiments of the present application provide a data processing method, device, and storage medium. In this embodiment of the application, for multiple data tables to be queried, indexes of multiple data tables can be generated according to the primary and foreign key relationships between multiple data tables; The foreign key relationship uses the indexes of multiple data tables to connect multiple data tables to obtain the connection result; after that, the connection result can be queried according to the query request to obtain the query result corresponding to the query request. Among them, according to the primary and foreign key relationship between multiple data tables, multiple data tables are connected by using the indexes of multiple data tables, and the multi-way connection of multiple data tables is realized without multiple bidirectional connections, resulting in bidirectional The intermediate connection result of the connection, therefore, can reduce the connection query time and improve the connection query efficiency.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular to a data processing method, device and storage medium. Background technique [0002] In today's information age, the application and research of information data has become a trend. Based on its advantages, databases are widely used in data storage, management, maintenance and query. [0003] A database is a computer software system that stores and manages data according to its data structure, and often needs to provide data of different dimensions for different users. Join query is the most important query method in relational databases, and multiple table queries can be realized through join operators. The connection operation provided by the existing query engine only supports two-way connection, and a large number of intermediate connection results are generated during the connection query process, which greatly affects the query speed. Contents of the ...

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 Patents(China)
IPC IPC(8): G06F16/22G06F16/28
CPCG06F16/2228G06F16/2282G06F16/284
Inventor 吴斌董宇李飞飞吉剑南易珂王琦琛董威
Owner ALIBABA CLOUD COMPUTING LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products