Cassandra二级索引

Question

我只想学习Cassandra，并尝试将RDBMS设计转换为Canssandra。考虑到我的应用程序正部署在多个数据中心。

数据库设计：

       A) CF : USER
              1) email_id - primary key
              2) fullname
              3) organization - ( I didnt create a separate table for organization )

       B) CF : ORG_USER

             1) organization - Primary Key
             2) email_id

             Here, my intention is to get users belong to an organization.
             Here, I can make the organization in the user table as secondary index, but heard that, this may hit the performance.
             Could you please clarify me which is the better approach?

谢谢，Baskar.S

Answer 1

只要基数较低，组织可能是二级索引的一个很好的候选者。换句话说，如果您有许多重复的组织值，请使用辅助索引。如果不是这样，手动构建索引(正如您在ORG_USER CF中指出的那样)是一种很好的方法。