Method and system for data migration
First Claim
1. A method for determining whether a data migration server should migrate source data from a source database to a destination database, wherein the source and destination databases carry out one or more transactions, comprising:
- determining the average power consumption per transaction of the source database;
surveying with the data migration server a plurality of candidates for a destination database by monitoring the power consumption level of each of the plurality of candidates,wherein the step of monitoring the power consumption level comprises checking each of the plurality of candidates for i) available space;
ii) power consumed up to the point of checking; and
iii) maximum monthly power consumption limit;
comparing the average power consumption per transaction of the source database against the average power consumption per transaction of each candidate;
selecting a candidate from the plurality of destination database candidates that uses less power consumption per transaction than the source database;
moving the source data to the selected destination database; and
surveying with the data migration server, after moving the source data to the selected destination database, the plurality of candidates for changes in the average power consumption per transaction of each candidate; and
relocating the source data from the selected destination database to a second destination database if the second destination database uses less power consumption per transaction than the selected destination database.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and system for migrating source data from one or more databases to a destination database, wherein the destination database is selected based on power consumption of the destination database. A data migration server determines which destination database should be selected by selecting a number of candidates and comparing the power consumed, the available space and the maximum monthly power consumption limit. A user intervention policy is created to evaluate which data should be moved to a destination database. A “payback period” is calculated to determine the amount of time that will elapse before savings are realized.
-
Citations
17 Claims
-
1. A method for determining whether a data migration server should migrate source data from a source database to a destination database, wherein the source and destination databases carry out one or more transactions, comprising:
-
determining the average power consumption per transaction of the source database; surveying with the data migration server a plurality of candidates for a destination database by monitoring the power consumption level of each of the plurality of candidates, wherein the step of monitoring the power consumption level comprises checking each of the plurality of candidates for i) available space;
ii) power consumed up to the point of checking; and
iii) maximum monthly power consumption limit;comparing the average power consumption per transaction of the source database against the average power consumption per transaction of each candidate; selecting a candidate from the plurality of destination database candidates that uses less power consumption per transaction than the source database; moving the source data to the selected destination database; and surveying with the data migration server, after moving the source data to the selected destination database, the plurality of candidates for changes in the average power consumption per transaction of each candidate; and relocating the source data from the selected destination database to a second destination database if the second destination database uses less power consumption per transaction than the selected destination database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A system for determining whether source data should be migrated from one or more source databases to a destination database comprising:
-
one or more source databases; a plurality of destination databases; one or more staging databases; a data migration server; whereby the data migration server determines whether the one or more source databases should be moved to one or more of the plurality of destination databases based on power consumption parameters, selects one of the destination databases for the migration of the source data thereto by i) monitoring the power consumption level of the plurality of destination databases by checking each of the plurality of candidates for available space, power consumed up to the point of checking, and maximum monthly power consumption limit;
ii) comparing the power consumption level of each of the plurality of destination databases; and
iii) selecting the destination database that uses the least amount of power per transaction,moves the source data to the selected destination database, continues to survey the plurality of candidates for changes in the average power consumption per transaction of each candidate; and relocates the source data from the selected destination database to a second destination database if the second destination database uses less power consumption per transaction than the selected destination database. - View Dependent Claims (11, 12, 13, 14)
-
-
15. A computer program product encoded in a non-transitory computer readable storage medium for instructing a migration data server to determine whether source data from a source database should be moved to a destination database, wherein the source and destination databases carry out one or more transactions, comprising:
-
instructing the migration data server to determine the average power consumption per transaction of the source database; instructing the migration data server to survey a plurality of candidates for a destination database by evaluating the average power consumption per transaction of each candidate, wherein the migration data server evaluates the average power consumption per transaction of each candidate comprises checking each of the plurality of candidates for i) available space;
ii) power consumed; and
iii) maximum monthly power consumption limit;instructing the migration data server to compare the average power consumption per transaction of the source database against the average power consumption per transaction of each candidate; instructing the migration data server to determine if the average power per transaction of the source database is greater than the average power consumption per transaction of any of the plurality of candidates; instructing the migration data server to select the destination database that uses less power consumption per transaction than the source database; instructing the migration data server to move the source data to the selected destination database; instructing the migration data server to survey, after moving the source data to the selected destination database, the plurality of candidates for changes in the average power consumption per transaction of each candidate; and instructing the migration data server to relocate the source data from the selected destination database to a second destination database if the second destination database uses less power consumption per transaction than the selected destination database. - View Dependent Claims (16, 17)
-
Specification