公开(公告)号：US10185744B2

公开(公告)日：2019-01-22

申请号：US14747767

申请日：2015-06-23

Applicant: SAP SE

Inventor： Christian Bensberg ,  Norman May ,  Sung Heun Wi ,  Sang Il Song ,  Christian Kraus

IPC: G06F17/30

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.

公开(公告)号：US20160378826A1

公开(公告)日：2016-12-29

申请号：US14747767

申请日：2015-06-23

Applicant: SAP SE

Inventor： Christian Bensberg ,  Norman May ,  Sung Heun Wi ,  Sang Il Song ,  Christian Kraus

IPC: G06F17/30

CPC classification number: G06F17/30457 ,  G06F17/3048

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.

Abstract translation: 在一般方面，用于在表上具有多个分区的数据库的表上执行查询的计算机实现的方法可以包括接收请求表上的视图的查询。 表上的视图可以基于表中多个分区的分区中包含的数据。 该方法还可以包括确定查询的缓存结果在数据库中不可用，并且至少从多个分区的分区的数据生成查询的结果。 在生成之后，该方法可以包括将包括结果的高速缓存构建到查询，将查询的事务标识符与结果相关联到高速缓存中的查询结果; 并将结果返回到查询。