The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 11, 2008
Filed:
Aug. 30, 2004
Adiel Yoaz, Foster City, CA (US);
Thierry Cruanes, Redwood City, CA (US);
Bhaskar Ghosh, Burlingame, CA (US);
Subramanian Muralidhar, Fremont, CA (US);
Adiel Yoaz, Foster City, CA (US);
Thierry Cruanes, Redwood City, CA (US);
Bhaskar Ghosh, Burlingame, CA (US);
Subramanian Muralidhar, Fremont, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
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.