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

Data query method and device, equipment and storage medium

A data query and database technology, applied in the field of data processing, can solve problems such as difficult to realize database data query, and achieve the effect of improving convenience

Pending Publication Date: 2022-03-08
BEIJING QIYI CENTURY SCI & TECH CO LTD
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, if the user does not understand or is not familiar with the SQL language, it is difficult to realize the data query of the database that adopts the columnar storage format that supports the nested structure. Therefore, how to improve the data query convenience of this kind of database is an essential Technical problems that technical personnel in the field need to solve

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] The solution of the present application is applicable to data query of a database adopting a columnar storage format supporting data structure, for example, data query of a database adopting Parquet.

[0056] The following will clearly and completely describe the technical solutions in the embodiments of the application with reference to the drawings in the embodiments of the application. Apparently, the described embodiments are only some of the embodiments of the 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 making creative efforts belong to the scope of protection of this application.

[0057] Such as figure 1 As shown, it shows a schematic flow chart of an embodiment of the data query method provided by the present application. The method of this embodiment can be applied to any computer device. The method of this embodiment can include:

[0058] S101. Deter...

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 invention provides a data query method and device, equipment and a storage medium, the method comprises the steps that query condition information used for querying a target database is determined, the query condition information indicates a to-be-queried target table, query conditions and output fields needing to be output, and the query conditions comprise conditions needing to be met by the to-be-matched query fields; determining a target field belonging to the array type in the query field and the output field; by taking the target field as a sub-table and the target table as a main table, generating a connection relationship for left-connecting the sub-table and the main table; taking a connection table represented by the connection relationship as a table to be queried in the SQL query statement, and constructing the SQL query statement according to the SQL grammar in combination with the query condition and the output field; and querying a target database based on the SQL query statement to query data from a target table in the target database. According to the scheme, under the condition that the database adopts the column storage format supporting the nested structure, the convenience of querying the data in the database can be improved.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular to a data query method, device, equipment and storage medium. Background technique [0002] In the era of big data, columnar storage formats that support nested structures have become increasingly common in databases. For example, Parquet is a more commonly used columnar storage format that supports nested structures. [0003] In the case where the database adopts a columnar storage format that supports nested structures, such as Parquet, the database supports query statements using a structured query language (Structured Query Language, SQL). However, if the user does not understand or is not familiar with the SQL language, it is difficult to realize the data query of the database that adopts the columnar storage format that supports the nested structure. Therefore, how to improve the data query convenience of this kind of database is an essential Technical ...

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/242G06F16/2452G06F16/2455G06F16/25
CPCG06F16/2282G06F16/2433G06F16/24528G06F16/2456G06F16/258
Inventor 赵全超
Owner BEIJING QIYI CENTURY SCI & TECH CO 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