Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-08-30
2008-11-11
Fleurantin, Jean B. (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07451133
ABSTRACT:
Techniques are provided for processing a database statement that includes a table function capable of parallel execution, where the input of the table function is specified in a subquery. During compilation of the database statement, a global cursor is generated for the database statement. The global cursor includes a first plan component for executing the table function and a second plan component for generating input for the table function. A “dummy” cursor is then generated. When slaves execute the table function, they call the dummy cursor for input. When a slave calls the dummy cursor for input, the dummy cursor causes a context switch back to the global cursor, so that the second plan component within the first cursor generates the input for the slave.
REFERENCES:
patent: 4860201 (1989-08-01), Stolfo et al.
patent: 5325525 (1994-06-01), Shan et al.
patent: 5765146 (1998-06-01), Wolf et al.
patent: 5835755 (1998-11-01), Stellwagen, Jr.
patent: 5857180 (1999-01-01), Hallmark et al.
patent: 6081801 (2000-06-01), Cochrane et al.
patent: 6085189 (2000-07-01), Pirahesh et al.
patent: 6112198 (2000-08-01), Lohman et al.
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6430550 (2002-08-01), Leo et al.
patent: 6466931 (2002-10-01), Attaluri et al.
patent: 6507834 (2003-01-01), Kabra et al.
patent: 6529901 (2003-03-01), Chaudhuri et al.
patent: 6622138 (2003-09-01), Bellamkonda et al.
patent: 6625593 (2003-09-01), Leung et al.
patent: 6721724 (2004-04-01), Galindo-Legaria et al.
patent: 6910032 (2005-06-01), Carlson et al.
patent: 6928451 (2005-08-01), Mogi et al.
patent: 6954776 (2005-10-01), Cruanes et al.
patent: 6968335 (2005-11-01), Bayliss et al.
patent: 7020661 (2006-03-01), Cruanes et al.
patent: 7051034 (2006-05-01), Ghosh et al.
patent: 7089356 (2006-08-01), Chen et al.
patent: 7234112 (2007-06-01), Brown et al.
patent: 2002/0038300 (2002-03-01), Iwata et al.
patent: 2003/0055813 (2003-03-01), Chaudhuri et al.
patent: 2003/0065644 (2003-04-01), Horman et al.
patent: 2003/0229640 (2003-12-01), Carlson et al.
patent: 2004/0172626 (2004-09-01), Jalan et al.
patent: 2005/0049996 (2005-03-01), Srinivasan et al.
patent: 2005/0131879 (2005-06-01), Ghosh et al.
patent: 2005/0131890 (2005-06-01), Cruanes et al.
patent: 2005/0132383 (2005-06-01), Ghosh et al.
“Office Action” received in related case U.S. Appl. No. 10/944,175, filed Sep. 16, 2004, 20 pages.
Cruanes Thierry
Ghosh Bhaskar
Muralidhar Subramanian
Yoaz Adiel
Fleurantin Jean B.
Hickman Palermo & Truong & Becker LLP
Jami Hares
Oracle International Corporation
LandOfFree
Executing nested subqueries of parallel table functions in... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Executing nested subqueries of parallel table functions in..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Executing nested subqueries of parallel table functions in... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4026951