How to answer queries of form "Give me the top 10 messages"

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

How to answer queries of form "Give me the top 10 messages"

mobiledreamers
Hey guys
how do we answer queries of type - give me the top 10 messages
or top 10 users and so on
thanks


Example: SuperColumns for Search Apps

You can think of each supercolumn name as a term and the columns within as the docids with rank info and other attributes being a part of it. If you have keys as the userids then you can have a per-user index stored in this form. This is how the per user index for term search is laid out for Inbox search at Facebook. Furthermore since one has the option of storing data on disk sorted by "Time" it is very easy for the system to answer queries of the form "Give me the top 10 messages". For a pictorial explanation please refer to the Cassandra powerpoint slides presented at SIGMOD 2008.

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: How to answer queries of form "Give me the top 10 messages"

Jonathan Ellis-3
Have you read this?

http://blog.evanweaver.com/articles/2009/07/06/up-and-running-with-cassandra/

On Fri, Jul 10, 2009 at 4:43 PM, <[hidden email]> wrote:

> Hey guys
> how do we answer queries of type - give me the top 10 messages
> or top 10 users and so on
> thanks
>
> Example: SuperColumns for Search Apps
>
> You can think of each supercolumn name as a term and the columns within as
> the docids with rank info and other attributes being a part of it. If you
> have keys as the userids then you can have a per-user index stored in this
> form. This is how the per user index for term search is laid out for Inbox
> search at Facebook. Furthermore since one has the option of storing data on
> disk sorted by "Time" it is very easy for the system to answer queries of
> the form "Give me the top 10 messages". For a pictorial explanation please
> refer to the Cassandra powerpoint slides presented at SIGMOD 2008.
Loading...