Archive for the ‘Digital Marketing’ Category

12
Jun
   

Back in 2005, when we first founded Aster Data, our vision was to take some of the latest technology innovations – including MPP shared-nothing architectures; Linux-based commodity hardware; and novel analytical interfaces like Google’s MapReduce – and bring them to mainstream enterprises. This vision translated into a strategy focused not only on big data innovations, but also on delivering technologies that make big data viable for enterprise environments. SQL-MapReduce®, our industry-leading patented technology that combines standard SQL processing with a native MapReduce execution environment, is one example of how we make big data enterprise ready.

Today we have completed another major milestone on providing value to our customers by announcing a major innovation: Aster SQL-H™, a seamless way to execute SQL & SQL-MapReduce on Apache™ Hadoop™ data.

This is a significant step forward from what was state-of-the-art until yesterday. What was missing? A common DBMS-Hadoop connector operating at the physical layer. This means that getting data from Hadoop to a database required a Hadoop expert in the middle to do the data cleansing and the data type translation. If the data was not 100% clean (which is the case in most circumstances) a developer was needed to get it to a consistent, proper form. Besides wasting the valuable time of that expert, this process meant that business analysts couldn’t directly access and analyze data in Hadoop clusters. Other database connectors require duplicating the data into HDFS by using proprietary formats; a cumbersome and expensive approach by any measure.

SQL-H, an industry-first, solves all those problems.

First, we have integrated Aster’s metadata engine with Hadoop’s emerging metadata standard, HCatalog. This means that data stored in Hadoop using Pig, Hive & HBase can be “seen” in an Aster system as if they are just another Aster view. The business implication is that a business analyst using standard SQL or a BI tool can have full and seamless access to Hadoop data through the Aster’s standard ODBC/JDBC connector and Aster’s SQL engine. There is no need to have a human in the middle to translate the data or ensure its consistency; and no need to file tickets or call up experts to get the data the business needs. Everything happens transparently, seamlessly, and instantly. This is an industry first, since today all available Hadoop tools either do not provide standard SQL interfaces that are well optimized, do not provide native BI compatibility, or require manual data translation and movement from Hadoop to a third party system. None of these approaches are viable options for SQL & BI execution on Hadoop data, thus making it hard for enterprises to get value from Hadoop.

Secondly, SQL-H provides a high-performance, type-safe data connector, that can take a SQL or SQL-MapReduce query that involves Hadoop data, automatically select the minimum subset of data in Hadoop that is required for execution of the query, and run the query on the Aster system. The performance of running SQL and SQL-MapReduce analytics in Aster is significantly higher than Hadoop because (a) Aster can optimize data partitioning and distribution, thus reducing network transfers and overhead; (b) Aster’s engine can keep statistics about the data and use that to optimize execution of both SQL & MapReduce; (c) Aster’s SQL queries are cost-based-optimized which means that it can handle very complex SQL, including SQL produced by BI tools, very efficiently.

In addition, one can take advantage of SQL-H to apply the 50+ pre-build SQL-MapReduce apps that Teradata Aster provides on Hadoop data, thus doing big data analytics that are impossible to do in every other database without having to write a single line of Java MapReduce code! These apps include functions for path & pattern analysis, statistics, graph, text analysis, and more.

Teradata Aster is committed to groundbreaking product innovation as the key strategy in maintaining our #1 position in the big analytics market. SQL-H is another important step that we expect will make Hadoop and big data analytics much more palatable for enterprise environments, allowing business analysts, SQL power-users & BI tool users to analyze Hadoop data without having to learn about Hadoop interfaces and code.

If you want to find out more we’ll be talking about SQL-H at Hadoop Summit, on webcast taking place June 21st, at the upcoming Big Analytics 2012 events in Chicago & New York, and at the annual Teradata Partners event.



26
Apr
By Paul Barrett in Digital Marketing, Social Media, Teradata Aster on April 26, 2012
   

What questions are important to you about Social Media?

John Lovett from Web Analytics Demystified just published a new white paper on Social Analytics. Lovett, who has written the book on Social Analytics (literally), lays out a compelling vision for Deeper Social Analytics for companies.  He clearly presents the value of companies to go beyond surface level analytics of likes, followers and friends and challenges the CMO to ask deeper and more important questions.

I love the three key questions presented in the paper that really hit the c-suite.  These are

  • What is the Audience?
  • What is the Activity?
  • What is the Action?

These 3 questions provide a framework to share social media initiatives with business leaders and strip away all the non-business related questions that become so distracting in understanding the impact of social media on the enterprise.

Although we are still in the early, Black and White TV stage of social analytics, Teradata Aster has been heavily influenced by our customers’ needs in the social space.  Customers like LinkedIn,  Gilt Groupe, MySpace, and Myzinga have redefined how consumers interact with each other through music, shopping, and content.  Attensity running on Aster promises to bring together big data and social analytics that starts to deliver on Mr. Lovett’s proposition of deeper social analytics.

Teradata’s strategy to marry big data analytics and marketing applications with its industry-leading database solutions is steeped with the concept of deeper analytics.  In social analytics, we have identified 10 key business questions that should be asked about every social post.   In a market where posts can go viral, impact brand, customer perception, and revenue, being able to quickly and effectively navigate deeper social analytics becomes a mission critical capability.

Beyond John’s questions, the 10 key questions are:

  • What was said?
  • What is it about? (ie,  product, service, brand, experience)
  • Is it a common sentiment?
  • What are the trends on this topic?
  • Who said it?
  • What is their value?
  • How engaged are they?
  • What is their influence?
  • How do I respond?
  • Was my response effective?

To effectively answer these questions CMO’s need a set of marketing technologies.  These include:

  • A social listening platform that analyzes social timelines for owned, embassy and public feeds.  These tools identify what was said, what it is about and if it is a common sentiment.
  • The second level demands a customer hub to understand who posting and what the customer relationship is with them and to measure the customer value of that relationship.
  • The third level requires social network analytics and the ability to find implicit and explicit social connections.  This helps illuminate how engaged customers are and their level of influence – or who influences them
  • The fourth level is where integrated marketing management and customer facing marketing applications come it.  Once you understand what was said, who said it and the potential impact – how do you respond?  Is it a one-on-one conversation, a social discussion or was a bigger issue identified that may result in marketing campaigns?

Are these the right business questions to ask?  What else do you want to know about social media posts in your business?