SHARE
Facebook X Pinterest WhatsApp

Teradata Unifies SQL and Hadoop

Ever since the first Hadoop system found its way into the enterprise, IT organizations have been looking for ways to couple SQL to Big Data. While there are already a number of options available to do just that, Teradata is taking that need for integration to a whole other level. The company today unveiled the […]

Written By
MV
Mike Vizard
Oct 17, 2012

Ever since the first Hadoop system found its way into the enterprise, IT organizations have been looking for ways to couple SQL to Big Data. While there are already a number of options available to do just that, Teradata is taking that need for integration to a whole other level.

The company today unveiled the Teradata Aster Big Analytics Appliance, which combines Hadoop with an instance of the massively parallel database technology that Teradata gained with the acquisition of Aster Data last year.

According to Tasso Argyros, co-president of Teradata Aster, rather than simply hosting the two databases on the same platform, Teradata has integrated them at a deeper metadata level. Using a distribution of Hadoop from Hortonworks, Teradata is providing support for both MapReduce and a fully ANSI-compatible instance of SQL known as SQL-H to make it easier for applications to query structured, semi-structured and unstructured data. In addition, the appliance comes with a library of over 50 pre-built functions for running analytics to help organizations derive immediate value from their investment, says Argyros.

Using a 40 Gigabit-per-second InfiniBand connection, the Teradata Aster Big Analytics Appliance can be integrated with an existing data warehouse from Teradata to create a data management platform that spans Hadoop, a massively parallel database and a traditional SQL database system.

Teradata also released AsterExpress, a downloadable version of the new offering that is intended to make it easier for developers and data scientists to get a jumpstart on building applications on top of a virtual appliance.

As powerful as Hadoop is there are still many issues to be addressed, not the least of which is the performance of a system that is essentially based on “micro-batch” architecture. At the same time, IT organizations have billions of dollars invested in SQL. Rather than wasting time arguing over which approach is better, the reality is that each approach lends itself to different use cases. The challenge is finding ways to unify those platforms in a way that not only creates new unique applications that add a lot of business value, but also keep the costs associated with having multiple data management platforms to a minimum.

MV

Michael Vizard is a seasoned IT journalist, with nearly 30 years of experience writing and editing about enterprise IT issues. He is a contributor to publications including Programmableweb, IT Business Edge, CIOinsight and UBM Tech. He formerly was editorial director for Ziff-Davis Enterprise, where he launched the company’s custom content division, and has also served as editor in chief for CRN and InfoWorld. He also has held editorial positions at PC Week, Computerworld and Digital Review.

Recommended for you...

Observability: Why It’s a Red Hot Tech Term
Tom Taulli
Jul 19, 2022
Top GRC Platforms & Tools in 2022
Jira vs. ServiceNow: Features, Pricing, and Comparison
Surajdeep Singh
Jun 17, 2022
IT Business Edge Logo

The go-to resource for IT professionals from all corners of the tech world looking for cutting edge technology solutions that solve their unique business challenges. We aim to help these professionals grow their knowledge base and authority in their field with the top news and trends in the technology space.

Property of TechnologyAdvice. © 2025 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.