Minimize downtime with immediate upgrade of data in databases

1. A computer-implemented method for updating travel commerce data within a database, comprising:

determining a cut-off date, the cut-off date being provided by an owner of the database, and the cut-off date defining current data that has been provided to the database after the cut-off date and historical data that has been provided to the database on or before the cut-off date;

defining a first group of data that populates a first group of entries within a first table based on the cut-off date;

defining a second group of data that populates a second group of entries within the first table based on the cut-off date;

providing the second group of data from the first table in a second table;

converting the first group of data from a first data structure to a second data structure to provide converted first data that populates the first group of entries within the first table;

testing the converted first data within the first table;

upon successfully completing testing of the converted first data, making the converted first data available for access over a network within the first table;

converting the second group of data from the first data structure to the second data structure to provide converted second data in the second table, a code associated with converting the first group of data and the second group of data being reusable across a variety of database systems;

moving the converted second data from the second table to the second group of entries within the first table; and

making the converted second data available for access over the network within the first table.

2. The method of claim 1 , wherein the first group of data comprises post cut-off date data.

3. The method of claim 1 , wherein the second group of data comprises pre cut-off date data.

4. The method of claim 1 , further comprising identifying one or more partitions of the first table as including the second group of data based on the cut-off date.

5. The method of claim 4 , wherein providing the second group of data in the second table comprises switching the one or more partitions of the first table to the second table.

6. The method of claim 1 , wherein converting the first group of data and converting the second group of data each comprises executing one or more scripts.

7. The method of claim 6 , wherein the one or more scripts are executed to convert both the first group of data and the second group of data.

8. The method of claim 6 , wherein the one or more scripts each comprise a table variable that is generic to the first table and the second table.

9. The method of claim 1 , further comprising enabling foreign key constraints before converting the first group of data.

10. The method of claim 1 , further comprising:

enabling foreign keys before converting the second group of data; and

enabling the foreign keys after switching the converted second data to the first table.

11. The method of claim 1 , further comprising:

receiving user input commanding a pause when converting the second group of data; and

completing execution of an intermediate conversion in response to receiving the user input.

12. The method of claim 1 , wherein the data comprises transactional data.

13. The method of claim 12 , wherein the transaction data comprises booking data associated with at least one of a travel reservation, a car rental reservation and a hotel reservation.

14. The method of claim 1 , wherein making the converted first data available for access over the network occurs before switching the converted second data to the first table.

15. The method of claim 1 , wherein making the converted second data available for access over the network comprises switching the converted second data to the first table.

16. The method of claim 1 , further comprising:

determining that the database does not include partitioned tables; and

copying the database to provide a copied database in response to determining that the database does not include partitioned tables, wherein the second table is provided in the copied database.

17. The method of claim 16 , wherein converting the first group of data from a first data structure to a second data structure to provide converted first data within the first table further comprises providing partitions with the first table.

18. The method of claim 16 , wherein converting the second group of data from the first data structure to the second data structure to provide converted second data in the second table further comprises providing partitions in the second table.

19. The method of claim 16 , wherein making the converted first data available for access over the network comprises moving the converted first data to the copied database.

20. The method of claim 19 , further comprising entering the converted first data into reserved partitions of the second table.

21. The method of claim 16 , wherein making the converted first data available for access and making the converted second data available for access occur concurrently by making the second table available for access over the network.

22. A system comprising:

one or more computers; and

a computer-readable medium coupled to the one or more computers having instructions stored thereon which, when executed by the one or more computers, cause the one or more computers to perform operations for updating travel commerce data within a database, the operations comprising:

determining a cut-off date, the cut-off date being provided by an owner of the database, and the cut-off date defining current data that has been provided to the database after the cut-off date and historical data that has been provided to the database on or before the cut-off date;

defining a first group of data that populates a first group of entries within a first table based on the cut-off date;

defining a second group of data that populates a second group of entries within the first table based on the cut-off date;

providing the second group of data from the first table in a second table;

converting the first group of data from a first data structure to a second data structure to provide converted first data that populates the first group of entries within the first table;

testing the converted first data within the first table;

upon successfully completing testing of the converted first data, making the converted first data available for access over a network within the first table;

converting the second group of data from the first data structure to the second data structure to provide converted second data in the second table, a code associated with converting the first group of data and the second group of data being reusable across a variety of database systems;

moving the converted second data from the second table to the second group of entries within the first table; and

making the converted second data available for access over the network within the first table.

23. A non-transitory computer storage medium encoded with a computer program, the program comprising instructions that when executed by one or more computers cause the one or more computers to perform operations for updating travel commerce data within a database, the operations comprising:

determining a cut-off date, the cut-off date being provided by an owner of the database, and the cut-off date defining current data that has been provided to the database after the cut-off date and historical data that has been provided to the database on or before the cut-off date;

defining a first group of data that populates a first group of entries within a first table based on the cut-off date;

defining a second group of data that populates a second group of entries within the first table based on the cut-off date;

providing the second group of data from the first table in a second table;

converting the first group of data from a first data structure to a second data structure to provide converted first data that populates the first group of entries within the first table;

testing the converted first data within the first table;

upon successfully completing testing of the converted first data, making the converted first data available for access over a network within the first table;

converting the second group of data from the first data structure to the second data structure to provide converted second data in the second table, a code associated with converting the first group of data and the second group of data being reusable across a variety of database systems;

moving the converted second data from the second table to the second group of entries within the first table; and

making the converted second data available for access over the network within the first table.