Database redistribution in dynamically-configured database systems

摘要

A database system may implement resource management for redistribution of stored database information in additional database resources. Resource management may include detection of the presence of additional database resources, such as storage and processing resources. Based on conditions associated with the additional resources and database information selected for potential redistribution, resource management may include a determination as to whether or not redistribution of the database information is to be performed. Resource management may include a cost-benefit analysis to determine if redistribution of database information is to be performed. The cost-benefit analysis may be based on factors related to both the additional resources and the database information being considered for redistribution.

主权项

1. A resource management tool for a database system, the resource management tool comprising:
a memory device; and a processor in communication with the memory device, the processor configured to: detect availability of additional database resources to the database system in response to addition of the additional database resources to the database system, wherein the additional database resources include at least one of additional processing resources and additional storage resources; identify a database object associated with original database resources of the database system to be redistributed from the original database resources to the additional database resources, wherein the original database resources include at least one of processing resources and storage resources; determine presence of at least one condition associated with at least one of the additional database resources and the identified database object; and redistribute at least a portion of the database object from the original database resources to the additional database resources in response to the presence of the at least one condition, wherein the redistribution disassociates the at least a portion of the database object from the original database resources and associates the at least a portion of the database object with the additional database resources.