Welcome!

SDN Journal Authors: Destiny Bertucci, Liz McMillan, Pat Romanski, Elizabeth White, Amitabh Sinha

Related Topics: @DXWorldExpo, Microsoft Cloud, Containers Expo Blog, Silverlight, @CloudExpo, SDN Journal

@DXWorldExpo: Article

Hybrid Big Data Solutions

Use Cases for Microsoft PolyBase

Microsoft recently announced the PolyBase technology as part of SQL Server 2012 Parallel Data Warehouse solution. PolyBase is a breakthrough new technology on the data processing engine in SQL Server 2012 Parallel Data Warehouse designed as the simplest way to combine non-relational data and traditional relational data in your analysis.

PolyBase is part of an overall Microsoft "Big Data" solution that already includes HDInsights (a 100% Apache Hadoop compatible distribution for Windows Server and Windows Azure), Microsoft Business Intelligence, and SQL Server 2012 Parallel Data Warehouse. PolyBase is built into SQL Server 2012 Parallel Data Warehouse to bring "Big Data" benefits within the power of a traditional data warehouse.

Much like the success and adoption of the Hybrid Cloud Delivery Model whereby enterprises found it comfortable to run their workloads partly on-premise and partly in the cloud, this new set of technologies like PolyBase can be termed "Hybrid BigData Delivery."

This concept of bringing the power of Big Data analysis as part of traditional relational databases will likely have a huge impact on the enterprise for the following reasons.

  • In terms of knowledge management of their IT department, enterprises cannot afford to spend time learning new technologies on Big Data whereas they have huge investments on staff with skill on traditional RDBMS.
  • More than staff skills, enterprise use cases that can benefit from Big Data can't really ignore Relational Database processing. This is mainly because enterprise have built all their key decision criteria as relational database data over a period of time and without utilizing them any meaningful insights from massive quantities of unstructured data generated from unconventional sources cannot be realized.

The following use cases explain why "Hybrid Big Data" solutions like PolyBase are likely have a larger impact on the enterprises than the Pure Play Big Data solutions.

Voice Of Customer & Product Quality Analysis
Understanding the issues of your customer and ensure that they are fixed in the product implementations is of the utmost importance for the organizations and the following are components that fit in to the Hybrid Big Data Model.

  • Big Data Components:
    • Call Logs from various call center transactions
    • Event Data from Social Networks
  • Traditional RDBMS Components:
    • Integration with Product master / Bill Of Material
    • Integration with Plants
    • Integration with Supplier Data
    • Integration with various Engineering Processes

From the above segregation of data sources Hybrid Big Data solutions like PolyBase can best attend this use case.

Campaign Effectiveness & Advertisement Targeting
Campaign analysis enables organizations to gauge the success of various campaigns by measuring campaign costs, leads generated and leads converted to customers. One of the major drivers for campaign effectiveness is the advertisement targeting engine, which selects the best recommendation for a given user. This solution is again best served with a Hybrid Big Data solution.

  • Big Data Components:
    • Click Stream analytics information to understand customer behavior
    • Event data from social networks
  • Traditional RDBMS Components:
    • Historical scores on existing customers
    • Predictive mining models built as part of OLAP engines
    • Integration with legacy systems of marketing & finance
    • Integration with risk analysis

ITIL Event Analysis & Predictive Analytics
Information generated from various server logs along with other real time information like network utilization are key to predicting the behavior of IT systems and predict the likelihood of any failures in the near feature. This kind of analysis is key to the availability of large enterprise IT systems. Again this is a good candidate for Hybrid Big Data analysis.

  • Big Data Components:
    • Massive amounts of log files generated from various servers
  • Traditional RDBMS Components:
    • Known error databases
    • System topologies and mapping
    • Event correlation engines whose algorithms are best implemented using traditional RDBMS stored procedures

Fraud Detection Analytics
Financial organization which deals with large amounts of real time events, need to have a robust event correlation mechanisms to ensure that there are no fraudulent transactions.

  • Big Data Components:
    • Event data generated from various channels
    • Social media data like customer location information
    • Image processing data
  • Traditional RDBMS Components:
    • Validation metadata for transactions
    • Customer master

Summary
As evident major use cases in the enterprise will continue to use large amounts of relational data already captured and accurately maintained; however, enterprises do need the power and flexibility of Big Data processing solutions to handle the unstructured real-time data coming from various new sources.

This can be best achieved with Hybrid Big Data technologies like Microsoft PolyBase, and more case studies on this front will emerge sooner.

More Stories By Srinivasan Sundara Rajan

Highly passionate about utilizing Digital Technologies to enable next generation enterprise. Believes in enterprise transformation through the Natives (Cloud Native & Mobile Native).

@CloudExpo Stories
The dynamic nature of the cloud means that change is a constant when it comes to modern cloud-based infrastructure. Delivering modern applications to end users, therefore, is a constantly shifting challenge. Delivery automation helps IT Ops teams ensure that apps are providing an optimal end user experience over hybrid-cloud and multi-cloud environments, no matter what the current state of the infrastructure is. To employ a delivery automation strategy that reflects your business rules, making r...
Modern software design has fundamentally changed how we manage applications, causing many to turn to containers as the new virtual machine for resource management. As container adoption grows beyond stateless applications to stateful workloads, the need for persistent storage is foundational - something customers routinely cite as a top pain point. In his session at @DevOpsSummit at 21st Cloud Expo, Bill Borsari, Head of Systems Engineering at Datera, explored how organizations can reap the bene...
Kubernetes is an open source system for automating deployment, scaling, and management of containerized applications. Kubernetes was originally built by Google, leveraging years of experience with managing container workloads, and is now a Cloud Native Compute Foundation (CNCF) project. Kubernetes has been widely adopted by the community, supported on all major public and private cloud providers, and is gaining rapid adoption in enterprises. However, Kubernetes may seem intimidating and complex ...
In a recent survey, Sumo Logic surveyed 1,500 customers who employ cloud services such as Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP). According to the survey, a quarter of the respondents have already deployed Docker containers and nearly as many (23 percent) are employing the AWS Lambda serverless computing framework. It’s clear: serverless is here to stay. The adoption does come with some needed changes, within both application development and operations. Tha...
In his session at 21st Cloud Expo, Michael Burley, a Senior Business Development Executive in IT Services at NetApp, described how NetApp designed a three-year program of work to migrate 25PB of a major telco's enterprise data to a new STaaS platform, and then secured a long-term contract to manage and operate the platform. This significant program blended the best of NetApp’s solutions and services capabilities to enable this telco’s successful adoption of private cloud storage and launching ...
In his general session at 21st Cloud Expo, Greg Dumas, Calligo’s Vice President and G.M. of US operations, discussed the new Global Data Protection Regulation and how Calligo can help business stay compliant in digitally globalized world. Greg Dumas is Calligo's Vice President and G.M. of US operations. Calligo is an established service provider that provides an innovative platform for trusted cloud solutions. Calligo’s customers are typically most concerned about GDPR compliance, application p...
The past few years have brought a sea change in the way applications are architected, developed, and consumed—increasing both the complexity of testing and the business impact of software failures. How can software testing professionals keep pace with modern application delivery, given the trends that impact both architectures (cloud, microservices, and APIs) and processes (DevOps, agile, and continuous delivery)? This is where continuous testing comes in. D
The 22nd International Cloud Expo | 1st DXWorld Expo has announced that its Call for Papers is open. Cloud Expo | DXWorld Expo, to be held June 5-7, 2018, at the Javits Center in New York, NY, brings together Cloud Computing, Digital Transformation, Big Data, Internet of Things, DevOps, Machine Learning and WebRTC to one location. With cloud computing driving a higher percentage of enterprise IT budgets every year, it becomes increasingly important to plant your flag in this fast-expanding busin...
Smart cities have the potential to change our lives at so many levels for citizens: less pollution, reduced parking obstacles, better health, education and more energy savings. Real-time data streaming and the Internet of Things (IoT) possess the power to turn this vision into a reality. However, most organizations today are building their data infrastructure to focus solely on addressing immediate business needs vs. a platform capable of quickly adapting emerging technologies to address future ...
SYS-CON Events announced today that Synametrics Technologies will exhibit at SYS-CON's 22nd International Cloud Expo®, which will take place on June 5-7, 2018, at the Javits Center in New York, NY. Synametrics Technologies is a privately held company based in Plainsboro, New Jersey that has been providing solutions for the developer community since 1997. Based on the success of its initial product offerings such as WinSQL, Xeams, SynaMan and Syncrify, Synametrics continues to create and hone in...
You know you need the cloud, but you’re hesitant to simply dump everything at Amazon since you know that not all workloads are suitable for cloud. You know that you want the kind of ease of use and scalability that you get with public cloud, but your applications are architected in a way that makes the public cloud a non-starter. You’re looking at private cloud solutions based on hyperconverged infrastructure, but you’re concerned with the limits inherent in those technologies.
Nordstrom is transforming the way that they do business and the cloud is the key to enabling speed and hyper personalized customer experiences. In his session at 21st Cloud Expo, Ken Schow, VP of Engineering at Nordstrom, discussed some of the key learnings and common pitfalls of large enterprises moving to the cloud. This includes strategies around choosing a cloud provider(s), architecture, and lessons learned. In addition, he covered some of the best practices for structured team migration an...
With tough new regulations coming to Europe on data privacy in May 2018, Calligo will explain why in reality the effect is global and transforms how you consider critical data. EU GDPR fundamentally rewrites the rules for cloud, Big Data and IoT. In his session at 21st Cloud Expo, Adam Ryan, Vice President and General Manager EMEA at Calligo, examined the regulations and provided insight on how it affects technology, challenges the established rules and will usher in new levels of diligence arou...
Most technology leaders, contemporary and from the hardware era, are reshaping their businesses to do software. They hope to capture value from emerging technologies such as IoT, SDN, and AI. Ultimately, irrespective of the vertical, it is about deriving value from independent software applications participating in an ecosystem as one comprehensive solution. In his session at @ThingsExpo, Kausik Sridhar, founder and CTO of Pulzze Systems, discussed how given the magnitude of today's application ...
The “Digital Era” is forcing us to engage with new methods to build, operate and maintain applications. This transformation also implies an evolution to more and more intelligent applications to better engage with the customers, while creating significant market differentiators. In both cases, the cloud has become a key enabler to embrace this digital revolution. So, moving to the cloud is no longer the question; the new questions are HOW and WHEN. To make this equation even more complex, most ...
As you move to the cloud, your network should be efficient, secure, and easy to manage. An enterprise adopting a hybrid or public cloud needs systems and tools that provide: Agility: ability to deliver applications and services faster, even in complex hybrid environments Easier manageability: enable reliable connectivity with complete oversight as the data center network evolves Greater efficiency: eliminate wasted effort while reducing errors and optimize asset utilization Security: imple...
Mobile device usage has increased exponentially during the past several years, as consumers rely on handhelds for everything from news and weather to banking and purchases. What can we expect in the next few years? The way in which we interact with our devices will fundamentally change, as businesses leverage Artificial Intelligence. We already see this taking shape as businesses leverage AI for cost savings and customer responsiveness. This trend will continue, as AI is used for more sophistica...
In his Opening Keynote at 21st Cloud Expo, John Considine, General Manager of IBM Cloud Infrastructure, led attendees through the exciting evolution of the cloud. He looked at this major disruption from the perspective of technology, business models, and what this means for enterprises of all sizes. John Considine is General Manager of Cloud Infrastructure Services at IBM. In that role he is responsible for leading IBM’s public cloud infrastructure including strategy, development, and offering m...
Digital transformation is about embracing digital technologies into a company's culture to better connect with its customers, automate processes, create better tools, enter new markets, etc. Such a transformation requires continuous orchestration across teams and an environment based on open collaboration and daily experiments. In his session at 21st Cloud Expo, Alex Casalboni, Technical (Cloud) Evangelist at Cloud Academy, explored and discussed the most urgent unsolved challenges to achieve f...
In his session at 21st Cloud Expo, Raju Shreewastava, founder of Big Data Trunk, provided a fun and simple way to introduce Machine Leaning to anyone and everyone. He solved a machine learning problem and demonstrated an easy way to be able to do machine learning without even coding. Raju Shreewastava is the founder of Big Data Trunk (www.BigDataTrunk.com), a Big Data Training and consulting firm with offices in the United States. He previously led the data warehouse/business intelligence and B...