JISC Digital Media has released "Systems for Managing Digital Media Collections."
Here's an excerpt :
Everyone's collection and context is unique, so your choice of a system (or systems) for managing your media will require a careful assessment of your needs and resources and an evaluation of the available options. This paper provides an overview of a number of different approaches to digital media management: from some very cheap and 'low-tech' approaches to much more complex and specialised solutions. Another paper in this series discusses some of the commonly available functionality in more detail and raises some key questions to consider when choosing a system . . .
We have given more than thirty examples of systems below, with links to further descriptions on JISC Digital Media's website or to external sites. These examples are not meant to be exhaustive or to imply any sort of endorsement or criticism: they are offered for information purposes only. This is a competitive and fast-changing environment, in which new versions are pushed out, new systems emerge, and last year's cutting-edge features become standard issue.