A dielectric constant database retrieval method and system

A technology of dielectric constant and retrieval system, which is applied in the field of database retrieval, can solve problems such as inappropriateness and degradation of retrieval performance, and achieve the effects of improving relevance, speed of retrieval, and ease of use

Active Publication Date: 2016-03-30
KUNMING UNIV OF SCI & TECH
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, many technical terms do not have a unified rule to follow, such as "titanium concentrate", it is obviously inappropriate to analyze it as "titanium concentrate" and "concentrate".
At the same time, using the fuzzy retrieval method, the database system will scan text fields during retrieval. If too much fuzzy retrieval is used, the retrieval performance of the system will decrease.

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
  • A dielectric constant database retrieval method and system
  • A dielectric constant database retrieval method and system
  • A dielectric constant database retrieval method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0041] The concept tree structure is: the first layer is the root node, the second layer is metal elements, the third layer is a compound, and the fourth layer is mineral.The sub -node of the point is the mineral containing the compound. In addition to the root node, the information of each node is in addition to the field value of the mineral name, but also includes molecular formula, taste and power value.The content of the compounds of its parent node contained in the minerals is percentage, and the quality of the remaining nodes is set to 1.

[0042] Step S102: Search for retrieval words associated with user retrieval words in the concept tree. After obtaining the retrieval word entered by the user, search for the field value in the concept tree.Then insert the node and its related nodes into a node list according to the rules, continue to execute the search until the search for the full concept tree, and return the node list;

[0043] If the concept tree is N layer, in order ...

Embodiment 2

[0065] Table 1

[0066]

[0067] Table 2

[0068] The establishment of the concept tree can be edited and established through the relevant software, or it can be established through the procedure. The conceptual tree generation module 202 can further establish the concept tree further according to the recorded fields of the search field.In the field, a main correlation factor between minerals is chemical elements, compounds, and mineral components. In this example, the name is "mineral name" as a search field, and the method of automatic establishment of concept tree in the conceptual tree generation module 202 uses a method of automatic establishment of concept treeThe

[0069] a) Establish a list of metal elements;

[0070] b) From the mineral component table and mineral dielectric constant table, the compound and mineral list is obtained through the association query;

[0071] c) Further, first establish the root node of the concept tree;

[0072] d) The second layer of metal...

Embodiment 3

[0090] The SQL statement generation module 204 submits the SQL statement to the database retrieval module 205 to search in the database. Through the search, the "Titanium Iron Mine" and the "magnesium titanium ore" dielectric constant information can be obtained.Display module 206 to the user through the interface.

[0091] If the correlation parameter is set to r = 2, satisfy R image 3 Among the concept trees shown, the parent nodes of the second floor of "Titanium Iron Mine" include "titanium" and "iron". According to the rules, the concept tree search module in the SQL statement generation module 204 will bring "titanium" andAll sub -nodes of "Iron", including compound nodes and mineral nodes, are inserted into the list of nodes, and the final SQL statement is:

[0092] "SELECT mineral name, quality, dielectric constant, dielectric loss from omatomy Frequency table where mineral name =‘ titanium ’or mineral name =‘ titanium dioxide ’or mineral name =‘ fETIO 3 'OR mineral name =...

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 provides a dielectric constant database retrieval method and system, including the following steps: (A) establishing a concept tree; (B) searching for user search terms in the concept tree to obtain more relevant search terms; (C) generating Query condition expression; (D) Retrieve the database; (E) Reorder the retrieval results. The present invention also provides a dielectric constant database retrieval system, which includes: database; database management module; concept tree generation module; interface input module; SQL statement generation module; database retrieval module; interface display module. The beneficial effects of the present invention are: the correlation degree of information retrieval in relational databases is improved, and the time for users to search for information is saved; the correlation degree is further quantified in combination with the concept tree, and a correlation degree parameter is introduced, so that when retrieving information for users, accuracy and fuzzy More options are provided; the relationship between search terms and concepts is used to dynamically calculate weights to further improve user experience.

Description

Technical field [0001] The invention involves the field of database retrieval and especially involves a dielectric constant database retrieval method and system. Background technique [0002] Minerals' dielectric constants have important reference value in many scientific research fields. The dielectric constant refers to an important data for the electrical performance of electrical or insulating materials for electrical or insulating materials.In the field of metallurgy, there are many mineral records involved in the mineral dielectric constant database, and how to effectively retrieve the information required by the user in a large number of databases in a large number of databases is also an important research direction for database systems in various professional fields.Essence [0003] When retrieved mineral dielectric constants in the database, retrieval is based on the name of the mineral.If you retrieve the "sulfur mine", the conventional database retrieval method can be...

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 KUNMING UNIV OF SCI & TECH
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