WO2016082432A1

WO2016082432A1 - Data query method and device

Info

Publication number: WO2016082432A1
Application number: PCT/CN2015/076790
Authority: WO
Inventors: 冯电明; 于同泉
Original assignee: 中兴通讯股份有限公司
Priority date: 2014-11-27
Filing date: 2015-04-16
Publication date: 2016-06-02
Also published as: CN105701111A

Abstract

A data query method and device, the method comprising: one or more functional units sending a to-be-queried keyword to a centralized service unit respectively via corresponding client units; the service unit employing the received to-be-queried keyword to obtain a query result from a data base; and if the query result indicates the query is failed, then the service unit employing the keyword of the failed query to obtain a query result from the data base according to a preset re-query period. Through the technical solution provided in an embodiment of the present invention, re-querying is performed by the service unit to shorten a re-query path, thus improving re-query efficiency.

Description

Method and device for querying data

Technical field

This paper relates to database technology in the field of communications, and in particular to a method and apparatus for querying data.

Background technique

In a device for communication, such as a computer network device, it is often encountered that two or more functional units in the device need to query data from a database. The functional unit is used to implement a specific service function, for example, to implement a bidirectional forwarding detection (BFD) function. At present, the method for querying data includes: one or more functional units respectively send a to-be-checked keyword to a corresponding service unit via a corresponding client unit; the service unit forwards the received pending keyword to a database; and the database is based on the received The keyword is searched and the query result is returned to the service unit; the service unit returns the received query result to the corresponding client unit; the client unit determines whether the query is successful according to the received query result, and if the query is successful, the query result is obtained. The checked keyword is returned to the corresponding functional unit. If the query fails, the client unit sends a query for the failed query to the service unit according to the pre-set re-query period, so as to implement the re-inquiring query for the failed query. .

In the current method for querying data, if the query fails, the client unit periodically re-queries. On the one hand, since the query path of the re-query is: the client unit goes to the database via the corresponding service unit, the query path of the re-query is longer, and is required. The query time is longer, which makes the re-query less efficient; on the other hand, since the similar re-query function needs to be implemented in multiple client units, this increases the implementation resources.

Summary of the invention

In order to solve the above technical problem, an embodiment of the present invention provides a method and apparatus for querying data, which can shorten the query path of re-query, thereby improving query efficiency of re-query.

The embodiment of the invention discloses a method for querying data, including:

The one or more functional units respectively send the to-be-checked keywords to the unified service unit via the corresponding client unit;

The service unit obtains the query result from the database by using the received keyword to be checked. If the query result indicates that the query fails, the service unit obtains the query result from the database by using the keyword that fails the query according to the preset re-query cycle.

The service unit obtains the query result from the database by using the keyword to be checked, including:

The service unit forwards the received to-be-checked keyword to the database;

The database performs a query according to the received keyword to be checked, and returns the query result to the service unit.

If the query result indicates that the query is successful, the method further includes: the service unit transmitting the checked keyword in the query result to the functional unit via the client unit.

If the query result indicates that the query is successful, the method further includes: the service unit saves a correspondence between the to-be-checked keyword and the checked keyword in the query result.

When obtaining a message for notifying a re-query, the method further includes:

The service unit determines, according to the saved correspondence, whether there is a to-be-searched keyword that needs to be re-queried, and if so, obtains the query result from the database by using the determined to-be-checked keyword.

When the message includes the checked keyword, the determining whether the presence comprises: determining whether there is a corresponding pending keyword according to the checked keyword and the corresponding relationship in the message, and if yes, determining The pending keyword is the pending keyword that needs to be re-queried.

When the message includes the to-be-checked keyword, the determining whether the presence of the keyword includes: determining whether the keyword to be checked in the message exists in the correspondence, and if yes, determining the to-be-checked keyword is required Re-query the pending keywords.

The embodiment of the invention further discloses an apparatus for querying data, comprising one or more functional units, a client unit corresponding to the functional unit, a service unit, and a database, wherein

a functional unit, configured to send a to-be-searched keyword to the service unit via the corresponding client unit;

a client unit, configured to forward information between the functional unit and the service unit;

a service unit, configured to forward the to-be-checked keyword from the client to the database; when the query result from the database indicates that the query fails, the query result is obtained from the database by using a keyword that fails the query according to a preset re-query cycle;

The database queries the keywords to be checked from the service unit and returns the query results to the service unit.

The service unit is further configured to: when the query result indicates that the query is successful, send the checked keyword in the query result to the functional unit via the client unit.

The service unit is further configured to: when the query result indicates that the query is successful, save a correspondence between the to-be-checked keyword and the checked keyword in the query result.

When the message for notifying the re-inquiry is obtained, the service unit is further configured to: determine, according to the saved correspondence, whether there is the to-be-searched keyword that needs to be re-queried, and when it is determined to exist, use the determined to-be-checked The keyword obtains the query result from the database.

When the message includes the checked keyword and the message is obtained, the service unit is specifically configured to:

Determining whether there is a corresponding to-be-searched keyword according to the checked keyword and the corresponding relationship in the message, and when the existence is determined, obtaining the query result from the database by using the determined to-be-checked keyword.

When the message includes the to-be-checked keyword and the message is obtained, the service unit is specifically configured to:

Determining whether there is a to-be-searched keyword in the message in the correspondence, and when it is determined to exist, obtaining the query result from the database by using the determined keyword to be checked.

Compared with the related art, the technical solution of the embodiment of the present invention includes: one or more functional units respectively send a to-be-searched keyword to a unified service unit via a corresponding client unit; the service unit obtains the to-be-checked keyword from the database If the query result shows that the query fails, the service unit obtains the query result from the database by using the keyword that fails the query according to the preset re-query cycle. Through the technical solution of the embodiment of the present invention, the re-query by the service unit is implemented. On the one hand, since the query path of the re-query is: the service unit to the database, the re-query is performed. The query path is shorter, which improves the query efficiency of re-query. On the other hand, due to the re-query function implemented in the service unit, multiple clients are prevented from repeatedly implementing similar re-query functions, thereby saving resources.

Other features and advantages of the embodiments of the invention will be set forth in the description in the description in the claims The objectives and other advantages of the embodiments of the present invention can be realized and obtained by the structure of the invention.

BRIEF abstract

The accompanying drawings are used to provide a further understanding of the embodiments of the embodiments of the invention, and .

1 is a flowchart of a method for querying data according to an embodiment of the present invention;

FIG. 2 is a schematic structural diagram of a device for querying data according to an embodiment of the present invention.

Embodiments of the invention

Embodiments of the present invention will be described in detail below with reference to the accompanying drawings. It should be noted that, in the case of no conflict, the features in the embodiments and the embodiments in the present application may be arbitrarily combined with each other.

The steps illustrated in the flowchart of the figures may be executed in a computer system such as a set of computer executable instructions. Also, although logical sequences are shown in the flowcharts, in some cases the steps shown or described may be performed in a different order than the ones described herein.

FIG. 1 is a flowchart of a method for querying data according to an embodiment of the present invention. As shown in FIG. 1, the method includes:

Step 101: The one or more functional units respectively send the to-be-checked keywords to the unified service unit via the corresponding client unit.

It is emphasized here that one or more functional units respectively send the to-be-checked keywords to a unified service unit via the corresponding client unit.

Step 102: The service unit obtains the query result from the database by using the received keyword to be checked. If the query result indicates that the query fails, the service unit checks according to a preset re-query cycle. The failed keyword is retrieved from the database.

The service unit obtains the query result from the database by using the to-be-checked keyword, and the service unit forwards the received candidate keyword to the database; the database performs the query according to the received keyword to be checked, and returns the query result to the service unit.

The re-query cycle in step 102 can be a minute time, such as 1 minute, 5 minutes, or 10 minutes.

Optionally,

If the query result indicates that the query is successful, the method of the embodiment of the present invention further includes: the service unit sends the checked keyword in the query result to the functional unit via the client unit.

Optionally,

If the query result indicates that the query is successful, the method of the embodiment of the present invention further includes: the service unit saves the correspondence between the keyword to be checked and the checked keyword in the query result.

Correspondingly,

When the message for informing the re-inquiry is obtained, the method of the embodiment of the present invention further includes: the service unit determines, according to the saved correspondence, whether there is a to-be-searched keyword that needs to be re-queried, and if yes, uses the determined keyword to be checked from The database gets the result of the query; if it doesn't exist, it ends.

When the message includes the checked keyword, whether the foregoing determination includes: determining whether there is a corresponding candidate to be checked according to the checked keyword and the corresponding relationship in the message, and if yes, determining the to-be-checked keyword needs to be re-queried. The keyword to be checked.

When the message includes the to-be-checked keyword, whether the presence or absence of the above-mentioned determination includes: determining whether there is a to-be-searched keyword in the message in the correspondence, and if so, determining the to-be-checked keyword is a to-be-checked keyword that needs to be re-queried.

2 is an apparatus for querying data according to an embodiment of the present invention. FIG. 2 includes one or more functional units, a client unit corresponding to a functional unit, a service unit, and a database, where

The functional unit is configured to send the to-be-checked keyword to the service unit via the corresponding client unit.

A client unit, set to forward information between a functional unit and a service unit.

The service unit is configured to forward the to-be-searched keyword from the client to the database; when the query result from the database indicates that the query fails, the query result is obtained from the database according to the preset re-query period using the keyword that fails the query.

The database is set to query based on the pending keyword from the service unit and return the query result to the service unit.

Optionally,

The service unit is further configured to: when the query result shows that the query is successful, send the checked keyword in the query result to the functional unit via the client unit.

Optionally,

The service unit is further configured to: when the query result indicates that the query is successful, save the correspondence between the checked keyword and the checked keyword in the query result.

Optionally,

When the message for notifying the re-inquiry is obtained, the service unit is further configured to: determine, according to the saved correspondence, whether there is a to-be-checked keyword that needs to be re-queried, and when it is determined to exist, use the determined keyword to be checked from the database. Get the query results.

When the message includes the checked keyword, and the message is obtained, the service unit is configured to: determine whether there is a corresponding pending keyword according to the checked keyword and the corresponding relationship in the message, and when it is determined to exist, determine to use The pending keyword gets the query result from the database.

When the message includes the to-be-checked keyword and the message is obtained, the service unit is configured to: determine whether there is a to-be-checked keyword in the message in the correspondence, and when it is determined to exist, use the determined keyword to be checked to obtain from the database. search result.

One of ordinary skill in the art will appreciate that all or a portion of the steps of the above-described embodiments can be implemented using a computer program flow, which can be stored in a computer readable storage medium, such as on a corresponding hardware platform (eg, The system, device, device, device, etc. are executed, and when executed, include one or a combination of the steps of the method embodiments.

All or part of the steps of the above embodiments may also be implemented using an integrated circuit. These steps may be separately fabricated into individual integrated circuit modules, or a plurality of modules or steps may be implemented as a single integrated circuit module. Thus, the invention is not limited to any particular hardware and software. Combine.

The devices/function modules/functional units in the above embodiments may be implemented by a general-purpose computing device, which may be centralized on a single computing device or distributed over a network of multiple computing devices.

When each device/function module/functional unit in the above embodiment is implemented in the form of a software function module and sold or used as a stand-alone product, it can be stored in a computer readable storage medium. The above mentioned computer readable storage medium may be a read only memory, a magnetic disk or an optical disk or the like.

Industrial applicability

Through the technical solution of the embodiment of the present invention, the re-query is implemented by the service unit. On the one hand, since the query path of the re-query is: the service unit to the database, the query path of the re-query is shorter, thereby improving the query efficiency of the re-query. On the other hand, since the re-query function is implemented in the service unit, multiple clients are prevented from repeatedly implementing similar re-query functions, thereby saving resource realization.

Claims

A method of querying data, including:

The one or more functional units respectively send the to-be-checked keywords to the unified service unit via the corresponding client unit;

The service unit obtains the query result from the database by using the received keyword to be checked. If the query result indicates that the query fails, the service unit obtains the query result from the database by using the keyword that fails the query according to the preset re-query cycle.
The method according to claim 1, wherein the service unit obtains the query result from the database by using the to-be-checked keyword, including:

The service unit forwards the received to-be-checked keyword to the database;

The database performs a query according to the received keyword to be checked, and returns the query result to the service unit.
The method according to claim 1, if the query result indicates that the query is successful, the method further comprises: the service unit transmitting the checked keyword in the query result to the functional unit via the client unit.
The method according to claim 3, if the query result indicates that the query is successful, the method further comprises: the service unit saving a correspondence between the to-be-checked keyword and the checked keyword in the query result .
The method according to claim 4, when the service unit obtains a message for notifying a re-query, the method further comprises:

The service unit determines, according to the saved correspondence, whether there is a to-be-searched keyword that needs to be re-queried, and if so, obtains the query result from the database by using the determined to-be-checked keyword.
The method according to claim 5, wherein the message includes the checked keyword; the determining whether there is a to-be-searched keyword that needs to be re-queried includes: according to the checked keyword and the message The corresponding relationship determines whether there is a corresponding keyword to be checked. If yes, the determined keyword to be checked is a to-be-checked keyword that needs to be re-queried.
The method according to claim 5, wherein the message includes the to-be-checked keyword; the determining whether there is a to-be-checked keyword that needs to be re-queried includes: determining whether the message exists in the correspondence relationship The keyword to be checked in the case, if it exists, the identified keyword to be checked is the to-be-checked keyword that needs to be re-queried.
An apparatus for querying data, comprising: one or more functional units, a client unit corresponding to the functional unit, a service unit, and a database, wherein

The function unit is configured to send a to-be-searched keyword to the service unit via the corresponding client unit;

The client unit is configured to forward information between the function unit and the service unit;

The service unit is configured to forward the to-be-checked keyword from the client to the database; when the query result from the database indicates that the query fails, the query result is obtained from the database by using a keyword that fails the query according to a preset re-query cycle;

The database is configured to perform a query according to the to-be-checked keyword from the service unit, and return the query result to the service unit.
The apparatus according to claim 8, wherein the service unit is further configured to: when the query result indicates that the query is successful, send the checked keyword in the query result to the function via the client unit unit.
The apparatus according to claim 8, wherein the service unit is further configured to: save the check keyword between the checked keyword and the checked keyword in the query result when the query result indicates that the query is successful Correspondence relationship.
The apparatus according to claim 10, when obtaining a message for notifying a re-query, the service unit is further configured to: determine, according to the saved correspondence, whether there is the to-be-checked keyword that needs to be re-queried, when it is determined When present, the query result is obtained from the database using the determined key to be checked.
The apparatus of claim 11, wherein the message comprises the checked keyword; when the message is obtained, the service unit is set to:

Determining whether there is a corresponding to-be-searched keyword according to the checked keyword and the corresponding relationship in the message, and when the existence is determined, obtaining the query result from the database by using the determined to-be-checked keyword.
The apparatus of claim 11, wherein the message comprises the to-be-checked keyword; when the message is obtained, the service unit is set to:

Determining whether there is a to-be-searched keyword in the message in the correspondence, and when it is determined to exist, obtaining the query result from the database by using the determined keyword to be checked.
A computer readable storage medium storing program instructions that, when executed, implement the method of any of claims 1-7.