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

Keyword search method of relational database

A query method and database technology, applied in relational databases, database models, electrical and digital data processing, etc., can solve problems such as difficult to solve ambiguity problems, unsolved path selection and other problems, and achieve the effect of simplifying schema diagrams

Inactive Publication Date: 2015-04-29
BEIJING AEROSPACE FUDAO HIGH TECH
View PDF2 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] These methods have their own limitations: unifying the relationship requires a special design of the database table; the minimum connection is difficult to solve the ambiguity problem; the partition-based method does not solve the path selection in the case of lossless connection

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
  • Keyword search method of relational database
  • Keyword search method of relational database
  • Keyword search method of relational database

Examples

Experimental program
Comparison scheme
Effect test

example

[0152] Taking the museum database as an example, it includes the management of staff, artegacts, and events: such as Figure 11 Shown:

[0153] If the task to be performed is as follows:

[0154] 1. Find the name of the museum and its corresponding owner;

[0155] 2. Find employees who were born after 1990 and work in the "National Craft Museum";

[0156] 3. Find crafts made after 1990, which are named after "Modern Art".

[0157] A set of keywords that need to be queried needs to be released to users to know:

[0158] museum (museum), department (department), staff (employee), artifact (craft), event (event), director (owner).

[0159] The user can then execute the following query:

[0160] 1. Query museum.name, museum.owner

[0161] 2. Query employee conditions employee.birthday>=1990-01-01 and museum=”National Craft Museum”

[0162] 3. Query handicraft conditions handicraft.time>=1990 and exhibition.name="modern art"

[0163] The system converts the user query into ...

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 keyword search method of a relational database. The method comprises the steps of 1) providing a serial of search keywords to a user through a search system for a special database; 2) inputting the keywords by the user during searching, and combining the keywords by the system; 3) performing dependence mapping of the keywords combination and database search language SQL by the system; 4) dynamically linking with the database through SQL search language, so as to achieve accurate data search. According to the method, a keyword search language is provided to the user; the user can accurately search in the database through the language; the search language is flexible and can be flexibly configured when the database structure changes; the grammar is simple and intuitive, and the user can use easily; the search result is accurate.

Description

technical field [0001] The invention relates to a data search method, in particular to a keyword query method of a relational database. Background technique [0002] With the popularity of search engines and the explosive growth of document data, keyword query has become the main way of information retrieval. However, in the field of relational databases, information is divided into different database tables through relationships, which also brings obstacles to providing keyword queries while achieving high data consistency, high reliability, and less redundancy. Because the data after multi-table connection is the result of the query, the inverted index method for the document cannot be directly applied to the relational database system; the update of a single table involves the update of a large amount of data, making this A problem is more complicated. The result of the SQL (Structured Query Language) statement is real-time, and the update of the search engine is freque...

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
CPCG06F16/2455G06F16/285
Inventor 梁栋
Owner BEIJING AEROSPACE FUDAO HIGH TECH
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