Archive for the ‘Vertica Community Edition’ Category

Partner Interview: Logi Analytics & Haven OnDemand

Logi interview

Last week I sat down with Steven Schneider from Logi Analytics to discuss their integration with the new Haven OnDemand.

HP: What is new with the Haven OnDemand integration with Logi Analytics?

Logi Analytics: So, with IDOL and its new web-services oriented architecture as well as Vertica and its natural SQL layer, you can use Logi’s direct-connect model to not only query and access features, but also integrate that data with other sources.

For example, with Logi you can query your data using Vertica, return the data to IDOL, and execute an operation such as Natural language translation ECT… Then, take the result, and create a visualization. It’s really neat because now you can provide a unified visualization tier on top of both Vertica and IDOL, allowing people to interact with them in a business use-case type environment.

That’s really cool, especially because getting Vertica and IDOl data to work with one another is so incredibly powerful.

Logi Analytics: And that’s kind of unique to us which is why I get excited about it, you know? There are a lot of software BI tools that can talk to SQL and there are some application web environments that can talk to web services. However, to do both of those together and pull them into one unified interface, (and by unified I’m not just talking about two panels, but actually taking the results of one and feeding it into another) enables you to discover completely unique metrics. It’s pretty cool. Check out this video to see a great example of how you can use Logi to come up with a metric to predict churn based on data contained in both IDOL and Vertica independently. It’s pretty interesting and unique.

HP: How does Logi take advantage of Vertica and IDOL specifically?

Logi Analytics: We wanted to let Vertica do what it’s designed to do. Not only does Logi treat it Vertica as a data source, but when the end user wants to do an aggregation or any kind of operation, it’s actually passing those operations back to Vertica. Other BI solutions will say “sure we work with Vertica”, but they’re actually just pulling the data from Vertica and putting it into their own repository to work with it there. That kind of defeats the purpose of Vertica’s speed and high performance analytics doesn’t it? you can’t actually execute a sequence of commands with IDOL or Vertica, you can only load from them initially. From then on, you’re forced to execute commands locally. It’s pretty limiting.

HP: With these new services (IDOL OnDemand, Vertica OnDemand) being available to a wider audience than ever before, what kind of new customers are you looking forward to working with?

Logi Analytics: So there are two kind of avenues. First, there are startups and SMBs in the software industry that want to embed IDOL and/ or Vertica as part of the apps they’re creating. They are trying to get the apps to market quickly and provide proof concepts. That’s a big market for us as we have over 600 OEM partners. These companies may not have had the resources to connect with HP Vertica or Idol in the past, but HAVEn makes it more accessible.

Then there are medium sized companies that maybe aren’t enterprise-sized in their infrastructure, but are still quite complex and have a lot of data they can use – for instance, healthcare and insurance companies.

Regardless of any company’s size Haven makes it easy to create proof concepts and stand up apps without going through the classic corporate IT infrastructure deployment process. In development you don’t need that. They can stand up and they can develop, concurrently with the corporate IT process instead of sequentially.

HP: What’s the coolest use case you’ve encountered with Logi and Haven?

Logi Analytics: I would say Glassbeam, a machine data analytics company, is an interesting one. There’s a great video online that breaks it down. Glassbeam collects unstructured data from machines and converts into structured data based on its own proprietary language, giving customers insight into the performance of their products. They use Logi as their analytics platform and Vertica as their database, allowing them to pass back aggregation and filters to Vertica taking advantage of that deep integration we discussed earlier. Since their implementation, Glassbeam has been able to scale a lot faster.

HP: What are you most excited about for the future of Logi and Vertica?

Logi Analytics: We would love to extend our relationship with Haven OnDemand beyond Logi Info to Logi Vision, our visual analytics slice-and-dice product for business users. We’d also love to expand our role to facilitating the acquisition of data from places like Social media, and analyze it from there, opening up our joint use case to many more organizations.


Gartner Magic Quadrant Released – HP Vertica Enters the Leader’s Quadrant

The Gartner Magic Quadrant has long been recognized as critical research that organizations rely on to weigh, evaluate, and ultimately select vendors as the infrastructure for their IT initiatives.

Yesterday, Gartner released the 2014 Gartner Magic Quadrant for Data Warehouse and Database Management Systems. We are very proud to announce that the HP Vertica Analytics Platform has entered the Leaders Quadrant, gaining in both terms of execution as well as its ability to fulfill our vision of storing, exploring, and serving data and insights to thousands of organizations.

We encourage you to read this complimentary report, as you consider HP Vertica to handle your most extreme Big Data analytics initiatives. And, we especially want to thank all of our innovative customers that push us each and every day to build the best, most scalable, and open analytics platform on the planet.

Want to get started with HP Vertica? Download our Community Edition – it’s free up to 1 TB with no time limit.

Setting the Record Straight on Column Stores (Again?!)

Couple months ago I went to SIGMOD 2012.  One of the big award winners there was Bruce Lindsay (IBM Fellow Emeritus), a true patriarch of relational databases.  (System R; enough said!)

I was somehow drawn to him before I figured out his name, and before I learned that he was an award winner.  Maybe it was the hairdo and mannerisms.

Or maybe it was how he asked the presenters of the paper on “MCJoin” something along the lines of  “So, I’ve written a few join algorithms in my day and one of the things that set me back a few months each time was OUTER JOINs”.  Which, in my day, set me back a few months.

Back to the awards.  Each recipient gave a talk.  Bruce gave a very interesting presentation covering RDBMS, how it built up to something useful over the years, and then considered whether we are “losing our way”.  I was a bit surprised that he listed “column stores” as a “detour” on the path of RDBMS progress.  This is his slide (and, as you view it, try imagine someone in the row in front of you cackling about how Mike Stonebraker would react to it…):


Announcing the Vertica Community Edition

by Colin Mahony, VP of Products & Business Development
and Shilpa Lawande, VP of Engineering

Vertica has had an amazing journey since it was founded in 2005. We’ve built a great product, a great team and an incredibly strong and loyal customer base and partner ecosystem. When we first started, no one had even heard of a column store, and today, ‘Big Data Analytics’ is taking the industry by storm. Every day we see companies – big and small – in industries from retail to gaming becoming more data-driven and doing amazing things with the help of analytics. We feel proud and humbled to see the transformation impact the Vertica Analytics Platform has had on our customers’ businesses, and we believe the time has come to broaden access to our technology to a wider Big Data community.

Today, we are truly excited to announce the Vertica Community Edition beta program! The Vertica Community Edition will offer many of the same features as the enterprise edition of the Vertica Analytics Platform to anyone who wants to discover the power of Vertica.  And, as part of the Community Edition beta announcement, we are developing a new MyVertica Community portal which will provide a platform for Vertica users and partners to interact and share knowledge and code with the entire Vertica user community.

Vertica has always been a customer-driven company and we couldn’t have built Vertica without ideas, feedback and guidance from our customers and partners. We hope that the Vertica community will play a similar role going forward – sharing ideas and best practices and providing candid feedback about the product and how it can be made richer and simpler to use.  The MyVertica community portal will feature product downloads, forums, documentation,  training materials, FAQs and best practice guides. We will also be maintaining a GitHub code repository where community users will be able to share code samples, user-defined extensions built using our SDK, adapters to 3rd party products, and more. We hope that with the Community Edition, we take a small step towards our vision of democratizing data and making data and analytics accessible to all!

To register for the Vertica Community Edition beta program, simply visit and complete the registration form.  The beta program will be limited initially, but full availability of the Vertica Community Edition software is expected by the end of the year.

On behalf of Vertica and HP, we are excited to contribute something back to the Vertica Community.  We sincerely invite you to join and contribute, and we can’t wait to see the many cool things you will do with Big Data and Vertica!

Shilpa & Colin

Get Started With Vertica Today

Subscribe to Vertica