Actually I think in the video they said they store each messageID as a seperate column, that way they can do range queries correct?<br><br>so it would be:<br><br>aloha: { message1: &quot;2343&quot;, message2: &quot;9590002&quot;, ....}<br>
<br><div class="gmail_quote">On Thu, Jul 1, 2010 at 6:25 PM, S Ahmed <span dir="ltr">&lt;<a href="mailto:sahmed1020@gmail.com">sahmed1020@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
So trying to map how facebook implemented a CF of type Super to index message terms.<br><br>Is this json representation correct?<br><br>MessageIndex = {<br><br>   userid1 : {<br><br>    aloha : { messageIdList: &quot;234,2343234,23423434,234255,345345,2342,532432&quot;},<br>

    clown : { messageIdList: &quot;632, 2342, 23452, 234234, 234234&quot;},<br>    ..<br>    ..<br>    ..<br>   },<br><br>   userid2 : {<br><br>       eating : { messageIdList: &quot;234,2343234,23423434,234255,345345,2342,532432&quot;},<br>

    studying : { messageIdList: &quot;632, 2342, 23452, 234234, 234234&quot;},<br>    ..<br>    ..<br>    ..<br><br>   }<br><br>}<br><br><br>So if a user searches for the term &quot;clown&quot;, they you perform a lookup in the CF named &quot;MessageIndex&quot;, and use do a lookup for the row of the currently logged in user by UserID (which is the key), and then look for a a CF with the term &quot;clown&quot; and return the value.<br>

<br>Is this a proper representation and am I using the correct terminology?<br><br><br>
</blockquote></div><br>