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.

2016: QueryGrid is upgraded

On September 15, 2016 Teradata announced release of release of the version of QueryGrid.

The product gives an opportunity to analyze data from diverse, multisystem data warehouses. In QueryGrid of the next generation the powerful foundation architecture with basic improvements among which is expected:

• one connector for each direct system for ensuring consistent syntax and logic of work regardless of in what system the request forms
• system services, including the increased security, enciphering and monitoring of performance

Improvements in Teradata QueryGrid of the next generation will be available to the order since 4th quarter 2016.

2014

Support of Oracle Database

On October 7, 2014 the Teradata company announced full support by the Teradata QueryGrid system of data transmission for the analysis between databases of Teradata and Oracle, it allows users of data warehouses of Teradata to integrate analytical information with a DB of Oracle.

The updated functionality

Software of Teradata QueryGrid supports work with a DB of Oracle.

Teradata QueryGrid at the heart of Data Fabric

On November 6, 2014 the Teradata company provided a universal data structure (Data Fabric) on the Teradata QueryGrid platform.

By means of this structure it is possible to turn a set of specialized solutions into the managed analytics ecosystem. The universal data structure connects among themselves different tools of the analysis, the data warehouse and the separate systems, turning them into uniform and uninterruptedly the working analytics ecosystem for business users.

Structure of Teradata QueryGrid

The universal data structure is interconnected with the different systems. It provides flexibility and helps with the choice of file and operating systems, data types, analytical mechanisms and characteristics of architecture of the systems corresponding to business objectives. By means of it safe, optimal accomplishment of requests within several mechanisms of processing and storages will be organized.

New opportunities of a universal data structure of Teradata QueryGrid help:

• implement interaction between databases of Teradata
  • the Companies can take advantage of family of platforms of Teradata considering specifics of the workloads connecting the different systems in business objectives, providing performance, availability and value of data and also scaling an analytical ecosystem in an effective and economic way. The Teradata systems interact so that constantly to guarantee the maximum capacity necessary for accomplishment of SLA agreements, managing balancing of workloads of systems. Work with a system is simple, both for administrators, and for users, by means of a uniform panel of observation of use of cross-platform resources through the integrated execution plan of a request and to the general instruments of administration. The companies get advantages of the multisystem Teradata environment and ease of use of one system.

• interact between the Teradata database and the Teradata Aster database
  • QueryGrid complements possibilities of a DB of Teradata with the modern built-in functions of Teradata Aster, including nPath, Graph and Sessionize. Simplicity of integration allows users of a DB of Teradata to cause the Aster functions in SQL queries. One command is enough for data management using more than 100 built-in analytic functions.

• perform the adaptive optimizer (Adaptive Optimizer)
  • the Adaptive optimizer within a DB of Teradata provides the highest performance of the requests executed on several systems of different suppliers using different technologies. It is reached due to dynamic collecting of statistics at return of results of requests from the remote systems. These results are combined with step planning of requests that the requests which turned out as a result were expedited and is effective, even when data are taken from systems with different technologies, for example from relational DB of Oracle, Hadoop or NoSQL MongoDB.

Possibilities of a universal data structure will become available after updating of QueryGrid and Teradata Database at the end of the 4th quarter 2014.

Within a product approach to multisystem analytics practices, giving to users an opportunity to work independently with the data and analytics through SQL. Users can apply the experience and skills of SQL, receiving analysts necessary for them without additional training.

QueryGrid representation: Teradata-Hadoop (2013)

Teradata QueryGrid helps to automate and optimize use of the analytical systems by means of distribution of data processing by all platforms:

• reduce data movement and process them where they are;
• minimize duplication of data;
• automate processing and data movement between systems;
• provide data movement in both directions.