Path generation and selection tool for database objects

US10726052B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

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

Key dates

• Filing date: Jul 3, 2018
• Grant date: Jul 28, 2020
• Expiry date: Jan 22, 2039

Classification

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

Abstract

Techniques and solutions are described for determining, evaluating, and selecting data retrieval pathways. A plurality of database objects, such as tables, can be retrieved, and relationships between them determined. The relationships are between various attributes of the database objects. A plurality of pathways are determined between at least two target database objects, where the path determination does not consider attribute-level relationship information. After a path is determined, the relationship-level information can be added. A summary of the path, and relationship information, can be displayed to a user. A user can select paths to remove from the display, and can indicate one or more database objects that are required for a valid path, one or more database objects that are prohibited from valid paths, or combinations thereof. A user can select a path, and a query language statement to implement the path can be generated and displayed to the user.