Abstract: An apparatus is provided for facilitating a local database system to execute a query function at a foreign database system. The apparatus comprises a processor of the local database system and a storage device communicatively coupled with the processor.

Abstract: A data engine request is received on a local data system. The data engine request includes a portion of the request that is to be processed on an external data engine system. The portion is forwarded to the external data engine system and statistics for accessing external objects of the external data engine system is acquired. The statistics are evaluated for compliance with a Service Level Goal (SLG) associated with the request. Rules-based processing permits optimization and planning of the request on the local data engine system to be modified in view of the statistics received from the external data engine system to comply with the SLG. In an embodiment, actual resource utilization metrics noted during execution of the portion on the external data engine system is provided as feedback to the local data engine system for re-planning and re-optimizing the request with a modified execution plan.

Abstract: A system for managing data access, processing, and data movement across disparate data sources in a heterogeneous analytical environment. Communication and access between multiple disparate data sources is provided by an interconnect mechanism includes connectors at data source nodes and links established between the connectors to form a fabric, i.e., a set of interconnected nodes, which organizes components into a discrete environment and enables communication between paired data sources of the same or differing type within the environment.

Abstract: An apparatus is provided for facilitating a local database system to execute a query function at a foreign database system. The apparatus comprises a processor of the local database system and a storage device communicatively coupled with the processor.