Check patentability & draft patents in minutes with Patsnap Eureka AI!

Database design method for quickly generating tree structure

A design method and database technology, applied in electrical digital data processing, special data processing applications, computing, etc., can solve the problems of suspended animation of application systems and affect system efficiency, and achieve the effect of improving operating efficiency, saving server resources, and improving efficiency.

Active Publication Date: 2013-01-30
BEIJING JINHER SOFTWARE
View PDF5 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, in the traditional application system, the design of the tree structure database is that the child nodes record the ID of the parent node, and the tree structure is produced in a recursive manner when the page is displayed. This design method seriously affects the system when a large amount of data is displayed. Efficiency, which may cause the entire application system to be in a state of suspended animation

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
  • Database design method for quickly generating tree structure
  • Database design method for quickly generating tree structure
  • Database design method for quickly generating tree structure

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] The present invention will be further described below with reference to the accompanying drawings, so that those skilled in the art can implement the present invention with reference to the present specification.

[0017] like figure 1 As shown, the database design method of the rapid spanning tree structure of the present invention comprises the following steps:

[0018] Step 1, create a two-dimensional table in the database with tree-like relationship data, including a tree structure information table and a Sort table, the tree structure information table is used to record the node information in the tree structure, and the node information includes node ID, A description of the node name, its parent node ID, and other attribute information. The traditional way is to use the tree structure information table to generate tree structure data in a recursive way. This design method seriously affects the system efficiency when a large amount of data is displayed, and may c...

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 a database design method for quickly generating a tree structure, which comprises the following steps that (1) a tree structure information sheet and a Sort sheet are created in a database with tree relation data, the tree structure information sheet is used for recording node information in the tree structure, the Sort sheet is related to the tree structure information sheet and used for recording the relation between nodes of the tree structure, and each node has a Sort ID value; (2) when the node information in the tree structure information sheet is modified, the modified information is saved in the tree structure information sheet and related in the Sort sheet, and then the Sort sheet is reordered, so that the modified tree structure relation is recorded in the Sort sheet; and (3) sequencing is performed according to the field ID value in the Sort sheet, data are read, and the tree structure information is queried. By using the method disclosed by the invention, the operating efficiency is increased, and server resources are saved.

Description

technical field [0001] The invention relates to the field of computer technology, and more particularly, to the field of database design in an application system. Background technique [0002] At present, in the traditional application system, the design of the tree structure database is that the child nodes record the ID of the parent node. When the page is displayed, the tree structure is produced in a recursive way. This design method seriously affects the system when a large amount of data is displayed. Efficiency may cause the entire application system to be in a state of suspended animation. SUMMARY OF THE INVENTION [0003] The purpose of the present invention is to provide a database design method for rapidly generating tree structure, which is directly generated by direct sorting when generating tree structure data in all application systems. [0004] In order to solve the difficulties existing in the prior art and achieve the above purpose, the present invention...

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
IPC IPC(8): G06F17/30
Inventor 刘欣茹
Owner BEIJING JINHER SOFTWARE
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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