Media Manager has got to be one of the worst DBMS implementations I've ever seen, and I don't know what SCS is thinking. (actually I do).
The only benefit I see is that it reads the tags on Sony loops. The darned thing is convoluted and not optimized or intuitive.
It seems to me that the media-tags relationship is backwards, and the queries take too long. I can't "feel" the schema, and I get the impression that the data is built with "brute force" recursive queries.
And why can't it be a standalone app too? That way we can open it when we feel in the mood to "organize".