Patent · US Active

Conversion of model views into relational models

US11681702B2 · kind B2 · utility

0Cited by

2References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Taehyung Lee · Seoul, KR
Wolfgang Stephan · Heidelberg, DE
Felix Knittel · Walldorf, DE
Chuho Chang · Suneung-ri, KR

Key dates

Filing date	Jan 15, 2020
Grant date	Jun 20, 2023
Priority date	—
Expiry date	Oct 9, 2040

Classification

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

Abstract

Disclosed herein are system, method, and computer tangible medium embodiments for generating a relational database model from a model view that provides an estimate for generating query plan for a query on the model view, according to an embodiment. A join model of a model view set on one or more database tables is received. At least one index conversion of the join model is performed, where the index conversion converts at least one index in the join model into at least one leaf node in a relational model tree. At least one join conversion of the join model is performed where the at least one join conversion generates a node in the relational model tree that joins a first and second leaf nodes in the relational model tree. A requested parameter conversion is performed, where the requested parameter conversion includes an attribute or key figure requested by a query.

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