Systems and methods for dynamically selecting a logical location for an index

摘要

A computer-implemented method for dynamically selecting a logical location for an index is described. Information relating to a computing device and a location within the computing device is collected. The information is uploaded to a database. The database is queried for stored information relating to at least one computing device and at least one location within the at least one computing device. A performance score is calculated from the stored information. A logical location for the index is selected based on the calculated scores.

主权项

1. A computer-implemented method for dynamically selecting a logical location for an index, comprising:
collecting information relating to a computing device and a location within the computing device; uploading the information to a database; querying the database for stored information relating to a plurality of computing devices and at least one storage location within each of the plurality of computing devices; determining a maximum and minimum performance interval based on the stored information relating to the plurality of computing devices; calculating a device score from the stored information for each of the plurality of computing devices, wherein the device score is based on a product of a number of processor cores and an amount of available read-access memory (RAM) in each of the plurality of computing devices; normalizing the device score for each of the plurality of computing devices in relation to the maximum and minimum performance interval; calculating a location score from the stored information for the at least one storage location within each of the plurality of computing devices, the location score being calculated at least in part on past performance information of the storage location during a period of time; combining the normalized device score and the location score related to each computing device to obtain a final score for each of the plurality of computing devices; and selecting a logical location for the index based on the final score of one of the plurality of computing devices.