locked
Help with the design of a content management system RRS feed

  • Question

  • Dear Architects

    Would you please help me with finding a good design approach for the following scenairos?

    We are going to design a kind of content publishing system in which:

    1- Content is stored in binary "doc, pdf, jpg.." format.

    2- For doc and docx types, an xml copy is stored as well (this is a business need)

    3- some meta data such as country of origin, last review date etc is stored.

    4- there is a versioning requirement which means a document (along with its meta data) might be duplicated and then modified as a new version.

    5- there is a need of searching in the (primarily) content of the xml , (if possible) content of the doc, docx and pdf files as well as the meta dta.

    6- an external xml editor tool (the company is using Arbertext XML editor) will be used to check-out , edit and check-in the xml (and some times) .doc file.

    my questions are:

    1- where is the best place to store the xml and doc files? is SharePoint a good one? it provides versioning, check-in and check-out features.  in

    2- if I store the xml and doc files in SharePoint, will I be able to search and find them based on their content? (i.e. search for AREF in the body of a .doc) . Does SharePoint or any add-ins such as FAST search server provide xpath /xquery features?

    3- is storing in DB a good idea? what search facilities will I need fo search an xml file ? (xQuery?)  .

     p.s. is there any good XML editor that I can use to replace Arbortext XML editor? The reason that the organisation loves this old tool is tht it is very good at editing SGML docs. and also it allowes applying stylesheets on the xml docs.

    Thanks

    Wednesday, June 8, 2011 12:29 AM

Answers

  • Hi Arefk,

    First you need to know more information about SharePoint, I suggest to read more about sharepoint features and SharePoint search capabilities.

    About questions I have some knowledge about question 1 & 2.

    1.                    Where is the best place to store the xml and doc files? Is SharePoint a good one? It provides versioning, check-in and check-out features.

    §   SharePoint have great Content Management features, and good choice when you need great tool to store, archive, search and create documents. For more information http://sharepoint.microsoft.com/en-us/product/capabilities/content/Pages/Content-Management-System.aspx

     

    2.                    If I store the xml and doc files in SharePoint, will I be able to search and find them based on their content? (i.e. search for AREF in the body of a .doc) . Does SharePoint or any add-ins such as FAST search server provide xpath /xquery features?

    §   Yes, SharePoint can find documents based on their content, it your company has a lot of information with a lot of different document formats (Office docs, PDF, Webpages, txt …..) SharePoint search vary good option. And about xpath /xquery sharepoin I don’t know a lot of info but you can custom SharePoint search. For more information http://sharepoint.microsoft.com/en-us/product/capabilities/search/Pages/Search-Server.aspx

     

    Finally, I suggested that I move this question to the SharePoint forums.

    I hope you'll find this helpful

    Regards,


    • Marked as answer by ArefK Thursday, June 9, 2011 4:47 AM
    Wednesday, June 8, 2011 8:07 AM

All replies

  • Hi Arefk,

    First you need to know more information about SharePoint, I suggest to read more about sharepoint features and SharePoint search capabilities.

    About questions I have some knowledge about question 1 & 2.

    1.                    Where is the best place to store the xml and doc files? Is SharePoint a good one? It provides versioning, check-in and check-out features.

    §   SharePoint have great Content Management features, and good choice when you need great tool to store, archive, search and create documents. For more information http://sharepoint.microsoft.com/en-us/product/capabilities/content/Pages/Content-Management-System.aspx

     

    2.                    If I store the xml and doc files in SharePoint, will I be able to search and find them based on their content? (i.e. search for AREF in the body of a .doc) . Does SharePoint or any add-ins such as FAST search server provide xpath /xquery features?

    §   Yes, SharePoint can find documents based on their content, it your company has a lot of information with a lot of different document formats (Office docs, PDF, Webpages, txt …..) SharePoint search vary good option. And about xpath /xquery sharepoin I don’t know a lot of info but you can custom SharePoint search. For more information http://sharepoint.microsoft.com/en-us/product/capabilities/search/Pages/Search-Server.aspx

     

    Finally, I suggested that I move this question to the SharePoint forums.

    I hope you'll find this helpful

    Regards,


    • Marked as answer by ArefK Thursday, June 9, 2011 4:47 AM
    Wednesday, June 8, 2011 8:07 AM
  • I don't know about searching contents.

    That sounds like it could be pretty resource intensive.

    Otherwise it sounds like Sharepoint is a good match.

    You want to ask some Sharepoint specialists though.

    Wednesday, June 8, 2011 10:15 AM
  • Shameless plug: EMC ApplicationXtender meets all of your requirements, including full text search.  It has a services based SDK as well.

    Evan

     

    Wednesday, June 8, 2011 12:16 PM