Digital Eagle

September 7, 2007

Computers: Column-Oriented Databases

Filed under: Uncategorized — Stephen aka DigitalEagle @ 9:11 pm

I just came across this article:

Relational database pioneer says technology is obsolete

Are we really ready to call relational database’s “legacy technology”? My first reaction is that column-oriented will only ever be niche software. The article points out that data can be read faster because the columns are together, but what about writing the data? I would think that while data may be accessed by the column, data would be written by the row. So, I would guess that column databases fit well in the data-warehouse niche, but for day-to-day transactional data, we are still going to use relational databases.

Hopefully, I will get the opportunity to work with such a database so that I can have more than just a first reaction.

BigTable

The most interesting thing to me about the article is the mentioning of BigTable. BigTable is the database that Google uses. Here are some more links on BigTable:

Google Research Publication: BigTable

Wikipedia: BigTable

Jeff Dean in lecture at University of Washington

Apache Hadoop

My next question was, I wonder if Google releases the code for BigTable. The best answer that I could find came from Wikipedia: project Hadoop/project HBase.

Hadoop is part of Apache Lucene.

Wikipedia: Hadoop

Wikipedia: Lucene

Apache Lucene

Hadoop Project

Hadoop FAQ

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: