This was my long pending question in my mind. I found a article by Justin Ball that resembles my ideas . Really good one.

http://www.justinball.com/2007/09/24/how-to-manage-60000-digital-photos/