# US 11,442,956 B2 · Transactional-unstructured data driven sequential federated query method for distributed systems > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,442,956 B2 - Document ID: US11442956B2 - Status: Granted - Kind: B2 - Application number: 17/193,495 - Filed: 2021-03-05 - Published: 2021-08-26 - Granted: 2022-09-13 - Earliest claimed: 2016-06-23 - Assignees: Schneider Electric USA, Inc. - Applicants: Schneider Electric USA, Inc. - Inventors: Charbel Joseph El Kaed; Stephen Dillon - Web page: https://patentgrep.com/patent/US11442956B2 ## CPC - G06F 16/256: {in federated or virtual databases} - G06F 16/2379: {Updates performed during online database operations; commit processing} - G06F 16/2477: {Temporal data queries} - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract Methods and systems are disclosed for receiving a sequential federated query; deconstructing the sequential federated query into query elements; identifying a Transactional-Unstructured Data Source (TUDS), a Contextual-Characteristic Data Source (CCDS), and a data organization parameter based on the query elements; generating a TUDS result data set from the TUDS based on the parameter; processing the TUDS result data set and the parameter to develop a CCDS query; generating a CCDS result data set from the CCDS based on the developed CCDS query and the parameter; generating a final sequential federated query data set based on the CCDS result data set and the parameters; processing a formatted sequential federated query data set based on the processing of the final sequential federated query data set and the parameter; and providing the formatted sequential federated query data set to a management system for action. ## Claims ### Claim 1 A method of processing a sequential federated query for distributed systems, 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. ### Claim 2 (depends on 1) The method of claim 1, further comprising receiving, at the processor, the sequential federated query from one of a user and a system. ### Claim 3 (depends on 1) The method of claim 1, further comprising receiving, at the processor, the sequential federated query from one of a database, a user interface, and an application interface. ### Claim 4 (depends on 1) The method of claim 1, wherein the query elements are time series based. ### Claim 5 (depends on 4) The method of claim 4, wherein the query elements are one of time series data, time series state data, time stamp data and, unstructured data formats. ### Claim 6 (depends on 1) The method of claim 1 wherein the first result data set includes operational anomaly data generated by connected elements. ### Claim 7 (depends on 1) The method of claim 1, wherein the second result data set is contextual based data. ### Claim 8 (depends on 7) The method of claim 7, wherein the contextual based data is one of data locations, data operations, and data sources. ### Claim 9 (depends on 1) The method of claim 1, wherein the management system for action is a Building Management System (BMS). ### Claim 10 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. ### Claim 11 (depends on 10) The non-transitory computer readable medium of claim 10, wherein the at least one processor is further configured to receive the sequential federated query from one of a user and a system. ### Claim 12 (depends on 10) The non-transitory computer readable medium of claim 10, wherein the at least one processor is further configured to receive the sequential federated query from one of a database, a user interface, and an application interface. ### Claim 13 (depends on 10) The non-transitory computer readable medium of claim 10, wherein the query elements are time series based. ### Claim 14 (depends on 13) The non-transitory computer readable medium of claim 13, wherein the query elements are one of time series data, time series state data, time stamp data and, unstructured data formats. ### Claim 15 (depends on 10) The non-transitory computer readable medium of claim 10, wherein the first result data set includes operational anomaly data generated by connected elements. ### Claim 16 (depends on 10) The non-transitory computer readable medium of claim 10, wherein the second result data set is contextual based data. ### Claim 17 (depends on 16) The non-transitory computer readable medium of claim 16, wherein the contextual based data comprises one of data locations, data operations, and data sources. ### Claim 18 (depends on 10) The non-transitory computer readable medium of claim 10, wherein the management system for action is a Building Management System (BMS). ### Claim 19 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.