you can create the inverted index in the same CF ... just means you
would have potentially lots more rows ...
do you have a use-case or hypothetical you can share? if not ... here's one.
http://code.google.com/p/oauth-php it has an RDBMs suggested
model.... http://oauth-php.googlecode.com/svn/trunk/library/store/mysql/mysql.sql
how would you model that? self serving as it's my plan today / tomorrow ....
On Thu, Jun 23, 2011 at 6:43 PM, mcasandra <mohitanchlia@gmail.com> wrote:
> How should one go about creating a data model from RDBMS ER into Big Table
> Data model? For eg: RDBMS has many indexes required for queries and I think
> this is the most important aspect when desiging the data model in Big Table.
>
> I was initially planning to denormalize into one CF and use secondary
> indexes. However I also read that creating secondary indexes have
> performance impact. So other option is to create inverted index. But it also
> seems to be bad to have too many CFs. We have requirements to support high
> volume min of 500 writes + 500 reads per sec.
>
> What would you advise?
|