topic Re: Urgent: Help needed to integrate alfresco in Alfresco Archive

Urgent: Help needed to integrate alfresco

itsard — Thu, 09 Jul 2009 11:55:42 GMT

We are planning to integrate Alfresco DMS and RMS with our existing system.Our HR, Payroll and other common modules have a lot of complex applications.Our concern is how would the relational database integrity be maintained in Alfresco database as it stores just the metadata for recordsand the data

Re: Urgent: Help needed to integrate alfresco

zaizi — Thu, 09 Jul 2009 18:59:30 GMT

Our concern is how would the relational database integrity be maintained in Alfresco database as it stores just the metadata for records
and the data being stored in the file system.

Transactional integrity is maintained when content is uploaded, edited and deleted.

Also, if there are too many records for an application, wont the metadata table
contain a lot many records affecting the performance in turn?

Have you got 100 million records? http://www.alfresco.com/media/releases/2008/01/unisys-benchmark/

if we have to generate some complex reports on this data, where each field(Metadata) is stored in a other row,how it will affect the performance.

Compute aggregate values overnight and run your reports against them. You might want to take a look at reporting tools such as Pentaho or Jasper to assist you if you need a fully fledged reporting solution.

Re: Urgent: Help needed to integrate alfresco

itsard — Mon, 13 Jul 2009 07:00:27 GMT

Thanks for your reply.
I have another query.
I am using the DMS WebServices API for uploading and manipulating the content and other things.
I wish to provide the username and password just once to start the session and use the ticket that is generated for subsequent calls.
Now the AuthenticationUtils.startSession method initiates the session but how do i provide the ticket to other subsequent calls
to validate if the ticket is valid.