ablog

不器用で落着きのない技術者のメモ

Teradata の Query Grid とは

Teradata QueryGridの説明
Teradata QueryGrid™ 2.xは、1つ以上のデータ ソースにわたって、シームレスで高性能なデータ アクセス、処理、および移動を提供するデータ分析ファブリックです。

Teradata QueryGridは、次のコネクタをサポートします。

  • Teradata Database
  • Hive
  • Spark SQL
  • Oracle(ターゲット コネクタとしてのみ)
  • Presto
2.14 - Teradata QueryGridの概要 - Teradata QueryGrid

Teradata QueryGrid is a product of expansion of opportunities of "the lake of data" Hadoop and at the same time the analytics tool.

On April 24, 2014 Teradata announced solutions for the analysis of large volumes of data of Teradata QueryGrid the offer.

This solution - the only software product, for the April 24, 2014 optimizing processes of data analysis in enterprise scales and beyond its limits.


Description

Teradata QueryGrid provides to users simple and direct data access and to processes of analytics in the different systems using only one request in the database Teradata Database or Teradata Aster Database. Teradata QueryGrid involves analytical mechanisms and file systems to implement assessment and data analysis without use of special tools or other intervention of IT specialists. This solution minimizes need for movement and copying of data, allowing to process data where they are stored.

The Teradata Database 15 database supporting QueryGrid provides bilateral data movement and their cascade processing in Hadoop, Aster Database and other databases. From the Teradata Database database it is possible to send requests for data access, their filtering and return of subsets from Hadoop, Aster Database and other environments in Teradata Database for additional processing. The analysis can include data from Teradata Database and Hadoop.

The architecture of data of Teradata Unified Data Architecture integrating in itself Teradata Database the Teradata Aster Discovery Platform platform and technology Hadoop, allows Teradata QueryGrid to expand and supplement requests in databases Teradata and Aster, providing to users useful analytical information.

Teradata is going to create the software, it will connect among themselves analytical mechanisms and file systems and will expand data processing to scales of the whole enterprise.

Possibilities of Teradata QueryGrid will become available to users in the third quarter 2014.

https://tadviser.com/index.php/Product:Teradata_QueryGrid

例: CREATE FOREIGN SERVERの使用
この例では、LINKの名前と値のペアを使用して外部サーバーを作成します。リンクとそのプロパティは、QueryGridポートレットで定義されます。

CREATE FOREIGN SERVER Presto_1
USING
LINK(‘td1_presto1’)
DO IMPORT WITH TD_SYSFNLIB.QGInitiatorImport,
DO EXPORT WITH TD_SYSFNLIB.QGInitiatorExport;
2.09 - 使用上の注意 - Teradata QueryGrid