Patent · US Active

Dynamic automatic generation of database views

US10901987B2 · kind B2 · utility

1Cited by

11References

20Claims

0Family size

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	Jan 26, 2021
Priority date	—
Expiry date	Jun 5, 2039

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/955
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A process for mining existing views to generate new views is provided herein. A request to generate a proposed view combining a plurality of tables in a database may be received. One or more existing views in the database applicable to the request may be identified. The applicable existing views may include the plurality of tables in the request. One or more paths combining the plurality of tables may be identified in the respective one or more existing views. The identified one or more paths may be provided. One or more scores for the one or more paths may be generated and provided along with the one or more paths. A path may be automatically selected based on the scores or a path may be selected by a user. A view may be generated based on the selected path.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.