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

Data processing method and device, program product 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: 2021-09-28
ALIBABA CLOUD COMPUTING LTD +1
View PDF10 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 and device, program product and storage medium
  • Data processing method and device, program product and storage medium
  • Data processing method and device, program product 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

The embodiment of the invention provides a data processing method and device, a program product and a storage medium. In the embodiment of the invention, for a plurality of data tables to be queried, indexes of the plurality of data tables can be generated according to a primary and foreign key relationship among the plurality of data tables; then, according to the primary and foreign key relationship among the plurality of data tables, the plurality of data tables are connected by using the indexes of the plurality of data tables to obtain a connection result; and then the connection result is queried according to the query request to obtain a query result corresponding to the query request. According to the primary and foreign key relationship among the multiple data tables, the multiple data tables are connected by utilizing the indexes of the multiple data tables, so that multi-path connection of the multiple data tables is realized, multiple times of bidirectional connection are not required, and an intermediate connection result of the bidirectional connection is not required to be generated, therefore, the connection query time can be shortened, and the connection query efficiency can be improved.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular to a data processing method, device, program product, 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. ...

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 Applications(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