Minimize downtime with immediate upgrade of data in databases

摘要

Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for updating data stored within the database. In some implementations, actions include providing a plurality of cut-off dates, for each cut-off date in the plurality of cut-off dates determining a total time based on respective times associated with a plurality of tasks to provide a plurality of total times, each total time corresponding to a respective cut-off date, selecting an actual cut-off date based on the plurality of total times, and updating data within the database using the actual cut-off date.

主权项

1. A computer-implemented method for updating data within a database, the method being executed by one or more processors and comprising:
providing a plurality of cut-off dates, each cut-off date defining a first portion of the data within the database as pre cut-off date data and a second portion of the data within the database as post cut-off date data; for each cut-off date in the plurality of cut-off dates determining, by the one or more processors, a plurality of tasks associated with updating the data within the database, each plurality of tasks corresponding to a respective cut-off date; providing a plurality of total times by, for each cut-off date in the plurality of cut-off dates determining, by the one or more processors, a total time based on respective times associated with each task of the corresponding plurality of tasks to provide the total time to execute the plurality of tasks corresponding to the respective cut-off date; selecting, by the one or more processors, an actual cut-off date based on the plurality of total times; and updating, by the one or more processors, the data within the database using the actual cut-off date to define the first portion and the second portion of the data within the database.