The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Date of Patent:
Oct. 12, 2021

Filed:

Dec. 14, 2018
Applicant:

Sap SE, Walldorf, DE;

Inventors:

Jan Portisch, Bruchsal, DE;

Sandra Bracholdt, Dielheim, DE;

Volker Saggau, Bensheim, DE;

Assignee:

SAP SE, Walldorf, DE;

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/00 (2019.01); G06F 16/2453 (2019.01); G06F 16/28 (2019.01); G06F 16/901 (2019.01);
U.S. Cl.
CPC ...
G06F 16/24544 (2019.01); G06F 16/24535 (2019.01); G06F 16/289 (2019.01); G06F 16/9024 (2019.01);
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.


Find Patent Forward Citations

Loading…