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: 2006-11-08
HUAWEI TECH CO LTD
View PDF0 Cites 9 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, construct a dimension reduction strategy tree and place it in a relational database. When the required data is required, the system will automatically construct new query conditions sequentially according to the dimension reduction strategy tree, and then search 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 is queried and 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 in conjunction with the accompanying drawings and embodiments.

[0056] refer to figure 2 , figure 2 The implementation process of the method of the present inven...

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 shared, organized collection of relational data stored on a computer. Relational data is data represented by a relational digital model, and 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, which provide multiple-dimensional query conditions for users to input, and users need to retrieve the required information simply, quickly and intelligently , especially the widely used call center system, such as 114 telephone number inquiry desk, mobile 1860 customer service system, enterprise 800 call service center, etc. [0003] Usually, the implementation flow of the query to the database is a...

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 Applications(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

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

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