Patent · US Active

Unnesting of JSON arrays

US12373432B2 · kind B2 · utility

0Cited by

2References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Stefano Belloni · Waukee, US
Christian Bensberg · Heidelberg, DE
Daniel Ritter · Heidelberg, DE

Key dates

Filing date	Dec 9, 2022
Grant date	Jul 29, 2025
Priority date	—
Expiry date	Jun 13, 2043

Classification

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

Abstract

A method may include receiving a query including at least one unnest operation to unnest a plurality of elements from one or more JavaScript Object Notation (JSON) arrays. The at least one unnest operation may unnest the plurality of elements by generating a table in which each row of the table is populated by one of the plurality of elements. An execution plan may be generated to include a pre-filter operation to filter, prior to the at least one unnest operation, the plurality of elements included in the one or more JSON arrays. For example, the pre-filter operation may be performed by iterating through the elements from the one or more JSON arrays to identify one or more elements satisfying a predicate included in a where clause of the query. The query may be executed in accordance with the execution plan. Related systems and computer program products are also provided.

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