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

Database access method and system

An access method and database technology, applied in the directions of database distribution/replication, transmission system, structured data retrieval, etc., can solve the problems of heavy application server load, inability to support large user scale and growth of popular applications, and ensure correctness Effect

Active Publication Date: 2022-02-25
HUAWEI TECH CO LTD
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This will lead to two problems: the number of supported users is limited, and the database has a maximum number of connections, which limits the maximum number of application servers, making it impossible to support the large user scale of popular applications; the number of supported APPs is limited, and the number of APPs is limited. The growth will cause the number of database connections of each application server to increase exponentially, and finally the load of the application server will be too large to establish new connections
However, in the existing database proxy solution, the application server establishes multiple physical connections with the proxy server, and the increase in the number of APPs will still cause the number of connections of each application server to increase exponentially, which will eventually lead to excessive load on the application server and the establishment of no new connection
In addition, since a connection from an application server to a proxy server corresponds to a connection from a proxy server to a database, the maximum number of connections to the database still limits the number of connections from the application server to the proxy server, resulting in the inability to support the large user scale of popular applications

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 access method and system
  • Database access method and system
  • Database access method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] The technical solutions in the embodiments of the present application will be described below with reference to the accompanying drawings.

[0057] figure 1 It is a schematic diagram of an architecture of a device-cloud application system according to an embodiment of the present application. Such as figure 1 As shown, the system includes a user device 11 , an application layer 12 , an agent layer 13 , a management device 14 and a storage layer 15 . Wherein, the application layer 12 includes a plurality of application servers, figure 1 Application servers AS1-AS6 are schematically shown in . The proxy layer 13 includes an access layer 131 and an execution layer 132, wherein the access layer 131 includes a plurality of access servers, figure 1 The access servers A1-A3 are schematically shown in , and the execution layer 132 includes a plurality of execution servers, figure 1 Execution servers E1-E3 are schematically shown in . The storage layer 15 includes a plural...

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

An embodiment of the invention provides a database access method and a database access system. The system comprises a plurality of application servers, a plurality of access servers, a plurality of execution servers and a plurality of databases. Each application server is only connected with one access server, and each access server is connected with a plurality of databases through a plurality of execution servers. The plurality of databases comprise a first database in which the data of the first application is stored, and the number of connections between each application server and the access server is smaller than the number of connections between the execution server and the servers of the plurality of databases. In response to a service request initiated by the first application, the application server generates a first operation request for the first database; and the first operation request and a first identifier for indicating the first database are sent to the access server. Through adopting the database access method provided by the embodiment of the invention, a large number of applications can be supported, and an ultra-large user scale can be supported.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a database access method and system. Background technique [0002] In the current device-cloud application system, an application (Application, APP) can access any application server among multiple application servers in the cloud, and each application server needs to connect to the database of any APP to store and access data of any APP. Therefore, each application server must establish a connection pool for each database. When the application scale grows, it is necessary to increase the application server and database accordingly. This will lead to two problems: the number of supported users is limited, and the database has a maximum number of connections, which limits the maximum number of application servers, making it impossible to support the large user scale of popular applications; the number of supported APPs is limited, and the number of APPs is limited. T...

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 Applications(China)
IPC IPC(8): H04L67/1097H04L67/141H04L41/0668H04L67/10G06F16/27
CPCH04L67/1097H04L67/141H04L41/0668H04L67/10G06F16/27
Inventor 游运华陈鹏宇周新满
Owner HUAWEI TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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