System and method for providing highly available database...

Details System and method for providing highly available database... System and method for providing highly available database...

2011-07-19

2011-07-19

Le, Miranda (Department: 2159)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S759000, C707S769000

Reexamination Certificate

active

07984042

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: 4827423 (1989-05-01), Beasley et al.
patent: 5138712 (1992-08-01), Corbin
patent: 5202971 (1993-04-01), Henson et al.
patent: 5230050 (1993-07-01), Iitsuka et al.
patent: 5265065 (1993-11-01), Turtle
patent: 5305448 (1994-04-01), Insalaco et al.
patent: 5459862 (1995-10-01), Garliepp et al.
patent: 5560005 (1996-09-01), Hoover et al.
patent: 5623666 (1997-04-01), Pike et al.
patent: 5659781 (1997-08-01), Larson
patent: 5692178 (1997-11-01), Shaughnessy
patent: 5706516 (1998-01-01), Chang et al.
patent: 5727206 (1998-03-01), Fish et al.
patent: 5778354 (1998-07-01), Leslie et al.
patent: 5802523 (1998-09-01), Jasuja et al.
patent: 5822531 (1998-10-01), Gorczyca et al.
patent: 5828876 (1998-10-01), Fish et al.
patent: 5832521 (1998-11-01), Klots et al.
patent: 5864843 (1999-01-01), Carino et al.
patent: 5872981 (1999-02-01), Waddington et al.
patent: 5890153 (1999-03-01), Fukuda et al.
patent: 5920872 (1999-07-01), Grewell et al.
patent: 5956705 (1999-09-01), Stevens et al.
patent: 6105026 (2000-08-01), Kruglikov et al.
patent: 6108654 (2000-08-01), Chan et al.
patent: 6115703 (2000-09-01), Bireley et al.
patent: 6148299 (2000-11-01), Yoshimoto
patent: 6185601 (2001-02-01), Wolff
patent: 6219662 (2001-04-01), Fuh et al.
patent: 6223187 (2001-04-01), Boothby et al.
patent: 6253196 (2001-06-01), Fuh et al.
patent: 6314563 (2001-11-01), Agesen et al.
patent: 6347374 (2002-02-01), Drake et al.
patent: 6370529 (2002-04-01), Kruglikov et al.
patent: 6374238 (2002-04-01), Iwata et al.
patent: 6378126 (2002-04-01), Tang
patent: 6401120 (2002-06-01), Gamache et al.
patent: 6405252 (2002-06-01), Gupta et al.
patent: 6418441 (2002-07-01), Call
patent: 6418542 (2002-07-01), Yeager
patent: 6430698 (2002-08-01), Khalil et al.
patent: 6449627 (2002-09-01), Baer et al.
patent: 6463457 (2002-10-01), Armentrout et al.
patent: 6466574 (2002-10-01), Fujisaki et al.
patent: 6480854 (2002-11-01), Gross et al.
patent: 6490610 (2002-12-01), Rizvi et al.
patent: 6549957 (2003-04-01), Hanson et al.
patent: 6560216 (2003-05-01), McNiff et al.
patent: 6598058 (2003-07-01), Bird et al.
patent: 6625602 (2003-09-01), Meredith et al.
patent: 6708195 (2004-03-01), Borman et al.
patent: 6718486 (2004-04-01), Roselli et al.
patent: 6738362 (2004-05-01), Xu et al.
patent: 6772255 (2004-08-01), Daynes
patent: 6799173 (2004-09-01), Czajkowski et al.
patent: 6804711 (2004-10-01), Dugan et al.
patent: 6807540 (2004-10-01), Huras et al.
patent: 6892205 (2005-05-01), Colrain et al.
patent: 7007034 (2006-02-01), Hartman et al.
patent: 7359925 (2008-04-01), Sugiyama
patent: 2002/0083084 (2002-06-01), Sugiyama
patent: 2002/0091718 (2002-07-01), Bohannon et al.
patent: 2002/0107957 (2002-08-01), Zargham et al.
patent: 2003/0033317 (2003-02-01), Ziglin
patent: 2004/0205414 (2004-10-01), Roselli et al.
U.S. Appl. No. 10/087,494, filed Feb. 28, 2002.
U.S. Appl. No. 10/086,949, filed Feb. 28, 2002.
U.S. Appl. No. 10/086,782, filed Feb. 28, 2002.
Mahapatra, T. et al., “Oracle Parallel Processing” Aug. 2000, O'Reilly, pp. 1-7.
“Notice of Allowance” in related case U.S. Appl. No. 10/086,782, filed Feb. 28, 2002, 7 pages.
“Sun Cluster 2.2 Software Installation Guide,” Sun Microsystems, Part No. 809-5342, Jul. 2000, Revision A.
“Compact ProLiant Clusters HA/F100 and HA/F200 Administrator Guide,” Compaq Computer Corporation, Part No. 380362-002, Second Edition (Sep. 1999).

Affiliated with

Also associated with

Rating

System and method for providing highly available database... 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 providing highly available database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for providing highly available database... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2719653