公开(公告)号：US09946781B2

公开(公告)日：2018-04-17

申请号：US14728246

申请日：2015-06-02

Applicant: SAP SE

Inventor： Bjoern Mielenhausen

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30595 ,  G06F17/30424 ,  G06F17/30466

Abstract: In some example embodiments, a first alias creation statement is received. The first alias creation statement comprises a first table identifier of a first table, a second table identifier of a second table, a first alias identifier, and a first common table expression, and the first common table expression comprises the first table identifier. A first alias for the second table is generated based on the first alias creation statement, with the first alias comprising the first alias identifier and the first common table expression. The first alias is stored as metadata of the second table. A first query statement is received, with the first query statement comprising the second table identifier and the first alias identifier, and the first query statement is rewritten using the first common table expression based on the first alias identifier to generate a first rewritten query statement.