公开(公告)号：US10691688B2

公开(公告)日：2020-06-23

申请号：US15186300

申请日：2016-06-17

Applicant: SAP SE

Inventor： Anisoara Nica ,  Peter Bumbulis ,  Reza Sherkat ,  Mihnea Andrei ,  Anil K. Goel

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/22

Abstract: Cracking page-loadable columns for in-memory data management is described herein. An embodiment operates by accessing a column according to a received query, determining that the received query requires a non-critical data structure associated with the column, and rebuilding the non-critical data structure from data associated with the column.

公开(公告)号：US20180329974A1

公开(公告)日：2018-11-15

申请号：US15796365

申请日：2017-10-27

Applicant: SAP SE

Inventor： Christian Bensberg ,  Alexander Boehm ,  Adrian Dragusanu ,  Xun Cheng ,  Reza Sherkat ,  Anisoara Nica ,  Mihnea Andrei

IPC: G06F17/30

CPC classification number: G06F17/30303

Abstract: Disclosed herein are system, method, and computer program product embodiments for determining a constraint data statistics object is consistent. An embodiment operates by receiving a query for a database table. The embodiment determines a constraint data statistic object associated with a partition of the database table. The embodiment determines the constraint data statistics object is consistent with a data state of the partition of the database table based on consistency metadata of the constraint data statistics object. The embodiment processes the query for the database table based on the determining the constraint data statistics object is consistent with the data state of the partition of the database table.

公开(公告)号：US20180329973A1

公开(公告)日：2018-11-15

申请号：US15796288

申请日：2017-10-27

Applicant: SAP SE

Inventor： Reza Sherkat ,  Anisoara Nica ,  Xun Cheng ,  Prabhas Kumar Samanta ,  Mihnea Andrei

IPC: G06F17/30

CPC classification number: G06F17/30584 ,  G06F17/30292 ,  G06F17/30306 ,  G06F17/30339 ,  G06F17/30371 ,  G06F17/30469 ,  G06F17/30536

Abstract: Disclosed herein are system, method, and computer program product embodiments for performing dynamic partition pruning using data statistic objects as data integrity constraints. An embodiment operates by partitioning a database table into a plurality of partitions based on a partition criterion. The embodiment creates a data statistics object for a partition in the plurality of partitions. The embodiment receives a query for the database table. The embodiment determines the data statistics object is consistent with data in the partition. The embodiment processes the query for the partition based on the data statistics object.

公开(公告)号：US20180329941A1

公开(公告)日：2018-11-15

申请号：US15796326

申请日：2017-10-27

Applicant: SAP SE

Inventor： Anisoara NICA ,  Reza Sherkat ,  Mihnea Andrei

IPC: G06F17/30

CPC classification number: G06F17/30584 ,  G06F17/30292 ,  G06F17/30306 ,  G06F17/30339 ,  G06F17/30371 ,  G06F17/30469 ,  G06F17/30536

Abstract: Disclosed herein are system, method, and computer program product embodiments for using a data statistic as a dynamic data integrity constraint. An embodiment operates by defining a data statistic for a column or a set of columns of a partition of a plurality of partitions of a database table. The embodiment creates a constraint data statistics object based on the data statistic. The embodiment receives a query for the database table. The embodiment determines the constraint data statistics object is consistent with a data state of the partition. The embodiment derives an implied constraint based on the constraint data statistics object. The embodiment processes the query for the partition based on the implied constraint.

公开(公告)号：US20170322960A1

公开(公告)日：2017-11-09

申请号：US15150301

申请日：2016-05-09

Applicant: SAP SE

Inventor： Thorsten Glebe ,  Martin Heidel ,  Michael Muehle ,  Felix Knittel ,  Reza Sherkat

IPC: G06F17/30 ,  G06F3/06

CPC classification number: G06F16/2228 ,  G06F3/0608 ,  G06F3/064 ,  G06F3/0674 ,  G06F16/2219

Abstract: A method, computer program product and system are provided. The method, computer program product and system execute a process for storing an object in an object container that is stored in a persistency of a disk storage. The object container has size criteria whereby objects meeting the size criteria of the object container can be assigned to the object container. The object container can facilitate storing multiple objects to optimize disk storage usage by facilitating the assigning of multiple objects to the same disk storage page.