Data processing: database and file management or data structures – Database design – Database and data structure management
Reexamination Certificate
2011-03-08
2011-03-08
Lu, Kuen S (Department: 2163)
Data processing: database and file management or data structures
Database design
Database and data structure management
C707S809000
Reexamination Certificate
active
07904489
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.
REFERENCES:
patent: 6920563 (2005-07-01), Kohl et al.
patent: 7093137 (2006-08-01), Sato et al.
patent: 7111005 (2006-09-01), Wessman
patent: 7266699 (2007-09-01), Newman et al.
patent: 7797342 (2010-09-01), Banks et al.
patent: 7827403 (2010-11-01), Wong et al.
patent: 2001/0034704 (2001-10-01), Farhat et al.
patent: 2004/0255133 (2004-12-01), Lei et al.
patent: 2007/0074047 (2007-03-01), Metzger et al.
patent: 2007/0079119 (2007-04-01), Mattsson et al.
patent: 2007/0214167 (2007-09-01), Nair et al.
patent: WO-01/35226 (2001-05-01), None
DB2 Portal Blog, “Update Schema and Catmaint [DB2 9 for z/OS],” http://www.db2portal.com/labels/DB2%209.html, 67 pages, (last visited Dec. 18, 2007).
Ho Binh V
Lu Kuen S
Magee Theodore M.
Target Brands Inc.
Westman Champlin & Kelly P.A.
LandOfFree
Database unload/reload of partitioned tables does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Database unload/reload of partitioned tables, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database unload/reload of partitioned tables will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2758299