Evaluating expressions in stored procedures

Details Evaluating expressions in stored procedures Evaluating expressions in stored procedures

2007-08-21

2007-08-21

Wassum, Luke S (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

10081079

ABSTRACT:
A database system includes components for executing stored procedures that include at least one of a conditional expression, assignment expression, and dynamic database query language (e.g., SQL) statement. For each such expression, a predetermined type of code is generated and inserted into the object code corresponding to the stored procedure. When executing the stored procedure object code, the predetermined type of code is evaluated directly without having to generate a separate database query language statement.

REFERENCES:
patent: 5675804 (1997-10-01), Sidik et al.
patent: 5794231 (1998-08-01), Li et al.
patent: 5875334 (1999-02-01), Chow et al.
patent: 5930795 (1999-07-01), Chen et al.
patent: 5948063 (1999-09-01), Cooper et al.
patent: 6202070 (2001-03-01), Nguyen et al.
patent: 6327629 (2001-12-01), Wang et al.
patent: 6340977 (2002-01-01), Lui et al.
patent: 6477540 (2002-11-01), Singh et al.
patent: 6507834 (2003-01-01), Kabra et al.
patent: 6604096 (2003-08-01), Couch et al.
patent: 6732084 (2004-05-01), Kabra et al.
patent: 6741997 (2004-05-01), Liu et al.
patent: 7010784 (2006-03-01), Sentovich et al.
PR Newswire “Oracle Delivers Superior Performance and Scalability with Latest Release of Oracle9i Application Server”, Jun. 5, 2001.
Naude, F. and V. Harshvardhan “Oracle9i Release 1 New Features/Upgrade FAQ”, downloaded from www.orafaq.com, Aug. 14, 2001.
Vijay, S. “PL/SQL Native Compilation and Performance”, downloaded from www.dbaoncall.net, Dec. 20, 2001.
Oracle “PL/SQL User's Guide and Reference, Release 9.0.1”, Chapter 12 Tuning PL/SQL Applications, downloaded from download-ease.oracle.com, 2001.
Pribyl, B. and S. Feuerstein “Learning Oracle PL/SQL”, Sebastopol:O'Reilly & Associates, Inc., 2002, pp. 1-19, 329-330, ISBN: 0-596-00180-0.
Feuerstein, S. and B. Pribyl “Oracle PL/SQL Programming”, Sebastopol:O'Reilly & Associates, Inc., 2002, pp. 3-21, 718-721, 761-762. ISBN: 0-596-00381-1.
Lamba, R. “PL/SQL Native Compilation”, Technical Paper, TATA Consultancy Services, Oct. 2003.
Schrag, R. “Native PL/SQL Compilation in Oracle9i”, Powerpoint Presentation, downloaded from www.dbspecialists.com. undated.
Oracle “Native Compilation of PL/SQL”, downloaded form www.oracle.com, undated.
Rosenberg, D. “Bringing Java to the Enterprise: Oracle on its Java Server Strategy”, IEEE Internet Computing, vol. 2, No. 2, Mar./Apr. 1998, pp. 52-59.
Halfhill, T.R. “How to Soup Up Java”, Byte Magazine, May 1998.
Nobody Win “Soory for 9i”, Oracle-L listserv posting, Nov. 3, 2000.
Gadhia, T. and C. Racicot “PC/SQL Enhancements Planned for Future Oracle Releases”, downloaded from www.quest-pipelines.com
ewsletter/Oracle—PLSQL—Enhancements.doc, Jun. 2000.
Oracle “Natively Compiled Code”, Oracle8i Java Developer's Guide, Release 3 (8.1.7).
Llewellyn, B., S. Picciano and B. Kuder “New PL/SQL Features in Action: Real World Case Studies”, Paper #32501, delivered at OracleWorld, Nov. 11, 2002.
Quest Software “Pipeline Newsletter Archive—Oracle PL/SQL”, downloaded from www.quest-pipelines.com/pipelines/plsql
ews—archive.htm, Jul. 6, 2006.
NCR “Introduction to Teradata® RDBMS”, Version V2R4.0/V2R4.0.1, Publication R035-1091-060A, Sep. 2000.
NCR “Introduction to Teradata® RDBMS”, Version V2R4.1, Publication B035-1091-061A, Jun. 2001.
See 1 in Addendum.
See 2 in Addendum.
Bryn Llewellyn; PL/SQL Enhancements in Oracle9I; Paper #129, Oracle Openworld, San Francisco, Tue Dec. 4, 2001; Oracle.
Uwe Suckow, IFB Informatik Fur Banken AG; Native Compilation Von PL/SQL in Oracle91; Seite 54—Newsletter Apr. 2001; Tips & Techniques.
U.S. Appl. No. 10/126,403, entitled “Caching Stored Procedure Code,” by Rolf Günter Erich Stegelmann and Jeetendra Chaware, filed Apr. 19, 2002.

Affiliated with

Also associated with

Rating

Evaluating expressions in stored procedures does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Evaluating expressions in stored procedures, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Evaluating expressions in stored procedures will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3830613