Declarative rules for optimized access to data

US10592509B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Torsten Ziegler · Dielheim, DE
• Christian Hansen · Hattingen, DE
• Frank-Martin Haas · Wiesloch, DE
• Stefan Baeuerle · Walldorf, DE
• Mihnea Andrei · Issy-les-Moulineaux, FR
• Alexander Boehm · Sandhausen, DE

Key dates

• Filing date: May 22, 2017
• Grant date: Mar 17, 2020
• Expiry date: Jan 16, 2038

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/24564
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

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.