Dynamic generation of join statements for database operations

US11144549B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Jan Portisch · Bruchsal, DE
• Sandra Bracholdt · Dielheim, DE
• Volker Saggau · Bensheim, DE

Key dates

• Filing date: Dec 14, 2018
• Grant date: Oct 12, 2021
• Expiry date: Jun 6, 2039

Classification

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

Abstract

A process for mining existing views to generate join statements is provided herein. A request to generate a join statement may be received, which may include a database object identifier to be part of the join statement. One or more views in the database may be identified, which may include the database object identifier. One or more edges in the one or more views may be identified, which may include the database object identifier. Scores for the one or more edges may be calculated. The edges may be filtered based on their scores according to one or more filtering rules. The filtered edges may be provided. A selected edge may be received, which may be selected from the provided filtered edges. The join statement may be generated in a query language. The join statement may be based on the selected edge. The generated join statement may be provided.