Method for querying keyword based on topic cluster unit in relational database

A query method and database technology, applied in the field of keyword query based on subject cluster units, can solve the problems of not considering the query efficiency of large-scale relational databases, unfavorable users to find expected query answers, and large-scale tables.
CN105975488AInactive Publication Date: 2016-09-28HARBIN ENG UNIV
3 Cites 20 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
HARBIN ENG UNIV
Publication Date
2016-09-28
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention relates to the field of information retrieval, in particular to a method for querying a keyword based on a topic cluster unit in a relational database, and aims to solve the problem of huge time overhead caused by frequent table connections in a query process for an existing keyword online query method as well as the problem of low query efficiency of an existing keyword offline query method for query on a large-scale database with a complicated internal structure and huge data volume. The method for querying the keyword based on the topic cluster unit in the relational database is implemented by the following steps of 1, constructing a topic cluster unit: (1), performing vertical grouping based on data table characteristics and query logs; (2), proposing a table connection sequence optimization scheme in a topic cluster; and (3), performing horizontal grouping based on a topic cluster tuple association graph; 2, establishing an association rule-based index optimization mechanism; and 3, returning a query result to a user. The method is applied to the field of the information retrieval.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to the field of information retrieval, in particular to a keyword query method based on subject cluster units in a relational database. Background technique

[0002] In recent years, keyword query has been successfully applied as an important query technology in the field of information retrieval. Because of its simple and easy-to-use features, it is accepted by more and more users. For relational databases, there is also a need for a simple and effective query method to obtain information of interest to users from complex relational databases. Traditional structured query methods, such as SQL query, not only require users to understand the complex underlying schema of relational databases, but also require users to master the use of related query languages, which brings great difficulties and inconveniences to the query work. Therefore, keyword query technology based on relational database has received extensive attention. Som...

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