Invention Grant
- Patent Title: SQL extended with transient fields for calculation expressions in enhanced data models
-
Application No.: US15145559Application Date: 2016-05-03
-
Publication No.: US10095758B2Publication Date: 2018-10-09
- Inventor: Daniel Hutzel , Timm Falter , Stefan Baeuerle
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fountainhead Law Group P.C.
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F7/00

Abstract:
A database language (e.g. SQL) is extended to define a transient field whose value is derived from data stored in a database. The value of the transient field is calculated by the database engine for consumption as needed by the application layer, for example as part of a particular data model. The value of the transient field may not be materialized as a persistent field in the underlying database table, or may be selectively materialized based upon a heuristic or hint. Certain embodiments may implement the transient field as a basic elaboration on standard SQL utilizing an identifier. Some embodiments may implement the transient field as an entity where SQL has been extended to accommodate concepts of a higher-level Entity Relationship Model (ERM). The use of constants and/or floating values (e.g. a current time) in connection with transient fields, is also disclosed.
Public/Granted literature
- US20160246858A1 SQL EXTENDED WITH TRANSIENT FIELDS FOR CALCULATION EXPRESSIONS IN ENHANCED DATA MODELS Public/Granted day:2016-08-25
Information query