Author Archive

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.


Financial Analytics with HP Vertica and Vichara Technologies


If you’re an investor on Wall Street you want to know with a good amount of certainty that you aren’t throwing your money into a crapshoot. As it turns out, the government feels the same way. Since the Financial crisis of 2008, the government has added regulations for FSIs (Financial Services Institutions) to follow in order to prevent a repeat scenario. Financial organizations rely on FSIs like Vichara Technologies in order to analyze risk and to provide a comprehensive, aggregated view of a firm’s potential to default at any point of time. As you can imagine, those analyses require looking at a LOT of data.

Take this particular case:

The Monte Carlo method is a common way of producing a VaR (Value at Risk) analysis for the future of FSI’s many accounts by running millions of simulations based on existing data sets. A VaR is essentially a snap shot of the level of risk within a firm at any given point in time. A risk-balance sheet, if you will. The Monte Carlo method of determining a VaR works by running simulations based on past data, say a year’s worth, and then using the results to determine the maximum losses a firm can incur over a year’s time within a percentage of certainty (95% is most common).

In other words, imagine you’re at a poker table with your friends on a Friday night and in the pot is the equivalent to the combined yearly income of everyone at the table. But instead of taking a leap of faith and calling for a raise based on the way your buddy Dave is picking his nose, you get to play the same hand over and over and over again in your head (millions of times) in order to see how the odds are stacked against you with let’s say around 95% accuracy. Imagine being able to do all of that before you decide to fold or go all in with your life’s savings. This type of analysis is used by firms every day to calculate risk effectively and efficiently, so the faster one can run them the more accurate they can be. That’s where HP Vertica and Vichara come into play.

Vichara Technologies deals with these types of risk-modeling calculations every day, and was in need of an upgrade from their Legacy DB. With HP Vertica leading the charge on reinventing RDBMS, it was the obvious choice. In two recent use cases, Vichara was able to leverage its risk assessment software, vLense, on top of the HP Vertica database to totally revolutionize the way these two companies looked at their financial risk analytics. For you engineers out there, V lens is a lot like a Visual studio for C++, but for their own custom language, VQuery, specializing in financial analysis.

Using vLens on top of HP Vertica, the two companies involved in these cases were able to pull from their own data, instead of having to outsource to 3rd parties like Moodys and Fannie Mae. This not only granted them autonomy, but allowed them to create daily reports rather than waiting days, if not weeks, to get the answers they needed. In addition, the data was no longer hidden behind a few programmers running custom scripts to ETL the data. Now even portfolio managers can use the intuitive query builder interface to create ad-hoc queries on the fly. From analyzing the data, they can then easily export the results into SAS or R for further insight. Transparency at its finest.

Wrapping it all up, the folks at Vichara touched on one of the crucial aspects of Vertica during the webinar: the most bang for your buck. Use whatever hardware you want and start small and go big.We aren’t tying you to a multi-million dollar physical ball and chain that might be outdated in a year,we scale when you scale, and we won’t take your arm and leg in the process.

Check out the webinar here to learn more.


HP Discover: Introducing HP Vertica OnDemand


Yesterday the sun rose over the beautiful city of Barcelona, and with it, HP Discover. Back in Cambridge MA the excitement is just as high as we finally get to reveal to the world what we’ve all been tirelessly working on. We have some great announcements for you from the HP Vertica platform, one of which is the exciting launch of HP Vertica OnDemand.

So let’s say you’ve got a startup with an awesome product , but you still have a pretty tight budget. We understand, we’ve been there. Small organizations like yours face challenges in Big Data and analytics every day. But now there’s good news—HP Vertica OnDemand!

HP Vertica OnDemand, provides a solution that allows for flexible scaling and pricing, and also provides the same speed and performance our customers have come to expect from our Enterprise Edition of HP Vertica Analytics Platform.

From the start, we designed HP Vertica OnDemand to be easy to set up, hassle-free, and fast. You can get set up in under 30 minutes and be running complex SQL queries in no time, performing geopatial and predictive analytics, advanced timeseries, and much, much more.

Finally there’s the price. Budgets can be tight, and we wanted to provide a service that could fit an organization’s needs without costing an arm and a leg. Starting at $999 a month, HP Vertica OnDemand is the perfect solution to start small, and scale easily to whatever your needs might be in the future. Interested? You can learn more here

You can also follow along with all of the action in Barcelona with the HP DISCOVER Insider

Throwback Thursday: Our Ascent has begun!

Around 5 years ago there was a time where you could fit the names of every Vertica employee on a single poster. Today let’s just say it would take something much bigger, perhaps a tapestry. This particular poster was put together after we launched in 2007. Hats off to Ben Vandiver for hanging onto this piece of Vertica history! Here we are 7 years later, still climbing with no signs of slowing down.


Throwback Thursday: The Andover Office

We all catch ourselves thinking about the past from time to time. The good ol’ days, the bad ones, the “meh” ones. It’s all part of the adventure that got us here to today. At Vertica, we’ve certainly had quite the journey since our founding in 2005, and there are still many grizzled Vertica veterans in our ranks to this day. Starting this week we’ll be sharing some of our fond memories of the past, both for Vertica, and the Big Data industry in general.

Old Vertica Office

Our first entry is a snapshot from 2008 of the old Andover offices. Ben Vandiver, one of our Senior Engineers, recalled that the conference room heating was so bad, they had to jury-rig a pipe to route the heat exhaust from our data center into the room to stay warm. Ingenuity at it’s finest ladies and gentlemen. Needless to say we’ve come a long way since then, but you gotta love the start up days, and that that mentality still lives on here today.

DbVisualizer Free for HP Vertica

DB Visualizer for HP Vertica

As a special service to Vertica users and the Big Data community, we have released a new version of DbVisualizer, DbVisualizer Free for Vertica, which is now available for free on the HP Vertica Marketplace. This is an optimized version of DB Visualizer that is unique to Vertica, as it is customized specifically for unique Vertica functions, like viewing projections, and some features usually reserved for the pro version such as multiple execution options. Now available for download here.

Get Started With Vertica Today

Subscribe to Vertica