Urgent: Help needed to integrate alfresco

[itsard]

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 records
and the data being stored in the file system.Also, if there are too many records for an application, wont the metadata table
contain a lot many records affecting the performance in turn? and 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.

[zaizi]

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.

[itsard]

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.