Dynamic configuration and self-tuning of inter-nodal communication resources in a database management system
First Claim
Patent Images
1. A system comprising:
- a plurality of server computers having memories for storing a plurality of server partitions forming a database management system (DBMS) server instance, each of the plurality of server partitions being located on one of the plurality of server computers in the system;
a mechanism in each of the plurality of server partitions; and
a daemon in each of the plurality of server partitions,responsive to one of the plurality of server partitions receiving a communication resource configuration request from one ofa client in the system,another server partition in the DBMS server instance, andthe daemon in the one server partition,the mechanism in the one server partition dynamically configuring a number of communication resource elements initialized in the one server partition for communication with one or more other server partitions in the DBMS server instance,dynamic configuration of the number of communication resource elements initialized in the one server partition being accomplished in real-time without having to stop and restart the DBMS server instance,the daemon in the one server partition communicating the communication resource configuration request to at least one other server partition in the DBMS server instance using one or more communication resource elements initialized in the one server partition.
0 Assignments
0 Petitions
Accused Products
Abstract
A database management system in which a plurality of nodes form a database instance, each node including a communication manager for dynamically configuring inter-nodal communication resources. The communication manager receives communication resource allocation requests from clients or a self-tuning algorithm. A resource self-tuning mechanism allocates or de-allocates memory blocks used for communication resource elements dynamically in real time without cycling the instance. Memory blocks are de-allocated asynchronously by placing associated communication resource elements in quarantine until all communication resource elements associated with the memory block are quarantined.
-
Citations
12 Claims
-
1. A system comprising:
-
a plurality of server computers having memories for storing a plurality of server partitions forming a database management system (DBMS) server instance, each of the plurality of server partitions being located on one of the plurality of server computers in the system; a mechanism in each of the plurality of server partitions; and a daemon in each of the plurality of server partitions, responsive to one of the plurality of server partitions receiving a communication resource configuration request from one of a client in the system, another server partition in the DBMS server instance, and the daemon in the one server partition, the mechanism in the one server partition dynamically configuring a number of communication resource elements initialized in the one server partition for communication with one or more other server partitions in the DBMS server instance, dynamic configuration of the number of communication resource elements initialized in the one server partition being accomplished in real-time without having to stop and restart the DBMS server instance, the daemon in the one server partition communicating the communication resource configuration request to at least one other server partition in the DBMS server instance using one or more communication resource elements initialized in the one server partition. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A non-transitory memory of a server computer for storing one of a plurality of server partitions forming a database management system (DBMS) server instance, the one server partition configured for:
-
receiving a communication resource configuration request at the one server partition, the communication resource configuration request being received from one of a client in the system, another server partition in the DBMS server instance, and a daemon in the one server partition; dynamically configuring a number of communication resource elements initialized in the one server partition for communication with one or more other server partitions in the DBMS server instance, the dynamic configuration of the number of communication resource elements initialized in the one server partition being accomplished in real-time without having to stop and restart the DBMS server instance; and communicating the communication resource configuration request to at least one other server partition in the DBMS server instance using one or more communication resource elements initialized in the one server partition. - View Dependent Claims (9, 10, 11, 12)
-
Specification