Database retrieval method based on search engine technology

A search engine and database technology, applied in the direction of structured data retrieval, database model, relational database, etc., can solve the problems of high performance cost and performance degradation, and achieve the effect of high-efficiency retrieval function

Inactive Publication Date: 2014-04-23
GOSUNCN TECH GRP
View PDF5 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Due to the characteristics of relational databases, after the relevant fields are indexed, the performance of other database operations, such as inserting, updating, deleting, etc. will be reduced; moreover, when the retrieval conditions are complex, more fields need to be indexed, The performance cost will be greater
In addition, after the database is partitioned and table-divided, if you need to search in the global data, you still have to face the performance problem of data merging and sorting

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
  • Database retrieval method based on search engine technology

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The present invention will be further described below in conjunction with the accompanying drawings.

[0028] combine figure 1 Shown, a kind of database retrieval method based on search engine technology, described method comprises:

[0029] S1. Set up a retrieval server with a service interface to provide auxiliary fast retrieval services. The retrieval server regularly obtains updated data from the relational database according to the set time interval and in combination with the timestamp of the latest data acquisition. Data, after the new data is word-segmented, an inverted index is built based on the word-segmentation and the inclusion relationship of the document, and written into a compact index file. When the index file increases to a certain extent, merge it;

[0030] S2. The application software sends a retrieval request to the retrieval server through the service interface;

[0031] S3. The retrieval server searches the index files for content that meets t...

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 database retrieval method based on the search engine technology. The method comprises that S1, a retrieval server with a service interface for providing auxiliary rapid retrieval service is set, and the retrieval server obtains data from a relational database and establishes indexes; S2, a client sends a retrieval request to the retrieval server through the service interface; S3, the retrieval server obtains a retrieval result according to retrieval conditions and sends the retrieval result to the client through the server interface; S4, the client processes and displays the returned result. The database retrieval method based on the search engine technology adds the retrieval server under the premise of not affecting the system performance of an original database to achieve a high-efficiency retrieval function.

Description

technical field [0001] The invention relates to information retrieval technology, in particular to a database retrieval method based on search engine technology. Background technique [0002] Currently, to retrieve the contents of a relational database, SQL query statements are generally written and executed by the database system. However, for a large number of records, such as hundreds of millions, the efficiency of database retrieval is very low. [0003] In order to improve the retrieval efficiency, the technical methods currently used are all optimized around the database itself, including: 1. Indexing the fields that often need to be used as retrieval conditions; 2. Partitioning or sub-table processing of large database tables, combined with applications Logic optimization to improve the efficiency of retrieval of some data. [0004] However, although creating indexes and partitioning tables can improve the efficiency of content retrieval for relational databases, th...

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/2228G06F16/284
Inventor 劳定雄吴仲谋陈刚蔡青
Owner GOSUNCN TECH GRP
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap