US 12,072,878 B2
Search architecture for hierarchical data using metadata defined relationships
George John Kellner, San Mateo, CA (US); Jung Min Ha, Menlo Park, CA (US); Mark Pearson, Redwood Shores, CA (US); Jingyi Han, San Jose, CA (US); Jennifer Darmour, Seattle, WA (US); Abhay Kumar, Hyderabad (IN); David Barry Groves, Queensland (AU); Hong Tuck Liew, Singapore (SG); Abburi Rahul Krishna Naga Karthik, Vijayawada (IN); Johnson Kunnel Joesph, Hyderabad (IN); Ann Deena Philip, Cupertino, CA (US); Subramanya Sarma Kuchi Venkata Raghavendra, Hyderabad (IN); Jitin Sai Pichika, Telangana (IN); and Srinivas Sureshkumar Guthivari, Frisco, TX (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Sep. 22, 2021, as Appl. No. 17/448,489.
Prior Publication US 2023/0090050 A1, Mar. 23, 2023
Int. Cl. G06F 16/2453 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/2453 (2019.01) [G06F 16/2228 (2019.01)] 17 Claims
OG exemplary drawing
 
1. One or more non-transitory computer-readable media storing instructions, which when executed by one or more hardware processors, cause performance of operations comprising:
receiving a hierarchical data set comprising a plurality of objects, each of the plurality of objects being related to at least one other object in the plurality of objects via a hierarchical relationship of a plurality of hierarchical relationships;
receiving metadata, corresponding to the hierarchical data set, identifying a first set of one or more attributes to be indexed in a search index;
generating one or more relational tables to represent the hierarchical data set, the relational tables storing values within the hierarchical data set in association with a corresponding attribute name;
generating the search index based on the first set of one or more attributes at least by:
indexing, in the search index, a first value corresponding to a first attribute of the first set of one or more attributes;
referencing, in the search index, one or more return values that are (a) stored in the one or more relational tables and (b) to be returned in response to any queries comprising the first value;
subsequent to generating the one or more relational tables to represent the hierarchical data set and the search index referencing the one or more relational tables:
displaying a hierarchy of nodes corresponding to the plurality of objects in the hierarchical data set;
concurrently with displaying the hierarchy of nodes, receiving a query for identifying one or more nodes in the hierarchy of nodes based on the first value;
accessing the search index and the one or more relational tables to identify the one or more return values, from the one or more relational tables, at least by referencing the search index in relation to the first value;
mapping the one or more return values to the one or more nodes in the hierarchy of nodes; and
visually identifying the one or more nodes in the hierarchy of nodes in response to the query for identifying the one or more nodes based on the first value.