Federation capabilities

With Big SQL you can efficiently query data on Hadoop and also combine data spread around different enterprise data warehouses. The federation capability of Big SQL lets you query against and combine with Hadoop data, as well as letting you push down predicates. Not all data moves back and forth between the systems; only the results of the predicates are sent back to combine with Hadoop data.

With federation, you can use a single database connection to access data across Hadoop and dozens of relational database types, whether they are on the cloud, on premises, or both. Big SQL includes Fluid Query capabilities to enhance virtualization with various data warehouses. You can also federate with S3 Object Storage and WebHDFS (technical preview only).

Federation consists of the following: a federated server, federated database, data sources, clients which can be users and applications to access both local database and database from data sources. Federation is known for its strengths:

Transparent

Correlate data from local tables and remote data sources, as if all the data is stored locally in the federated database

Extensible

Update data in relational data sources, as if the data is stored in the federated database

Autonomous

Move data to and from relational data sources without interruptions

High function

Take advantage of the data source processing strengths, by sending requests to the data sources for processing

High performance

Compensate for SQL limitations at the data source by processing parts of a distributed request at the federated server

Learn more: Federation