Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2011-08-09
2011-08-09
Breene, John (Department: 2162)
Data processing: database and file management or data structures
Database and file access
Query optimization
C707S718000
Reexamination Certificate
active
07996387
ABSTRACT:
In one embodiment, a database server registers one or more functions included in a user-defined index that includes one or more auxiliary properties. The one or more functions are operable to generate index entries of the user-defined index for the one or more auxiliary properties. The one or more auxiliary properties are different than, and in addition to, a primary property of the user-defined index that provides for evaluating a query operator. The database server receives a first statement that defines the user-defined index, where the first statement includes one or more parameters that define the one or more auxiliary properties. The database server invokes the one or more functions in response to the first statement, where the one or more functions when invoked generate and store the index entries of the user-defined index according to the one or more parameters that define the one or more auxiliary properties.
REFERENCES:
patent: 5893104 (1999-04-01), Srinivasan et al.
patent: 6338056 (2002-01-01), Dessioch et al.
patent: 6370522 (2002-04-01), Agarwal et al.
patent: 2006/0167850 (2006-07-01), Fish et al.
patent: 2008/0059440 (2008-03-01), Barsness et al.
U.S. Appl. No. 12/027,918, filed Feb. 7, 2008, Notice of Allowance, Dec. 9, 2010.
Benoit Dageville et al., “Automatic SQL Tuning in Oracle 10g”, Proceeding of the 30thVLDB Conference, Toronto, Canada, 2004, pp. 1098-1109.
Das Dinesh
Hu Ying
Krishnamurthy Sriram
Lin Wesley
Sundara Seema
Breene John
Hickman Palermo & Truong & Becker LLP
Myint Dennis
Oracle International Corporation
LandOfFree
Techniques for extending user-defined indexes with auxiliary... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Techniques for extending user-defined indexes with auxiliary..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Techniques for extending user-defined indexes with auxiliary... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2719402