FAQ
Hi,
I have a scenario as described below
user U1 - books purchased ,b1, b5, ... so on
user U2 - books purchased ,b2, b7, ... so on
...
...
...
Un - books purchased b1, b2 .... so on

how can a design an index in such a way that
- i can search who purchased a book say b1, sort the result by purchase date
- find all the users who purchased a book say b1 in last 30 days
- find users who matches certain criteria and also purchased a book say b1
(sort by purchased date)

the details of the user is large , so i do not want to have multiple entry
for same user in the index.

Thanks in advance for any help.

Regards,
Prabin

Search Discussions

  • Petite Abeille at Nov 5, 2009 at 6:33 am

    On Nov 5, 2009, at 7:18 AM, prabin meitei wrote:
    how can a design an index in such a way that
    - i can search who purchased a book say b1, sort the result by
    purchase date
    - find all the users who purchased a book say b1 in last 30 days
    - find users who matches certain criteria and also purchased a book
    say b1
    (sort by purchased date)
    Sounds like you would be better off using a proper relational model
    for the purpose at hand...

    Tangentially relevant link:

    "Double-thinking in SQL"
    http://explainextended.com/2009/07/12/double-thinking-in-sql/

    Cheers,

    --
    PA.
    http://alt.textdrive.com/nanoki/


    ---------------------------------------------------------------------
    To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
    For additional commands, e-mail: java-user-help@lucene.apache.org

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupjava-user @
categorieslucene
postedNov 5, '09 at 6:19a
activeNov 5, '09 at 6:33a
posts2
users2
websitelucene.apache.org

2 users in discussion

Petite Abeille: 1 post Prabin meitei: 1 post

People

Translate

site design / logo © 2022 Grokbase