Transactional-unstructured data driven sequential federated query method for distributed systems

A non-transitory computer readable medium storing sequences of computer-executable instructions for processing a sequential federated query for distributed systems, the sequences of computer executable instructions including instructions that instruct at least one processor to:

• deconstruct a sequential federated query into query elements, wherein the sequential federated query identifies a first data source, a second data source, and a data organization parameter;
• transmit a first query to the first data source, wherein the first query is generated based on the data organization parameter, and wherein data stored in the first data source includes unstructured data and data structured according to one or more heterogeneous data structures;
• generate a first result data set from the first data source based on response to the first query;
• develop a second query based on the first result data set and the data organization parameter;
• generate a second result data set from the second data source based on the developed second query and the data organization parameter;
• process the second result data set and the data organization parameter to generate a formatted sequential federated query data set;
• and
• provide the formatted sequential federated query data set to a management system for action.

A system, comprising:

• one or more computer processors;
• and
• a non-transitory memory containing computer-readable program code that, when executed by operation of the one or more computer processors, performs an operation for processing a sequential federated query for distributed systems, the operation comprising:
• deconstructing, at a processor, a sequential federated query into query elements, wherein the sequential federated query identifies a first data source, a second data source and a data organization parameter;
• transmitting, by the processor, a first query to the first data source, wherein the first query is generated based on the data organization parameter, and wherein data stored in the first data source includes unstructured data and data structured according to one or more heterogeneous data structures;
• generating, at the processor, a first result data set from the first data source based on a response to the first query;
• developing a second query, at the processor, based on the first result data set and the data organization parameter;
• generating, at the processor, a second result data set from the second data source based on the developed second query and the data organization parameter;
• processing the second result data set and the data organization parameter to generate a formatted sequential federated query data set;
• and
• providing, at the processor, the formatted sequential federated query data set to a management system for action.