Vertica

Author Archive

Faster Analytics for GoodData

vertica_results_1

Recently GoodData, a provider of end-to-end Cloud BI and data warehouse platform solutions, transitioned from Postgres to a columnar database and shared the details of their migration in a post on their developer blog. Spoiler alert, they chose HP Vertica.

After evaluating multiple columnar databases, GoodData determined that HP Vertica was the best fit to power their platform. Among the speed and features like high availability and massive parallelism Tomáš Jirotka, Product Manager for GoodData, mentions that HP Vertica “is the best product we may have as an underlying database engine of our analytical data marts with large fact tables.” They discovered that HP Vertica performed 3 times faster than on postgres without any special optimizations for a columnar database.

We’re extremely excited that GoodData chose HP Vertica as their Big Data analytics engine of choice and are looking forward to powering their Big Data solutions. Learn more about GoodData’s performance experiments with HP Vertica.

Democratic National Committee Leverages Big Data to Turn Politics into Political Science

As part of our continuing podcast series, Dana Gardner, president and principal analyst for Interarbor Solutions, sits down with Chris Wegrzyn of the Democratic national committee to discuss how HP Vertica proved to be vital to their success in the 2012 presidential elections. Listen to the podcast to learn how Wegrzyn and his team are using Vertica to allocate information from across the entire organization at unparalleled speeds, and create a “smaller and smarter” budget. In addition, not only was Vertica key to identifying exactly who the DNC needed to be focusing their message towards during the previous election, but Wegrzyn assures that it will be heavily involved in all future campaigns as well.

Listen to the podcast or read the transcript.

Announcing the Big Data Hawkathon Winners

What happens when you unleash a few dozen geeks on some big data with a powerful analytics platform like HP Vertica for a day?

There was no fowl play and the results were starling. And yes, they were winging it… Sorry, I couldn’t resist.

At the HP Vertica Big Data Conference, HP Vertica teamed up with the Audubon Society to sponsor the first-ever Vertica Big Data Hackathon — or, as it affectionately became known, Hawkathon! At this event, teams of one to five people spent the day using the HP Vertica Analytics Platform to analyze/visualize interesting Big Data sets. Each team had about seven hours to build something cool. The teams with the best solutions were awarded prizes.

The goal of the Hawkathon was to give people an opportunity to explore HP Vertica’s capabilities in a creative, non-work environment. There were five data sets pre-loaded on the cloud-hosted HP Vertica clusters, including:

  • Apache public email archives
  • Wikipedia website traffic statistics
  • Global weather observations

Perhaps the most interesting data set was the Audubon Christmas Bird Count (CBC) database. The CBC, which provides critical data on bird population trends, was most frequently chosen data set by the Hawkathon teams.
There were really no rules for the Hawkathon. Teams had full root access and could use any other tools they wish. At the end of the day, each team had to demonstrate their work to all other participants and a team of judges. Judging considered the following five categories:

  1. Technical Merit/Use of HP Vertica Features
  2. Completed Solution/Level of Functionality
  3. Ease of Use/Visualization
  4. Impactful/Solve Real-World Problem
  5. Creativity/Wow Factor

After demonstrations, the judges conferred and chose the top three teams. Prizes included HP Slate tablets, Beats Audio headphones, and Amazon gift cards.

The Compete team (the digital marketing optimization service) took third place. Led by Principal Architect, Seth Madison, the Compete team custom developed an application that displayed bird species population trends over time (see graphic above).

The one-man-team from Looker, the business intelligence software company, took second place. Lloyd Tabb, Looker founder and CTO, implemented their self-service BI tool to make CBC data exploration easy.

The first place team did an impressive analysis on the effect of weather on the quality of wine. This team had members from Deloitte Consulting (Jason Chiu), HP Global Delivery (Filip Nowicki), and HP Labs (Daniel Gmach and Alvin AuYoung). They combined several technologies and data sets to isolate the atmospheric attributes that impact wine production and even went so far as to make some wine-type recommendations. Though there were no sommeliers in the room that could confirm or dispute their findings, it is a testament to the infinite uses of HP Vertica and Big Data in general.

This Hawkathon was very successful, in my opinion. The room remained highly energized and participants really got to use the HP Vertica Analytics Platform in new and interesting ways that they might not have had time to do back in the office. Many teams did not want to stop working!

“We were very excited by the degree of interest in Audubon’s Christmas Bird Count dataset, the largest and longest running animal census on the planet. We saw considerable potential in the ideas and applications developed by the competing teams. The results of the Hawkathon offer strong support for our efforts to collaborate with new partners—such as HP Vertica—to address critical conservation challenges, both present and future, ” says Candan Soykan, Quantitative Ecologist at Audubon.

The Hawkathon provided a venue for exploring the capabilities of the HP Vertica Analytics Platform to work with massive quantities of data. Given the explosion of data we’re witnessing, it is more important than ever to have powerful tools to operate upon and monetize this data. As such, we’relooking forward to holding additional hackathons in the near future. Interested in hosting a hackathon or joining one at HP Vertica headquarters in Cambridge? Just let us know!

Doing Everything with Big Data

Earlier this year we invited Chris Wegryzyn, Director of Data Architecture for the Democratic National Committee, to participate in “The Disruptive Power of Big Data,” a webinar discussing how the Vertica analytics platform played a central role in achieving his organizations key focus—to measure everything. As this was one of the most successful programs we’ve run recently, it was a true pleasure to have him back speaking at the HP Vertica Big Data Conference 2013.

The story of how the DNC integrated data analytics into their organization is incredible. They went from having no Big Data program in 2008 to creating one of the most impressive big data analytics organizations we’ve seen in 2012—And Vertica was the heart of their platform. Vertica enabled them to build a single, comprehensive platform that empowered staffers throughout the campaign to utilize data, everything from registered voter lists and social data to data collected by their army of volunteers, to make the right decisions in communicating their message to the voters.

At Vertica we are always talking about the power of real-time insights and how timely business intelligence is critical to making the smartest choices, but the DNC had to take this a step further. As Chris mentioned during the conference, his organization had “the mother of all deadlines.” Every decision had to matter, from each email sent out to potential voters to what media purchases they should make in any given market. All of their data had to be working for them.

Check out this video where Chris discusses how they achieved this. For his organization Big Data analytics became rooted in their philosophy allowing them to translate all of their raw data into insights that fueled their success. At one point in the video, responding to a question about the role of data, Chris smiled and said, “We did everything with data.” That’s the kind of message we can get behind at Vertica.

Did you miss the HP Vertica Big Data Conference? Check out our conference wrap up page to see some of the highlights. We’ll continue to post updates to the page in the coming weeks so don’t be a stranger.

Bird Watching, Vertica, and a Room Full of Data Geeks

Each December the National Audubon Society coordinates the Christmas Bird Count, when masses of avid birdwatchers dust off their binoculars and set out to record the number of birds seen in a predetermined area. This centuries-old survey, first proposed to end the more gruesome tradition of Christmas “side hunts” (when the birds were shot on sight instead of counted), draws thousands of participants from around the globe to collect and record regional population data of birds. This rich data set is used in conservation data each year, but what happens when you let a room full of data geeks loose on this information?

That’s exactly what we set out to answer by hosting our first hackathon (also known as the HAWKathon) at the HP Vertica Big Data Conference 2013. Multiple teams combed through a number of rich data sets, including the Audubon data, Apache data, and Wikimedia and Wikinews page counts, to find hidden data gems and compete for the best discoveries.

Our second place winner, Lloyd Tabb, Founder, Chairman and CTO of Looker, did just that. Lloyd built his solution using the Vertica analytics platform and Looker, his query-based BI tool, to visualize the data. While the dashboard shows a staggering amount of data, one of my favorite observations noted was that three regions, California, Texas, and New York, counted more birds than there were species. I didn’t know Texas had so many bird lovers. Take a look at this graphic to see some of the other discoveries Lloyd made.

This year’s hackathon was an overwhelming success and a huge thanks to all of the participants and organizers, especially the Audubon Society for providing the data and making the hackathon such a great event. We’ll see you at next year’s HP Vertica Big Data Conference.

Stay tuned for more posts about the hackathon and Big Data Conference in the coming weeks.

Data-Driven Decision Making with the Vertica Analytics Platform

Physicians need access to a wealth of critical information from multiple systems in order to make life-saving decisions on a daily basis. Greg Gootee, Product Manager, MZI Healthcare, discusses how their new application, powered by the Vertica analytics platform, helps deliver better patient care through data-driven decision making. Delivering information in a timely manner is central to their application’s success. Check out this video shot at HP Discover 2013 to see how HP Vertica helps Greg and his team provide physicians with the information they need to make more accurate point-of-care decisions. In the video Mr. Gootee recounts how his Aunt may have avoided a tragic incident with better point-of-care services–the type of services MZI Healthcare and the Vertica analytics platform provide.

Backstage with HP Software

Jeff Healey, Director of Product Marketing for HP Vertica, discusses the power of HAVEn, HP’s groundbreaking big data analytics platform at HP Discover 2013.

Get Started With Vertica Today

Subscribe to Vertica