Patent ID: 9679013
Date: 2017-06-13
CPC Classifications: G06F

Claim:
1. A database manager for generating a cached memory space, wherein the cached memory space is a data sharing space (DSS) for a base table having a set of rows with stored data, the database manager configured to: receive a set of requests to generate tables, each request including a query to the base table, wherein the set of requests includes a first query to generate a first table, a second query to generate a second table, and a third query to generate a third table; access a row from the set of rows; apply each query to the row to generate a set of query results, wherein the first table and the second table include a same row from the base table as a query result; determine an index value for the row based on the query results; store, based on the index value, at least a portion of the row in the DSS, wherein the index value is used to map a location of the portion of the row stored in the DSS; store the same row in the DSS; determine that the first query, the second query, and the third query are a common query; and direct, in response to determining that the third query is the common query, the third query to the DSS to retrieve the same row.