Method and systems for concurrent collection and generation of shared data

1. A method for controlling concurrent access to a shared resource in a distributed computing environment, comprising:

receiving a first access request to write first data, during a first session associated with a first user, to a shared resource having a fixed size, the first data including a structured query language (SQL) statement to write data to the shared resource, the database including the shared resource represented as a linked list;

based on receipt of the first access request, checking a status indicator counter to determine if any concurrent session associated with a second user is reading any data from the shared resource by requesting a list of SQL statements from the shared resource, the status indicator:

i) being incremented each time a new read concurrent session is initiated,

ii) being decremented each time an existing read concurrent session is released,

iii) having a value of zero when no read concurrent session is running, and

iv) showing that no concurrent session is reading any data from the shared resource when the list of SQL statements issued to the shared resource has been sent to the second user;

based on a determination that no concurrent session is reading any data from the shared resource and that writing the first data to the shared resource will exceed the fixed size of the shared resource, removing oldest data from the shared resource and writing the first data as newest data of the shared resource; and

based on a determination that any data from the shared resource is being read during any concurrent session, preventing the oldest data in the shared resource from being removed until the status indicator indicates that no concurrent session is reading any data from the shared resource, the shared resource further including stored third data that is younger than the second data and older than the first data.

2. The method of claim 1 , wherein the status indicator is a Boolean flag that is set to TRUE when the at least one concurrent session is running and set to FALSE when the at least one concurrent session is not running.

3. The method of claim 1 , wherein the status indicator is a counter that is incremented each time a new read concurrent session is initiated and decremented each time an existing read concurrent session is released, wherein no read concurrent session is running when a value of the counter is zero.

4. The method of claim 1 , wherein the first data comprises a structured query language (SQL) statement to write data to the shared resource, the database including the shared resource.

5. The method of claim 1 , wherein any concurrent session reading any data from the shared resource is requesting a list of structured query language (SQL) statements issued to the shared resource, the status indicator showing that no concurrent session is reading any data from the shared resource when the list of SQL statements issued to the shared resource has been sent to the second user.

6. A non-transitory computer-readable storage medium encoded with instructions, which when executed, cause one or more processors to:

receive a first access request to write first data, during a first session associated with a first user to a shared resource having a fixed size, the shared resource being represented as a linked list;

based on receipt of the first access request, check a status indicator counter to determine if any concurrent session associated with a second user is reading any data from the shared resource by requesting a list of SQL statements from the shared resource, the status indicator:

i) being incremented each time a new read concurrent session is initiated,

ii) being decremented each time an existing read concurrent session is released,

iii) having a value of zero when no read concurrent session is running, and

iv) showing that no concurrent session is reading any data from the shared resource when the list of SQL statements issued to the shared resource has been sent to the second user;

based on a determination that no concurrent session is reading any data from the shared resource and that writing the first data to the shared resource will exceed the fixed size of the shared resource, remove oldest data from the shared resource and write the first data as newest data of the shared resource; and

based on a determination that any data from the shared resource is being read during any concurrent session, prevent the oldest data in the shared resource from being removed until the status indicator indicates that no concurrent session is reading any data from the shared resource, the shared resource further including stored third data that is younger than the second data and older than the first data.

7. The computer-readable medium of claim 6 , wherein the status indicator is defined as a Boolean flag that is set to TRUE when the at least one concurrent session is running and set to FALSE when the at least one concurrent session is not running.

8. A content management system for providing controlled access to a shared resource in a distributed computing environment, comprising:

a repository having access and storage operations controlled by at least one content server; and

the content server including a content management framework, for integrated operation with the repository, and further comprising a processor-based application, which when executed by at least one computer associated with the content server, will cause the processor to:

receive a first access request to write first data, during a first session associated with a first user, to a shared resource having a fixed size in the data repository, the first data including a structured query language (SQL) statement to write data to the shared resource, the database including the shared resource represented as a linked list;

based on receipt of the first access request, check a status indicator counter to determine if any concurrent session associated with a second user by requesting a list of SQL statements from the shared resource, the status indicator:

i) being incremented each time a new read concurrent session is initiated,

ii) being decremented each time an existing read concurrent session is released,

iii) having a value of zero when no read concurrent session is running, and

iv) showing that no concurrent session is reading any data from the shared resource when the list of SQL statements issued to the shared resource has been sent to the second user;

based on a determination that no concurrent session is reading any data from the shared resource in the repository and that writing the first data to the shared resource will exceed the fixed size of the shared resource, request removal of oldest data from the shared resource and request that the first data be written to the repository as newest data of the shared resource, the writing inserting the first data into the linked list, the writing and removing maintaining the fixed size of the shared resource; and

based on a determination that any data from the shared resource in the repository is being read during any concurrent session, generate a command to prevent the oldest data in the shared resource from being removed until the status indicator indicates that no concurrent session is reading any data from the shared resource in the repository, the shared resource further including stored third data that is younger than the second data and older than the first data.

9. The content management system of claim 8 , wherein the status indicator is a Boolean flag that is set to TRUE when the at least one concurrent session is running and set to FALSE when the at least one concurrent session is not running.