Invention Grant
- Patent Title: Explicit declaration of associations to optimize grouping of elements by large data objects
-
Application No.: US15479479Application Date: 2017-04-05
-
Publication No.: US10402405B2Publication Date: 2019-09-03
- Inventor: Edgardo Gildo Koenig , Steffen Siegmund , Guenter Briam , Arndt Effern
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fish & Richardson P.C.
- Main IPC: G06F16/2453
- IPC: G06F16/2453
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.
Public/Granted literature
- US20180293277A1 EXPLICIT DECLARATION OF ASSOCIATIONS TO OPTIMIZE GROUPING OF ELEMENTS BY LARGE DATA OBJECTS Public/Granted day:2018-10-11
Information query
