PUSH-MODEL BASED INDEX DELETION

• US 20090106324A1
• Filed: 10/19/2007
• Published: 04/23/2009
• Est. Priority Date: 10/19/2007
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Mehta, Suhas R., Gutlapalli, Hari K., Kothari, Shirish K., Pak, Wai
• Granted Patent: US 9,594,784 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2228 Indexing structures

Abstract

A method and apparatus for push-model based index deletion. In one embodiment of the method, a first transaction is generated for deleting a first data object from memory. A first message is generated in response to generating the first transaction, wherein the first message comprises information related to an identifier of the first data object, and wherein the first message comprises information that indicates that the first data object was or will be deleted. The first message is then transmitted to a computer system that implements a search engine.

Claims

1. A method comprising:

generating a first transaction for deleting a first data object from memory;

generating a first message in response to generating the first transaction, wherein the first message comprises information related to an identifier of the first data object, and wherein the first message comprises information that indicates that the first data object was or will be deleted;

transmitting the first message to a computer system that implements a search engine.

2. The method of claim 1 further comprising an act of the search engine deleting one or more instances of the identifier from a search index

3. The method of claim 1 wherein the search engine generates the identifier of the first data object using the information related to the identifier of the first data object.

4. The method of claim 3 wherein the first data object comprises a first record within a table of a database, wherein the information related to the identifier comprises a name of the table and a row number of the table that contains the first record.

5. The method of claim 1 wherein the information related to the identifier is the identifier.

6. A method comprising:

a search engine receiving a first message from a computer system that is in data communication with a memory system, wherein the first message comprises information related to an identifier of a first data object, and wherein the first message comprises information that indicates that the first data object was or will be deleted from the memory system;

deleting one or more instances of the identifier from a search index.

7. The method of claim 6 further comprising the search engine generating the identifier of the first data object using the information related to the identifier of the first data object.

8. The method of claim 6 wherein the information related to the identifier, is the identifier.

9. The method of claim 6 the first data object comprises a first record within a table of a database, wherein the information related to the identifier comprises a name of the table and a row number of the table that contains the first record.

10. A computer readable memory (CRM) comprising computer executable instructions, wherein a method is implemented in response to executing the computer executable instructions, the method comprising:

generating a first transaction for deleting a first data object from memory;

generating a first message in response to generating the first transaction, wherein the first message comprises information related to an identifier of the first data object, and wherein the first message comprises information that indicates that the first data object was or will be deleted;

transmitting the first message to a computer system that implements a search engine.

11. The CRM of claim 10 wherein the first message comprises an instruction to delete one or more instances of the identifier from a search index.

12. The CRM of claim 10 wherein the first data object comprises a first record within a table of a database, wherein the information related to the identifier comprises a name of the table and a row number of the table that contains the first record.

13. The CRM of claim 10 wherein the information related to the identifier, is the identifier.

14. A computer readable memory (CRM) comprising computer executable instructions, wherein a method is implemented in response to executing the computer executable instructions, the method comprising an act of deleting one or more instances of an identifier from a search index in response to a first computer system receiving a first message from a second computer system that is in data communication with a memory system, wherein the first computer system implements a search engine, wherein the first message comprises information related to an identifier of a first data object, and wherein the first message comprises information that indicates that the first data object was or will be deleted from the memory system.

15. The CRM of claim 14 wherein the method further comprises an act of generating the identifier of the first data object using the information related to the identifier of the first data object

16. The CRM of claim 14 wherein the information related to the identifier, is the identifier.

17. The CRM of claim 14 wherein the first data object comprises a first record within a table of a database, wherein the information related to the identifier comprises a name of the table and a row number of the table that contains the first record.

18. An apparatus comprising:

means for generating a first transaction for deleting a first data object from memory;

means for generating a first message in response to generating the first transaction, wherein the first message comprises information related to an identifier of the first data object, and wherein the first message comprises information that indicates that the first data object was or will be deleted;

means for transmitting the first message to a computer system that implements a search engine.

19. The apparatus of claim 18 further comprising means for deleting one or more instances of the identifier from a search index.

20. The apparatus of claim 18 further comprising means for generating the identifier of the first data object using the information related to the identifier of the first data object.