topic Data model cleanup in Alfresco Archive

Data model cleanup

thijslemmens — Thu, 05 Sep 2013 08:21:05 GMT

Dear allA big client of ours is using Alfresco in an archiving use case. They are putting in documents and custom metadata for over 5 years now, and have been extending the model on a regular basis. The repository contains about 8 million documents. The document model has a lot of unused fields and

Re: Data model cleanup

mitpatoliya — Thu, 05 Sep 2013 09:24:45 GMT

This is very tricky job even though you have all the tools.
I must say unless it is really necessary don't go for this.
If you have properties which are not used anywhere and you want to remove them you can directly change the model and do full re-indexing. That way all the references of old property will be removed from the contents.

Re: Data model cleanup

thijslemmens — Wed, 16 Oct 2013 06:45:45 GMT

Thanks for the comment. I agree that it is tricky, but it is not only unused properties. Some properties are duplicated with a slightly different name and should be merged. Some inheritance structures should be changed. It would need a long path of compatible document model changes and scripts. At least, we will test it thoroughly first before concluding it is possible.