Not sure where to post this question, or what to even search for the answer, so here goes...
I have hours of video downloaded from tape and stored on an external drive (AVI format).
I am looking for a S/W package that will let me catalog the scenes in each AVI file and assign different one or more categories / sub-categories to each scene.
Example, a scene of the family on the beach would be assigned to:
Who:Family
Who:Family:Child #1
Who:Family:Child #2

Where: Hawaii
Where: Beach

So, a year later, I can use this program to instantly find a scene of Child #2 at the Beach in Hawaii.

Here's one I ran across, although I have not used it, it sounds competent. I don't know if you would need to make subclips of your avi's, this has a nesting levels feature that might eliminate that need: Digital Photo and Video Organizer Software for huge Media collections - PicaJet FX. (http://www.picajet.com/en/index.php?page=Digital-Picture-Organizer)

If you have Adobe Bridge, you can view and rank individual clips, though I think you would have to make subclips to catalog and rank the subjects within an overall avi.
Battle Vaughan/miamiherald.com

I have a photo organizer (imatch) that works great.
I worry that a photo organizer that just happens to have support for AVI will work better for photos than AVI's