Database access method, system and device and storage medium

Abstract

The embodiment of the invention relates to a database access method, system and device and a storage medium. The method comprises the following steps: a database access request sent by a client is acquired through pre-established virtual connection, the access request comprises a routing rule identifier, the client is a terminal configured with various types of database connection driving assemblies, and the virtual connection is established by the client according to the database access request and the connection driving assemblies of the corresponding types of databases; determining a targetdatabase address corresponding to the access request according to the routing rule identifier and a preset routing rule; binding the virtual connection to an actual connection corresponding to the target database address; sending the access request to a target database through actual connection to obtain request data; and sending the request data to the client through the virtual connection. According to the embodiment of the invention, different types of databases can be accessed without creating a connection pool for each database, the number of data pools of a service system is reduced, and the system operation efficiency is improved.

Description

technical field [0001] The embodiment of the present invention relates to the field of computer technology, and in particular to a database access method, system, device and storage medium. Background technique [0002] Accessing the database is an essential link in the operator's business system. In order to adapt to various and emerging business scenarios, many different types of databases have been produced, such as relational databases, non-relational databases, and cache databases. In the end-to-end processing flow of a business system, it is often necessary to access multiple different types of physical databases at the same time. [0003] At present, if the business system wants to access multiple different types of physical databases at the same time, it is necessary to create a different type of connection pool for each database to be accessed, and the business system is generally multi-node distributed deployment, and each node server also has A connection pool ne...

AI Technical Summary

Problems solved by technology

[0005] Embodiments of the present invention provide a database access method, system, device, and storage medium to solve the problem that in the prior art, business systems create too many types and numbers of connection pools when accessing different types of databases, resulting in complicated system configuration adjustments and reduced Business system performance issues

Images