Generating and accessing a data table

Patent metadata

Field	Value
Publication number	US-9679014-B2
Application number	US-201414467312-A
Country	US
Kind code	B2
Filing date	Aug 25, 2014
Priority date	Jun 12, 2014
Publication date	Jun 13, 2017
Grant date	Jun 13, 2017

Abstract

A data sharing space (DSS) is generated for a base table having a set of rows with stored data. Requests are received to generate tables, each request including a query to the base table. A row from the set of rows is then accessed. The query is then applied to the row to generate results. An index value is then determined and a portion of the row is stored in the DSS based on the index value.

First claim

What is claimed is:

1. A method 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 method comprising:
receiving 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;
accessing a row from the set of rows;
applying 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;
determining an index value for the row based on the query results;
storing, 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;
storing the same row in the DSS;
determining that the first query, the second query, and the third query are a common query; and
directing, in response to determining that the third query is the common query, the third query to the DSS to retrieve the same row.

2. The method of claim 1 , further comprising:
indicating the tables that include the row using the index value.

3. The method of claim 2 , further comprising:
generating an individual binary bit value using each query result from the set of query results; and
indicating a table from the tables, corresponding to the individual binary bit, includes the row.

4. The method of claim 1 , wherein receiving a set of requests to generate tables includes requests to update the tables.

5. The method of claim 1 , further comprising:
checking a table from the tables for a share parameter in response to accessing the row.

6. The method of claim 5 , further comprising:
determining the at least a portion of the row is stored in the DSS using the share parameter.

7. The method of claim 5 , further comprising:
determining the table is to be updated using the share parameter.

Assignees

• IBM

Inventors

• Konik Rafal P
• Mittelstadt Roger A
• Muras Brian R
• Theuer Mark W

Classifications

• G06F16/24552 Primary

  Database cache management · CPC title

• G06F16/221

  Column-oriented storage; Management thereof · CPC title

• G06F16/24539

  using cached or materialised query results · CPC title

• G06F16/2237

  Vectors, bitmaps or matrices · CPC title

• G06F17/30315

  Physics · mapped topic