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

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

Pending Publication Date: 2019-05-10
广州优态科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Executing multiple queries will greatly increase data query IO costs and network bandwidth costs

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
  • Query data hierarchy output method
  • Query data hierarchy output method
  • Query data hierarchy output method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0036] figure 1 It is a one-to-one level process flow diagram in traditional technology. For the one-to-one level output in traditional technology, for example, target output: {user:”hugh”, age:21, wallet:{cash:90.0}, vip:{level:9}}, output the user's name, age, wallet cash, membership card level.

[0037] The data query process is as follows:

[0038] Bad data query method (3 queries): query user table, query wallet table, query member table;

[0039] Resu...

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 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.

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

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/2453G06F16/2455
Inventor 冯嘉宁
Owner 广州优态科技有限公司
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com