CN116450725A - Method, apparatus, electronic device, and medium for performing database operations - Google Patents
Method, apparatus, electronic device, and medium for performing database operations Download PDFInfo
- Publication number
- CN116450725A CN116450725A CN202310449839.2A CN202310449839A CN116450725A CN 116450725 A CN116450725 A CN 116450725A CN 202310449839 A CN202310449839 A CN 202310449839A CN 116450725 A CN116450725 A CN 116450725A
- Authority
- CN
- China
- Prior art keywords
- information
- routing
- node information
- routing node
- node
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 60
- 230000004044 response Effects 0.000 claims abstract description 34
- 238000012545 processing Methods 0.000 claims description 39
- 238000004590 computer program Methods 0.000 claims description 17
- 238000004422 calculation algorithm Methods 0.000 description 10
- 238000010586 diagram Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 7
- 238000004891 communication Methods 0.000 description 6
- 238000003672 processing method Methods 0.000 description 6
- 230000015556 catabolic process Effects 0.000 description 5
- 238000013468 resource allocation Methods 0.000 description 5
- 230000000694 effects Effects 0.000 description 4
- 238000000605 extraction Methods 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 230000005012 migration Effects 0.000 description 2
- 238000013508 migration Methods 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
Embodiments of the present disclosure disclose methods, apparatuses, electronic devices, and media for performing database operations. One embodiment of the method comprises the following steps: in response to receiving the database operation request information, acquiring a routing node information set, wherein the routing node information in the routing node information set is output by a corresponding proxy server; based on the database operation request information, identifying the routing node information set to obtain target routing information; and forwarding the database operation request information to a proxy server corresponding to the target routing information for executing the database operation. This embodiment is related to big data, and can improve efficiency of performing database operations.
Description
Technical Field
Embodiments of the present disclosure relate to the field of computer technology, and in particular, to a method, an apparatus, an electronic device, and a medium for performing database operations.
Background
Methods for performing database operations are one technique for operating a distributed database. Currently, in performing database operations on distributed databases, the following methods are generally adopted: routing computation is performed by JDBC (Java Database Connectivity, java database connection) clients and directly connect to the database to perform database operations, or routing computation is performed by proxy servers and perform database operations.
However, the inventors have found that when database operations are performed on a distributed database in the above manner, there are often the following technical problems:
because the JDBC client is directly connected with the database, when the database operation request for a certain hot spot data increases sharply, the database cache breakdown is easy to be caused, other database operation requests of users are affected, if the proxy server mode is used, because the users need to build and deploy a virtual host and a load balancing server, or a plurality of third party components are introduced, the realization logic is complex, the execution architecture of the database operation is complex, and therefore, the efficiency of executing the database operation is reduced.
The above information disclosed in this background section is only for enhancement of understanding of the background of the inventive concept and, therefore, may contain information that does not form the prior art that is already known to those of ordinary skill in the art in this country.
Disclosure of Invention
The disclosure is in part intended to introduce concepts in a simplified form that are further described below in the detailed description. The disclosure is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used to limit the scope of the claimed subject matter.
Some embodiments of the present disclosure propose methods, apparatuses, electronic devices, and media for performing database operations to address one or more of the technical problems mentioned in the background section above.
In a first aspect, some embodiments of the present disclosure provide a method for performing database operations, the method comprising: obtaining a routing node information set in response to receiving database operation request information, wherein the routing node information in the routing node information set is output by a corresponding proxy server; based on the database operation request information, identifying the routing node information set to obtain target routing information; and forwarding the database operation request information to a proxy server corresponding to the target routing information for executing the database operation.
Optionally, the identifying the routing node information set based on the database operation request information to obtain target routing information includes: extracting the database operation request information to obtain key data information; and carrying out matching processing on the key data information and the routing node information set to obtain target routing information.
Optionally, the matching processing is performed on the key data information and the routing node information set to obtain target routing information, including: and selecting one piece of routing node information meeting the first preset historical operation condition from the routing node information set as target routing information.
Optionally, the matching processing is performed on the key data information and the routing node information set to obtain target routing information, and the method further includes: selecting routing node information meeting a second preset historical operation condition from the routing node information set as node information to be screened, and obtaining a node information set to be screened; and generating target routing information based on the node information set to be screened.
Optionally, the matching processing is performed on the key data information and the routing node information set to obtain target routing information, and the method further includes: determining the routing node information set as a node information set to be screened in response to determining that the routing node information set does not have the routing node information meeting the preset history condition; and generating target routing information based on the node information set to be screened.
Optionally, the generating the target routing information based on the node information set to be screened includes: in response to determining that the node information set to be screened meets the preset node quantity condition, determining a weight value corresponding to each node information to be screened in the node information set to be screened based on a preset resource score configuration information set to obtain a weight value set; selecting a weight value meeting a preset weight condition from the weight value set as a target weight value; and determining the node information to be screened corresponding to the target weight value as target routing information.
Optionally, before the obtaining the routing node information set in response to receiving the database operation request information, the method further includes: for each routing node identifier in a preset routing node identifier set, executing the following steps: acquiring a node resource information group, a history list operation information set and a forwarding terminal identifier from the routing nodes corresponding to the routing node identifiers; and determining the route node identification, the node resource information group, the history list operation information set, the forwarding terminal identification, preset history operation template information, a first preset validity period and a second preset validity period as route node information.
In a second aspect, some embodiments of the present disclosure provide an apparatus for performing database operations, the apparatus comprising: an obtaining unit configured to obtain a set of routing node information in response to receiving database operation request information, wherein the routing node information in the set of routing node information is output by a corresponding proxy server; the identification processing unit is configured to perform identification processing on the routing node information set based on the database operation request information to obtain target routing information; and the forwarding unit is configured to forward the database operation request information to the proxy server corresponding to the target routing information so as to execute the database operation.
Optionally, the identification processing unit is further configured to: extracting the database operation request information to obtain key data information; and carrying out matching processing on the key data information and the routing node information set to obtain target routing information.
Optionally, the identification processing unit is still further configured to: and selecting one piece of routing node information meeting the first preset historical operation condition from the routing node information set as target routing information.
Optionally, the identification processing unit is further configured to: selecting routing node information meeting a second preset historical operation condition from the routing node information set as node information to be screened, and obtaining a node information set to be screened; and generating target routing information based on the node information set to be screened.
Optionally, the identification processing unit is further configured to: determining the routing node information set as a node information set to be screened in response to determining that the routing node information set does not have the routing node information meeting the preset history condition; and generating target routing information based on the node information set to be screened.
Optionally, the identification processing unit is still further configured to: in response to determining that the node information set to be screened meets the preset node quantity condition, determining a weight value corresponding to each node information to be screened in the node information set to be screened based on a preset resource score configuration information set to obtain a weight value set; selecting a weight value meeting a preset weight condition from the weight value set as a target weight value; and determining the node information to be screened corresponding to the target weight value as target routing information.
Optionally, before the obtaining the routing node information set in response to receiving the database operation request information, the apparatus for performing the database operation is further configured to: for each routing node identifier in a preset routing node identifier set, executing the following steps: acquiring a node resource information group, a history list operation information set and a forwarding terminal identifier from the routing nodes corresponding to the routing node identifiers; and determining the route node identification, the node resource information group, the history list operation information set, the forwarding terminal identification, preset history operation template information, a first preset validity period and a second preset validity period as route node information.
In a third aspect, some embodiments of the present disclosure provide an electronic device comprising: one or more processors; a storage device having one or more programs stored thereon, which when executed by one or more processors causes the one or more processors to implement the method described in any of the implementations of the first aspect above.
In a fourth aspect, some embodiments of the present disclosure provide a computer readable medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the method described in any of the implementations of the first aspect above.
In a fifth aspect, some embodiments of the present disclosure provide a computer program product comprising a computer program which, when executed by a processor, implements the method described in any of the implementations of the first aspect above.
The above embodiments of the present disclosure have the following advantageous effects: by the method for executing database operations according to some embodiments of the present disclosure, the efficiency of executing database operations may be improved. Specifically, the cause of the reduced execution efficiency of the database operation is that: because the JDBC client is directly connected with the database, when the database operation request for a certain hot spot data increases sharply, the database cache breakdown is easy to be caused, other database operation requests of users are affected, if the proxy server mode is used, because the users need to build and deploy a virtual host and a load balancing server, or a plurality of third party components are introduced, the realization logic is complex, the execution architecture of the database operation is complex, and therefore, the efficiency of executing the database operation is reduced. Based on this, methods for performing database operations of some embodiments of the present disclosure first acquire a set of routing node information in response to receiving database operation request information. The routing node information in the routing node information set may be output by a corresponding proxy server. Thus, the following JDBC client terminal can identify a proxy server matched with the database operation according to the database operation request so as to be used for executing the database operation. And then, based on the database operation request information, carrying out identification processing on the routing node information set to obtain target routing information. Thus, a proxy server for performing the database operations described above can be determined. And finally, forwarding the database operation request information to a proxy server corresponding to the target routing information for executing the database operation. Therefore, the method for executing database operations according to some embodiments of the present disclosure adopts a combination of the JDBC client and the proxy server, so that the JDBC client does not need to directly connect to the database, and delegate the database operation request to the corresponding proxy server for execution, thereby avoiding the breakdown of the database cache and other database operation requirements affecting the user. In addition, in the mode of combining the JDBC client and the proxy server, a virtual host and a traffic load balancing server do not need to be built and deployed, and excessive third party components do not need to be deployed, so that the execution architecture of database operation is simpler. Thus, the efficiency of performing database operations can be improved.
Drawings
The above and other features, advantages, and aspects of embodiments of the present disclosure will become more apparent by reference to the following detailed description when taken in conjunction with the accompanying drawings. The same or similar reference numbers will be used throughout the drawings to refer to the same or like elements. It should be understood that the figures are schematic and that elements and components are not necessarily drawn to scale.
FIG. 1 is a schematic illustration of one application scenario of a method for performing database operations according to some embodiments of the present disclosure;
FIG. 2 is a system architecture diagram of a method for performing database operations according to some embodiments of the present disclosure;
FIG. 3 is a flow chart of some embodiments of a method for performing database operations according to the present disclosure;
FIG. 4 is a flow chart of further embodiments of a method for performing database operations according to the present disclosure;
FIG. 5 is a schematic structural diagram of some embodiments of an apparatus for performing database operations according to the present disclosure;
fig. 6 is a schematic structural diagram of an electronic device suitable for use in implementing some embodiments of the present disclosure.
Detailed Description
Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete. It should be understood that the drawings and embodiments of the present disclosure are for illustration purposes only and are not intended to limit the scope of the present disclosure.
It should be noted that, for convenience of description, only the portions related to the present invention are shown in the drawings. Embodiments of the present disclosure and features of embodiments may be combined with each other without conflict.
It should be noted that the terms "first," "second," and the like in this disclosure are merely used to distinguish between different devices, modules, or units and are not used to define an order or interdependence of functions performed by the devices, modules, or units.
It should be noted that references to "one", "a plurality" and "a plurality" in this disclosure are intended to be illustrative rather than limiting, and those of ordinary skill in the art will appreciate that "one or more" is intended to be understood as "one or more" unless the context clearly indicates otherwise.
The names of messages or information interacted between the various devices in the embodiments of the present disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.
The present disclosure will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.
Fig. 1 is a schematic diagram of one application scenario of a method for performing database operations according to some embodiments of the present disclosure.
In the application scenario of fig. 1, first, the electronic device 101 acquires the routing node information set 103 in response to receiving the database operation request information 102. The routing node information in the routing node information set may be output by a corresponding proxy server. The electronic device may be a JDBC client device. The proxy server is correspondingly provided with at least one database. For example, the above-described routing node information set may include routing node information 1 and routing node information 2. The routing node information 1 may be { proxy 1, [ { hardware resource 1 already used 70% }, { hardware resource 2 already used 50% } ] }. The routing node information 2 may be { proxy 2, [ { hardware resource 1, already used 60% }, { hardware resource 2, already used 50% } ] }. Then, based on the database operation request information 102, the routing node information set 103 is identified, and the target routing information 104 is obtained. For example, the target routing information 104 may be { routing node information 2}. Finally, the database operation request information 102 is forwarded to the proxy server corresponding to the target routing information 104 for performing the database operation.
The electronic device 101 may be hardware or software. When the electronic device is hardware, the electronic device may be implemented as a distributed cluster formed by a plurality of servers or terminal devices, or may be implemented as a single server or a single terminal device. When the electronic device is embodied as software, it may be installed in the above-listed hardware device. It may be implemented as a plurality of software or software modules, for example, for providing distributed services, or as a single software or software module. The present invention is not particularly limited herein.
It should be understood that the number of terminal devices in fig. 1 is merely illustrative. There may be any number of electronic devices as desired for an implementation.
Fig. 2 illustrates an exemplary system architecture 200 for a method of performing database operations in accordance with some embodiments of the present disclosure.
As shown in fig. 2, system architecture 200 may include a client 201, a client 202, a client 203, a proxy server 204, a proxy server 205, a proxy server 206, and a database cluster 207. Wherein the clients 201-203 may be JDBC clients. Any one of the clients 201-203 may identify a proxy server from the proxy servers 204-206 according to the database operation request of the user, and forward the database operation request of the user to the identified proxy server for performing the database operation. After the client terminal forwards successfully, whether to disconnect from the proxy server is not specifically limited herein. Each of the proxy servers 204-206 may determine a database and a data table corresponding to the database operation after receiving the database operation request, and perform the database operation according to the database and the data table.
Clients 201-203 and proxy servers 204-206 may be hardware or software. When the clients 201-203 and proxy servers 204-206 are hardware, they may be implemented as a distributed device cluster/distributed server cluster made up of multiple devices/servers, or as a single device/single server. When clients 201-203 and proxy servers 204-206 are software, they may be implemented as, for example, multiple software or software modules to provide distributed services, or as a single software or software module. The present invention is not particularly limited herein.
With continued reference to fig. 3, a flow 300 of some embodiments of a method for performing database operations according to the present disclosure is shown. The method for performing database operations comprises the steps of:
step 301, in response to receiving the database operation request information, acquiring a routing node information set.
In some embodiments, an execution body (e.g., the electronic device shown in fig. 1) for executing the database operation may obtain the routing node information set through a wired connection or a wireless connection in response to receiving the database operation request information. The database operation request information may be information requesting to perform a database operation. For example, the database operation described above may be, but is not limited to, one of the following: query operations, update operations, data migration operations, and the like. The database operation request information may include SQL (Structured Query Language ) statements and task type identifications. The task type identifier may be an identifier of a task type corresponding to the database operation. The task type may be, but is not limited to, one of the following: large task types and regular task types. The large task type may characterize the corresponding database operation as an operation that takes more time than a preset duration threshold. The preset time period threshold may be an upper limit value of a preset time period. For example, the above-described large task type database operation may be, but is not limited to, one of the following: slow query operations (e.g., data migration operations), operations to create very large data tables. The conventional task type may characterize an operation in which the corresponding database operation does not exceed the preset duration threshold. The routing node information in the routing node information set may be output by a corresponding proxy server. The routing node information in the routing node information set corresponds to the proxy server one by one. The routing node information in the routing node information set may include, but is not limited to, at least one of: routing node identification, node resource information groups, etc. The routing node identification may be an identification of a proxy server. The routing node identifiers are in one-to-one correspondence with the proxy servers. The node resource information in the node resource information group may be usage information of hardware resources on the corresponding proxy server. The hardware resources may include, but are not limited to, at least one of: CPU (Central Processing Unit ) resources, memory resources, and network I/O (Input/Output) resources. The node resource information in the node resource information group may include a resource identification and an amount of used resources. The resource identification may be an identification of a hardware resource. The resource identifiers may be in one-to-one correspondence with hardware resources. The amount of used resources may be a ratio of the number of used hardware resources to the total number.
It should be noted that the wireless connection may include, but is not limited to, 3G/4G connections, wiFi connections, bluetooth connections, wiMAX connections, zigbee connections, UWB (ultra wideband) connections, and other now known or later developed wireless connection means.
Optionally, before acquiring the routing node information set in response to receiving the database operation request information, the executing body may further execute the following steps for each routing node identifier in the preset routing node identifier set:
the first step, obtaining node resource information group, history list operation information set and forwarding terminal identification from the routing node corresponding to the routing node identification. Wherein, the routing node may be a proxy server. The history table operation information in the history table operation information set may be information of a data table corresponding to one SQL statement executed by the corresponding proxy server. The history table operation information in the history table operation information set may include, but is not limited to, at least one of: table identification, home library identification, etc. The table identification may be an identification of a data table. The table identifiers are in one-to-one correspondence with the data tables. The home library identifier may be an identifier of a database in which the data table is located. The home base identifiers are in one-to-one correspondence with the databases. The forwarding terminal identifier may be an identifier of a JDBC client corresponding to the SQL statement received by the proxy server. The forwarding terminal identifiers are in one-to-one correspondence with the JDBC clients.
And a second step of determining the route node identification, the node resource information group, the history list operation information set, the forwarding terminal identification, preset history operation template information, a first preset validity period and a second preset validity period as route node information. The preset historical operation template information may be information of a template corresponding to a preset piece of SQL statement. The preset historical operation template information may include, but is not limited to, at least one of the following: template identification, keywords, etc. The template identifier may be an identifier of a template. The template identifiers are in one-to-one correspondence with the templates. The keywords may characterize database operations. The first preset validity period may be a validity period of history table operation information set in advance. For example, the validity period may be "2023-01-03 to 2024-01-02". The second preset validity period may be a preset validity period of the preset historical operation template information. It should be noted that, the preset historical operation template information included in the routing node information may be null, and at this time, any template is not bound to the corresponding routing node.
As an example, if the above SQL statement is "select from materials", the template may be "select_from_". The key may be, but is not limited to, one of the following: select queries, insert inserts, delete deletions, etc.
Optionally, the executing body may further store the routing node information set in a cache area.
In practice, the executing body may also periodically acquire the node resource information group, the history table operation information, and the forwarding terminal identification from the proxy server, and update the routing node information. In addition, the execution body may further delete the invalid history table operation information and the invalid preset history operation template information included in the routing node information periodically. In addition, the proxy server can also send the forwarding terminal identifier corresponding to the JDBC client to the cache area immediately after successfully receiving the SQL statement sent by the JDBC client, so as to update the corresponding routing node information in real time.
Step 302, based on the database operation request information, the route node information set is identified and processed to obtain the target route information.
In some embodiments, the executing body may perform identification processing on the routing node information set based on the database operation request information to obtain the target routing information. The target routing information may be information of a proxy server for executing an SQL statement corresponding to the database operation request information. The execution body may perform identification processing on the routing node information set through a preset identification processing method based on the database operation request information, so as to obtain target routing information.
As an example, the above identification processing method may include, but is not limited to, at least one of: a polling method, a load balancing method, etc.
Step 303, forwarding the database operation request information to the proxy server corresponding to the target routing information for executing the database operation.
In some embodiments, the executing entity may forward the database operation request information to a proxy server corresponding to the target routing information for executing the database operation. First, the execution body may select, from a preset set of routing address information, routing address information that matches the target routing information as the target routing address information. The preset routing address information in the routing address information set may be preset information of a web address of a proxy server. The routing address information in the routing address information set may include an address identification, an IP (Internet Protocol ) address, and a port number. The address identifier may be an identifier of a web address of the proxy server. The address identifiers are in one-to-one correspondence with websites of the proxy server. The matching with the target routing information may be that the address identifier included in the routing address information is the same as the routing node identifier included in the target routing information. The database operation request information may then be forwarded to a proxy server corresponding to the target routing address information for performing the database operation.
Alternatively, the database operation may be performed by:
the first step, the proxy server corresponding to the target routing information can determine the database and table division field information corresponding to the SQL statement included in the database operation request information through a preset analysis processing method. The above-mentioned database and table field information may include, but is not limited to, the following: a sub-base field value and a sub-table field value. The database field value may be an identification of a database to which the SQL statement is to be connected. The above-mentioned sub-table field values may be used to determine the data table to which the SQL statement corresponds.
As an example, the parsing method may include, but is not limited to, at least one of: regular matching methods, recursive descent algorithms, etc.
And secondly, the proxy server can determine target table information corresponding to the SQL sentence according to a preset sub-library and sub-table information set and the sub-library and sub-table field information. The preset database and table dividing information set can be set by a user through a user interface of the proxy server. The database and table dividing information in the database and table dividing information set may include, but is not limited to, at least one of the following: database identification, sub-table fields, sub-table algorithm information, etc. The database identifier may be an identifier of a database. The database identifiers are in one-to-one correspondence with the databases. The sub-table field may be a field for splitting one complete data table into at least two tables. The sub-table algorithm information may characterize the sub-table algorithm. The target table information may be information of a data table corresponding to the SQL statement. First, the sub-database sub-table information matched with the sub-database sub-table field information is selected from the sub-database sub-table information set as target sub-database sub-table information. The database identifier included in the database sub-table field information is the same as the database sub-field value included in the database sub-table field information. And then, determining the target table identification according to a table division algorithm corresponding to the table division algorithm information included in the target database table division information and a table division field value included in the database table division field information. And finally, determining the database field value and the target table identifier as target table information.
As an example, the above-described sub-table algorithm may include, but is not limited to, at least one of: modulo arithmetic based on self-increasing primary key, string hash modulo arithmetic, etc.
And thirdly, the proxy server is connected with a database and a data table corresponding to the target table information, and executes the SQL sentence.
The above embodiments of the present disclosure have the following advantageous effects: by the method for executing database operations according to some embodiments of the present disclosure, the efficiency of executing database operations may be improved. Specifically, the cause of the reduced execution efficiency of the database operation is that: because the JDBC client is directly connected with the database, when the database operation request for a certain hot spot data increases sharply, the database cache breakdown is easy to be caused, other database operation requests of users are affected, if the proxy server mode is used, because the users need to build and deploy a virtual host and a load balancing server, or a plurality of third party components are introduced, the realization logic is complex, the execution architecture of the database operation is complex, and therefore, the efficiency of executing the database operation is reduced. Based on this, methods for performing database operations of some embodiments of the present disclosure first acquire a set of routing node information in response to receiving database operation request information. Wherein, the routing node information in the routing node information set is output by the corresponding proxy server. Thus, the following JDBC client terminal can identify a proxy server matched with the database operation according to the database operation request so as to be used for executing the database operation. And then, based on the database operation request information, carrying out identification processing on the routing node information set to obtain target routing information. Thus, a proxy server suitable for performing the database operations described above may be determined. And finally, forwarding the database operation request information to a proxy server corresponding to the target routing information for executing the database operation. Therefore, the method for executing database operations according to some embodiments of the present disclosure adopts a combination of the JDBC client and the proxy server, so that the JDBC client does not need to directly connect to the database, and delegate the database operation request to the corresponding proxy server for execution, thereby avoiding the breakdown of the database cache and other database operation requirements affecting the user. In addition, in the mode of combining the JDBC client and the proxy server, a virtual host and a traffic load balancing server do not need to be built and deployed, and excessive third party components do not need to be deployed, so that the execution architecture of database operation is simpler. Thus, the efficiency of performing database operations can be improved.
With further reference to FIG. 4, a flow 400 of further embodiments of a method for performing database operations is shown. The process 400 of the method for performing database operations includes the steps of:
step 401, in response to receiving the database operation request information, acquiring a routing node information set.
In some embodiments, the specific implementation of step 401 and the technical effects thereof may refer to step 301 in the embodiment corresponding to fig. 3, which is not described herein again.
And step 402, extracting the database operation request information to obtain key data information.
In some embodiments, the execution body may perform extraction processing on the database operation request information to obtain key data information. The key data information may be information required for determining a proxy server executing the SQL statement. The key data information may include, but is not limited to, at least one of: a critical task type identifier, a critical data table identifier, a critical template identifier, etc. The above-mentioned critical task type identification can be the above and the task type identifier corresponding to the SQL statement. The key data table identifier may be an identifier of a data table corresponding to the SQL statement. The key template identifier may be an identifier of a template corresponding to the SQL statement. And extracting the database operation request information through a preset extraction algorithm to obtain key data information.
As an example, the extraction algorithm described above may include, but is not limited to, at least one of: keyword extraction algorithms, conditional random fields, etc.
And step 403, carrying out matching processing on the key data information and the routing node information set to obtain target routing information.
In some embodiments, the executing body may perform matching processing on the key data information and the routing node information set to obtain target routing information. The execution body may select, as the target routing information, routing node information satisfying a preset big task condition from the routing node information set in response to determining that the key task type identifier included in the key data information matches with the preset big task configuration information. The preset big task configuration information may be information of a proxy server corresponding to a preset big task type database operation. The preset big task configuration information may include a big task type identifier and an execution server identifier. The large task type identifier may be a task type identifier corresponding to a large task type. The execution server identification may be an identification of a proxy server performing database operations of a large task type. The matching with the preset big task configuration information can be: the key task type identifier included in the key data information is the same as the big task type identifier included in the preset big task configuration information. The preset big task condition may be: the routing node identification included in the routing node information is the same as the execution server identification included in the preset big task configuration information.
In some optional implementations of some embodiments, the executing entity may select, from the routing node information set, routing node information that satisfies a first predetermined history operating condition as the target routing information. Wherein, the first preset historical operating condition may be: the user time is in a first preset validity period in the routing node information, and the table identifier in the included history table operation information is the same as the key data table identifier included in the key data information.
In some optional implementations of some embodiments, the executing body may further perform matching processing on the key data information and the routing node information set to obtain target routing information through the following steps:
and selecting the routing node information meeting the second preset historical operation condition from the routing node information set as the node information to be screened to obtain the node information set to be screened. Wherein, the second preset historical operating condition may be: and the user time is in a second preset validity period in the routing node information, and the template identification in the included preset historical operation template information is the same as the key template identification included in the key data information.
And secondly, generating target routing information based on the node information set to be screened. The execution subject can generate target route information based on the node information set to be screened through the identification processing method.
In some optional implementations of some embodiments, the executing body may further perform matching processing on the key data information and the routing node information set to obtain target routing information through the following steps:
and determining the routing node information set as a node information set to be screened in response to determining that the routing node information set does not have the routing node information meeting the preset history condition. The preset history condition may be routing node information that satisfies the first preset history operation condition or the first preset history operation condition. And determining the routing node information in the routing node information set as the node information to be screened to obtain the node information set to be screened in response to determining that the routing node information meeting the preset history condition does not exist in the routing node information set.
And secondly, generating target routing information based on the node information set to be screened. The execution subject can generate target route information based on the node information set to be screened through the identification processing method.
In some optional implementations of some embodiments, the executing entity may generate the target routing information based on the node information set to be screened by:
in the first step, in response to determining that the node information set to be screened meets the preset node quantity condition, a weight value corresponding to each node information to be screened in the node information set to be screened is determined based on a preset resource score configuration information set, and a weight value set is obtained. The preset node number condition may be that the number of node information to be screened in the node information set to be screened is greater than 1. The resource score configuration information in the preset resource score configuration information set may be: and according to the influence degree of the hardware resources on the operation of the proxy server, distributing the total score and the score information corresponding to the hardware resources. The total score may be a preset value. For example, the total score may be 10. The resource score configuration information in the resource score configuration information set may include a resource type identifier and a resource score. The resource type may be a type of hardware resource. The resource score may be a score corresponding to a hardware resource. For example, the CPU resource type, the resource score may be 5. First, the execution body may select one resource score configuration information satisfying a preset resource score condition from the resource score configuration information set as target resource configuration information. The preset resource score condition may be that the resource score in the resource score configuration information is the maximum value of the resource scores included in the resource score configuration information set. Then, for each node information to be screened in the node information set to be screened, selecting one node resource information matched with the target resource allocation information from a node resource information group included in the node information to be screened as target node resource information, determining a difference between a preset value and a used resource amount included in the target node resource information as an unused resource amount, and determining a product of the unused resource amount and a resource score included in the target resource allocation information as a weight value. Wherein, the matching with the target resource configuration information may be: the node resource information includes the same resource identifier as the resource type identifier included in the target resource configuration information. The predetermined value may be 1. Finally, each determined weight value is determined as a weight value set.
Optionally, the executing body may determine, based on a preset resource score configuration information set, a weight value corresponding to each node information to be screened in the node information set to obtain a weight value set:
for each node information to be screened in the node information set to be screened, executing the following steps:
step one, matching the node resource information set included in the node information to be screened with the resource score configuration information set to obtain the node resource configuration information set. Wherein, the node resource configuration information in the node resource configuration information group can comprise a resource type identifier, a used resource amount and a resource score. For each node resource information in the node resource information group, a resource score in one resource score configuration information matched with the node resource information in the resource score configuration information set, a resource type identifier included with the node resource information, and a used resource amount may be determined as node resource configuration information. The matching with the node resource information may be that the resource type identifier included in the resource score configuration information is the same as the resource identifier included in the node resource information.
And step two, for each node resource allocation information in the node resource allocation information group, determining a product of the used resource amount and the resource score included in the node resource allocation information as a resource consumption score, and determining a difference between the resource score and the resource consumption score as a resource remaining score.
And thirdly, determining the sum of the determined residual scores of the resources as a weight value.
And secondly, selecting a weight value meeting a preset weight condition from the weight value set as a target weight value. The preset weight condition may be that the weight value is a maximum value in the weight value set.
And thirdly, determining node information to be screened corresponding to the target weight value as target routing information. Firstly, determining each node information to be screened corresponding to the target weight value as a node information group to be screened. Then, in response to determining that the node information set to be screened meets the node quantity condition, the identification processing method can be used for determining target routing information according to the node information set to be screened. The node number condition may be that the number of node information to be screened in the node information group to be screened is greater than 1. And finally, determining one piece of node information to be screened of the node information group to be screened as target routing information in response to determining that the node information group to be screened does not meet the node quantity condition.
Optionally, the executing body may further determine, as the target routing information, node information to be screened that satisfies the preset forwarding terminal condition in the node information group to be screened in response to determining that node information to be screened that satisfies the preset forwarding terminal condition exists in the node information group to be screened. The preset forwarding terminal condition may be that a forwarding terminal identifier included in the node information to be screened is the same as a preset terminal identifier. The preset terminal identifier may be an identifier of a JDBC client. The preset terminal identifiers are in one-to-one correspondence with the JDBC clients.
And step 404, forwarding the database operation request information to a proxy server corresponding to the target routing information for executing the database operation.
In some embodiments, the specific implementation of step 404 and the technical effects thereof may refer to step 303 in the embodiment corresponding to fig. 3, which is not described herein.
As can be seen in fig. 4, the flow 400 of the method for performing database operations in some embodiments corresponding to fig. 4 embodies the step of matching critical data information with a set of routing node information, as compared to the description of some embodiments corresponding to fig. 3. Therefore, the schemes described in the embodiments can determine the corresponding routing node according to the task type, can determine the corresponding routing node according to the association relation between the data table and the routing node, can determine the corresponding routing node according to the association relation between the SQL statement template and the routing node, and can determine the corresponding routing node according to the historical forwarding relation between the JDBC client and the routing node. Therefore, the number of repeated route calculation by the JDBC client can be reduced, and the target route node can be determined more quickly. In addition, when the routing nodes cannot be determined according to the task types or the association relations, or a plurality of routing nodes meeting the conditions exist, a better routing node is determined according to the resource use condition of each routing node and used for executing the database operation, so that load balance among all proxy servers can be achieved. Thus, the utilization rate of resources, and the efficiency of database execution can be improved.
With further reference to fig. 5, as an implementation of the method shown in the above figures, the present disclosure provides some embodiments of an apparatus for performing database operations, which apparatus embodiments correspond to those method embodiments shown in fig. 3, and which apparatus is particularly applicable in a variety of electronic devices.
As shown in fig. 5, an apparatus 500 for performing database operations includes: an acquisition unit 501, an identification processing unit 502, and a forwarding unit 503. Wherein, the obtaining unit 501 is configured to obtain a routing node information set in response to receiving the database operation request information, where the routing node information in the routing node information set is output by a corresponding proxy server; an identification processing unit 502 configured to perform identification processing on the routing node information set based on the database operation request information to obtain target routing information; and a forwarding unit 503 configured to forward the database operation request information to a proxy server corresponding to the target routing information, so as to perform a database operation.
In some alternative implementations of some embodiments, the identification processing unit 502 may be further configured to: extracting the database operation request information to obtain key data information; and carrying out matching processing on the key data information and the routing node information set to obtain target routing information.
In some alternative implementations of some embodiments, the identification processing unit 502 may be further configured to: and selecting one piece of routing node information meeting the first preset historical operation condition from the routing node information set as target routing information.
In some alternative implementations of some embodiments, the identification processing unit 502 may be further configured to: selecting routing node information meeting a second preset historical operation condition from the routing node information set as node information to be screened, and obtaining a node information set to be screened; and generating target routing information based on the node information set to be screened.
In some alternative implementations of some embodiments, the identification processing unit 502 may be further configured to: determining the routing node information set as a node information set to be screened in response to determining that the routing node information set does not have the routing node information meeting the preset history condition; and generating target routing information based on the node information set to be screened.
In some alternative implementations of some embodiments, the identification processing unit 502 may be further configured to: in response to determining that the node information set to be screened meets the preset node quantity condition, determining a weight value corresponding to each node information to be screened in the node information set to be screened based on a preset resource score configuration information set to obtain a weight value set; selecting a weight value meeting a preset weight condition from the weight value set as a target weight value; and determining the node information to be screened corresponding to the target weight value as target routing information.
In some optional implementations of some embodiments, before the obtaining the routing node information set in response to receiving the database operation request information, the apparatus 500 for performing the database operation may be further configured to: for each routing node identifier in a preset routing node identifier set, executing the following steps: acquiring a node resource information group, a history list operation information set and a forwarding terminal identifier from the routing nodes corresponding to the routing node identifiers; and determining the route node identification, the node resource information group, the history list operation information set, the forwarding terminal identification, preset history operation template information, a first preset validity period and a second preset validity period as route node information.
It will be appreciated that the elements recited in the apparatus 500 for performing database operations correspond to the various steps in the method described with reference to fig. 3. Thus, the operations, features and resulting benefits described above with respect to the method are equally applicable to the apparatus 500 and the units contained therein, and are not described in detail herein.
Referring now to fig. 6, a schematic diagram of an electronic device 600 (e.g., electronic device 101 of fig. 1) suitable for use in implementing some embodiments of the present disclosure is shown. The electronic device shown in fig. 6 is merely an example and should not impose any limitations on the functionality and scope of use of embodiments of the present disclosure.
As shown in fig. 6, the electronic device 600 may include a processing means (e.g., a central processing unit, a graphics processor, etc.) 601, which may perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 602 or a program loaded from a storage means 608 into a Random Access Memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the electronic apparatus 600 are also stored. The processing device 601, the ROM 602, and the RAM 603 are connected to each other through a bus 604. An input/output (I/O) interface 605 is also connected to bus 604.
In general, the following devices may be connected to the I/O interface 605: input devices 606 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, and the like; an output device 607 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage 608 including, for example, magnetic tape, hard disk, etc.; and a communication device 609. The communication means 609 may allow the electronic device 600 to communicate with other devices wirelessly or by wire to exchange data. While fig. 6 shows an electronic device 600 having various means, it is to be understood that not all of the illustrated means are required to be implemented or provided. More or fewer devices may be implemented or provided instead. Each block shown in fig. 6 may represent one device or a plurality of devices as needed.
In particular, according to some embodiments of the present disclosure, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, some embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method shown in the flow chart. In such embodiments, the computer program may be downloaded and installed from a network via communications device 609, or from storage device 608, or from ROM 602. The above-described functions defined in the methods of some embodiments of the present disclosure are performed when the computer program is executed by the processing device 601.
It should be noted that, in some embodiments of the present disclosure, the computer readable medium may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In some embodiments of the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In some embodiments of the present disclosure, however, the computer-readable signal medium may comprise a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, fiber optic cables, RF (radio frequency), and the like, or any suitable combination of the foregoing.
In some implementations, the clients, servers may communicate using any currently known or future developed network protocol, such as HTTP (HyperText Transfer Protocol ), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the internet (e.g., the internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed networks.
The computer readable medium may be contained in the electronic device; or may exist alone without being incorporated into the electronic device. The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: obtaining a routing node information set in response to receiving database operation request information, wherein the routing node information in the routing node information set is output by a corresponding proxy server; based on the database operation request information, identifying the routing node information set to obtain target routing information; and forwarding the database operation request information to a proxy server corresponding to the target routing information for executing the database operation.
Computer program code for carrying out operations for some embodiments of the present disclosure may be written in one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in some embodiments of the present disclosure may be implemented by means of software, or may be implemented by means of hardware. The described units may also be provided in a processor, for example, described as: a processor includes an acquisition unit, an identification processing unit, and a forwarding unit. The names of these units do not constitute a limitation on the unit itself in some cases, and for example, the acquisition unit may also be described as "acquiring a set of routing node information in response to receiving database operation request information, wherein the routing node information in the set of routing node information is a unit output by a corresponding proxy server".
The functions described above herein may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: a Field Programmable Gate Array (FPGA), an Application Specific Integrated Circuit (ASIC), an Application Specific Standard Product (ASSP), a system on a chip (SOC), a Complex Programmable Logic Device (CPLD), and the like.
Some embodiments of the present disclosure also provide a computer program product comprising a computer program which, when executed by a processor, implements any of the methods for performing database operations described above.
The above description is only of some preferred embodiments of the present disclosure and the technical principle to be applied, and is not limited to the technical solutions formed by the specific combination of the above technical features, but also covers other technical solutions formed by any combination of the above technical features or the equivalent features thereof without departing from the inventive concept. Such as the above-described features, are mutually substituted with (but not limited to) the features having similar functions disclosed in the embodiments of the present disclosure.
Claims (11)
1. A method for performing database operations, comprising:
obtaining a routing node information set in response to receiving database operation request information, wherein the routing node information in the routing node information set is output by a corresponding proxy server;
based on the database operation request information, identifying the routing node information set to obtain target routing information;
and forwarding the database operation request information to a proxy server corresponding to the target routing information for executing database operation.
2. The method of claim 1, wherein the identifying the routing node information set based on the database operation request information to obtain target routing information includes:
Extracting the database operation request information to obtain key data information;
and carrying out matching processing on the key data information and the routing node information set to obtain target routing information.
3. The method of claim 2, wherein the matching the key data information and the routing node information set to obtain target routing information includes:
and selecting one piece of routing node information meeting the first preset historical operation condition from the routing node information set as target routing information.
4. The method of claim 2, wherein the matching the key data information and the routing node information set to obtain target routing information further comprises:
selecting routing node information meeting a second preset historical operation condition from the routing node information set as node information to be screened, and obtaining a node information set to be screened;
and generating target routing information based on the node information set to be screened.
5. The method of claim 2, wherein the matching the key data information and the routing node information set to obtain target routing information further comprises:
Determining the routing node information set as a node information set to be screened in response to determining that the routing node information set does not have the routing node information meeting the preset history condition;
and generating target routing information based on the node information set to be screened.
6. The method according to one of claims 4-5, wherein the generating target routing information based on the set of node information to be screened comprises:
in response to determining that the node information set to be screened meets the preset node quantity condition, determining a weight value corresponding to each node information to be screened in the node information set to be screened based on a preset resource score configuration information set to obtain a weight value set;
selecting a weight value meeting a preset weight condition from the weight value set as a target weight value;
and determining node information to be screened corresponding to the target weight value as target routing information.
7. The method of claim 1, wherein prior to the obtaining the set of routing node information in response to receiving database operation request information, the method further comprises:
for each routing node identifier in a preset routing node identifier set, executing the following steps:
Acquiring a node resource information group, a history list operation information set and a forwarding terminal identifier from the routing nodes corresponding to the routing node identifiers;
and determining the routing node identification, the node resource information group, the history list operation information set, the forwarding terminal identification, preset history operation template information, a first preset validity period and a second preset validity period as routing node information.
8. An apparatus for performing database operations, comprising:
an acquisition unit configured to acquire a set of routing node information in response to receiving database operation request information, wherein the routing node information in the set of routing node information is output by a corresponding proxy server;
the identification processing unit is configured to perform identification processing on the routing node information set based on the database operation request information to obtain target routing information;
and the forwarding unit is configured to forward the database operation request information to a proxy server corresponding to the target routing information for executing database operation.
9. An electronic device, comprising:
one or more processors;
a storage device having one or more programs stored thereon,
When executed by the one or more processors, causes the one or more processors to implement the method of any of claims 1-7.
10. A computer readable medium having stored thereon a computer program, wherein the computer program, when executed by a processor, implements the method of any of claims 1-7.
11. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310449839.2A CN116450725A (en) | 2023-04-24 | 2023-04-24 | Method, apparatus, electronic device, and medium for performing database operations |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310449839.2A CN116450725A (en) | 2023-04-24 | 2023-04-24 | Method, apparatus, electronic device, and medium for performing database operations |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116450725A true CN116450725A (en) | 2023-07-18 |
Family
ID=87133538
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310449839.2A Pending CN116450725A (en) | 2023-04-24 | 2023-04-24 | Method, apparatus, electronic device, and medium for performing database operations |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116450725A (en) |
-
2023
- 2023-04-24 CN CN202310449839.2A patent/CN116450725A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110311983B (en) | Service request processing method, device and system, electronic equipment and storage medium | |
| WO2019200714A1 (en) | Server connection method, computer readable storage medium, terminal device, and apparatus | |
| CN110019080B (en) | Data access method and device | |
| CN110909521B (en) | Online document information synchronous processing method and device and electronic equipment | |
| WO2023202276A1 (en) | Domain name resolution request processing method and apparatus, and device, medium and program product | |
| CN111930770A (en) | Data query method and device and electronic equipment | |
| CN110489474B (en) | Data processing method, device, medium and electronic equipment | |
| CN114461247A (en) | Hot update method, device, electronic equipment and computer readable medium | |
| CN116743785A (en) | Cloud network data storage method, device, equipment and medium based on fog calculation | |
| CN113553206B (en) | Data event execution method and device, electronic equipment and computer readable medium | |
| CN108810130B (en) | Method and device for planning distribution request | |
| CN116450725A (en) | Method, apparatus, electronic device, and medium for performing database operations | |
| CN115396494A (en) | Real-time monitoring method and system based on stream computing | |
| CN112257039B (en) | Identity attribute adding method and device and electronic equipment | |
| CN110941683B (en) | Method, device, medium and electronic equipment for acquiring object attribute information in space | |
| CN113127550A (en) | Information processing method, information processing device, electronic equipment and storage medium | |
| CN114115941A (en) | Resource sending method, page rendering method, device, electronic equipment and medium | |
| CN114035861A (en) | Cluster configuration method and device, electronic equipment and computer readable medium | |
| CN113420400A (en) | Routing relation establishing method, request processing method, device and equipment | |
| CN110019671B (en) | Method and system for processing real-time message | |
| CN108520025B (en) | Service node determination method, device, equipment and medium | |
| CN112181605A (en) | Load balancing method and device, electronic equipment and computer readable medium | |
| CN110705935A (en) | Logistics document processing method and device | |
| CN113472565B (en) | Method, apparatus, device and computer readable medium for expanding server function | |
| CN116319322B (en) | Power equipment node communication connection method, device, equipment and computer medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |