US 11,886,415 B2
Data retrieval from hierarchical industrial asset datasets
Karan Sonawane, Mumbai (IN); Shreyas Lele, Mumbai (IN); Mangesh Dashmukhe, Pune (IN); and Sandeep Patil, Mumbai (IN)
Assigned to Baker Hughes Holdings LLC, Houston, TX (US)
Filed by Baker Hughes Holdings LLC, Houston, TX (US)
Filed on Jun. 15, 2021, as Appl. No. 17/348,332.
Prior Publication US 2022/0398237 A1, Dec. 15, 2022
Int. Cl. G06F 16/22 (2019.01)
CPC G06F 16/2282 (2019.01) [G06F 16/221 (2019.01); G06F 16/2246 (2019.01)] 21 Claims
OG exemplary drawing
 
1. A method comprising:
controlling, by one or more processors, a detection of operational data, by using one or more sensors, the operational data comprising sensor measurements indicative of operations of industrial assets;
storing, by the one or more processors, the operational data, in a node table of a hierarchical dataset, stored in a partition of a database, the node table comprising a plurality of rows and a plurality of columns, each asset datum of a plurality of asset data comprising a plurality of asset properties characterizing the industrial assets, wherein the hierarchical dataset comprises a plurality of node data comprising a plurality of asset data and a plurality of edge data indicative of a relation between a pair of asset data of the plurality of asset data;
receiving, by the one or more processors, data characterizing a user request indicative of retrieval of a portion of the hierarchical dataset associated with a hierarchical industrial asset, the user request comprising pagination criteria and a search parameter;
selecting, by the one or more processors, the portion of the hierarchical dataset based on the search parameter;
dividing, by the one or more processors, the portion of the hierarchical dataset into a plurality of data subsets to generate the plurality of data subsets from at least the portion of the hierarchical dataset-based on a threshold data subset size included in the pagination criteria and based on a structure of the hierarchical dataset arranged in an order of decreasing hierarchical value, wherein a size of each data subset of the plurality of data subsets is less than the threshold data subset size; and
providing, by the one or more processors to a user device, the plurality of data subsets in a sequential order.