Service request processing method and device

A business request and processing device technology, applied in the field of data processing, can solve problems affecting user experience, increase the burden of the terminal where the application is located and network operations, and increase the burden of database operations, so as to avoid the reduction of user experience and avoid repeated sending of business requests , The effect of reducing the operating burden

Inactive Publication Date: 2018-10-12
BEIJING QIHOO TECH CO LTD +1
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] It can be seen that in the existing business request processing scheme, when the number of business requests currently processed by the database reaches the upper limit that the database can support, when a new application sends a business request to the database, on the one hand, since the database directly returns business requests to the application The request failed message, therefore, will affect the user experience
At the same time, using the application requires repeated service requests until the request succeeds, which will not only affect the user experience, but also increase the operational burden of the terminal where the application is located and the network
On the other hand, because the database has to repeatedly determine whether there is an idle connection and return a message of business request failure to the application, it will also increase the operational burden of the database.

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
  • Service request processing method and device
  • Service request processing method and device
  • Service request processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0018] refer to figure 1 , which shows a schematic flowchart of steps of a method for processing a service request in Embodiment 1 of the present invention.

[0019] The service request processing method in this embodiment includes the following steps:

[0020] Step S102: Intercept the service request sent by the application to the database.

[0021] Among them, the service request is any service request that the application can send to the database, for example: a request to obtain a user number, a request to obtain the remaining traffic value of a package, etc.

[0022] It should be noted that in this embodiment, the service request sent by the application to the database may be intercepted by the middleware set between the application and the database, or may be intercepted by any other appropriate device.

[0023] Step S104: Determine whether there is an idle connection to the database in the connection pool.

[0024] In the connection pool, according to the supportable...

Embodiment 2

[0032] refer to figure 2 , which shows a schematic flowchart of steps of a service request processing method according to Embodiment 2 of the present invention.

[0033] The service request processing method in this embodiment includes the following steps:

[0034] Step S202: the middleware intercepts the service request sent by the application to the database.

[0035] Wherein, in this embodiment, the middleware is used to intercept the service request sent by the application to the database, and the middleware is set between the application and the database. The so-called gap is not a gap in the physical sense, but because the middleware intercepts the data sent between the application and the database, so it is called the middleware set between the application and the database.

[0036] It should be noted that the application, middleware, and database can be set on the same device, or each can be set on one device, or a combination of two can be set on different devices....

Embodiment 3

[0052] refer to image 3 , which shows a schematic flowchart of steps of a service processing method according to Embodiment 3 of the present invention.

[0053] The business processing method of this embodiment specifically includes the following steps:

[0054] Step S302: The middleware generates a connection pool according to the connection information supported by the database.

[0055] Wherein, the middleware is arranged between the application and the database. A connection pool is used to manage the connections that a database can support.

[0056] An optional generation method for the middleware to generate a connection pool based on the connection information that the database can support is as follows: the middleware determines the upper limit of the connection that the database can support according to the connection information that the database can support; set the same number in the connection pool Connection. For example: the upper limit of connections suppo...

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

Provided are a service request processing method and device. The method comprises: intercepting a service request sent to a database from an application; determining whether an idle connection to the database exists in a connection pool; if not, saving the service request and continuing to determine whether an idle connection to the database exists in the connection pool according to a set rule, until an idle connection is produced in the connection pool; and selecting the produced idle connection and sending the service request to the database using the selected idle connection. By means of the present invention, a service request only needs to be sent once by an application, and thus it can be ensured that the service request can be processed by a database, so that not only the reduction of the usage experience caused by the fact that a user receives a service request failure message can be avoided, but the condition where the service request is sent repeatedly by the application can also be avoided. Therefore, the operation burden of a terminal and a network where the application is can be reduced, and the usage experience of the user can also be improved.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a service request processing method and device. Background technique [0002] At present, in the relational database system and the non-distributed database system, the architecture of direct connection between the application and the database is mainly adopted. When a database system with this architecture processes a business request, the application directly sends the business request to the database, and the database returns the corresponding response result to the application. [0003] With this existing business request processing scheme, when the number of business requests currently processed by the database reaches the upper limit that the database can support (the number of connections to the database reaches the upper limit), and when a new application sends a business request to the database, the database receives the business request After the reques...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/00
Inventor 朱超陈非王超
Owner BEIJING QIHOO TECH CO LTD
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