Partial query caching

Details Partial query caching Partial query caching

G - Physics

06

F

G06F 17/30 (2006.01)

Patent

CA 2562281

When a query is performed an execution plan is formed, which is made up of a plurality of plan operators. Before executing any given plan operator, a storage area is checked. If a results set has been stored corresponding to the plan operator, then the cached results set is used instead of the executing the plan operator. If no results set exists that corresponds to the particular plan operator, the plan operator is executed, and the results set that is output may be stored for use by another plan operator of another execution plan.

Lorsqu'une requEte est effectuEe, un plan d'exEcution est formé, constitué d'une multitude d'opErateurs de plan. Avant l'exEcution de tout opErateur de plan, une zone de stockage est vErifiEe. Si un ensemble de rEsultats correspondant A l'opErateur de plan a été stocké, alors l'ensemble des rEsultats mis en antEmEmoire est utilisE au lieu d'exEcuter l'opErateur de plan. Si aucun ensemble de rEsultats correspondant A l'opErateur de plan en particulier n'existe, l'opErateur de plan est exEcutE, et l'ensemble des rEsultats sorti peut Etre stockE afin d'Etre utilisE par un autre opErateur de plan d'un autre plan d'exEcution.

Affiliated with

Also associated with

Rating

Partial query caching does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Partial query caching, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Partial query caching will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1667137