Database retrieval method and system

A database and index retrieval technology, applied in the Internet field, can solve problems such as the large-scale promotion and adoption of unfavorable technical solutions, increase the cost or complexity of technical solutions, and the difficulty of implementing solutions, so as to improve speed, save costs, and improve overall efficiency. Effect

Pending Publication Date: 2018-03-27
TVM BEIJING TECH
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0017] Existing database retrieval technology solutions, in order to solve the huge number of user visits and peak visits at a specific moment, commonly used solutions include: database SQL slow query optimization, such as rebuilding related indexes, optimizing where clauses, etc.; Write separation, such as MySQL's Master / Slave structure; database sub-database sub-table, this solution can reduce the pressure on a single database server, but it will also bring system complexity
The above-mentioned solutions will increase the cost or complexity of the technical solution, resulting in difficulty in the implementation of the solution, which is not conducive to the large-scale promotion and adoption of this type of technical solution

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 and system
  • Database retrieval method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] The preferred embodiments of the present invention will be described below in conjunction with the accompanying drawings. It should be understood that the preferred embodiments described here are only used to illustrate and explain the present invention, and are not intended to limit the present invention.

[0046] figure 1 It is a flow chart of the database retrieval method in Embodiment 1 of the present invention. Such as figure 1 As shown, the process includes the following steps:

[0047] Step S101, analyzing search keywords.

[0048] Step S102, judging whether the keyword is in the index, if so, turn to S105.

[0049] Retrieve keyword, if there is this keyword in the index, then turn to step S105;

[0050] If not, execute step S103.

[0051] The index is stored in the cache;

[0052] Retrieval of the index is also done in memory;

[0053] The storage and retrieval of indexes supports the cluster memory model of cluster servers.

[0054] Step S103, searching...

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 and system. The method comprises the steps that S101, a retrieval keyword is analyzed; S102, whether the keyword is in an index is judged, if yes, the step S105 is turned to; S103, retrieval is performed on a database, whether the keyword exists in the database is judged, and if not, the step S105 is turned to; S104, index entries of the keywordare established; and S105, a retrieval result is output. Through the technical scheme, cost of the overall technical scheme is saved, database information retrieval speed is increased, the complexityof the technical scheme is lowered, the comprehensive efficiency of database retrieval is improved, and the database retrieval method and system meet the demand of the Internet technology and the market for rapid development.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a database retrieval method and system. Background technique [0002] The rapid development of the Internet has become an important part of people's lives and an important carrier for the spread and development of human civilization. It has penetrated into all aspects of economic, political, cultural, and social life, and has changed people's communication and thinking methods. Whether it is in the industrial field or in the field of social life, the Internet has brought great changes to people. [0003] As the core of Internet data records, databases also penetrate into all aspects of society and are widely developed and applied. A database is a collection of related data organized according to a certain structure and rules. It is established from a global perspective and organized, described and stored according to a certain data model. Its structure is based on the natu...

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/245
Inventor 陈杰
Owner TVM BEIJING TECH
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