Tree structure data query method, device and equipment and storage medium

A technology of data query and tree structure, which is applied in the field of tree table query of big data technology, and can solve the problem of low query efficiency

Pending Publication Date: 2020-10-30
CHINA PING AN PROPERTY INSURANCE CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The main purpose of the present invention is to solve the problem of low query efficiency in the existing recursive query tree structure data in the data warehouse hive

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] Embodiments of the present invention provide a tree structure data query method, device, device, and storage medium, which are used to obtain the coding information of each organization node and generate organization information by hierarchically associating the tree structure data in the data warehouse hive. Hierarchical wide tables improve the efficiency of hierarchical relational query of multi-layer organizations in hive.

[0029] The terms "first", "second", "third", "fourth", etc. (if any) in the description and claims of the present invention and the above drawings are used to distinguish similar objects, and not necessarily Used to describe a specific sequence or sequence. It is to be understood that the terms so used are interchangeable under appropriate circumstances such that the embodiments described herein can be practiced in sequences other than those illustrated or described herein. Furthermore, the term "comprising" or "having" and any variations thereo...

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 relates to the technical field of big data, and discloses a tree structure data query method, device and equipment and a storage medium, which are used for improving the query efficiencyof tree structure data. The tree structure data query method comprises the steps of receiving a data query request to obtain encoding information of a target institution node and a hierarchical valueof a to-be-queried institution node; reading a preset mechanism dimension table according to the encoding information to obtain a hierarchical value of the target mechanism node; querying a preset mechanism level wide table according to the level value of the to-be-queried mechanism node, the coded information and the level value of the target mechanism node to obtain to-be-verified coded information; when the to-be-verified coded information is not the null value, sending the to-be-verified coded information to the terminal; and when the to-be-verified coded information is a null value, recursively querying the preset mechanism dimension table to obtain coded information of the to-be-queried mechanism node, and recording the coded information in a preset mechanism level wide table. The invention also relates to a blockchain technology, and the target institution node can be stored in the blockchain node.

Description

technical field [0001] The invention relates to the field of tree table query of big data technology, in particular to a tree structure data query method, device, equipment and storage medium. Background technique [0002] With the increase of data diversity, the number of tables is also increasing. The metadata management platform is an important management tool in the field of big data. Through the metadata management platform, the field name, annotation information, and blood relationship of the table can be queried according to the table. and queries for user-defined functions. [0003] However, in actual development and use, the level line of an organization is obtained through the relationship between the upper and lower levels of the organization. Usually, the table stores the coding information of each organization node, the organization level and the parent organization node, and the coding information of each organization node It can only be found through layers o...

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/2455G06F16/242
CPCG06F16/2246G06F16/2282G06F16/2425G06F16/2455
Inventor 陈润红
Owner CHINA PING AN PROPERTY INSURANCE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap