Database unload/reload of partitioned tables
US7904489B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | May 9, 2008 |
| Grant date | Mar 8, 2011 |
| Priority date | — |
| Expiry date | Oct 23, 2029 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/217
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Values stored in partitioned tables are unloaded into files with one partition per file using a database unload utility. This utility forms a punch file that includes instructions to perform a load of data from the unloaded files into the partitioned table. The punch file is read to determine the names of the unloaded files. These names are altered to form new files. Values in the unloaded files are modified and the modified values are written to the new files. A new punch file is created that is more efficient than the initial punch file and that allows data in the partitioned table to be replaced on a partition basis with the data in the new files. The new punch file is then executed to load the modified values in the new files into the partitioned table.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.