I know that the subject indicates maybe a post on the wrong forum, but the questions are not on data access properly speaking.
I have to re-design a module that displays multimedia catalogs for 3G mobile phones.
The catalogs are stored as trees in a database. The tree is changing with the connexion type and with time (for ex. porn categories are displayed only after certain hours of the day). At each page we must know the mother and daughters of the category, and sometimes the little-daughters.
For now, each time a connexion is made on the site, the tree is built with DAO's, and kept in HTTP session. A node of the tree (for example a video) is accessed via a request parameters like this :
And after that, a recursive method was browsing the whole tree until it found the node.
I was wondering :
1) is there a better way to organise url's (like /cat1/cat12/cat121?videoid=54321), to go straight to the node
2) how could I implement in an elegant manner a servlet that would allow the browsing of the tree (subclassing DispatcherServlet ?)
3) how could I limit the amount of data hold into the session
Thanks for your answsers.
PS : sorry for my poor english