I was asked a question about a concern on having indexes and in one case having to duplicate 7 times the data if we move from RDBMS to noSQL DB.
My reply that I wanted to get feedback on(please let me know if I am dead wrong or what else I may be missing) was 1. It's a column based sparse table so null's take up no space(ie. More room when we need to duplicate) 2. Indexes take up space in an RDBMS already and are essentially duplication in your old RDBMS anyways 3. The designs will be quite a bit different eliminating the need for those indexes(maybe we only have 3 later out of the 7, and the indexes in hbase are a bit bigger than indexes in the old RDBMS too???) Thanks for any feedback here Dean This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system.
