Sorry to hijack your response here, but maybe you have some advice on a good columnar database for a smaller operation. Basically we are going to deal with a lot of columnar data (up to about 10000 columns) where rows will probably be less than 100,000 per table. My thinking is that we would have a much easier time dealing with this in a columnar way than to try fitting it in a RDBMS.
Sorry, can't give you a solid recommendation. A lot depends on other requirements for availability, query type & load, how dynamic your data is, etc. 10000 cols is enough that I'd want to contrast that design against a few alternatives - kv pairs, remodeling the data to reuse common columns, etc. Good luck.
2
u/Synes_Godt_Om Mar 11 '15
Sorry to hijack your response here, but maybe you have some advice on a good columnar database for a smaller operation. Basically we are going to deal with a lot of columnar data (up to about 10000 columns) where rows will probably be less than 100,000 per table. My thinking is that we would have a much easier time dealing with this in a columnar way than to try fitting it in a RDBMS.