The name of the base system (platform): | Apache Hadoop |
Developers: | Teradata |
Last Release Date: | 2015/03/31 |
Technology: | BI, OLAP, DBMS |
Content |
The Teradata company decided to deliver since September, 2011 analytical Aster DBMS including in the form of a hardware and software system, like systems Oracle Exadata, EMC Greenplum and SAP HANA. Now Aster is offered in the form of the software product for local installation and cloud deployment. DBMS- the complex will be based on the same hardware platform, as Teradata data warehouses. The "iron" Aster option will appear at the beginning of the next year.
Aster is known mainly for special implementation of a program framework of the distributed data processing of MapReduce allowing to cause functions of a system by means of standard SQL queries. Along with a hardware and software system the new version of DBMS — Aster Database 5.0 in which these opportunities will extend will be released. According to Teradata, mechanisms of the analysis of behavior of users on the websites, effectiveness of marketing campaigns and a decision tree and also other analytic functions are added. Other improvements concern management of workloads and the speed of execution of SQL queries.
2012
Teradata Aster SQL-H
The Teradata corporation, the developer of solutions for storage and data analysis, announced in July, 2012 release of the Aster SQL-H software package providing to business analysts means of organic integration of widely used BI-applications with large volumes of the data which are stored in Apache Hadoop distributed file system. Using Aster SQL-H, business will be able to find the hidden opportunities of receiving an additional profit, using analytics as the driving force and a basis for acceptance of the weighed and optimal solutions, claim in the company.
Many companies accumulate a huge number of information from different sources — a log of work of web applications, machine data, different text data, saving them in a cost-efficient distributed file system of Hadoop (HDFS, Hadoop Distributed File System). However it is difficult to user to take and analyze this information standard means of the business analysis because of its complexity and variety of incompatible data types, noted in Teradata.
"Business users are in great need in expansion of opportunities of the analysis of large volumes of data, and today Teradata offers these opportunities to those who make crucial decisions — Scott Gnau, the director of Teradata Labs said. — Aster SQL-H is success synonym for those business analysts who use the raw semistructured data of Hadoop by search of new ways of improving competitiveness".
Aster SQL-H — is a new component of the software package Teradata Aster along with the Teradata Aster MapReduce platform, the Aster database, the SQL-MapReduce interface and a set of the Aster MapReduce Analytics analytical applications. It works as a part of the solution Aster MapReduce Appliance which is focused on the analysis of large volumes of data and provides a scaling option and high processing speed, reported in the company.
"Aster SQL-H has two important features: first, it for the first time gives an opportunity of use of the SQL language for the transparent and convenient Hadoop data access — Tasso Arygros, the cochairman of Teradata Aster noted in return. — Secondly, all tools of the Aster MapReduce platform are used for Hadoop data analysis, including more than 50 built-in analytical applications of MapReduce and the patented SQL-MapReduce interface now. The result exceeds all expectations: users have more opportunities of the analysis and the advanced means for work with data in enterprise scales, plus saving of time and means".
According to Teradata, in Aster SQL-H practices from the Apache HCatalog project with the open code using metadata for access simplification directly to data are used. One of the main project participants of HCatalog is the Hortonworks company.
"The Teradata company showed readiness to help customers as it is possible to use more effectively information accumulated by them, having developed a convenient method of the Hadoop data access using the modern technologies created by community of Apache Hadoop developers. Thanks to integration with services HCatalog, Aster SQL-H simplifies the analysis of large volumes of data as for business analysts and information processing specialists, and for employees of IT departments as data of Hadoop are available using standard means of ANSI SQL and BI means now — Rob Bearden, the CEO of Hortonworks explained. — Moreover, a broad set of analytic functions SQL-MapReduce gives to community of users to Hadoop ample opportunities for better data analysis, thereby doing business even more successful".
Aster SQL-H is a part of the software of the Aster Database 5.0 database which will be available to acquisition in the third quarter 2012.
2015
Teradata Aster Discovery shows results
On January 20, 2015 the Teradata company announced a research of the cumulative economic effect which is carried out by Forrester Consulting by request of Teradata which revealed - the Teradata Aster Discovery platform showed convincing economic and technology results.
The Teradata Aster Discovery platform is the solution for collecting and the analysis of Big Data allowing the companies to take the important commercial information from Big Data. The research revealed that use of the Aster platform helped the retail company to get commercial, marketing and technology advantages:
- Cost efficiency (return of investments) in the amount of 106% with a payback period of 13.9 months and total benefit in three years in the amount of 6.1 mln. dollars.
- Growth of number of transition of potential buyers in actual, as result — direct influence on profitability indicators
- Growth of economy due to increase in effectiveness of IT and users
- Sales growth in connection with increase in marketing effectiveness
- Simplicity of system implementation in the available infrastructure
- Increase in effectiveness of IT and users
- Increase in efficiency of expenditure of the marketing budget due to identification of new important factors *
The solutions Teradata Aster allow to elicit the valuable facts in the cases connected with the analysis of social networks and agents of influence, leakage of clients, the analysis of behavior, way to purchase commission, fraud, a financial analysis and individual recommendations.
The Aster Discovery platform is characteristic several advantages:
- Capability create data models, information storage and work with unstructured data.
- Capability reduce labor costs as for management of the platform specialized skills are not required.
- Existence of visual tools for an output of the important commercial information and increase in marketing effectiveness.
As a part of innovations of the Aster Discovery platform mechanism of creation of diagrams Teradata Aster SQL-GR and software environment of Teradata SNAP Framework (Teradata Aster Seamless Network Analytic Processing Framework). The SNAP Framework environment helps to connect together different analytical mechanisms and file storages, opening possibilities of deep search in data.
Calculating total economic effect (TEI), Forrester defined four directions on which work of the Teradata Aster Discovery platform had an impact:
- advantages,
- costs,
- flexibility
- risks.
start of Teradata Aster AppCenter Prepares
On March 31, 2015 Teradata Corp. announced applications launch for work with Big Data on the Teradata Aster AppCenter platform (AppCenter).
Reason for creation of a new solution of Teradata were problems which the organizations face trying to take valuable information for business from diverse Big Data.
Previously configured templates the having properties of analytical logic, the including data schemes, interactive visualization and a user-friendly interface for work with the repeating analysis tasks are provided in applications.
AppCenter helps to implement access to applications via the web portal, and the Teradata Aster Discovery platform ensures necessary scalability and functioning of such web services as authentication and authorization for increase in security. The AppCenter web interface simplifies information processing from different devices, including tablets. Integrating third-party and open libraries of visualization for evident representation of results, AppCenter guarantees the maximum flexibility. The product offers a set of methods of application integration for work with Big Data and tools of the business analysis, visualization.
AppCenter will become available to purchase at the end of the third quarter 2015 and will be compatible to Teradata Aster Database 6.0 unrolled on own servers of the client or in a cloud.