A multi-tree structure database design method and device
A design method and tree structure technology, applied in the database field, can solve problems such as inability to effectively realize real-time change of multi-tree nodes, and achieve the effect of improving tree query and processing efficiency and low memory resource consumption
Active Publication Date: 2019-08-13
CHINA CONSTRUCTION BANK
View PDF7 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
When elements exist in multiple trees, they can only be changed sequentially according to the type of the tree, and real-time changes of multi-tree nodes cannot be effectively realized
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0024] 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 creative efforts fall within the protection scope of the present invention.
[0025] The embodiment of the present invention provides a multi-tree structure database design method and device, which can reduce memory resource consumption and realize real-time change of multi-tree nodes. The following are detailed introductions respectively.
[0026] see figure 1 , figure 1 It is a schematic flowchart of a method for designing a database with a multi-tree structure provided by an embodiment of the present invention. Such as figure 1 As sho...
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
Login to View More Abstract
An embodiment of the invention discloses a multi-tree structure database design method. The multi-tree structure database design method comprises the following steps of establishing a node information table and a node relational table; correspondingly changing the element basic information of a changed element in the node information table when element change is generated; inquiring element rule serial numbers which are corresponding to different trees in the node relational table according to an element serial number of the changed element and other attached condition information of the changed element and generating into new element rule serial numbers based on a father node element serial number of the changed element and the element rule serial numbers; updating the element rule serial numbers of involved change records in the node relational table according to a change type of the changed element. The multi-tree structure database design method can reduce internal storage resource consumption, improve the tree inquiring and processing efficiency and achieve change of multi-tree nodes in real time.
Description
technical field [0001] The invention relates to the field of databases, in particular to a multi-tree structure database design method and device. Background technique [0002] In the design of database systems, tree structure is an important form of information organization, and all prototypes with hierarchical relationships can be described by trees. At present, the social division of labor is becoming more and more refined, and tree elements no longer exist alone. On the one hand, the same individual element may exist in multiple trees. Taking people as an example, they are a node in the family tree at home, and employees in the enterprise. A certain node of the tree, etc. On the other hand, the relationship between different element individuals is also diversified. Therefore, the efficiency of multi-tree storage and query will seriously affect the performance and resource utilization of computer information systems. [0003] At present, for the database design method 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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/22
CPCG06F16/21G06F16/2246
Inventor 高剑武陶晖刘青周剑一王海涛洪晓林廖爽吴昀蓁齐珑王京花
Owner CHINA CONSTRUCTION BANK