Design doubt

[prabin meitei]

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

[Petite Abeille]

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@...
For additional commands, e-mail: java-user-help@...