Fast retrieval and generation display method for task tree based on SQL database

A database and task technology, applied in the field of structured query language SQL retrieval, can solve the problem that sorting rules cannot be quickly retrieved, and achieve the effect of fast task tree retrieval and shortened query time

Inactive Publication Date: 2010-09-08
LINKAGE SYST INTEGRATION
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0018] The problem to be solved by the present invention is: the SQL language cannot quickly retrieve the unrecognizable sorting rules, especially for the task tree in project management, a method for quickly retrieving the task node information in the database table is needed

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
  • Fast retrieval and generation display method for task tree based on SQL database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] For basic SQL statements, the format of the task node number cannot identify its size relationship. The query sorting of SQL statements uses the size of the sorting keywords to sort, so as to list the SQL query results. What needs to be solved is how to convert the task node number into information that can be sorted by SQL.

[0029] The present invention converts the task node numbers of the task tree into information that can be sorted by SQL. Specifically, each group of numbers of the task node numbers is subjected to numerical weighting processing, and then code conversion is performed to form a sorting value that can be determined by the database. According to the obtained Sorting values, sorting the task nodes through SQL language, realizing the retrieval of the task tree, and further generating and displaying; the value weighting process is: determine the weighting factor f according to the maximum number of child nodes under each node of the task tree, and the w...

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 method for fast retrieving, generating and displaying a task tree based on an SQL database. The method is characterized in that the number of task nodes of the task tree is converted into information capable of ordering for SQL, particularly, the numerical value weighting process and the code conversion are performed to each group of number for the number of task nodes, so as to form ordering numerical values through which the database can judge the size, ordering of the task nodes is performed through SQL language according to the obtained ordering numerical values,so as to realize retrieval of the task tree, and the further generating display is performed. Wherein, the numerical value weighting process adopts the way that each group of number for the number ofthe task nodes is multiplied by weighting factors to achieve the weighting process; the code conversion adopts the way that each group of number for the number of task nodes after the weighting process is connected in the form of character strings in sequence in the number of task nodes, and final format conversion values or ordering numerical values of the number of task nodes are obtained.

Description

technical field [0001] The invention relates to a structured query language SQL (Structured Query Language) retrieval technology, in particular to a method for fast retrieval and generation and display of a task tree based on an SQL database. Background technique [0002] In the SQL language, a large number of query and sorting methods are provided. The SQL language has certain requirements for the basis of sorting, such as simple numerical sorting, according to the size of the value; character sorting, sorting according to the size of its ASCII code; and time sorting, according to the order of time. [0003] The execution efficiency of the same statement to achieve the purpose varies greatly with different combinations. In actual application, if the required sorting basis does not conform to the default sorting rules of SQL, but a sorting rule that cannot be recognized by SQL, generally the following methods are used to deal with this problem: [0004] 1) Extract the data...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 黄锡伟曹阳柏传军李玉凌
Owner LINKAGE SYST INTEGRATION
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