Universal tree structure data query method and device

A data query and tree structure technology, applied in the computer field, can solve problems such as consumption, multi-database performance, and inconsistency of relational database methods, and achieve the effect of reducing performance consumption and better versatility
CN110704430AInactive Publication Date: 2020-01-17JIANGSU SUNING LOGISTICS CO LTD
1 Cites 2 Cited by

Patent Information

Authority / Receiving Office
CN Β· China
Patent Type
Applications(China)
Current Assignee / Owner
JIANGSU SUNING LOGISTICS CO LTD
Publication Date
2020-01-17
Estimated Expiration
Not applicable Β· inactive patent

Smart Images

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

Abstract

The invention discloses a universal tree structure data query method and device, relates to the technical field of computers, and aims to realize the universality of a child node set query method andreduce the performance consumption of a database. The universal tree structure data query method comprises the following steps: establishing a tree structure in a database, wherein each node in the tree structure is used for storing resource data; optimizing a table structure of each node, wherein the table structure comprises a father node ID, a node ID, a node name, a node hierarchy and a searchID; and obtaining a query instruction, and obtaining a query result of the child node set through the search ID. The universal tree structure data query device applies the universal tree structure data query method provided by the scheme.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to the field of computer technology, in particular to a general tree structure data query method and device. Background technique

[0002] There are many kinds of relational databases commonly used, including Oracle database, mysql database, sqlServer database and db2 database. Among them, Oracle database and sqlServer database need to use specific functions and syntax to support recursive query, and mysql database and db2 database need to use custom Functions can support recursive queries. It can be seen that the existing relational databases have different methods for querying tree-structured data, and they all rely on recursive query strategies to realize the query of subtree data. As we all know, recursive query needs to query the database multiple times. In order to obtain the query set of sub-nodes, especially for tree structures with a large number of sub-nodes, more database performance is consumed. Contents of the inven...

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