Deprecated: Function split() is deprecated in /home/tbriggs/public_html/s9y/plugins/serendipity_event_metadesc/serendipity_event_metadesc.php on line 101

Links for the Week

Regarding the last link in this list, I have to ask: is there any reason InfoBright's approach couldn't be applied to a row-based system? Sounds a lot like Netezza Zone Maps to me... Thoughts/opinions/answers, anyone? (InfoBright, are you listening?)

• I'm not 100% positive, but I believe that these comments are about Ab Initio. Regardless, this sounds like another potential piece of a Data Management System.

Don't Just Do Something, Stand There! Avoiding Junior DBA Mistakes - This article is four years old, but it's still damn good advice.

Vertica Analytic Database for the Cloud - This could very quietly become the biggest shock to the database industry since Netezza.

Oracle Caches In on Its Acquired TimesTen Technology - Interesting thoughts on Oracle's use of its TimesTen product. Multi-temperature databases, anyone?

SQL Server 2008 Data Warehousing Solutions - Setting aside the fact that the title sounds like an oxymoron, I'm not sure there's anything here other than "me too" features. MS clearly continues to close the gap on Oracle and DB2 though, at least feature-wise.

• A good write-up about InfoBright by David Raab. Maybe I just haven't looked hard enough, but this is the first lucid description of why InfoBright is different that I've seen.

Trackback specific URI for this entry

No Trackbacks

On the surface, Netezza’s zone maps appear to be similar but actually what we are doing is very different. We collect metadata (of various types) on subsets of the column data, all columns regardless of type. In addition, we use this information for many different purposes during query execution and optimization. We have full information at the metadata layer and use it to execute queries. This is how we achieve fast query on very large data sets.

The techniques we are using could be applied to a row oriented database, but the combination of the knowledge grid and compression are more suited to a column oriented database.

If you would like to discuss further I would be happy to spend some time with you.

Cheers -Victoria
Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.