Tuesday, March 30, 2010

Please don't puzzle on Column-Stores

Daniel Abadi have a blog post here:
http://dbmsmusings.blogspot.com/2010/03/distinguishing-two-major-types-of_29.html

I want to leave a comment and to correct it here:

It is meaningless to compare the two groups, they target to different applications. I think the post just make more confusion. And what Mr. Stonebraker said is also not right.

I think the only thing which make these confusions is the term "column" in Group A. In fact, it is not traditional "column" of RDBMS area. And your example of a traditional spreadsheet table is also not the real target of Group A. The "column" name in Group A is in fact data (not schema).

If have got to change the term, I think we can change the term "column" in Group A to "end-key". In fact, in Bigtable, there is no column, it is "qualifier".

In short:
(1) Group A's "column" is in data, not schema.
(2) Group B's "column" is in schema.
They are different in conception and application target.

6 comments:

  1. This is such a great resource that you are providing and you give it away for free. I love seeing websites that understand the value of providing a quality resource for free. Want to find out the net worth of your favorite entrepreneurs, athletes, actors, celebrities? See more in Celebrity net worth.

    ReplyDelete
  2. If you have any medical condition like injury or disability then you should see a kinesiologist. We have an experienced team of kinesiologists who can offer the benefits of both practices and ensure optimal healing and strengthening of your body. At SpinWise, we provide Kinesiology sessions in Melbourne that can be used as an alternative to counselling and psychotherapy, particularly where the cause of the malaise is unconscious, or relevant to past life experiences.
    mobile wallet uae

    ReplyDelete
  3. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
    3D Laser Scanning Targets
    3D Scanning Reverse Engineering
    Reverse Engineering Services

    ReplyDelete
  4. Excellent Blog to read. You have shared a useful information. Thank you.
    SEO Training in Chennai
    SEO Course in Chennai

    ReplyDelete