Invention Grant
- Patent Title: Constraint satisfaction software tool for database tables
-
Application No.: US15940372Application Date: 2018-03-29
-
Publication No.: US10817504B2Publication Date: 2020-10-27
- Inventor: Conrad Drescher , Mirko Rahn
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Klarquist Sparkman, LLP
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/22 ; G06F16/2455

Abstract:
Techniques and solutions are provided for analyzing constraints. A disclosed embodiment provides for determining whether a table contains a valid tuple, and if so, the minimum index of the first valid tuple. Determining whether the table contains a valid tuple can provide an early indication of whether a set of constraints is violated or entailed, for positive and negative constraints, respectively. Determining the minimum index of the first valid tuple can expedite subsequent constraint analysis. Further disclosed embodiments provide for removal of duplicate and wildcard values from a set of constraints, which can facilitate negative constraint analysis. An indication can be provided, such as through a user interface, of whether a set of constraints is violated or entailed. Software can restrict selection of values that may result in constraint violation based on the provided indication.
Public/Granted literature
- US20190303472A1 CONSTRAINT SATISFACTION SOFTWARE TOOL FOR DATABASE TABLES Public/Granted day:2019-10-03
Information query