Database agency method and device

An agent device and database technology, applied in the database field, can solve the problems affecting system performance, large amount of data, frequent database operations, etc., and achieve the effects of high query efficiency and short response time.

Active Publication Date: 2014-04-16
BEIJING FEINNO COMM TECH
View PDF4 Cites 28 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, at present, many database proxy software do not do the separation of reading and writing of the back-end database, or multiple databases use the same connection pool, which increases the pressure on the database and increases the resp

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 agency method and device
  • Database agency method and device
  • Database agency method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] In order to make the object, technical solution and advantages of the present invention clearer, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0045] figure 1 It is a flow chart of the first preferred embodiment of the database proxy method of the present invention, which receives the request sent by the database application terminal according to the application needs, and returns the execution result to the database application terminal. The method includes the following steps:

[0046] S100. Establish a connection pool for each of the multiple databases.

[0047] S200. Receive the request sent by the database application end.

[0048] S300. Call the database connection in the connection pool to perform database operation according to the received request.

[0049] S400. Return the execution result to the database application side.

[0050] figure 2 It is a detailed flowchart of ...

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 agency method and device. The database agency method includes the first step of establishing one connection pool for each database in multiple databases, the second step of receiving requests sent by database application clients, the third step of calling database connection in the connecting pools for database operation according to the received requests, and the fourth step of returning execution results to the database application clients. The third step of calling database connection in the connecting pools for database operation includes analyzing information in the requests to obtain database operating commands, determining the databases as operating objects according to the database operating commands and configuration information, wherein the configuration information includes database types of the multiple databases, calling the database connection in the connecting pools corresponding to the determined databases, applying the database connection to send the database operating commands to the determined databases, and receiving the execution results from the determined databases.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database agent method and device. Background technique [0002] The database agent is located between the underlying database and the user application system. It is mainly used to shield the underlying details of the heterogeneous database. It is a bridge for communication between the application server and the background database. When the application server needs to perform an operation request on a database, such as an SQL request, it searches for a matching database connection through the database middleware, forwards the SQL request to the corresponding database, and operates the database through the database middleware. Its main function is to encapsulate the complex and cumbersome database application interface and database operation process, simplify the database operation of the application program, and improve the efficiency of application program development. [0...

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
IPC IPC(8): G06F17/30
CPCG06F16/252G06F16/27
Inventor 魏智强
Owner BEIJING FEINNO COMM 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