SQL extended with transient fields for calculation expressions in enhanced data models

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

• providing an in-memory database comprising data of a first type;
• causing an in-memory database engine to receive from a query engine implemented within the in-memory database, a query in a database language defining a transient field by an identifier prepended with a modifier, wherein the database language is extended to include an entity of an entity-relationship model, and the transient field is defined by the entity;
• causing the in-memory database engine to communicate with the in-memory database to generate a query result from the query, wherein the in-memory database engine fills in a value for the transient field derived at least in part from the data of the second type materialized in a persistent field in the in-memory database and comprising a constant or a floating value, wherein the value for the transient field is only persistently materialized based upon a hint comprising a directive in a declaration of the transient field in the entity relationship model;
• and
• causing the in-memory database engine to communicate the query result to the query engine for display to a user.

A computer system comprising:

• one or more processors;
• a software program, executable on said computer system, the software program configured to:
• provide an in-memory database comprising data of a first type;
• cause an in-memory database engine to receive from a query engine implemented within the in-memory database, a query in a database language defining a transient field, wherein the database language is extended to include an entity of an entity-relationship model, and the transient field is defined by the entity;
• cause the in-memory database engine to communicate with the in-memory 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 materialized in a persistent field in the in-memory database and comprising a constant or a floating value, wherein the value for the transient field is only persistently materialized based upon a hint comprising a directive in a declaration of the transient field in the entity-relationship model;
• and
• cause the in-memory database engine to communicate the query result to the query engine for display to a user.