CN114706837A - Database access method and device - Google Patents

Abstract

The invention provides a database access method and a database access device, and belongs to the technical field of computers. The database access method comprises the following steps: under the condition that a target application node needs to access a target database object, acquiring configuration parameters related to the target database object; determining an RAC node and an access parameter which are correspondingly connected with the target application node according to the configuration parameters; and accessing the target database object through the RAC node according to the access parameter, and executing target operation on data corresponding to the target database object. The invention can reduce the private network communication between RAC nodes and reduce the private network flow to a certain extent.

Description

Database access method and device

technical field

The present invention relates to the field of computer technology, and in particular, to a database access method and device.

Background technique

When using Oracle RAC (real application clusters, real-time application clusters) environment, it often happens that different client applications access the same database object in the database through different RAC nodes at the same time, which makes a large number of private networks between RAC nodes. inter-communication, resulting in an increase in private network traffic.

SUMMARY OF THE INVENTION

The present invention provides a database access method and device, which are used to solve the defect in the prior art that a large amount of private network traffic will be generated when different application nodes simultaneously access the same database object through the RAC node, and reduce the private network traffic to a certain extent.

The present invention provides a database access method, comprising: when a target application node needs to access a target database object, acquiring a configuration parameter associated with the target database object; and determining the target application according to the configuration parameter A node corresponds to a connected RAC node and an access parameter; the target database object is accessed through the RAC node and according to the access parameter, and a target operation is performed on the data corresponding to the target database object.

According to a database access method provided by the present invention, the configuration parameters include: the number of application nodes corresponding to the target database object, the number of RAC nodes connected to the target database object, and the target database object Corresponding node configuration rules; wherein, the node configuration rules are used to reflect the connection configuration relationship between the application node and the RAC node when accessing the target database object.

According to a database access method provided by the present invention, the determining the RAC node and the access parameter corresponding to the target application node connection according to the configuration parameter includes: according to the number of application nodes corresponding to the target database object , the number of RAC nodes connected to the target database object, and the node configuration rules, determine the RAC nodes connected to the target application node; based on the number of application nodes corresponding to the target database object and the target Whether the database object can be partitioned determines the access parameter corresponding to the target application node.

According to a database access method provided by the present invention, determining the access parameter corresponding to the target application node based on the number of application nodes corresponding to the target database object and whether the target database object can be partitioned, including: In the case that the target database object can be partitioned, the accessible data area corresponding to the target application node is determined from at least one data area, and the access parameter corresponding to the target application node is obtained; wherein, the at least one data area corresponding to the target application node is obtained. The data area is obtained by performing a partition processing operation on the target database object based on the number of application nodes corresponding to the target database object.

According to a database access method provided by the present invention, determining the access parameter corresponding to the target application node based on the number of application nodes corresponding to the target database object and whether the target database object can be partitioned, including: In the case that the target database object cannot be partitioned, the accessible database objects corresponding to the target application node are determined from at least two database objects, and the access parameters corresponding to the target application node are obtained; wherein the at least The two database objects are obtained by performing a copy processing operation on the target database object based on the number of application nodes corresponding to the target database object.

According to a database access method provided by the present invention, the accessing the target database object through the RAC node and according to the access parameter, and performing a target operation on the data corresponding to the target database object includes: accessing the target database object through the RAC node, accessing the accessible data area corresponding to the target application node in the target database object, and performing the target operation on the data in the data area.

According to a database access method provided by the present invention, the accessing the target database object through the RAC node and according to the access parameter, and performing a target operation on the data corresponding to the target database object includes: accessing the target database object through the RAC The node accesses the accessible database object corresponding to the target application node, and executes the target operation on the data of the accessible database object.

According to a database access method provided by the present invention, before performing the target operation on the data corresponding to the target database object by accessing the target database object through the RAC node and according to the access parameter, the method further includes: The parameters related to load balancing of the database corresponding to the target database object are set to ineffective state.

The present invention also provides a database access device, comprising:

a parameter obtaining module, configured to obtain the configuration parameters associated with the target database object when the target application node needs to access the target database object;

a node determination module, configured to determine, according to the configuration parameters, the RAC node and access parameters corresponding to the connection of the target application node;

An operation module, configured to access the target database object through the RAC node and according to the access parameter, and perform a target operation on the data corresponding to the target database object.

The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and running on the processor, the processor implements any one of the database access methods described above when the processor executes the program .

The present invention also provides a non-transitory computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, implements any one of the above-mentioned database access methods.

The database access method and device provided by the present invention determine the RAC node and access parameters connected to the target application node by acquiring the configuration parameters associated with the target database object, and then access the target database object through the corresponding RAC node and according to the access parameters, and Perform the target operation on the data in it, so that each application node accesses the target database object through a fixed RAC node. Due to the determination of the access parameters, when different application nodes access the target database object at the same time, there will not be a large number of private networks between the RAC nodes. Communication, on the basis of ensuring high availability and load balancing, reduces private network traffic to the greatest extent, thereby greatly increasing the upper limit of database load and reducing the overall pressure on the database.

Description of drawings

In order to explain the present invention or the technical solutions in the prior art more clearly, the following will briefly introduce the accompanying drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are the For some embodiments of the invention, for those of ordinary skill in the art, other drawings can also be obtained according to these drawings without any creative effort.

1 is a schematic flowchart of a database access method provided by the present invention;

2 is a schematic flowchart of the target application node accessing target database objects provided by the present invention;

3 is a schematic structural diagram of a database access device provided by the present invention;

FIG. 4 is a schematic structural diagram of an electronic device provided by the present invention.

Detailed ways

In order to make the objectives, technical solutions and advantages of the present invention clearer, the technical solutions in the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are part of the embodiments of the present invention. , not all examples. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

The terms "first", "second" and the like in the description and claims of the present invention are used to distinguish similar nodes, and are not used to describe a specific order or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances so that embodiments of the invention can be practiced in sequences other than those illustrated or described herein, and distinguish between "first", "second", etc. The nodes are usually of one type, and the number of nodes is not limited. For example, the first node may be one or more than one. In addition, "and/or" in the description and claims indicates at least one of the connected nodes, and the character "/" generally indicates that the associated nodes are in an "or" relationship.

It is to be understood that reference in the specification to "one embodiment" or "an embodiment" means that a particular feature, structure or characteristic associated with the embodiment is included in at least one embodiment of the present invention. Thus, appearances of "in one embodiment" or "in an embodiment" in various places throughout this specification are not necessarily necessarily referring to the same embodiment. Furthermore, the particular features, structures or characteristics may be combined in any suitable manner in one or more embodiments.

When different client applications access the same data block in the database through different RAC nodes at the same time, a large amount of private network traffic will be generated. Usually, there are two ways to solve this problem: one is to split the database objects through different modes. , but this method will result in that the summary data of some public classes in the database cannot be used in a better unified manner; another method is to split the database, but this method requires the application to add routing middleware for sub-database and sub-table, which will improve development cost. In order to solve the above problems, the present application provides a database access method.

The database access method of the present invention will be described below with reference to FIGS. 1-2 .

FIG. 1 is a schematic flowchart of a database access method provided by the present invention. As shown in Figure 1, the method includes:

Step 101, in the case that the target application node needs to access the target database object, obtain the configuration parameters associated with the target database object.

It should be noted that the application node can be understood as the device where the client application program that can simultaneously access the target database object is located.

It should be noted that Oracle's data access control seems to occur at the row (Row) level and the object (Object) level, but the actual operation object is a data block (Block), and the passed object is also a data block. The data block contains multiple data, so the application program accessing the database actually accesses a data block in the database; when multiple applications access the data block at the same time, only one application program can actually operate the data block, and the other The application needs to wait.

It should be understood that the target database object can be understood as a certain data block in a data table in the database, and this data block will be accessed by different application nodes through the RAC node at the same time.

It can be understood that when the target application node needs to access the target database object, the target application node obtains the configuration parameters associated with the target database object.

Optionally, the configuration parameters include:

The number of application nodes corresponding to the target database object, the number of RAC nodes connected to the target database object, and the node configuration rules corresponding to the target database object;

The node configuration rule is used to reflect the connection configuration relationship between the application node and the RAC node when accessing the target database object.

It should be noted that the number of application nodes corresponding to the target database object is the total number of different application nodes accessing the target database object at the same time;

It should be noted that RAC (real application clusters, real-time application clusters) is a new technology adopted in the new version of Oracle database, which has high availability. For RAC, Oracle uses the private network communication between each RAC node to perform memory fusion (cache fushion) to ensure the consistency of data access of each node.

For example, RAC node 1 has modified a data block A but has not committed or rolled back the operation. When RAC node 2 needs to access data block A at this time, it is queried that data block A is at RAC node 1, then RAC node 2 It will send information to RAC node 1, and let RAC node 1 transmit the modified data block A to RAC node 2 through the private network. When there is a large amount of memory fusion, the private network traffic will increase, which will affect the database performance.

It should be understood that the node configuration rule can help the target application node to determine the corresponding connected RAC node. The node configuration rule is a set of rules that have been determined in advance, and can be determined by itself in actual use.

Under the condition that the node configuration rules remain unchanged, after the RAC node corresponding to the target application node is determined, each time the target application node accesses the target database object, the target database object will be accessed through the fixed RAC node. For example, after it is determined that the target application node A is connected to the RAC node 1, each time the application node A accesses the target database, the target database is accessed through the RAC node 1.

Step 102: Determine, according to the configured parameters, a RAC node and access parameters to which the target application node is correspondingly connected.

It should be noted that the access parameter is a parameter that the application node needs to carry when accessing the target database object, and according to the parameter, the target application node can determine the location of the data in the target database object.

It can be understood that, according to the obtained configuration parameters, the target application node determines the corresponding connected RAC node and the access parameters that need to be carried when accessing the target database object.

Step 103: Access the target database object through the RAC node and according to the access parameter, and perform a target operation on the data corresponding to the target database object.

It can be understood that, performing the target operation on the data is performing one or more operations of adding, deleting, and modifying the data.

It can be understood that the target application node accesses the target database through the determined RAC node and access parameters, and performs addition, deletion and/or modification operations on data corresponding to the target database object.

The database access method provided by the present invention determines the RAC node and access parameters connected to the target application node by acquiring the configuration parameters associated with the target database object, and then accesses the target database object through the corresponding RAC node and according to the access parameters, and compares the The data performs the target operation, so that each application node accesses the target database object through a fixed RAC node. Due to the determination of the access parameters, when different application nodes access the target database object at the same time, there will be no large amount of private network communication between the RAC nodes. On the basis of ensuring high availability and load balancing, the private network traffic is reduced to the greatest extent, thereby greatly increasing the upper limit of the database load and reducing the overall pressure on the database.

Optionally, determining the RAC node and access parameters corresponding to the target application node connection according to the configuration parameter, including:

According to the number of application nodes corresponding to the target database object, the number of RAC nodes connected to the target database object, and the node configuration rule, determine the RAC node to which the target application node is connected;

Based on the number of application nodes corresponding to the target database object and whether the target database object can be partitioned, an access parameter corresponding to the target application node is determined.

It can be understood that a code can be determined for each application node through the node configuration rule, where the code is used to identify the application node and help the application node to determine the corresponding connected RAC node. For example, Oracle RAC has two nodes, namely RAC node 1 and RAC node 2. There are 16 application nodes corresponding to the target database object. Each application node is assigned a number in a preset order (such as increasing, decreasing), and the node The configuration rule can be that even-numbered application nodes access the target database through RAC node 1, and odd-numbered application nodes access the target database through RAC node 2; or, the node configuration rule can be that application nodes numbered 1 to 8 access RAC node 1, and the number of Application nodes 8 to 16 access RAC node 2.

It should be noted that the node configuration rules in the above examples do not constitute limitations on the node configuration rules of the present invention. Node configuration rules can be determined according to actual needs, and flexible configuration can be achieved to apply to different numbers of application nodes.

Partitioning the target database object is to divide the target database object into at least one data area, but not every database object can be divided.

In the case that the target database object can be divided, the number of the divided data areas must be consistent with the number of application nodes accessing the target database object at the same time.

It should be understood that one access parameter can be obtained when the target database object can be partitioned, and another access parameter can be obtained when the target database object cannot be partitioned, but both access parameters can determine the target. The location of the data in the database object for application nodes to perform operations on the data.

In the embodiment of the present invention, the RAC node to which the target application node is connected is determined according to the number of application nodes, the number of RAC nodes, and the node configuration rule, so that each application node accesses the target database object through the corresponding RAC node. The number of application nodes corresponding to the database object and whether the target database object can be partitioned, and the access parameters corresponding to the target application node are determined, so that the target application node can perform operations on the data in the target database object.

Optionally, determining the access parameter corresponding to the target application node based on the number of application nodes corresponding to the target database object and whether the target database object can be partitioned, including:

In the case that the target database object can be partitioned, determining an accessible data area corresponding to the target application node from at least one data area, and obtaining access parameters corresponding to the target application node;

The at least one data area is obtained by performing a partition processing operation on the target database object based on the number of application nodes corresponding to the target database object.

It should be noted that when multiple application nodes access the same database object at the same time, only one application node can operate the data object, and other application nodes need to wait. For an application node, if the RAC nodes corresponding to different application nodes are different, the database objects need to be sent through the private network when sending database objects, which increases the private network traffic.

Although different application nodes access the same target database object, the actual data to be manipulated by each application node is different. In the case that the target database object can be partitioned, the target database object is divided into at least one data area, so that each The data to be operated by an application node is in one data area, so that when multiple application nodes access the target database object at the same time, they can operate their corresponding data areas, so that multiple application nodes can operate the same target database object, reducing the time between RAC nodes. private network communication.

For example, 16 application nodes have been deployed to read the messages of a message queue. The messages read by each application node are different. Each application node only needs to trigger subsequent data processing operations according to each message, then all the messages in this queue The data blocks obtained by storing the corresponding data in the database are actually database objects that can be partitioned according to application nodes.

It should be understood that, when the target database object can be partitioned, the number of data areas of the target database object is determined according to the number of application nodes corresponding to the target database, so that each application node independently accesses a data area.

There is a one-to-one correspondence between each application node and the partitioned data area. After the partition ends, a partition key will be generated for each data area; at this time, the access parameters of the target application node include the code of the target application node and the corresponding data The partition key for the region.

In the embodiment of the present invention, by performing partition processing on the target database object, each application node corresponds to a data area, and then the access parameters of the application nodes are determined, so that when different application nodes access the target database object at the same time, through the access parameters simultaneously Operate the data in the target database object without affecting each other, thereby reducing the private network communication between the RAC nodes and reducing the private network traffic to a certain extent.

Optionally, performing a target operation on data corresponding to the target database object by accessing the target database object through the RAC node and according to the access parameter, including:

Through the RAC node, the accessible data area corresponding to the target application node in the target database object is accessed, and the target operation is performed on the data in the data area.

It can be understood that each application node accesses the corresponding data area respectively, and operates the data in the data area, and the application nodes do not affect each other.

In the embodiment of the present invention, each application node accesses the RAC section determined by the connection to access the corresponding data area, and operates the data in the data area, so as to achieve the purpose of simultaneously operating the target database object by multiple application nodes, so that each The operation data of the application nodes does not affect each other, which reduces the private network traffic to a certain extent, thereby increasing the upper limit of the database load and reducing the overall pressure on the database.

Optionally, determining the access parameter corresponding to the target application node based on the number of application nodes corresponding to the target database object and whether the target database object can be partitioned, including:

In the case that the target database object cannot be partitioned, determining an accessible database object corresponding to the target application node from at least two database objects, and obtaining an access parameter corresponding to the target application node;

The at least two database objects are obtained by performing a copy processing operation on the target database object based on the number of application nodes corresponding to the target database object.

It should be noted that although different application nodes access the same target database object, the actual data to be manipulated by each application node is different, then in the case that the target database object cannot be partitioned, the application node corresponding to the target database object will be The number of target database objects determines the number of target database objects to be replicated, and the target database objects are replicated so that each application node can operate a database object, so that when multiple application nodes access the target database object at the same time, they can operate their corresponding database objects. , thereby reducing the private network communication between RAC nodes.

For example, 16 application nodes have been deployed to read the messages of the first message queue. The message A read by application node A needs to be spliced with other messages (such as message B) in the processing process, and message B belongs to the second message queue. , then node A needs to use the data corresponding to message B when triggering the information processing operation after reading message A. At this time, message A and message B need to be conditionally associated, and this conditional association is determined by a service-like identification number. Associative, it has nothing to do with the application node. At this time, if the data involved in message B needs to be stored, it is a database object, and it is not recommended to partition according to the application read node.

It should be understood that the number of replicated database objects is consistent with the total number of application nodes, and each application node has a one-to-one correspondence with the replicated database objects. A database object generates a database object number; at this time, the access parameters of the target application node include the number of the target application node and the corresponding database object number.

It can be understood that the data in the replicated database objects are the same, and the replication of the database objects is a way of exchanging storage space for operational efficiency.

In the embodiment of the present invention, by duplicating the target database object, each application node corresponds to a database object, and then the access parameters of the application nodes are determined, so that when different application nodes access the target database object at the same time, the corresponding access parameters are used to determine the corresponding database object. The data in the database objects can be operated without affecting each other, thereby reducing the private network communication between the RAC nodes and reducing the private network traffic to a certain extent.

Optionally, performing a target operation on data corresponding to the target database object by accessing the target database object through the RAC node and according to the access parameter, including:

Through the RAC node, an accessible database object corresponding to the target application node is accessed, and a target operation is performed on the data of the accessible database object.

It is understandable that each application node accesses the corresponding database object respectively, and operates the data in the database object, and the application nodes do not affect each other.

In the embodiment of the present invention, each application node accesses the RAC section determined by the connection to access the corresponding database object, and operates the data in the database object, so as to realize the purpose of simultaneously operating the target database object by multiple application nodes, so that each The operation data of the application nodes does not affect each other, which reduces the private network traffic to a certain extent, thereby increasing the upper limit of the database load and reducing the overall pressure on the database.

Optionally, before performing the target operation on the data corresponding to the target database object by accessing the target database object through the RAC node and according to the access parameter, the method further includes:

The load balancing-related parameters of the database corresponding to the target database object are set to an ineffective state.

In one implementation, turn off load_balance in jdbc and set remote_listener in database parameters to a null value.

It should be noted that the purpose of setting the load balancing-related parameters of the database corresponding to the target database object to the ineffective state is to disable the automatic load balancing function of the database, so that the connection of the application node to the database corresponding to the target database object is established in the on a single node.

In the embodiment of the present invention, by setting the load balancing-related parameters of the database corresponding to the target database object to an ineffective state, it is ensured that each application node accesses the target database object through a fixed RAC node every time, so that the application The connection between the node and the database corresponding to the target database object is established on a single node, thereby reducing private network traffic.

FIG. 2 is a schematic flowchart of a target application node accessing a target database object provided by the present invention. As shown in Figure 2, the process includes:

Step 201, the target application node obtains configuration parameters;

Step 202, determining the number of application nodes corresponding to the target database object, the number of RAC nodes and the node configuration rule according to the configuration parameters;

Step 203, determining the RAC node connected to the target application node;

Step 204, determine whether the target database object can be partitioned, enter step 205 when the target database object can be partitioned, and enter step 206 when the target database object cannot be partitioned;

Step 205, determine that the access parameter is the number of the target application node and the partition key of the corresponding data area, and enter step 207;

Step 206, determine that the access parameter is the number of the target application node and the corresponding database object number, and enter step 207;

Step 207: Execute the target operation on the data of the target database object according to the RAC node connected to the target application node and the access parameter.

The database access device provided by the present invention will be described below, and the database access device described below and the database access method described above may refer to each other correspondingly.

FIG. 3 is a schematic structural diagram of a database access device provided by an embodiment of the present invention. As shown in FIG. 3, an embodiment of the present invention provides a path planning system based on deep reinforcement learning, including a parameter acquisition module 301, a node determination module 302 and Operation module 303, wherein:

A parameter obtaining module 301, configured to obtain configuration parameters associated with the target database object when the target application node needs to access the target database object;

A node determination module 302, configured to determine, according to the configuration parameters, the RAC node and access parameters corresponding to the connection of the target application node;

The operation module 303 is configured to access the target database object through the RAC node and according to the access parameter, and perform a target operation on the data corresponding to the target database object.

The database access device provided by the present invention determines the RAC node and access parameters connected to the target application node by acquiring the configuration parameters associated with the target database object, and then accesses the target database object through the corresponding RAC node and according to the access parameters, and compares the The data performs the target operation, so that each application node accesses the target database object through a fixed RAC node. Due to the determination of the access parameters, when different application nodes access the target database object at the same time, there will be no large amount of private network communication between the RAC nodes. On the basis of ensuring high availability and load balance, the private network traffic is reduced to the greatest extent, thereby greatly increasing the upper limit of the database load and reducing the overall pressure on the database.

Optionally, the configuration parameters include:

The number of application nodes corresponding to the target database object, the number of RAC nodes connected to the target database object, and the node configuration rules corresponding to the target database object;

The node configuration rule is used to reflect the connection configuration relationship between the application node and the RAC node when accessing the target database object.

Optionally, the node determination module 302 includes:

The RAC node determination unit is configured to determine the corresponding connection of the target application node according to the number of application nodes corresponding to the target database object, the number of RAC nodes connected to the target database object, and the node configuration rule. RAC node;

An access parameter determination unit, configured to determine an access parameter corresponding to the target application node based on the number of application nodes corresponding to the target database object and whether the target database object can be partitioned.

Optionally, the access parameter determination unit is used for:

In the case that the target database object can be partitioned, determining an accessible data area corresponding to the target application node from at least one data area, and obtaining an access parameter corresponding to the target application node;

The at least one data area is obtained by performing a partition processing operation on the target database object based on the number of application nodes corresponding to the target database object.

Optionally, the access parameter determination unit is used for:

In the case that the target database object cannot be partitioned, determine an accessible database object corresponding to the target application node from at least two database objects, and obtain an access parameter corresponding to the target application node;

The at least two database objects are obtained by performing a copy processing operation on the target database object based on the number of application nodes corresponding to the target database object.

Optionally, the operation module 303 is specifically used for:

Through the RAC node, the accessible data area corresponding to the target application node in the target database object is accessed, and the target operation is performed on the data in the data area.

Optionally, the operation module 303 is specifically used for:

Through the RAC node, an accessible database object corresponding to the target application node is accessed, and a target operation is performed on the data of the accessible database object.

Optionally, before performing the target operation on the data corresponding to the target database object by accessing the target database object through the RAC node and according to the access parameter, the method further includes:

The load balancing-related parameters of the database corresponding to the target database object are set to an ineffective state.

It should be noted here that the above-mentioned database access apparatus provided by the embodiments of the present invention can implement all the method steps implemented by the above-mentioned database access method embodiments, and can achieve the same technical effect, and the related The same parts and beneficial effects of the method embodiments will be described in detail.

FIG. 4 illustrates a schematic diagram of the physical structure of an electronic device. As shown in FIG. 4 , the electronic device may include: a processor (processor) 410, a communication interface (Communications Interface) 420, a memory (memory) 430 and a communication bus 440, The processor 410 , the communication interface 420 , and the memory 430 communicate with each other through the communication bus 440 . The processor 410 may invoke the logic instructions in the memory 430 to execute the database access method, the method comprising: in the case that the target application node needs to access the target database object, acquiring the configuration parameters associated with the target database object; The configuration parameter determines the RAC node and access parameter to which the target application node is correspondingly connected; the target database object is accessed through the RAC node and according to the access parameter, and the target database object is executed on the data corresponding to the target database object. operate.

In addition, the above-mentioned logic instructions in the memory 430 may be implemented in the form of software functional units and may be stored in a computer-readable storage medium when sold or used as an independent product. Based on such understanding, the technical solution of the present invention can be embodied in the form of a software product in essence, or the part that contributes to the prior art or the part of the technical solution. The computer software product is stored in a storage medium, including Several instructions are used to cause a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage medium includes: U disk, removable hard disk, Read-Only Memory (ROM, Read-Only Memory), Random Access Memory (RAM, Random Access Memory), magnetic disk or optical disk and other media that can store program codes .

On the other hand, the present invention also provides a non-transitory computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, it is implemented to execute the database access method provided by the above methods, and the method includes: In the case that the target application node needs to access the target database object, obtain the configuration parameters associated with the target database object; according to the configuration parameters, determine the RAC node and access parameters corresponding to the connection of the target application node; The RAC node accesses the target database object according to the access parameter, and performs a target operation on the data corresponding to the target database object.

The device embodiments described above are only illustrative, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in One place, or it can be distributed over multiple network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution in this embodiment. Those of ordinary skill in the art can understand and implement it without creative effort.

From the description of the above embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus a necessary general hardware platform, and certainly can also be implemented by hardware. Based on this understanding, the above-mentioned technical solutions can be embodied in the form of software products in essence or the parts that make contributions to the prior art, and the computer software products can be stored in computer-readable storage media, such as ROM/RAM, magnetic A disc, an optical disc, etc., includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform the methods described in various embodiments or some parts of the embodiments.

Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the present invention, but not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand: it can still be Modifications are made to the technical solutions described in the foregoing embodiments, or some technical features thereof are equivalently replaced; and these modifications or replacements do not make the essence of the corresponding technical solutions depart from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims (11)

1. a database access method, is characterized in that, comprises: In the case that the target application node needs to access the target database object, obtain the configuration parameters associated with the target database object; According to the configuration parameter, determine the RAC node and access parameter to which the target application node is correspondingly connected; The target database object is accessed through the RAC node and according to the access parameter, and a target operation is performed on the data corresponding to the target database object. 2. The database access method according to claim 1, wherein the configuration parameters comprise: The number of application nodes corresponding to the target database object, the number of RAC nodes connected to the target database object, and the node configuration rules corresponding to the target database object; The node configuration rule is used to reflect the connection configuration relationship between the application node and the RAC node when accessing the target database object. 3. The database access method according to claim 2, wherein determining the RAC node and the access parameter corresponding to the connection of the target application node according to the configuration parameter, comprising: According to the number of application nodes corresponding to the target database object, the number of RAC nodes connected to the target database object, and the node configuration rule, determine the RAC node to which the target application node is connected; Based on the number of application nodes corresponding to the target database object and whether the target database object can be partitioned, an access parameter corresponding to the target application node is determined. 4. The database access method according to claim 3, wherein, based on the number of application nodes corresponding to the target database object and whether the target database object can be partitioned, it is determined that the target application node corresponds to access parameters, including: In the case that the target database object can be partitioned, determining an accessible data area corresponding to the target application node from at least one data area, and obtaining access parameters corresponding to the target application node; The at least one data area is obtained by performing a partition processing operation on the target database object based on the number of application nodes corresponding to the target database object. 5. The database access method according to claim 3, wherein, based on the number of application nodes corresponding to the target database object and whether the target database object can be partitioned, it is determined that the target application node corresponds to access parameters, including: In the case that the target database object cannot be partitioned, determining an accessible database object corresponding to the target application node from at least two database objects, and obtaining an access parameter corresponding to the target application node; The at least two database objects are obtained by performing a copy processing operation on the target database object based on the number of application nodes corresponding to the target database object. 6. The database access method according to claim 4, wherein, by accessing the target database object through the RAC node and according to the access parameter, a target operation is performed on the data corresponding to the target database object, include: Through the RAC node, the accessible data area corresponding to the target application node in the target database object is accessed, and the target operation is performed on the data in the data area. 7. The database access method according to claim 5, wherein, by accessing the target database object through the RAC node and according to the access parameter, a target operation is performed on the data corresponding to the target database object, include: Through the RAC node, an accessible database object corresponding to the target application node is accessed, and a target operation is performed on the data of the accessible database object. 8 . The database access method according to claim 1 , wherein, by accessing the target database object through the RAC node and according to the access parameter, corresponding to the target database object. 9 . Before performing the target operation on the data, it also includes: The load balancing-related parameters of the database corresponding to the target database object are set to an ineffective state. 9. A database access device, characterized in that, comprising: a parameter obtaining module, configured to obtain the configuration parameters associated with the target database object when the target application node needs to access the target database object; a node determination module, configured to determine, according to the configuration parameters, the RAC node and access parameters corresponding to the connection of the target application node; An operation module, configured to access the target database object through the RAC node and according to the access parameter, and perform a target operation on the data corresponding to the target database object. 10. An electronic device, comprising a memory, a processor and a computer program stored on the memory and running on the processor, wherein the processor implements the program as claimed in claim 1 when the processor executes the program The database access method described in any one of to 8. 11. A non-transitory computer-readable storage medium on which a computer program is stored, characterized in that, when the computer program is executed by a processor, the database access method according to any one of claims 1 to 8 is implemented.

Images