Alfresco & XML databases

[jeroen]

Hi,

Has anyone experience in using an XML database (e.g. Berkeley DB XML) for Alfresco? The xml objects (files) in the database would contain both the data (that is, links to the files stored in a directory) and metadata. So, the objects would be represented using a kind of wrapper format (e.g. METS - http://www.loc.gov/standards/mets/)  containing both a piece of XML metadata and pointers to the actual files.

Would that be possible with Alfresco?

Thanks in advance
Best regards,
jeroen

[norgan]

Hi Jeroen,
you have to distinguish between the repository and the clients.

The repository supports a set of SQL databases and provides a set of interfaces APIsto the "top" and "side", namely JCR, CMIS, Webdav, CIFS, SOAP, REST and some others, I am sure. The interface towards the database uses hibernate. So either, you have a hibernate interface for your database, or the work to use an XML database for that should be considerable, I guess. But maybe, somebody here has done an SQL -> XML migration here?

The clients can do, whatever you want If your database implements a webservices or JCR interface, you should be up and going in no time. But only for the logic, you implement yourself in the client.

Norgan

[groutal]

If you would like to perform a SQL to XML data migration, you can use Talend Open Studio.

It is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes.

For more information: http://www.talend.com/