CACHING EXTERNAL DATA SOURCES FOR SQL PROCESSING
First Claim
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.
1 Assignment
0 Petitions
Accused Products
Abstract
Techniques are provided for caching external data sources for SQL processing. According to an embodiment, a database system receives a query that requires foreign data from an external data source. In response to receiving the query, the database system determines whether the foreign data currently resides in a cache of the database system. In response to determining that the foreign does not currently reside in the cache, the database system retrieves the foreign data from the external data source, maps the foreign data to a column granule of a table, and stores the column granule in the cache. In another embodiment, the database system receives a second query that requires the foreign data. In response to determining that the foreign data is cached with the stored column granule, the database system retrieves the column granule from the cache.
-
Citations
22 Claims
-
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 Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. One or more non-transitory computer-readable media storing instructions, which, in response to being executed by one or more processors, cause one or more computing devices to perform operations 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. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20, 21, 22)
-
Specification