Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2005-08-15
2009-08-18
Alam, Hosain T (Department: 2166)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
07577637
ABSTRACT:
While generating an execution plan for a database statement that includes a user-defined table function that requires partitioning of input data to the function, it is determined whether the partitioning of output data from an operation that feeds the function is compatible with the partitioning required by the function. If the partitioning of output data from the operation that feeds the function is compatible with the partitioning required by the function, then the execution plan is constructed to specify execution of both (1) the function and (2) the operation that feeds the function, by a same set of processes. For example, the operation that feeds the function and the function itself are clumped into the same sub-plan or sub-tree, which is scheduled and run in parallel on a set of parallel execution slaves.
REFERENCES:
patent: 5857180 (1999-01-01), Hallmark et al.
patent: 6112198 (2000-08-01), Lohman et al.
patent: 6665684 (2003-12-01), Zait et al.
patent: 6691101 (2004-02-01), MacNicol et al.
patent: 7103588 (2006-09-01), Beck et al.
patent: 2007/0208690 (2007-09-01), Schneider et al.
“General Case: Function behavior depends on the partitioning of the input data” retrieved on Dec. 23, 2005 from the Internet <URL: http://www.oracle.com/technology/sample—code/tech/pl—sql/htdocs/x/Table—Functions—C...> (Sep. 2, 2003) pp. 1-2.
“Pipelined Table Functions—New in Oracle 9i” retrieved on Dec. 23, 2005 from the Internet <URL: http://www.oracle.com/technology/sample—code/tech/pl—sql/htdocs/x/Table—Functions—C...> (Sep. 2, 2003) pp. 1-2.
“Piping data from one Table Function to the next—New in Oracle 9i” retrieved on Dec. 23, 2005 from the Internet: <URL: http://www.oracle.com/technology/sample—code/tech/pl—sql/htdocs/x/Table—Functions13 C...> (Sep. 2, 2003) pp. 1-2.
“Special Case: Function behavior is independent of the partitioning of the input data” retrieved on Dec. 23, 2005 from the Internet <URL: http://www.oracle.com/technology/sample—code/tech/pl—sql/htdocs/x/Table—Functions—C...> (Sep. 2, 2003) p. 1.
Alam Hosain T
Hickman Palermo & Truong & Becker LLP
Ng Amy
Oracle International Corporation
LandOfFree
Communication optimization for parallel execution of... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Communication optimization for parallel execution of..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Communication optimization for parallel execution of... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4065012