Adaptive caching for high volume extract transform load process

Details Adaptive caching for high volume extract transform load process Adaptive caching for high volume extract transform load process

2011-08-16

2011-08-16

Nguyen, Hiep (Department: 2187)

Electrical computers and digital processing systems: memory

Storage accessing and control

Hierarchical memories

Reexamination Certificate

active

08001332

ABSTRACT:
A method, system, and medium related to a mechanism to cache key-value pairs of a lookup process during an extract transform load process of a manufacturing execution system. The method includes preloading a cache with a subset of a set of key-value pairs stored in source data; receiving a request of a key-value pair; determining whether the requested key-value pair is in the preloaded cache; retrieving the requested key-value pair from the preloaded cache if the requested key-value pair is in the preloaded cache; queuing the requested key-value pair in an internal data structure if the requested key-value pair is not in the preloaded cache until a threshold number of accumulated requested key-value pairs are queued in the internal data structure; and executing a query of the source data for all of the accumulated requested key-value pairs.

REFERENCES:
patent: 6490652 (2002-12-01), Van Hook et al.
patent: 6564300 (2003-05-01), Chang
patent: 6895471 (2005-05-01), Tse et al.
patent: 7644234 (2010-01-01), Sasaki et al.
Barian Jarrett, “Perl ETL: Surrogate Key Lookup Caching”, Sep. 17, 2007, XP-002536189, [download Sep. 7, 2009], download from Internet URL: http://www.brianjarrett.com/2007/09/17/perl-etl-surrogate-key-look ..., 3pgs.

Affiliated with

Also associated with

Rating

Adaptive caching for high volume extract transform load process does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Adaptive caching for high volume extract transform load process, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Adaptive caching for high volume extract transform load process will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2710734