Query refactoring framework

US12229143B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Joerg Weller · Hessenhöfe, DE
• Helmut Holthoff · Düsseldorf, DE
• Dimitrij Raev · Biebesheim, DE
• Julian Frank · Балка Пшехская, DE
• Hari Venkatesh Subramanian · Wiesloch, DE

Key dates

• Filing date: Jul 22, 2022
• Grant date: Feb 18, 2025
• Expiry date: Jan 31, 2043

Classification

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

Abstract

Techniques and solutions are provided for improving query execution. Data models can be complex, which is often reflected in queries against such data models. The present disclosure provides a query refactoring technique where a complex query, such as a query expressed as a single select statement, can be formulated as a series of less complex queries. The workload of a database can be reduced by combining results of the less complex queries outside of the database. The present disclosure provides a framework for implementing these techniques, where the framework includes a virtual cube, a calculation engine, and one or more operations, which can all be implemented as classes in a programming language, and where a generic class or interface can help guide users in developing subclasses that provide a reformulation or refactoring of a complex query.