topic Re: document store update concurrency in ODS and Base Reporting

document store update concurrency

BenConner — Tue, 28 Feb 2017 14:17:28 GMT

Hi,

Does anyone know if different concurrent processes can update a document store? I have a document store as the name of the project and there are several long running process generating output to different folders within it.

Thanks!

--Ben

Re: document store update concurrency

RW9 — Tue, 28 Feb 2017 14:29:49 GMT

What software are you talking about, this seems to have nothing to do with Base SAS where you have posted? Clarify your question, provide software/version, examples etc.

Re: document store update concurrency

Kurt_Bremser — Tue, 28 Feb 2017 14:38:18 GMT

An ODS document store is a single .sas7bitm file. Since operating systems only allow write access to a file for one process at a time (and lock others out), I don't think that concurrent processes can write to a single document store at a given time.

Re: document store update concurrency

Kurt_Bremser — Tue, 28 Feb 2017 14:39:38 GMT

PS I moved the thread to the ODS community.

Re: document store update concurrency

BenConner — Tue, 28 Feb 2017 15:04:16 GMT

Thanks for switching it to the right area, Kurt. Been working with it so much lately I forget it is part of ODS.

Since SAS can support record-level locking for SAS datasets, was hoping the same might be true of document stores. I will construct a test case to verify it.

Thanks!

--Ben

Re: document store update concurrency

Kurt_Bremser — Tue, 28 Feb 2017 15:16:31 GMT

Record locking is part of the capabilities of a SAS/SHARE server, a specialized product for this type of requirements. And there it only works on SAS datasets, not on anything else.

A SAS .sas7bitm file is more like a zip or tar archive, not like a database table.

Re: document store update concurrency

BenConner — Tue, 28 Feb 2017 15:21:32 GMT

Ah. Thanks, Kurt. Good to know! I can always just use different stores for the individual components of this report group.

Ben