XML Schema and XML Content

cornekloppers — Tue, 27 Feb 2007 12:54:08 GMT

Hi allI'm currently investing a lot of time looking into utilizing JCR forgetting a huge amount of content under control (Legislative- andparliamentary data).Background information:I'm busy implementing XSD's for defining the document content structures foreach document type found within a Legislati

Re: XML Schema and XML Content

kbpair — Tue, 27 Feb 2007 14:53:47 GMT

We are in a similar situation and have been evaluating Alfresco. I think we will end up with two products - Alfresco for coarse grained Query and a native XML Database like MarkLogic for fine grained queries.

Here is my thinking, and I would love for someone from Alfresco to tell me I am wrong or just comment on this topic.

If you want your xml indexed so that you can run fine grained queries with XPath or XQuery against elements inside the XML document you cannot do it with Alfresco. Alfresco will let you do text based queries resulting in a google-like search and you can do XPath queries against only the JCR nodes (not the content of the nodes).

Alfresco does give you great coarse grained access, meaning if you want to find the whole document and you know the main search criteria, you can create your repository accordingly. You can also create different views of the data with templates but users cannot dynamically reformat the data as you can with XQuery. Users access content via defined 'views' and search via defined properties about the content (plus the text based search mentioned above).

Your question takes the logical step of breaking up the xml document with the help of a schema into JCR nodes. I am not aware of an automated way to do this and I think the volume of nodes that would create would be very large.

I thought I read somewhere Alfresco is hoping to one day be able to handle 1 billion nodes, but I think that may require multiple repositories and federated search. I do not know enough to really speak on this.

Our situation requires millions of updates each night and I do not think we could do this with Alfresco at that level.

I really wish there was a product that combined the fine-grained access of an XML Database with the coarse-grained access of a JCR implementation but I know of no product that does this today.

I think it may be on Alfresco's roadmap though.

Hope that helps and I would love to hear from Alfresco on the subject.

topic Re: XML Schema and XML Content in Alfresco Archive

XML Schema and XML Content

Re: XML Schema and XML Content