Andrew W Anderson

US Patent:

20160210326, Jul 21, 2016

Filed:

Sep 21, 2015

Appl. No.:

14/859420

Inventors:

KENNETH TOLMAN - Durham NC, US
KIMBERLY BUCKLER BOTHA - Durham NC, US
PAUL ANTHONY SMILEY - Raleigh NC, US
DAVID R. HENDERSON - Cary NC, US
ANDREW ANDERSON - Raleigh NC, US

Assignee:

SAS INSTITUTE INC. - Cary NC

International Classification:

G06F 17/30

Abstract:

An apparatus includes a renaming component to homogenized query instructions for retrieving data items from a data set organized using index labels by identifying a declaration instruction associating an object thereof with an index label, replacing the name provided to the object the with an archetypal name based on the index label, and generating change data associating the name with the archetypal name; a hashing component to take an instruction hash of the homogenized instructions; a cache control routine to find a matching instruction hash corresponding to results of earlier database queries in a results cache; and a reversal routine to, in response finding a matching instruction hash, retrieve a cached result from the results cache associated with the matching instruction hash, and replace a name of a different object therein based on the change data and the query instructions to generate a new result of the new database query.