Method and system decoding user defined functions

Details Method and system decoding user defined functions Method and system decoding user defined functions

2006-12-26

2006-12-26

Wassum, Luke S (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07155432

ABSTRACT:
A database engine and optimizer framework includes a decoder to identify and process SQL queries or statements that reference a UDF before they are executed. Once such a statement is detected, the decoder determines if the UDF is capable of being merged into an SQL statement and, if so, performs such a merge. In some embodiments, the decoder may not use a pre-cached version of the UDF but, instead, may include a component that locates and retrieves the latest version of the UDF for use when performing the merge. Also, for UDFs that cannot easily be merged into an SQL statement, the decoder may not merge the UDF into an SQL statement but may allow the optimizer and execution engine to retrieve and execute the UDF in the usual manner.

REFERENCES:
patent: 5765147 (1998-06-01), Mattos et al.
patent: 5987455 (1999-11-01), Cochrane et al.
patent: 6285996 (2001-09-01), Jou et al.
patent: 6353818 (2002-03-01), Carino, Jr.
patent: 6938044 (2005-08-01), Milby
patent: 2002/0129260 (2002-09-01), Benfield et al.
patent: 2003/0004935 (2003-01-01), Wilmot et al.
patent: 2003/0009446 (2003-01-01), Agarwal et al.
patent: 2003/0037048 (2003-02-01), Kabra et al.
patent: 2005/0154709 (2005-07-01), Barsness et al.
Kollar et al., “SQL Server Query Optimization and Tuning”, Sep. 9, 2003, Microsoft TechNet, pp. 7-9.
Taylor et al., “A deductive database system with applications to route planning”, 1991, Springer-Verlag (Wien, Australia).
Jaedicke et al., “On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS”, Proceedings of the 1998 ACM SIGMOD International Conference on Management of Data, pp. 379-389.

Affiliated with

Also associated with

Rating

Method and system decoding user defined functions 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 and system decoding user defined functions, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system decoding user defined functions will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3667566