History Infrastructure for Reporting in a Distributed System
The infrastructure may extend to multiple SQL servers in a distributed system. Data from the different systems can be compiled to provide a joint report.
Data from multiple systems
Red line: The data query from system 1 takes place in the short term storage for system 1 if data is required from multiple systems. The data required from system 2 is provided by a query from SQL server 1 to SQL server 2.
Data from another system
Green line: Data is exchanged directly at the system level to SQL server 2 if a data query from system 1 occurs for system 2 only.