Data retrieval from hierarchical industrial asset datasets

A system comprising:

• at least one data processor;
• memory coupled to the at least one data processor, the memory storing instructions to cause the at least one data processor to perform operations comprising:
• controlling a detection of operational data, by using one or more sensors, the operational data comprising sensor measurements indicative of operations of industrial assets;
• storing 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 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 the portion of the hierarchical dataset based on the search parameter;
• dividing 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, to a user device, the plurality of data subsets in a sequential order.

A computer program product comprising a non-transitory machine-readable medium storing instructions that, when executed by at least one programmable processor that comprises at least one physical core and a plurality of logical cores, cause the at least one programmable processor to perform operations comprising:

• controlling a detection of operational data, by using one or more sensors, the operational data comprising sensor measurements indicative of operations of industrial assets;
• storing 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 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 the portion of the hierarchical dataset based on the search parameter;
• dividing 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, to a user device, the plurality of data subsets in a sequential order.