Executing a large object fetch query against a database

Details Executing a large object fetch query against a database Executing a large object fetch query against a database

G - Physics

06

F

G06F 17/30 (2006.01) G06F 7/00 (2006.01)

Patent

CA 2419982

A database server helps to streamline retrieval of lob values by making the decision of sending a locator in replacement of the lob value, or the lob value itself, depending upon the specific lob value being retrieved. A threshold value is determined in a fetch query, and lob sizes below that threshold are sent as values in a corresponding fetch response, and lengths above are sent as locators in the fetch response. Indicators are inserted in a fetch parameter of the response to inform the receiving client about which form of retrieval was used for each requested lob value being returned. The use of the indicators provides for sending lob values to the client when the lob value is considered small, and sending the locator when the lob values are considered large in comparison to the threshold value. Therefore, the use of distinct indicators in the parameter of the response provides for the server system making a dynamic decision of sending either the LOB locator or an inline LOB value in the response, depending upon the specific value of the LOB in comparison to the threshold value. For example, the LOB values below the threshold are sent as values in columns or fetch answers of the response, while the LOB values above the threshold are sent as locators in place of the LOB values. The fetch parameter uses the distinct indicator values to help inform the client of the form of retrieval present in the response as a result of the query.

Affiliated with

Also associated with

Rating

Executing a large object fetch query against a 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 Executing a large object fetch query against a database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Executing a large object fetch query against a database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1455451