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.
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
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.
PUM

Abstract
Description
Claims
Application Information

- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.
© 2023 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap