Query data hierarchy output method

A technology for querying data and output methods, which is applied in the fields of electrical digital data processing, special data processing applications, digital data information retrieval, etc., can solve the problems of increasing data query IO costs and network bandwidth costs, and achieves low processor energy-enhancing costs. , reduce network throughput loss and improve the effect of high concurrency capability
CN109739879APending Publication Date: 2019-05-10广州优态科技有限公司
0 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
广州优态科技有限公司
Publication Date
2019-05-10

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention discloses an output method of a query data level. The output method comprises the following steps of: A) querying a user table and an association table for one time; B) outputting an intermediate result set; C) carrying out configuration processing on the intermediate result set by using a column merging method or a row merging method to obtain a target result set; and D) outputtingthe target result set. The method for outputting the query data level has the beneficial effects that the data query IO loss can be greatly reduced, the network throughput loss is greatly reduced, thehigh-concurrency energizing cost is reduced, and the high-concurrency capability is improved.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to the field of output hierarchy output, in particular to an output method for querying data hierarchy. Background technique

[0002] Data output is the result set output after the business query is completed. The data structure of the result set generally has one-to-one level, one-to-many level and many-to-many level. Due to the sub-table storage characteristics of relational databases, multiple queries are required to output the hierarchy, resulting in a large amount of performance consumption. In terms of performance resource overhead: data query IO (input and output) cost ≥ network throughput > cpu computing cost, because the interface server is generally separated from the data server and transmits data through the network. Executing multiple queries greatly increases data query IO costs and network bandwidth costs. Contents of the invention

[0003] The technical problem to be solved by the present invention is to pro...

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