Entity-relationship model extensions using annotations

• US 9,430,523 B2
• Filed: 09/06/2013
• Issued: 08/30/2016
• Est. Priority Date: 09/06/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Falter, Timm, Hutzel, Daniel, Baeuerle, Stefan
• Primary Examiner(s): Kerzhner, Aleksandr
• Assistant Examiner(s): Cheung, Eddy
• Application Number:
  US14/020,664
• Publication Number:
  US 20150074081A1
• Time in Patent Office: 1,089 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2433 Query languages
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/288 Entity relationship models

Abstract

Embodiments extend the relational model and language of standard SQL, to recognize features of higher level entity-relationship models (ERMs). Annotation language is implemented in the data design language (DDL) to incorporate tables and entities Using DDL, annotations are typed structures of metadata. Annotations may be used for types, entities and elements. In the query language (QL), annotations may be added to the standard QL. A reflection program may use the metadata of the annotation language for reflection on the tables or entities.

Claims

1. A computer-implemented method comprising:

providing Structured Query Language (SQL) extensions for a relational model of a database described by SQL for use in coding database queries to recognize features of an entity-relationship model (ERM) for an application that stores data in the database,

wherein the SQL extensions include typed data structures for defining entities of the application, associations defining relationships between the entities of the application, and for defining annotations for data models of the application,

wherein the annotations enable defining additional metadata that extends data definitions of an existing data model of the application without requiring developing a new data model or redundant type structures for the application;

in a database query engine configured to query the database;

receiving a database query communicated to the database query engine, wherein the database query is coded in SQL with the SQL extensions;

translating the database query in the database query engine to query the database; and

receiving a query result from the database, wherein the existing data model of the application and the additional metadata defined by the extensions of SQL are processed together at runtime in the database query engine.

2. The computer-implemented method of claim 1 wherein native support for the ERM is added into the database query engine to enable processing of the SQL extensions.

3. The computer-implemented method of claim 1 wherein the annotations are added to a pre-defined view of the ERM.

4. The computer-implemented method of claim 1 wherein the annotations include metadata on types, entities and elements in data model definitions of the ERM.

13. The computer-implemented method of claim 1 wherein the typed structures include custom-defined types.

14. The computer-implemented method of claim 1 wherein annotating an entity, object, or element in the data model comprises generating an instance of the annotation type and assigning the instance to the entity, object, or element.

15. The computer-implemented method of claim 1 wherein code of the application that receives data from the database is operable to recover type information for elements of the data model of the application based on the SQL extensions.

5. A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:

providing Structured Query Language (SQL) extensions of for a relational model of a database described by SQL for use in coding database queries to recognize features of an entity-relationship model (ERM) for an application that stores data in the database,

wherein the SQL extensions include typed data structures for defining entities of the application, associations defining relationships between the entities of the application, and for defining annotations for data models of the application,

wherein the annotations enable defining additional metadata that extends data definitions of an existing data model of the application without requiring developing a new data model or redundant type structures for the application;

in a database query engine configured to query the database;

receiving a database query communicated to the database query engine, wherein the database query is coded in SQL with the SQL extensions;

translating the database query in the database query engine to query the database; and

receiving a query result from the database, wherein the existing data model of the application and the additional metadata defined by the extensions of SQL are processed together at runtime in the database query engine.

6. A non-transitory computer readable storage medium as in claim 5 wherein native support for the ERM is added into the database query engine to enable processing of the SQL extensions.

7. A non-transitory computer readable storage medium as in claim 5 wherein the annotations are added to a pre-defined view of the ERM.

8. A non-transitory computer readable storage medium as in claim 5 wherein the annotations include metadata on types, entities and elements in data model definitions of the ERM.

9. A system comprising:

a database organized according to a relational model described by a Structured Query Language (SQL);

a database query engine in communication with the database, the database query engine comprising at least one processor and a memory configured to store computer programs, which when executed by the processor, cause the processor to;

provide SQL extensions for the relational model of the database described by SQL for use in coding database queries to recognize features of an entity-relationship model (ERM) for an application that stores data in the database,

wherein the SQL extensions include typed data structures for defining entities of the application, associations defining relationships between the entities of the application, and for defining annotations for data models of the application,

wherein the annotations enable defining additional metadata that extends data definitions of an existing data model of the application without requiring developing a new data model or redundant type structures for the application;

in a database query engine configured to query the database;

receive a database query communicated to the database query engine, wherein the database query is coded in SQL with the SQL extensions;

translate the database query in the database query engine to query the database; and

receive a query result from the database, wherein the existing data model of the application and the additional metadata defined by the extensions of SQL are processed together at runtime in the database query engine.

10. A system as in claim 9 wherein native support for the ERM is added into the database query engine to enable processing of the SQL extensions.

11. A system as in claim 9 wherein the annotations are added to a pre-defined view of the ERM.

12. A system as in claim 9 wherein the annotations include metadata on types, entities and elements in data model definitions of the ERM.