IT & DATA MANAGEMENT RESEARCH,
INDUSTRY ANALYSIS & CONSULTING

CONTACT    SIGN IN    SIGN UP
    
White Paper
Powering SQL on Hadoop: Evaluation of TPC-DS Query Benchmark Using Hadoop
Date: 03/14/2017 Length: 5 pages Cost: $99.00

            Linked In    

Abstract:
EMA big data research conducted regularly from 2012-2016 shows that organizations implementing Hadoop as part of their data management environments are moving from simple exploratory use cases to complex workload-driven analytics use cases. These organizations are working for the implementation of mission-critical business goals and workloads in environments that utilize Hadoop. According to EMA panel respondents, the most commonly implemented use cases are market basket analysis, social brand management analysis, fraud analysis and risk assessment, geospatial grouping, and relationship analysis. All of these projects require access to speed of response and many different groups across the organization.

These advanced workloads are SQL-intensive, requiring a full range of current ANSI SQL query support--not just a subset. In addition, many workloads must support the type of low-latency response business stakeholders require. Finally, these platforms need to support a level of concurrent users who will use these environments. When analytical applications gain adoption, their use becomes widespread and the underlying data management platform needs to support users while providing an acceptable level of performance.

An effective SQL on Hadoop environment must support advanced ANSI SQL versions such as SQL99 and SQL2003 to effectively maintain analytical and business intelligence query workloads. This is essential for business users who are loath to make adjustments from the queries used currently. Full SQL support is also critical when an enterprise plans to utilize data analysis and data visualization tools which generate their own SQL in ways that the data consumer and IT technologies do not fully control.
Author:

John Myers


 




EMA Services

IT Professionals

EMA can help you:

  • Support your decisions
  • Succeed with key projects
  • Align IT with the business

Learn More!

IT Vendors

EMA can help you:

  • Build the right product
  • Reach the right prospects
  • Establish market credibility

Learn More!

EMA Advisory Notes Service

An Affordable Way to Stay on Top of Key Trends & Industry Events

Subscribe now

EMA Premium Research Service

In-Depth Insight into IT Management Benefits, Challenges & Best Practices in the Enterprise

Subscribe now




©1996-2017 Enterprise Management Associates, Inc. All rights reserved.
EMA™, ENTERPRISE MANAGEMENT ASSOCIATES®, and the mobius symbol are registered trademarks or common-law trademarks of Enterprise Management Associates, Inc.
Site Terms & Conditions | Integrity Policy | Site Map | My Account
Hide
Subscribe to EMA RSS Feed
Email
Show