Invention Application
- Patent Title: Constraint Data Statistics
-
Application No.: US15796326Application Date: 2017-10-27
-
Publication No.: US20180329941A1Publication Date: 2018-11-15
- Inventor: Anisoara NICA , Reza Sherkat , Mihnea Andrei
- Applicant: SAP SE
- Main IPC: G06F17/30
- IPC: G06F17/30

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
- US11468035B2 Constraint data statistics Public/Granted day:2022-10-11
Information query