I just poked around at the ResourceSpace site and the one thing they're not saying is where the assets in the database are coming from. It looks like a tool to search their assets, not to catalog your own.
Take a look at Microsoft Expression Media 2. I use it for pictures, but you can also catalogue other media files (video). And you can create several data bases, one for pictures , one for video files and so on.
It seemed that PPro had some sort of tool that would make use of Acrobat (of all things!) to let clients mark up and review footage. That kind of sounds like a feature you're looking for. A way to review long clips and mark regions in them, and then to search for the regions later on.
Yes, one of the functions we're talking about is pretty much a logging feature, or the sort of situation where you give footage to someone and have them mark selections or go through and catalog the shots.
I tried Premiere Element indexing features (just for the kick)... Probably the most slugish thing i installed on my computer since 5 years and no scene indexation...
I tried CatDV today. Very professionnal, convenient and fast. The thing i need... But no native support for wmv, mpeg2, avchd, etc. It is entirely based on QT. *Could* work with a Java plugin but i did'nt find how yet and the Windows file (other than avi) support looks rather buggy...
Yeah, the feature list for CatDV seemed like what you're looking for since it'll let you mark regions within a clip, do something like storyboards, export EDLs, etc. The file support probably fleshes out more as you install quicktime codecs but I'd like to see something similar that wasn't so tied to quicktime.
It's also a little pricey for an application that's not *quite* what you'd want, but I thought it was a good example.