Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Information searching method and device in relation ship data bank

An information retrieval and database technology, applied in the field of database applications, can solve the problems of long time-consuming query process and low efficiency, and achieve the effects of shortening the average service time, avoiding network transmission, and reducing work intensity

Inactive Publication Date: 2009-04-29
HUAWEI TECH CO LTD
View PDF3 Cites 27 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0019] The purpose of the present invention is to provide a method for information retrieval in a relational database, to overcome the need for manual intervention to perform another query operation when the required information cannot be retrieved in a query in the prior art, so that the query process takes a long time, The disadvantage of low efficiency can reduce the time consumed by network transmission and middleware calls, and improve query efficiency

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
  • Information searching method and device in relation ship data bank
  • Information searching method and device in relation ship data bank
  • Information searching method and device in relation ship data bank

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] The core of the present invention is that in an application system based on a relational database, according to business logic and / or business data distribution, a dimensionality reduction strategy tree is constructed and placed in the relational database. When the database is not retrieved according to user query conditions, When data is needed, the system automatically constructs new query conditions according to the dimension reduction strategy tree in turn, and then searches the database again according to the new query conditions, until the required data is obtained or the root node of the dimension reduction strategy tree returns None Information about the required data.

[0055] In order to enable those skilled in the art to better understand the solution of the present invention, the present invention will be further described in detail below with reference to the accompanying drawings and embodiments.

[0056] Reference figure 2 , figure 2 Shows the implementatio...

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

This invention discloses an information index method in a relation-type database including the following steps: structuring a dimensionality reduction strategy tree to be set in a database system, in which, said tree includes at least a sub-node and a root node, each sub-node includes the identification information of the local node number and enquiry condition combination information and lower level sub-node number, when searching said database according to user enquiry condition but does not get the necessary data, it structures new enquiry conditions based on the strategy tree, searching the database according to a new enquiry condition till getting the necessary data or enquiring the root node of the tree to feed back information of the undesired data. This invention discloses an information index device in a relation-type database including: an enquiry condition obtaining unit, an enquiry condition output unit, a strategy tree storage unit and an operation unit.

Description

Technical field [0001] The invention relates to database application technology, in particular to an information retrieval method and device in a relational database. Background technique [0002] A relational database is a collection of shared and organized relational data stored on a computer. Relational data is data represented by a relational digital model. The relational mathematical model describes data in the form of a two-dimensional table. In application systems that use relational databases to store information, there are a large number of multi-dimensional queries. This type of query provides multiple dimensional query conditions for users to input. At the same time, users need to retrieve the required information simply, quickly and intelligently. , Especially the widely used call center systems, such as 114 telephone number inquiry desk, mobile 1860 customer service system, enterprise 800 telephone service center, etc. [0003] Usually, the implementation process of ...

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 HUAWEI TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products