How to buy an analytic DBMS (overview)
I went to London for a couple of days last week, at the behest of Kognitio. Since I was in the neighborhood anyway, I visited their offices for a briefing. But the main driver for the trip was a seminar Thursday at which I was the featured speaker. As promised, the slides have been uploaded here.
The material covered on the first 13 slides should be very familiar to readers of this blog. I touched on database diversity and the disk-speed barrier, after which I zoomed through a quick survey of the data warehouse DBMS market. But then I turned to material I’ve been working on more recently – practical advice directly on the subject of how to buy an analytic DBMS.
I started by proposing a seven-part segmentation self-assessment:
- What is your tolerance for specialized hardware?
- What is your tolerance for set-up effort?
- What is your tolerance for ongoing administrative burden?
- What are your insert and update requirements?
- At what volumes will you run fairly simple queries?
- What are your complex queries like?
- Are you madly in love with your current DBMS?
That’s my way of unpacking such general questions as:
- What are your deep-seated platform prejudices?
- What kinds of skilled administrative personnel do you have available?
- What are the key drivers of TCO in your shop?
and
-
What are your real performance requirements?
Then I got even more direct, drilling down into the four-stage analytic DBMS buying process:
- Figure out what you’re trying to buy
- Make a short list
- Do free POCs
- Evaluate and decide
The least obvious part of that drill-down was probably my points on making sure you actually were building the evaluation around the right use cases, and hence the right target queries. I plan to say much more about that part soon. Stay tuned.
Related link
Comments
10 Responses to “How to buy an analytic DBMS (overview)”
Leave a Reply
Curt, you visited Kognitio, an analytical DBMS vendor that is pitching “data as a service,” and don’t see as an explicit, general question, “Would you be better off with a hosted solution?”
Kognitio’s isn’t the only hosted analytical DBMS that comes to mind of course. There’s also, for instance, LucidEra for folks doing performance management. And — the reason I mention LucidEra particularly — there’s what should possibly be your question 8:
8. What’s your budget?
That question springs relates to LucidEra because the analytical DBMS that backs LucidEra, LucidDB, if free, open source, as are the MonetDB analytical DBMS and MySQL+Infobright.
Seth,
I certainly agree that the “Are you hopelessly prejudiced?” class of questions is important. But while “Are you hopelessly prejudiced in favor of your incumbent DBMS?” and “Are you hopelessly prejudiced against specialized hardware?” will each get enough “Yes”es to be deserve top billing, I don’t see the same sort of commitment yet to data warehousing SaaS. It’s a rare buyer that won’t seriously consider an inhouse solution.
As for “Check your budget” — I seriously hope I don’t have to put THAT on a slide in an hour-long talk.
CAM
Yeah, you’re right. Hosted data warehousing holds an infinitesimal market share. Still, there are other examples such as Vertica’s use of the Amazon cloud.
Regarding budgets, (to further argue against myself), there’s the truism that data integration and cleansing can be expensive, and open source does not eliminate those labor costs.
Seth,
Exactly.
But the real reason it’s not in those slides is just a matter of expository flow. The points you raised were in the words of my talk much more than they were in the slides.
And even so the word “cost” is in them at least twice. I checked. 😉
My theory is that a large fraction of the discussion boils down to TCO anyway. Cash cost for license and maintenance fees may or may not be a big part of overall TCO. And to the frustration of my clients at Kognitio, I’m not in love with the argument that eliminating capex is a huge benefit in and of itself. After all, one can usually just lease the equipment one buys.
Home…
General Philosophy Extreme Lucidity Products Cloudera Cloud Service Customers Market Research Scale Unlimited Survey…
OK. That has to be one of my odder trackbacks …
Curt, that trackback was not supposed to happen :), this is our internal wiki. Checking into reason, thanks for pointing out. (would appreciate it you delete it).
Thx,
— amr
Amr,
Not to worry. Experience shows that trackback technology is not exactly bulletproof …
Best,
CAM
Curt,
We are currently in the process of selecting a DBMS vendor and I am trying to compare the TCO of different vendors. I came across this article quoting Gartner research:
http://www.teradata.com/library/pdf/tco.pdf
This seems dated (2001) and wondering what relevance it has in today’s market. Can you comment?
Thank you
Arvind.
Arvind,
I’m not even going to look at a 2001 Gartner quote, unless it’s for historical reasons. 😉
http://www.monash.com/adviseusers.html may be relevant, however. 🙂