Also check out
iView Media, now Microsoft Expression Media. It comes as a part of Office 2008. I've used some earlier versions of it and it's a pretty powerful catalog-store-retrieve solution. As most solutions it requires some heavy lifting in the input of the media in order to reap any benefits at the back end.