Patent · US Active

Conversion of model views into relational models

US10565200B2 · kind B2 · utility

1Cited by

0References

18Claims

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	Nov 23, 2015
Grant date	Feb 18, 2020
Priority date	—
Expiry date	Nov 30, 2037

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.