secondary index on column store dbs

Question

Hi,

Is there any column store database that supports secondary index ? I know HBase does, but it's not there yet.

Haggai.

Answer 1

Hi Take a look in this class IndexSpecification which is part of r0.19.3.

Here you can see how to use it (maybe they have a test for that as well) I've never used that and don't if it performs well. please share with us your results.

good luck -- Yonatan

Answer 2

By storing overlapping projections in different sort orders, column stores based on the C-Store architecture (so, as far as commericial implementations go, Vertica) natively support secondary indexes. See http://db.csail.mit.edu/projects/cstore/vldb.pdf

Also check out MonetDb, which treats "create index" statements as hints for its self-organizing engine.

Answer 3

Sybase IQ supports as many indexes as you might ever desire on every column and even within a column (e.g. the word index which lets you stay with defaults or specify your own delimiter)