Invention Application
- Patent Title: Constraint Data Statistics
-
Application No.: US17711608Application Date: 2022-04-01
-
Publication No.: US20220222244A1Publication Date: 2022-07-14
- Inventor: Anisoara Nica , Reza Sherkat , Mihnea Andrei
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/21 ; G06F16/27 ; G06F16/22 ; G06F16/2458 ; G06F16/2453

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.
Public/Granted literature
- US11734258B2 Constraint data statistics Public/Granted day:2023-08-22
Information query