US 11,899,644 B2
Technique of efficiently, comprehensively and autonomously support native JSON datatype in RDBMS for both OLTP and OLAP
Zhen Hua Liu, San Mateo, CA (US); Sriram Krishnamurthy, San Francisco, CA (US); Beda C. Hammerschmidt, Los Gatos, CA (US); Douglas J. McMahon, Redwood City, CA (US); Hui Joe Chang, San Jose, CA (US); Ying Lu, Sunnyvale, CA (US); Joshua Spiegel, St. Louis, MO (US); Srikrishnan Suresh, Belmont, CA (US); Vikas Arora, Burlingame, CA (US); Geeta Arora, Union City, CA (US); Sundeep Abraham, Redwood City, CA (US); Hui Zhang, San Ramon, CA (US); and Alfonso Colunga Sosa, Redwood City, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Jul. 8, 2022, as Appl. No. 17/860,187.
Application 17/860,187 is a division of application No. 16/904,417, filed on Jun. 17, 2020, granted, now 11,423,001.
Claims priority of provisional application 62/900,410, filed on Sep. 13, 2019.
Prior Publication US 2022/0342864 A1, Oct. 27, 2022
Int. Cl. G06F 16/22 (2019.01); G06F 16/2455 (2019.01); G06F 16/248 (2019.01); G06F 11/34 (2006.01); G06F 16/242 (2019.01)
CPC G06F 16/2282 (2019.01) [G06F 11/3409 (2013.01); G06F 16/221 (2019.01); G06F 16/244 (2019.01); G06F 16/248 (2019.01); G06F 16/24552 (2019.01); G06F 16/24556 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A method comprising:
receiving, by a database management system (DBMS) that stores a plurality of JavaScript object notation (JSON) documents, a structured query language (SQL) statement that uses elision to specify an aggregation function;
identifying a subset of the plurality of JSON documents that satisfy the SQL statement;
for each JSON document of the subset of the plurality of JSON documents, applying the aggregation function individually to said each JSON document to calculate a respective aggregate value of said each JSON document of a set of aggregate values; and
generating a result set that contains at least one respective aggregate value of said set of respective aggregate values for the subset of the plurality of JSON documents.