Invention Grant
- Patent Title: Database unload/reload of partitioned tables
- Patent Title (中): 数据库卸载/重新加载分区表
-
Application No.: US12118094Application Date: 2008-05-09
-
Publication No.: US07904489B2Publication Date: 2011-03-08
- Inventor: Bryan G. Grant
- Applicant: Bryan G. Grant
- Applicant Address: US MN Minneapolis
- Assignee: Target Brands, Inc.
- Current Assignee: Target Brands, Inc.
- Current Assignee Address: US MN Minneapolis
- Agency: Westman, Champlin & Kelly, P.A.
- Agent Theodore M. Magee
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

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.
Public/Granted literature
- US20090282055A1 DATABASE UNLOAD/RELOAD OF PARTITIONED TABLES Public/Granted day:2009-11-12
Information query