Data management device and data management method

Abstract

The invention provides a data management device and a data management method. The data management device comprises an acquisition module, a recording module and a query module, wherein the acquisition module acquires two-level data with superior-subordinate relationship among all combination from a pre-stored tree-structure data; the recording module takes parent-item data, parent-item levels, sub-item data and sub-item levels in the two-level data among all the combination as comparison relationship information to record; and the query module sets query conditions according to the recorded comparison relationship information so as to query the needed data at one or more than one of levels. In the invention, the levels and data nodes (in a tree structure) can be designated in the query conditions so as to easily query the data at any level and above or below any node.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a data management device and a data management method. Background technique [0002] At present, when the application database is used to store and query data in a tree-shaped storage structure (a storage structure with a hierarchical relationship between upper and lower levels), the storage method of lower-level storage of upper-level ID (Identity, identity number) is usually used, specifically: IDs are assigned to each level, and the ID of the upper level is directly recorded in the lower level records. For example, figure 1 It is a common tree structure diagram of an enterprise organization structure. "Headquarters" is the highest-level organization, which is assigned the ID mark "1"; "Headquarters" has distribution agencies and agency companies at all levels, and is assigned the ID mark "2" respectively. ~14...". Table 1 below shows the correspondence between org...

AI Technical Summary

Problems solved by technology

But you can only get all the superiors or subordinates, and there is nothing you can do to query the superiors or subordinates of any level, such as querying the level (level is not fixed) under a certain parent item, specifically such as querying the northern region (level 2 Unit) under the third-level agency (level 4) and those below level 4 do not need to query, there is nothing they can do

Images