Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database middleware and method for achieving connection between client and server by usingdatabase middleware

A client-server technology, applied in database management systems, structured data retrieval, electronic digital data processing, etc., can solve the problems of low efficiency of database middleware, and achieve the effect of improving performance and reducing waste.

Active Publication Date: 2021-04-06
HIGHGO SOFTWARE
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] The embodiment of the present invention provides a database middleware and its method for realizing the connection between the client and the server, so as to solve the problem of low working efficiency of the database middleware in the prior art

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 middleware and method for achieving connection between client and server by usingdatabase middleware
  • Database middleware and method for achieving connection between client and server by usingdatabase middleware
  • Database middleware and method for achieving connection between client and server by usingdatabase middleware

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0040] In the first embodiment, a database middleware implements a method for connecting a client to a server, such as figure 1 shown, including:

[0041] S1, create a service sub-process with the minimum number of idle service sub-processes;

[0042] S2, the service subprocess receives the connection request from the client, and connects the client to the server according to the connection request;

[0043] S3, when the number of idle service sub-processes is less than the minimum number of idle service sub-processes, create a service sub-process with the minimum number of idle sub-processes again until reaching the limit of the maximum number of service sub-processes;

[0044] S4. When the number of idle service sub-processes is greater than the maximum number of idle service sub-processes, recycle some idle service sub-processes.

[0045] Further, the method also includes:

[0046] Initialize a global connection pool shared by all processes. The global connection pool in...

no. 2 example

[0064] In the second embodiment, a database middleware applied to a session-level connection realizes a method for connecting a client to a server, such as figure 2 As shown, the method includes:

[0065] When the server starts, the main process creates a configurable number of service sub-processes to wait for the connection of the client;

[0066] Initializes a global connection pool shared by all processes. Connect to the back-end database server cluster through a connection pool. The global connection pool saves the connection information of the front and back ends. The size of the connection pool can be set through the configuration file.

[0067] like image 3 As shown, the information saved in the global connection pool includes information such as the connected user name, database name, and access time. In addition to these information, the connection identification information of the middleware connecting to each node of the back-end database cluster is also sav...

no. 3 example

[0075] In the third embodiment, a database middleware applied to a transaction level connection implements a method for connecting a client to a server. Its basic processing flow is the same as that of a session level connection. After the transaction, the connection will be set to an idle state, so that the connections of the same front-end user and the same database can use this slot connection again to achieve reuse.

[0076] Session-level connection processing has a flaw: a session always occupies a connection pool slot in the connection to the back-end database server, even if the session is not currently performing any operations; this will cause the connection resources in the slot waste, which degrades the performance of the entire system. The use of transaction-level connections can effectively use this part of resources and improve the performance of the entire system.

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 middleware and a method for achieving connection between a client and a server by using database middleware. The invention discloses a method for realizing connection between a client and a server by database middleware. The method comprises the following steps: creating a service sub-process with the minimum idle service sub-process number; the service sub-process receives a connection request of the client and connects the client to the server according to the connection request; when the number of the idle service sub-processes is smaller than the minimum number of the idle service sub-processes, creating the service sub-process with the minimum number of the idle service sub-processes again until the limit of the maximum number of the service sub-processes is reached; and when the number of the idle service sub-processes is greater than the maximum number of the idle service sub-processes, recovering part of the idle service sub-processes. By adopting the method, the maintenance connection service sub-processes can be dynamically created, the waste of computer resources can be reduced at the beginning, and the number of the service sub-processes can be increased when the connection number of the clients is increased, so that more clients can be served, and the performance of the whole database service system can be improved.

Description

technical field [0001] The invention relates to the field of database middleware, in particular to a database middleware and a method for realizing connection between a client and a server. Background technique [0002] Database middleware sits in the middle of database servers and database clients. The client directly sends the sql statement to the middleware, and the middleware operates the underlying database and returns the result. Middleware generally provides functions such as cluster management, connection pool, and SQL statement routing. [0003] The connection pool of the middleware has the characteristic of saving the connection to the back-end database; for the frequent connection and disconnection operations of a large number of clients, the connection pool can reduce the number of connection establishment times of the database server and improve the efficiency of the database server. Therefore, connection pooling is an important function point in middleware. ...

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): G06F16/25G06F9/50
CPCG06F16/252G06F9/5005
Inventor 周健身苗健卢健张鲁敏李鹏
Owner HIGHGO SOFTWARE
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com