Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-07-31
2007-07-31
Gaffin, Jeffrey (Department: 2165)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
10648008
ABSTRACT:
A technique for processing input data is provided. Multiple input rows to beloaded into a first structure are received. Each input row of the multiple input rows is processed to classify each input row as one of an insert row and an update row, wherein input duplicates are stored in the first structure and index entries for the input duplicates are stored in a second structure. After the multiple input rows have been processed, the input duplicates are automatically re-applied to the first structure and the index entries stored in the second structure are processed.
REFERENCES:
patent: 5584026 (1996-12-01), Knudsen et al.
patent: 5603024 (1997-02-01), Goldring
patent: 5684990 (1997-11-01), Boothby
patent: 5926816 (1999-07-01), Bauer et al.
patent: 5995980 (1999-11-01), Olson et al.
patent: 6421658 (2002-07-01), Carey et al.
patent: 6442543 (2002-08-01), Snodgrass et al.
patent: 6505200 (2003-01-01), Ims et al.
patent: 6829600 (2004-12-01), Gu et al.
patent: 6944633 (2005-09-01), Higa et al.
patent: 6985895 (2006-01-01), Witkowski et al.
patent: 7016903 (2006-03-01), Thusoo et al.
patent: 7020661 (2006-03-01), Cruanes et al.
patent: 2002/0111955 (2002-08-01), Colby et al.
patent: 2001022620 (2001-02-01), None
“Load and transform external data into Oracle 9i”, by Akadia. Available online at http://www.akadia.com/services/ora—etl.html#The%20MERGE%20Statement.
“Using Pipelined Table Functions (Oracle 9i)” by Toji Mammen George. Published Mar. 12, 2003. Available online at http://www.codeguru.com/cpp/data/mfc—database/oracle/article.php/c4285/.
“Oracle9i Database Daily Features Archives—August”, by Oracle. Available online at http://www.oracle.com/technology/products/oracl9i/daily/aug2001.html.
“MERGE Statement”, available online at http://www.oracle.com/technology/products/oracle9i/daily/Aug24.html, Posted Aug. 24, 2001.
U.S. Appl. No. 09/597,588, filed on Jun. 20, 2000, entitled “Technique for Enforcing Temporal Uniqueness in an Object/Relational Database Management System Environment,” invented by C.M. Saracco.
IBM Corporation.Table Management Utility. Reference Guide. IBM Brick Warehouse. Chapter entitled Loading Data into a Warehouse Language (XML). Version 6.2, Aug. 2002, Part. No. 000-9055 [online] Retrieved from http:www-3.ibm.com/software/data/informix/pubs/library/interim/9055-pdf.html, 408 pages.
NCR Corporation. Teradata® Multiload Reference. Release Jul. 6, 2002. B035-2409-122A, Dec. 2002, 294 pages [online] Retrieved from http://www.info.ncr.com/temp/2409-122A185057.pdf.
IBM Corporation.Using Red Brick Warehouse with IBM DB2 Warehouse Manager, 6 pages [online] Retrieved from http://www7b.boulder.ibm.com/dmdd/zones/informix/library/techarticle/0301jin.html.
Oracle 9i SQL Reference: MERGE, 3 pages [online] Retrieved from http://download-west.oracle.com/docs/cd/B10501—01/server.920/a96540/statements—915a.htm#2080943.
Jin Qi
Srinivasan Sriram
Davoa Janaki K.
Gaffin Jeffrey
International Business Machines - Corporation
Konrad Raynes & Victor LLP
Radtke Mark Andrew X
LandOfFree
Method, system, and article of manufacture for processing... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method, system, and article of manufacture for processing..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system, and article of manufacture for processing... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3800777