Services for Organizations

Using our research, best practices and expertise, we help you understand how to optimize your business processes using applications, information and technology. We provide advisory, education, and assessment services to rapidly identify and prioritize areas for improvement and perform vendor selection

Consulting & Strategy Sessions

Ventana On Demand

    Services for Investment Firms

    We provide guidance using our market research and expertise to significantly improve your marketing, sales and product efforts. We offer a portfolio of advisory, research, thought leadership and digital education services to help optimize market strategy, planning and execution.

    Consulting & Strategy Sessions

    Ventana On Demand

      Services for Technology Vendors

      We provide guidance using our market research and expertise to significantly improve your marketing, sales and product efforts. We offer a portfolio of advisory, research, thought leadership and digital education services to help optimize market strategy, planning and execution.

      Analyst Relations

      Demand Generation

      Product Marketing

      Market Coverage

      Request a Briefing



        Mark Smith's Analyst Perspectives

        << Back to Blog Index

        Teradata Aster Standardizes Access to Hadoop with SQL-H

        Using Hadoop just got easier, thanks to Teradata’s introduction of SQL-H, a new query interface to analyze data from Hadoop.  Most Hadoop access methods require preprocessing and staging of data from the Hadoop Distributed File System (HDFS) using technologies such as MapReduce. These approaches require new skills and technologies, introducing more time and costs for users, which offset the benefits of Hadoop, which according to our big data benchmark research include increasing the speed of analysis. Teradata has announced support for SQL-H not only for its own Aster Database 5.0, which it expects to release in the third quarter, but also supporting the commercial version of Hadoop through Hortonworks.

        Use of a familiar query interface, by contrast, reduces staffing and training issues required for learning more Hadoop-specific interfaces, which our research found to be the top two obstacles to big data analytics. Teradata Aster accomplishes this through utilizing use of HCatalog to get access to metadata that can be queried against using Aster SQL, ODBC, JDBC and ultimately any analytics or business intelligence tool, since the data then looks like a database table structure. The need to extract and store data from Hadoop into other database systems and thereby lose the computing power of Hadoop has been the Achilles heel of this big data technology. Analysts who want interactive and iterative discovery of their data now do not have to depend on the Hadoop Hive query language interface and can use more familiar tools like MicroStrategy and Tableau for analytics. Teradata Aster incorporates derivative analytics in its technology to be applied to data in Hadoop, including the customer and transaction data that, according to our research, top the list of types used. Its capabilities include analytics around paths, text, statistics, segmentation and broader customer interaction.

        Teradata Aster has an advantage over EMC Greenplum, IBM and Oracle, which do not provide this level of direct integration with Hadoop today. Their approach requires data duplication and does not leverage the extended power of Hadoop and use of HCatalog for metadata knowledge about the data itself. I expect that if other vendors want to exploit the power of Hadoop they will need to expand their support of it over the coming year.

        The introduction of SQL-H in Teradata Aster helps analysts streamline their analytics while reducing the custom coding and development required from IT staffers. Utilizing the Aster platform provides other computational processing advantages in its scale-out approach using a range of server technologies. According to our research, one-third of organizations plan to use Hadoop. For Teradata Aster, support for Hadoop builds on its existing big data support. Organizations looking to further exploit Hadoop  to analyze large volumes of data quickly should find Teradata Aster SQL-H a welcome advancement for their data and analytic options.

        Regards,

        Mark Smith – CEO & Chief Research Officer

        Authors:

        Mark Smith
        Partner, Head of Software Research

        Mark Smith is the Partner, Head of Software Research at ISG and Ventana Research leading the global market agenda as a subject matter expert in digital business and enterprise software. Mark is a digital technology enthusiast using market research and insights to educate and inspire enterprises, software and service providers.

        JOIN OUR COMMUNITY

        Our Analyst Perspective Policy

        • Ventana Research’s Analyst Perspectives are fact-based analysis and guidance on business, industry and technology vendor trends. Each Analyst Perspective presents the view of the analyst who is an established subject matter expert on new developments, business and technology trends, findings from our research, or best practice insights.

          Each is prepared and reviewed in accordance with Ventana Research’s strict standards for accuracy and objectivity and reviewed to ensure it delivers reliable and actionable insights. It is reviewed and edited by research management and is approved by the Chief Research Officer; no individual or organization outside of Ventana Research reviews any Analyst Perspective before it is published. If you have any issue with an Analyst Perspective, please email them to ChiefResearchOfficer@ventanaresearch.com

        View Policy

        Our Analysts

        Subscribe to Email Updates

        Posts by Topic

        see all


        Analyst Perspectives Archive

        See All