×

CACHING EXTERNAL DATA SOURCES FOR SQL PROCESSING

  • US 20140317084A1
  • Filed: 04/19/2013
  • Published: 10/23/2014
  • Est. Priority Date: 04/19/2013
  • Status: Active Grant
First Claim
Patent Images

1. A method for optimizing query processing, the method comprising:

  • receiving, at a database system, a query that requires foreign data from an external data source;

    in response to receiving the query, determining whether the foreign data currently resides in a cache of the database system;

    in response to determining that the foreign data does not currently reside in the cache;

    retrieving the foreign data from the external data source;

    mapping the foreign data to a column granule of a table; and

    storing the column granule in the cache;

    wherein the method is performed by one or more computing devices.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×