US 12,298,946 B2
Natively supporting JSON duality view in a database management system
Zhen Hua Liu, San Mateo, CA (US); Juan R. Loaiza, Woodside, CA (US); Sundeep Abraham, Redwood City, CA (US); Shubha Bose, Foster City, CA (US); Hui Joe Chang, San Jose, CA (US); Shashank Gugnani, Redwood City, CA (US); Beda Christoph Hammerschmidt, Palo Alto, CA (US); Tirthankar Lahiri, Palo Alto, CA (US); Ying Lu, San Jose, CA (US); Douglas James McMahon, Redwood City, CA (US); Aurosish Mishra, Sunnyvale, CA (US); Ajit Mylavarapu, Mountain View, CA (US); Sukhada Pendse, Foster City, CA (US); and Ananth Raghavan, San Francisco, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Oct. 14, 2022, as Appl. No. 17/966,736.
Prior Publication US 2024/0126729 A1, Apr. 18, 2024
Int. Cl. G06F 16/20 (2019.01); G06F 16/21 (2019.01); G06F 16/2453 (2019.01); G06F 16/84 (2019.01)
CPC G06F 16/212 (2019.01) [G06F 16/24534 (2019.01); G06F 16/86 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
receiving, by a database management system (DBMS), a request to return a JavaScript Object Notation (JSON) object from a JSON Duality View, said JSON Duality View defining an object schema for said JSON object, wherein said JSON Duality View maps base attributes of a plurality of base tables to a plurality of fields of said object schema; and
in response to receiving said request, generating, by said DBMS, said JSON object,
wherein said JSON object includes:
said plurality of fields of said object schema;
an object identifier field; and
a version signature field;
wherein generating said JSON object includes:
retrieving a set of base records for said JSON object based on said JSON Duality View;
populating said plurality of fields with values based on respective attribute values of said base attributes of said set of base records; and
deterministically generating a version signature for said version signature field object based on said respective attribute values of said base attributes of said set of base records.