Techniques for extending user-defined indexes with auxiliary...

Details Techniques for extending user-defined indexes with auxiliary... Techniques for extending user-defined indexes with auxiliary...

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.

Affiliated with

Also associated with

Rating

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.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2719402