InfoWorld publishes annual awards for data management applications. It selected Oracle UCM (formerly Stellent) as the best enterprise content management application and SDL-Tridion as the best web CMS. Both of these products have their strengths: UCM enables you to share documents stored natively in Microsoft Word as web pages relatively easily, while Tridion boasts impressive workflow capabilities likely to meet any web publishing need. Nevertheless, these products have a common shortcoming in a significant area.

While content management software is designed to manage content — words and media are processed, stored and delivered in a controlled fashion — this management itself needs to be managed: workflows need to be created, users added and withdrawn, permissions changed. The most important aspect of this management is changing how content is defined. This generally takes two forms: management of a taxonomy or classification system, and management of the “content types”, or schema that defines whether you’re looking at a press release, event or personal profile. It is extremely unlikely that you’ll get all these definitions right when you first set up your CMS, so the ability to alter and extend the systems is paramount.

Tridion and Oracle both struggle in this area. As a static publishing system, if you want to update a component (content type) in Tridion, you need to republish your schema, add content definitions in each place you’ve made a schema change and then republish the content. In UCM meanwhile, if you can navigate to the relevant administration area to actually make the change and fathom out the unnecessarily ugly interface, you still need to republish the schema and all the affected content even though it’s dynamically driven! You even need to do this if you make a change to the metadata schema, because this isn’t stored in the database as an index, but as a string in a field. This is something you’d expect Oracle to correct pronto with the 11g release due Q4 2008.

You might have thought this kind of thing would be pretty high up most vendors’ agenda, but this is a problem for many CMS. Vignette works ok unless you customise the schema, which many users do. You probably need to look at Mediasurface Morello if you think your content types are likely to change. The product allows you to rename and add fields as required. You need to change the presentation template if you want to see the field you’ve added displayed on a web page, and you run into trouble if your new field needs to be mandatory since your existing content won’t include this information, but it’s considerably easier to manage the content management this way than to republish an entire site.

So caveat emptor. Updating your schema should be an essential part of any CMS product selection, irrespective of awards.