Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-03-21
2006-03-21
Corrielus, Jean M. (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07016903
ABSTRACT:
The present invention provides the ability to alternatively update or insert a row into a table. This functionality is accomplished by merging a source table with a destination table such that the rows in the combined table are classified as an update row or an insert row. An identifier is inserted into each row to indicate its class. Examination of the identifier allows the row to be correctly inserted into the destination table or correctly updated in the destination table.
REFERENCES:
patent: 4506326 (1985-03-01), Shaw et al.
patent: 5555388 (1996-09-01), Shaughnessy
patent: 5692178 (1997-11-01), Shaughnessy
patent: 5706494 (1998-01-01), Cochrane et al.
patent: 5864512 (1999-01-01), Buckelew et al.
patent: 5956704 (1999-09-01), Gautam et al.
patent: 5963933 (1999-10-01), Cheng et al.
patent: 5978574 (1999-11-01), Sharma
patent: 6003022 (1999-12-01), Eberhard et al.
patent: 6009432 (1999-12-01), Tarin
patent: 6223182 (2001-04-01), Agarwal et al.
patent: 6356901 (2002-03-01), MacLeod et al.
patent: 6411951 (2002-06-01), Galindo-Legaria et al.
patent: 6418437 (2002-07-01), Cole
patent: 6453314 (2002-09-01), Chan et al.
patent: 6567823 (2003-05-01), Rothschild
patent: 6581205 (2003-06-01), Cochrane et al.
patent: 6636846 (2003-10-01), Leung et al.
patent: 6654756 (2003-11-01), Quernemoen et al.
patent: 6687798 (2004-02-01), Thusoo et al.
patent: 6735587 (2004-05-01), Colby et al.
patent: 6768986 (2004-07-01), Cras et al.
patent: 2004/0199519 (2004-10-01), Gu et al.
Ravi Kanth et al. Improved concurrency control techniques for multi-dimensional index structure, Parallel Processing Symposium, Apr. 3, 1998, pp. 580-586.
Amer-Yahia et al. A declarative approach to optimize bulk loading into databases, ACM Transactions on Database System. pp. 233-281, 2004.
Oracle Corporation, “Oracle9;Database Daily Feature, MERGE Statement,” published Sep. 17, 2002, 3 pages.
Shirinne Alison, et al., Oracle Corporation, “Oracle9i Warehouse Builder, User's Guide,” Release 9.0.3, Mar. 29, 2002, Part No. A97306-01, 35 pages.
Bedi Harmeek
Ghosh Bhaskar
Thusoo Ashish
Bingham & McCutchen LLP
Corrielus Jean M.
Oracle International Corporation
To Baoquoc N.
LandOfFree
Method for conditionally updating or inserting a row into a... 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 for conditionally updating or inserting a row into a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for conditionally updating or inserting a row into a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3572337