Advanced data models containing declarative and programmatic constraints

• US 9,176,801 B2
• Filed: 09/06/2013
• Issued: 11/03/2015
• Est. Priority Date: 09/06/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Baeuerle, Stefan, Falter, Timm, Hutzel, Daniel, Schejter, Lior, Zoch, Daniel, Bader, Andreas
• Primary Examiner(s): MOSER, BRUCE M
• Application Number:
  US14/020,672
• Publication Number:
  US 20150074069A1
• Time in Patent Office: 788 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/0751 Error or fault detection not based on redundancy power supply failures G06F1/30; network fault management H04L41/06
• CPC Class Codes: G06F 16/212 with details for data modelling support
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/24565 Triggers; Constraints
• CPC Class Codes: G06F 8/35 model driven
• CPC Class Codes: G06F 8/41 Compilation

Abstract

A database language is extended to define constraints on a data model (e.g., entity-relationship model) rather than the concrete database. The constraints can be declarative (e.g., constraints that are defined using expressions of the database language) or programmatic (e.g., constraints that are defined as a stored procedure implemented in a domain specific language). By storing the constraints at a higher level than the database level, the constraints can be performed without changing the persistency of the database. Also disclosed are techniques for handling of constraints on partially loaded entities.

Claims

1. A computer-implemented method comprising:

defining, by a computer, a constraint on an object of a data model, the data model being configured to define the object as a logical grouping of elements from an underlying database and the constraint being configured to execute a routine to validate an element of the object when a triggering event associated with the object is detected;

compiling, by the computer, the constraint into a runtime artifact associated with the object;

querying, by the computer, the underlying database to form a projection of the object that includes a subset of the logical grouping of elements; and

executing, by the computer, the runtime artifact when the triggering event is detected on the projection.

2. The computer-implemented method of claim 1, wherein the data model is specified in a domain specific language and the routine is expressed using expressions from the domain specific language.

3. The computer-implemented method of claim 1, wherein the triggering event is explicitly calling the constraint.

4. The computer-implemented method of claim 1, wherein the triggering event is one of saving, modifying, and deleting the object.

5. The computer-implemented method as in claim 1, wherein the triggering event does not change the persistency of the underlying database.

6. The computer-implemented method of claim 1, wherein the triggering event is a change to the underlying database.

7. The computer-implemented method of claim 1, wherein validating the element includes checking a dependency between the element and another element.

8. The computer-implemented method of claim 7, wherein the another element belongs to another object of the data model.

9. The computer-implemented method of claim 1, wherein the routine is configured to output an error or warning according to a setting on the constraint.

10. The computer-implemented method of claim 1, wherein executing the runtime artifact comprises:

determining that the element of the object to be validated by the constraint is missing from the projection of the object;

loading the element into the projection; and

performing the routine on the projection.

11. The computer-implemented method of claim 1, wherein executing the runtime artifact comprises:

determining that the element of the object to be validated by the constraint is missing from the projection of the object;

loading the object into the projection; and

performing the routine on the projection.

12. A non-transitory computer readable storage medium storing one or more programs, the one or more programs comprising instructions for:

defining a constraint on an object of a data model specified in a domain specific language, the data model being configured to define the object as a logical grouping of elements from an underlying database and the constraint being configured to execute a routine to validate an element of the object without changing the persistency of the underlying database when a triggering event associated with the object is detected, the routine being expressed using expressions from the domain specific language;

compiling the constraint into a runtime artifact associated with the object;

querying the underlying database to form a projection of the object that includes a subset of the logical grouping of elements; and

executing the runtime artifact when the triggering event is detected on the projection.

13. The non-transitory computer readable storage medium of claim 12, wherein the triggering event is explicitly calling the constraint.

14. The non-transitory computer readable storage medium of claim 12, wherein the triggering event is one of saving, modifying, and deleting the object.

15. The non-transitory computer readable storage medium of claim 12, wherein validating the element includes checking a dependency between the element and another element.

16. The non-transitory computer readable storage medium of claim 15, wherein the another element belongs to another object of the data model.

17. The non-transitory computer readable storage medium of claim 12, wherein performing the runtime artifact comprises:

determining that the element of the object to be validated by the constraint is missing from the projection of the object;

loading the element into the projection; and

performing the routine on the projection.

18. The non-transitory computer readable storage medium of claim 12, wherein executing the runtime artifact comprises:

determining that the element of the object to be validated by the constraint is missing from the projection of the object;

loading the object into the projection; and

performing the routine on the projection.

19. A computer system comprising:

a processor; and

a non-transitory computer readable medium having stored thereon one or more programs, which when executed by the processor, causes the processor to;

define, by a computer, a constraint on an object of a data model, the data model being configured to define the object as a logical grouping of elements from an underlying database and the constraint being configured to execute a routine to validate an element of the object when a triggering event associated with the object is detected;

compile, by the computer, the constraint into a runtime artifact associated with the object;

query, by the computer, the underlying database to form a projection of the object that includes a subset of the logical grouping of elements; and

execute, by the computer, the runtime artifact when the triggering event is detected on the projection.

20. The computer system of claim 19, wherein the data model is specified in a domain specific language and the routine is expressed using expressions from the domain specific language.