Patent · US Active

Caching views on historical data

US10185744B2 · kind B2 · utility

5Cited by

0References

12Claims

0Family size

Assignee

SAP SE · DE

Inventors

Christian Bensberg · Heidelberg, DE
Norman May · Karlsruhe, DE
Sung Heun Wi · Opo-eup, KR
Sang Il Song · Kirkland, US
Christian Kraus · Aystetten, DE

Key dates

Filing date	Jun 23, 2015
Grant date	Jan 22, 2019
Priority date	—
Expiry date	Apr 30, 2037

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/24552
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

In a general aspect, a computer-implemented method for executing a query on a table of a database, where the table has multiple partitions, can include receiving a query requesting a view on the table. The view on the table can be based on data included in a partition of the multiple partitions of the table. The method can also include determining a cached result to the query is not available in the database and generating a result to the query from, at least, the data of the partition of the multiple partitions. After the generating, the method can include building a cache including the result to the query, associating a transaction identifier for the query with the result to the query result in the cache; and returning the result to the query.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.