Method and Apparatus for Entity Removal from a Content Management Solution Implementing Time-Based Flagging for Certainty in a Relational Database Environment

1. A method of validating a request in connection with a content management system having a library server storing an item and a resource manager storing an object associated with the item, said method comprising: in response to receiving a request that affects the item, recording the request in a library server transaction table of the library server, the item comprising an identifier that identifies a location of the object in the resource manager which is external to the library server; identifying a version of the item; determining whether the request affects the object associated with the item, the object comprising a binary object which is stored in at least one of a file system, a file server, a file archive, or a database separate from the library; identifying a version of the object in response to determining that the request affects the object, by retrieving a timestamp and an identifier for the object; determining whether the request is valid based on the version of the item and the version of the object; and in response to determining that the request is not valid, rolling back the request by removing the entry for the request from the library server transaction table; wherein the item has an item identifier that is associated with the item, and the object has an object identifier that is associated with the object; and wherein the object identifier is different than the item identifier.

2. The method of claim 1 , wherein receiving the request comprises receiving a request for deleting the item.

3. The method of claim 1 , wherein identifying the version of the item comprises retrieving a timestamp for the item.

4. The method of claim 1 , wherein identifying the version of the item comprises retrieving the timestamp and an identifier for the item.

5. The method of claim 1 , wherein determining whether the request is valid comprises determining whether the version of the item matches the version of the object; and completing the request if the versions of the item and object match.

6. The method of claim 1 , wherein determining whether the request is valid comprises: determining whether the version of the item is older than the version of the object; and completing the request if the version of the item is older than the version of the object.

7. The method of claim 1 , wherein rolling back the request comprises rolling back any changes made to the item as a result of the request.

8. The method of claim 1 , wherein the item is configured to have multiple objects associated with the item.

9. An apparatus for validating a request in connection with a content management system having a library server storing an item and a resource manager storing an object associated with the item, said apparatus comprising: means for receiving a request that affects the item, and for recording the request in a library server transaction table of the library server, the item comprising an identifier that identifies a location of the object in the resource manager which is external to the library server; means for identifying a version of the item; means for determining whether the request affects the object associated with the item, the object comprising a binary object which is stored in at least one of a file system, a file server, a file archive, or a database separate from the library; means for identifying a version of the object in response to determining that the request affects the object, by retrieving a timestamp and an identifier for the object; means for determining whether the request is valid based on the version of the item and the version of the object; and means for, in response to determining that the request is not valid, rolling back the request by removing the entry for the request from the library server transaction table; wherein the item has an item identifier that is associated with the item, and the object has an object identifier that is associated with the object; and wherein the object identifier is different than the item identifier.

10. An application program for validating a request in connection with content management system having a library server storing an item and a resource manager storing an object associated with the item, said program comprising: program code for receiving a request that affects the item, and for recording the request in a library server transaction table of the library server, the item comprising an identifier that identifies a location of the object in the resource manager which is external to the library server; program code for identifying a version of the item; program code for determining whether the request affects the object associated with the item, the object comprising a binary object which is stored in at least one of a file system, a file server, a file archive, or a database separate from the library; program code for identifying a version of the object in response to determining that the request affects the object, by retrieving a timestamp and an identifier for the object; program code for determining whether the request is valid based on the version of the item and the version of the object; and program code for, in response to determining that the request is not valid, rolling back the request by removing the entry for the request from the library server transaction table; wherein the item has an item identifier that is associated with the item, and the object has an object identifier that is associated with the object; and wherein the object identifier is different than the item identifier.

11. The medium of claim 10 , further comprising program code for receiving a request for deleting the item.

12. The medium of claim 10 , further comprising program code for retrieving a timestamp for the item.

13. The medium of claim 10 , further comprising program code for retrieving the timestamp and an identifier for the item.

14. The medium of claim 10 , further comprising program code for retrieving a timestamp for the object.

15. The medium of claim 14 , further comprising program code for retrieving the timestamp and an identifier for the object.

16. The medium of claim 10 , further comprising: program code for determining whether the version of the item matches the version of the object; and program code for completing the request if the versions of the item and object match.

17. The medium of claim 10 , further comprising: program code for determining whether the version of the item is older than the version of the object; and program code for completing the request if the version of the item is older than the version of the object.

18. A method of processing requests that delete an item in connection with a content management system having a library server storing an item and a resource manager storing an object associated with the item, said method comprising: in response to receiving a request that deletes the item, recording the request in a library server transaction table of the library server, the item comprising an identifier that identifies a location of the object in the resource manager which is external to the library server; identifying a first age of the item affected by the request; determining whether the request affects the object associated with the item, the object comprising a binary object which is stored in at least one of a file system, a file server, a file archive, or a database separate from the library identifying a second age of the object in response to determining that the request affects the object; determining whether the request is valid based on the first age and the second age; selectively deleting the item and the object based on whether the first age of the item is greater than or equal to the second age of the object; and in response to determining that the request is not valid, rolling back the request by removing the entry for the request from the library server transaction table; wherein the item has an item identifier that is associated with the item, and the object has an object identifier that is associated with the object; and wherein the object identifier is different than the item identifier.

19. An apparatus for processing requests that delete an item in connection with a content management system having a library server storing the item and a resource manager storing an object associated with the item, said apparatus comprising: means for receiving a request that deletes the item, and for recording the request in a library server transaction table of the library server, the item comprising an identifier that identifies a location of the object in the resource manager which is external to the library server; means for identifying a first age of the item affected by the request; means for determining whether the request affects the object associated with the item, the object comprising a binary object which is stored in at least one of a file system, a file server, a file archive, or a database separate from the library; means for retrieving information indicating a second age of the object in response to determining that the request affects the object; determining whether the request is valid based on the first age and the second age; means for selectively deleting the item and the object based on whether the first age of the item is greater than or equal to the second age of the object; and means for, in response to determining that the request is not valid, rolling back the request by removing the entry for the request from the library server transaction table; wherein the item has an item identifier that is associated with the item, and the object has an object identifier that is associated with the object; and wherein the object identifier is different than the item identifier.