Method and device for storing query results, computing device

Abstract

Provided are a method and apparatus for storing a query result. The method comprises: determining multiple query tables corresponding to a first query request, wherein the first query request is used for requesting to perform a correlated subquery on the multiple query tables (S110); determining a target query table from the multiple query tables, wherein the target query table is a fact table of at least one query table in the multiple query tables except the target query table, and a fact table of the target query table does not exist in the multiple query tables (S120); determining a major key of a first table according to the target query table, wherein the first table is used for storing a query result corresponding to the first query request (S130); and storing the query result into the first table according to the major key of the first table (S140). The method and apparatus for storing a query result can avoid the problem in the prior art that the query efficiency is low when a correlated subquery is performed on the first tabled, thus improving the correlated subquery efficiency.

Description

Technical field [0001] The present invention relates to the field of databases, and more specifically, to a method and device for storing query results, and computing equipment. Background technique [0002] Transaction Processing Performance Council Benchmark TM H, TPC-H) is mainly used to simulate the application environment of real business, including simulating dynamic query of real business transaction database, as a reference for decision support and database application system. [0003] TPC-H mainly involves the following concepts: [0004] The fact table is used to store at least one fact record. Each fact record corresponds to a row in the fact table, and includes a key value column and a measure value column. The value in the key value column corresponds to the dimension of the fact record, for example, product origin , Commodity price, commodity quantity, transaction date, commodity type, commodity name, etc.; the value in the metric column corresponds to the subject cont...

AI Technical Summary

Problems solved by technology

[0025] Embodiments of the present invention provide a method, device, and computing device for storing query results, which can avoid the problem of low query efficiency when performing associated queries in the prior art

Images