Patent · US Active

Explicit declaration of associations to optimize grouping of elements by large data objects

US10402405B2 · kind B2 · utility

0Cited by

5References

17Claims

0Family size

Assignee

SAP SE · DE

Inventors

Edgardo Gildo Koenig · Leimen, DE
Steffen Siegmund · St. Leon-Rot, DE
Guenter Briam · Wiesloch, DE
Arndt Effern · Steinsfurt, DE

Key dates

Filing date	Apr 5, 2017
Grant date	Sep 3, 2019
Priority date	—
Expiry date	Nov 25, 2037

Classification

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

Abstract

The disclosure generally describes methods, software, and systems, including a method for optimizing queries referencing large object (LOB) information. A structured query language (SQL) query containing an LOB field is identified. LOB replacement information for the LOB field is obtained from a data model. The SQL query is optimized including substituting, using the obtained LOB replacement information, the LOB field with replacement language to create an updated SQL query, and extending the updated SQL query with a join of LOB field language to create an extended SQL query.

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