Software // Information Management
Commentary
4/18/2008
09:55 AM
Neil Raden
Neil Raden
Commentary
Connect Directly
RSS
E-Mail
50%
50%
Repost This

Databases ALIVE!

It wasn't so long ago that if you were considering a data warehouse, your choices for a relational database platform were limited to Oracle, IBM, Teradata or Microsoft... Database choices are now back, and then some!

It wasn't so long ago that if you were considering a data warehouse, your choices for a relational database platform were limited to Oracle, IBM, Teradata or Microsoft. In fact, I often wondered where all the choices went. Fifteen years ago, that list would have included lots of other choices. There were standalone database vendors like Sybase (their transactional database that is now Sybase ASE; Sybase IQ was not out in circulation yet), Informix and Red Brick. Most of the hardware vendors had their own offerings, too. We built some pretty good data warehouses for the times with Tandem, but there were also offerings from Digital, HP, Pyramid and probably a few others I've forgotten.

Database choices are now back, and then some.Sybase IQ is steadily building share and getting great reviews, HP has resuscitated Tandem in the huge BI/Neoview push. Informix technology is embedded in DB2 now (and also still sold separately) and Red Brick, believe it or not, is still supported by IBM.

But there is also a resurgence and proliferation of new choices in both pure database technology and data warehouse appliances.

ParAccel is a columnar database, meaning, ingested data records are physically shredded into columns and indexed, but are still addressed as if they are a row-oriented relational database using SQL. The same is true of Vertica. An even more radical departure from the typical row-oriented database is I-lluminate, which actually shreds the data further, down to the values themselves. And another startup, Truviso, reverses the whole process by satisfying "continuous" queries in stream and only saving the data later (and probably not all of it once it's used). SAP offers the BI Accelerator for Netweaver, which is not really a database, but an add-on device that creates indexes and aggregates for SAP's data warehouse [and other sources]. Databases, accelerators, appliances - the taxonomy is a little leaky, I admit, but that's a good thing.

Then there are the data warehouse appliances, which bundle server, storage and database in a box. We can say Netezza pioneered this approach (and it has profited handsomely), but purists will challenge this and point to many offerings in the past that were similar. The difference is that most of these were composed on proprietary hardware and software, but in reality, the current crop of appliances is pretty proprietary too, but that's a different discussion. Netezza, DATAllegro, Greenplum, Dataupia all use an enhanced version of open source database technology, usually Postgres or Ingres, but each has its own characteristics, so I would include them on a list of separate database choices.

I know I've overlooked some, and I surely will hear about it in email and in comments here, but one thing is undeniable - just when people bemoan the consolidation of a market and wring their hands that innovation is over, the market responds with a whole new crop of choices. This scenario plays out over and over. The same is true for the Gang of Four BI vendors now. Our technology landscape is geologically active. It's like a giant pot of onion soup with croutons floating on top, but over time, every one of them sinks and new ones float up.It wasn't so long ago that if you were considering a data warehouse, your choices for a relational database platform were limited to Oracle, IBM, Teradata or Microsoft... Database choices are now back, and then some!

Comment  | 
Print  | 
More Insights
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Elite 100 - 2014
Our InformationWeek Elite 100 issue -- our 26th ranking of technology innovators -- shines a spotlight on businesses that are succeeding because of their digital strategies. We take a close at look at the top five companies in this year's ranking and the eight winners of our Business Innovation awards, and offer 20 great ideas that you can use in your company. We also provide a ranked list of our Elite 100 innovators.
Video
Slideshows
Twitter Feed
Audio Interviews
Archived Audio Interviews
GE is a leader in combining connected devices and advanced analytics in pursuit of practical goals like less downtime, lower operating costs, and higher throughput. At GIO Power & Water, CIO Jim Fowler is part of the team exploring how to apply these techniques to some of the world's essential infrastructure, from power plants to water treatment systems. Join us, and bring your questions, as we talk about what's ahead.