公开(公告)号：US20180253473A1

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

申请号：US15601815

申请日：2017-05-22

Applicant: SAP SE

Inventor： Torsten Ziegler ,  Christian Hansen ,  Frank-Martin Haas ,  Stefan Baeuerle ,  Mihnea Andrei ,  Alexander Boehm

IPC: G06F17/30

CPC classification number: G06F16/24537 ,  G06F16/24564

Abstract: The present disclosure involves systems, software, and computer implemented methods for using declarative rules for optimized access to data. One example method includes receiving a structured query language (SQL) query, the SQL query associated with at least one database table and at least one predicate. A determination is made as to whether the SQL query is associated with at least one declarative rule based on the at least one database table and the at least one predicate. In response to determining that the SQL query is associated with at least one declarative rule, the at least one associated declarative rule is applied, during optimization of the SQL query. The at least one declarative rule defines a transformation to the SQL query to be performed during query optimization. An updated SQL query is generated based on the applied at least one associated declarative rule and the updated SQL query is provided.

公开(公告)号：US10592509B2

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

申请号：US15601815

申请日：2017-05-22

Applicant: SAP SE

Inventor： Torsten Ziegler ,  Christian Hansen ,  Frank-Martin Haas ,  Stefan Baeuerle ,  Mihnea Andrei ,  Alexander Boehm

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/2455

Abstract: The present disclosure involves systems, software, and computer implemented methods for using declarative rules for optimized access to data. One example method includes receiving a structured query language (SQL) query, the SQL query associated with at least one database table and at least one predicate. A determination is made as to whether the SQL query is associated with at least one declarative rule based on the at least one database table and the at least one predicate. In response to determining that the SQL query is associated with at least one declarative rule, the at least one associated declarative rule is applied, during optimization of the SQL query. The at least one declarative rule defines a transformation to the SQL query to be performed during query optimization. An updated SQL query is generated based on the applied at least one associated declarative rule and the updated SQL query is provided.