公开(公告)号：US10095758B2

公开(公告)日：2018-10-09

申请号：US15145559

申请日：2016-05-03

Applicant: SAP SE

Inventor： Daniel Hutzel ,  Timm Falter ,  Stefan Baeuerle

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.

公开(公告)号：US20180018368A1

公开(公告)日：2018-01-18

申请号：US15208736

申请日：2016-07-13

Applicant: SAP SE

Inventor： Stefan Baeuerle ,  Bjoern Mielenhausen ,  Daniel Hutzel ,  Ki Hong Kim ,  Di Wu ,  Long Zhang

IPC: G06F17/30

CPC classification number: G06F16/24544 ,  G06F16/22 ,  G06F16/24535

Abstract: A system, medium, and method to define a database table and view based on a database model using a database language statement, the database language statement including a statement to create the table and a forward-declared JOIN statement that names the table and view, respectively and includes information regarding a relationship between at least two entities of the database.

公开(公告)号：US20180336245A1

公开(公告)日：2018-11-22

申请号：US15596905

申请日：2017-05-16

Applicant: SAP SE

Inventor： Di Wu ,  Ki Hong Kim ,  Stefan Baeuerle ,  Steffen Weinstock ,  Daniel Hutzel ,  Zhi Qiao

IPC: G06F17/30

CPC classification number: G06F16/24535 ,  G06F16/212 ,  G06F16/245 ,  G06F16/24537

Abstract: A method for propagating a structure query language (SQL) association can include determining, based at least on a syntax of a SQL create view statement, that a SQL association requires propagation to a SQL view associated with the SQL create view statement. The SQL association can combine data from at least a first data model and a second data model at a database. The SQL view can comprise at least a portion of the combined data. An association information data structure can be generated for storing information corresponding to a definition of the SQL association. The SQL create view statement can be executed based on the association information data structure. Related systems and articles of manufacture, including computer program products, are also disclose.

公开(公告)号：US20160246858A1

公开(公告)日：2016-08-25

申请号：US15145559

申请日：2016-05-03

Applicant: SAP SE

Inventor： Daniel Hutzel ,  Timm Falter ,  Stefan Baeuerle

IPC: G06F17/30

CPC classification number: G06F17/30554 ,  G06F17/3041 ,  G06F17/30418 ,  G06F17/30501 ,  G06F17/30507 ,  G06F17/30604 ,  G06F17/30979

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.

公开(公告)号：US10558658B2

公开(公告)日：2020-02-11

申请号：US15596905

申请日：2017-05-16

Applicant: SAP SE

Inventor： Di Wu ,  Ki Hong Kim ,  Stefan Baeuerle ,  Steffen Weinstock ,  Daniel Hutzel ,  Zhi Qiao

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/21 ,  G06F16/245

Abstract: A method for propagating a structure query language (SQL) association can include determining, based at least on a syntax of a SQL create view statement, that a SQL association requires propagation to a SQL view associated with the SQL create view statement. The SQL association can combine data from at least a first data model and a second data model at a database. The SQL view can comprise at least a portion of the combined data. An association information data structure can be generated for storing information corresponding to a definition of the SQL association. The SQL create view statement can be executed based on the association information data structure. Related systems and articles of manufacture, including computer program products, are also disclose.

公开(公告)号：US10599650B2

公开(公告)日：2020-03-24

申请号：US15208736

申请日：2016-07-13

Applicant: SAP SE

Inventor： Stefan Baeuerle ,  Bjoern Mielenhausen ,  Daniel Hutzel ,  Ki Hong Kim ,  Di Wu ,  Long Zhang

IPC: G06F7/00 ,  G06F17/30 ,  G06F16/2453 ,  G06F16/22

Abstract: A system, medium, and method to define a database table and view based on a database model using a database language statement, the database language statement including a statement to create the table and a forward-declared JOIN statement that names the table and view, respectively and includes information regarding a relationship between at least two entities of the database.