System and method for pre-compiling a source cursor into a...

Details System and method for pre-compiling a source cursor into a... System and method for pre-compiling a source cursor into a...

2005-05-10

2005-05-10

Robinson, Greta (Department: 2167)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

06892205

ABSTRACT:
A system and method for enabling a second database instance to more quickly process a request to execute a database statement that has previously been executed by a first database instance is described. In one embodiment, the method involves sending the database statement from the first database instance to the second database instance, and generating by the second database instance one or more structures needed to prepare the statement for execution, such as a parse tree and an execution plan for the statement. If at some point in the future, the second database instance receives a request to execute the same statement, the above structures can be used for execution, thereby eliminating the need for one or more potentially time-consuming operations, such as generation of a parse tree or execution plan for the statement.

REFERENCES:
patent: 5623666 (1997-04-01), Pike et al.
patent: 5659781 (1997-08-01), Larson
patent: 5706516 (1998-01-01), Chang et al.
patent: 5727206 (1998-03-01), Fish et al.
patent: 5802523 (1998-09-01), Jasuja et al.
patent: 5828876 (1998-10-01), Fish et al.
patent: 5872981 (1999-02-01), Waddington et al.
patent: 5890153 (1999-03-01), Fukuda et al.
patent: 6108654 (2000-08-01), Chan et al.
patent: 6401120 (2002-06-01), Gamache et al.
patent: 6490610 (2002-12-01), Rizvi et al.
patent: 6625602 (2003-09-01), Meredith et al.
patent: 6772255 (2004-08-01), Daynes
patent: 6799173 (2004-09-01), Czajkowski et al.
Gray J et al., “Transaction Processing: Concepts and Techniques,” 1993, pp. 128-138, Morgan Kaufman, San Francisco, CA.

Affiliated with

Also associated with

Rating

System and method for pre-compiling a source cursor into a... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for pre-compiling a source cursor into a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for pre-compiling a source cursor into a... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3457933