It's not always practical or affordable for large enterprises to consolidate their disparate systems that store unstructured content such as documents, Web material, and digital media. Yet maintaining these siloed applications introduces different costs and risks, including lack of security and records management. ECM (enterprise content management) systems address these shortcomings while leaving your existing file servers and other repositories in place. Although ECMs typically require yet another database, users continue accessing their existing desktop files and processes, while the content manager provides centralized storage, indexing, versioning, workflow, retention, and other services.

The Bottom Line Oracle Universal Content Management 10g R3 Oracle Corp, oracle.com Excellent  8.7 criteria score weight Ease-of-use 9 25% Features 8 25% Scalability 9 15% Security 9 15% Management 9 10% Value 8 10% Cost: Starts at $100,000 per processor Platforms: Microsoft Windows (32-bit), Linux x86, z/Linux, Solaris (SPARC 32- and 64-bit and x86), AIX5L, HP-UX PA-RISC Bottom Line: Oracle UCM is a unified solution for securely managing documents, images, and other digital assets, plus Web sites. Content is delivered -- to the Internet, intranets, applications, and wireless devices -- using various methods, including Web services, HTTP, and RSS. Version 10g R3 has extensive Windows Explorer and Outlook integration, works with Microsoft SharePoint, and includes comprehensive search. Additionally, UCM includes strong information rights and records management. About our Reviews and Scoring Methodology

[ See also: InfoWorld Technology of the Year Awards Data Management winners ]

One of the better ECM products was Stellent Universal Content Management, which Oracle acquired when purchasing Stellent in late 2006. As you might expect, the renamed and updated Oracle UCM (Universal Content Management) Release 10g R3 is now better integrated with Oracle's other products. For example, UCM has an out-of-the-box provider for Oracle Database (making it easier to configure the database and to perform backups). Plus, as part of Oracle Fusion Middleware, UCM is "hot pluggable" into existing Oracle servers and can take advantage of the company's grid infrastructure, such as application clusters.

Click for larger view.

UCM Version 10g R3 is also more open than previous incarnations. An included Web Part lets users work with content from within Microsoft SharePoint. Additionally, there's new Outlook e-mail integration, smoother operation with Windows Explorer, and an automated WSDL generator that makes it easier to integrate UCM with other applications that consume Web services.

Content in, content out
I've been hammering away at Oracle UCM -- which includes Oracle Content Server, document management modules, and the universal content management pieces (Web content management, digital assets management, and records management) -- for a few weeks on a Windows Server 2003 machine. Oracle Database 10g XE was my database engine. My overall impression is that better usability, integration, and filing (more than 400 file formats are automatically converted using Web services) make UCM an excellent offering.

Contributing content to the repository required no extra steps as I dragged and dropped Microsoft Word and other document types from my desktop to a UCM folder that appeared within Windows Explorer. Oracle automatically applied metadata, while adding options to pop-up menus for document management functions such as Check Out. Similarly, Oracle-managed folders within Microsoft Outlook let me submit e-mails and attachments as records; I then managed this content directly from Outlook (such as searching and taking it offline for editing).

When I placed high-resolution images into a managed folder, UCM automatically created variations at different sizes and resolutions, such as ones appropriate for the Web.

The Web interface to UCM, a personalized portal for each user, now includes a leaner look and context-specific menus. Search enhancements, however, make up the bulk of changes. The new query builder helped me create advanced queries without writing any complex Boolean logic. Moreover, it was easy to narrow searches using metadata that was associated with documents. UCM takes this a step further by employing metadata depending on circumstances or a person's role. For example, you can search for only items containing a product name that is in your workflow.