Scalable design of relational database for resource management
AssigneeZoom Communications, Inc.
InventorsYuanyuan Du, Jingjin Xie
Life of this patent
Estimating the term…
Abstract
Systems and methods for resource management using a scalable resource management database are provided. A resource management tool accesses a resource management database. The resource management tool determines a size of an attribute value corresponding to an attribute of a resource instance satisfies a predetermined size threshold. The resource management tool determines a query frequency associated with the attribute value satisfies a predetermined frequency threshold. The resource management tool creates a value index table based on a value table, the value index table excluding the attribute value satisfying the predetermined size threshold and the predetermined frequency threshold.
Claims20
A method comprising:
- accessing a resource management database, the resource management database comprising a value table storing one or more attribute values corresponding to one or more attributes for one or more resource instances, the one or more resources instance comprising one or more runtime objects representing one or more compute resources;
- determining that a size of an attribute value corresponding to an attribute of a resource instance is greater than a predetermined size threshold;
- determining that a query frequency associated with the attribute value of the resource instance is less than a predetermined query frequency threshold;
- and
- creating a value index table based on the value table, the value index table excluding the attribute value of the resource instance.
A system comprising:
- a communications interface;
- a non-transitory computer-readable medium;
- and
- one or more processors communicatively coupled to the communications interface and the non-transitory computer-readable medium, the one or more processors configured to execute processor-executable instructions stored in the non-transitory computer-readable medium to:
- access a resource management database, the resource management database comprising a value table storing one or more attribute values corresponding to one or more attributes for one or more resource instances, the one or more resources instance comprising one or more runtime objects representing one or more compute resources;
- determine that a size of an attribute value corresponding to an attribute of a resource instance is greater than a predetermined size threshold;
- determine that a query frequency associated with the attribute value of the resource instance is less than a predetermined query frequency threshold;
- and
- create a value index table based on the value table, the value index table excluding the attribute value of the resource instance.
A non-transitory computer-readable medium comprising processor-executable instructions configured to cause one or more processors to:
- access a resource management database, the resource management database comprising a value table storing one or more attribute values corresponding to one or more attributes for one or more resource instances, the one or more resources instance comprising one or more runtime objects representing one or more compute resources;
- determine that a size of an attribute value corresponding to an attribute of a resource instance is greater than a predetermined size threshold;
- determine that a query frequency associated with the attribute value of the resource instance is less than a predetermined query frequency threshold;
- and
- create a value index table based on the value table, the value index table excluding the attribute value of the resource instance.
Dependencies are inferred from the claim text.