METHOD FOR DEFERRED DELETION OF ENTRIES FOR A DIRECTORY SERVICE BACKING STORE

• US 20080077584A1
• Filed: 11/06/2007
• Published: 03/27/2008
• Est. Priority Date: 04/29/1999
• Status: Active Grant

• Current Assignee: David Bachmann, Terry Dunkle
• Original Assignee: David Bachmann, Terry Dunkle
• Inventors: Bachmann, David, Dunkle, Terry
• Granted Patent: US 7,895,203 B2
• Time in Patent Office: Days
• US Class Current: 707/5
• CPC Class Codes: G06F 16/24554 Unary operations; Data partitioning operations
• CPC Class Codes: Y10S 707/962 Entity-attribute-value
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99953 Recoverability
• CPC Class Codes: Y10S 707/99957 Garbage collection

Abstract

A method for deleting entries from a directory in which directory information is stored in a set of database tables begins upon a request to delete a directory entry. In response, the directory entry is tagged, preferably by setting the entry'"'"'s creation time to a null value. If a search query is received thereafter, the routine excludes tagged entries from search results that would otherwise satisfy the search query. Periodically, the routine searches for tagged entries, and references to the tagged entries are then deleted throughout the set of database tables. Thus, the inventive method defers entry deletions to enable directory queries to be processed even if deleted entries have not yet been fully expunged from the directory.

Claims

1-10. -10. (canceled)

14. A method in a data processing system for searching a database from a directory service, comprising the steps of:

receiving a search query at the data processing system for a directory wherein the directory service is a Lightweight Directory Access Protocol (LDAP) directory service and the database is managed by a relational management service,

responsive to a search by the data processing system for directory entries that satisfy the search query, excluding given entries from search results that otherwise satisfy the search query, wherein the given entries identify database entries that have been tagged for deletion by setting a creation time of the directory entry to a predetermined value; and

returning by the data processing system the search results.

11. The method as described in claim 14, wherein the predetermined value is a null value.

12. The method as described in claim 14, wherein database entries that have been tagged for deletion are tagged in a first database table of a set of database tables that comprise the database and wherein the first database table is an entry table.

13. The method as described in claim 12 wherein the set of database tables includes at least one attribute table storing information about an attribute.

23. The computer implemented method of claim 14, wherein excluding tagged directory entries includes modifying an SQL query to exclude rows having a null change creation.

16. A computer program product in a computer-readable storage medium for searching a database from a directory service, comprising:

instructions for receiving a search query for a directory wherein the directory service is a Lightweight Directory Access Protocol (LDAP) directory service and the database is managed by a relational management service;

instructions responsive to a search for directory entries that satisfy the search query for excluding given entries from search results that otherwise satisfy the search query wherein the given entries identify database entries that have been tagged for deletion by setting a creation time of the directory entry to a predetermined value, and

instructions for returning the search results.

15. The computer program product of claim 16, wherein the predetermined value is a null value.

17. The computer program product as described in claim 16, wherein database entries that have been tagged for deletion are tagged in a first database table of a set of database tables that comprise the database and wherein the first database table is an entry table.

18. The computer program product as described in claim 17 wherein the set of database tables includes at least one attribute table storing information about an attribute.

24. The computer program product of claim 16, wherein the instructions for excluding tagged directory entries includes instructions for modifying an SQL query to exclude rows having a null change creation.

19. A directory service, comprising:

a bus;

a communications unit connected to the bus;

a storage device connected to the bus wherein the storage device includes computer usable program code;

a directory organized as a naming hierarchy having a plurality of entries each represented by a unique identifier, wherein the directory is compliant with the Lightweight Directory Access Protocol (LDAP);

a relational database management system having a backing store for storing directory data in a set of database tables; and

a processor unit connected to the bus wherein the processor unit executes the computer usable program code to receive a search query for a directory wherein the directory service is a Lightweight Directory Access Protocol (LDAP) directory service and the database is managed by a relational management service;

responsive to a search for directory entries that satisfy the search query exclude given entries from search results that otherwise satisfy the search query wherein the given entries identify database entries that have been tagged for deletion by setting a creation time of the directory entry to a predetermined value, and return the search results.

20. The directory service as described in claim 19 wherein the predetermined value is a null value.

21. The directory service as described in claim 19, wherein database entries that have been tagged for deletion are tagged in a first database table of a set of database tables that comprise the database and wherein the first database table is an entry table.

22. The directory service as described in claim 21 wherein the set of database tables includes at least one attribute table storing information about an attribute.

25. The directory service of claim 19, wherein the processor executing computer useable program code to exclude tagged directory entries further comprises the processor executing computer useable program code to modify an SQL query to exclude rows having a null change creation.