发明名称 |
SQL EXTENDED WITH TRANSIENT FIELDS FOR CALCULATION EXPRESSIONS IN ENHANCED DATA MODELS |
摘要 |
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. |
申请公布号 |
US2016246858(A1) |
申请公布日期 |
2016.08.25 |
申请号 |
US201615145559 |
申请日期 |
2016.05.03 |
申请人 |
SAP SE |
发明人 |
Hutzel Daniel;Falter Timm;Baeuerle Stefan |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
1. A computer-implemented method comprising:
providing a database comprising data of a first type; causing a database engine to receive from a query engine, a query in a database language defining a transient field; causing the database engine to communicate with the database to generate a query result from the query, wherein the database engine fills in a value for the transient field derived at least in part from data of a second type not materialized in a persistent field in the database and comprising a constant or a floating value; and causing the database engine to communicate the query result to the query engine for display to a user. |
地址 |
Walldorf DE |