Sap Se

Sap Ag

Christian Hansen

Mihnea Andrei

Stefan A Baeuerle

Alexander Boehm

Kerstin Hoeft

Torsten Ziegler

Frank-Martin Haas

Dirk Debertin

Tobias Wenner

Thomas Raupp

Ulrich Koch

Matthias Schwarz

Jemin Tanna

Harald Kuck

Cornelia Haase

Jens Otto

Michael Schafft

Hartwig Brand

Carsten Dietze-Selent

Peter Goebbels

Uwe Hommel

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.

Declarative rules for optimized access to data

Techniques for optimizing a software application include receiving, at a local computing system, a query from an application for data stored on a database table, the query including a context defined by a name of the database table; comparing the context of the query to a context of a predefined query scenario; based on the context of the query matching the context of the predefined query scenario, retrieving data stored on a secondary database replicated from data stored on a main database; and passing the retrieved data from the secondary database to the application.

Optimizing software applications

Growing community of inventors

Heidelberg, Germany

Christian Hansen