Computer implemented method for transforming an event notification within a database notification infrastructure

• US 20070250545A1
• Filed: 04/19/2006
• Published: 10/25/2007
• Est. Priority Date: 04/19/2006
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Mishra, Shailendra, Surlaker, Kapil
• Granted Patent: US 9,390,118 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

A computer implemented method for automatically transforming an event notification within a database notification infrastructure based on client specified formatting and/or editing procedures. The method includes transforming the event notification having a format compatible with a database using a client specific format conversion procedure into a client-compatible event notification format. Further, the method may include transforming the payload portion of the event notification having a format compatible with a database using a client specific format conversion procedure into a linear event notification format. Moreover, the method may include transforming the event notification using a client specific editing procedure. The client specified procedures may be specified during event registration by the client. The transformed and/or edited event notifications may be forwarded to the client.

Claims

1. A computer implemented method for processing an event notification within a notification infrastructure of a database system, said method comprising:

receiving an event registration, wherein said event registration specifies a client-compatible event notification format;

logging said event registration into an event queue of said database notification infrastructure;

accessing an event notification related to said event registration and having a format compatible with said database system;

transforming said event notification having a format compatible with said database system into a client-compatible event notification of said client-compatible event notification format using a client specific format conversion procedure, wherein said client specific format conversion procedure is stored on said database notification infrastructure.

2. The method as recited in claim 1 further comprising:

delivering said client-compatible event notification to said client.

3. The method as recited in claim 2, wherein said event registration also specifies a client-specific event notification delivery mechanism and wherein said delivery uses said delivery mechanism.

4. The method as recited in claim 3, wherein said delivery mechanism is selected from the group comprising:

electronic mail;

http;

delivery over a network to a user specified host and port; and

invocation of a stored PL/SQL procedure.

5. The method as recited in claim 2, wherein said delivering does not require said client to be logged into said database system.

6. The method as recited in claim 1, wherein said client-compatible event notification format is a linear format.

7. The method as recited in claim 6, wherein said linear format is selected from the group comprising:

text;

HTML; and

XML.

8. The method as recited in claim 1, wherein said format compatible with said database system is an ADT event notification format.

9. The method as recited in claim 1, wherein said event registration also specifies said format conversion procedure.

10. A computer implemented method for processing an event notification within a notification infrastructure of a database system, said method comprising:

receiving an event registration, wherein said event registration specifies a linear event notification format;

logging said event registration into an event queue of said database notification infrastructure;

accessing an event notification related to said event registration and having a format compatible with said database system;

transforming a payload portion of said event notification having a format compatible with said database system into an event notification of said linear format using a client specific format conversion procedure, wherein said client specific format conversion procedure is stored on said database notification infrastructure.

11. The method as recited in claim 10 further comprising:

delivering said event notification of said linear format to said client using a client specific event notification delivery mechanism and wherein said event registration also specifies said client-specific event notification delivery mechanism.

12. The method as recited in claim 11, wherein said delivery mechanism is selected from the group comprising:

electronic mail;

http;

delivery over a network to a user specified host and port; and

invocation of a stored PL/SQL procedure.

13. The method as recited in claim 11, wherein said delivering does not require said client to be logged into said database system.

14. The method as recited in claim 10, wherein said linear format is selected from the group comprising:

text;

HTML; and

XML.

15. The method as recited in claim 10, wherein said event notification having a format compatible with said database system is an ADT event notification.

16. The method as recited in claim 10, wherein said event registration also specifies said conversion procedure.

17. A computer implemented method for processing an event notification within a notification infrastructure of a database system, said method comprising:

receiving an event registration, wherein said event registration specifies a client specific editing format of said event notification;

logging said event registration into an event queue of said database notification infrastructure;

accessing said event notification related to said event registration and having a format compatible with said database system;

transforming said event notification into a client specific edited event notification of said client specific editing format using a client specific editing procedure, wherein said client specific editing procedure is stored on said database notification infrastructure.

18. The method as recited in claim 17 further comprising:

delivering said client specific edited event notification to said client.

19. The method as recited in claim 18, wherein said event registration also specifies a client-specific event notification delivery mechanism, and wherein said delivering uses said client specific event notification delivery mechanism.

20. The method as recited in claim 19, wherein said delivery mechanism is selected from the group comprising:

electronic mail;

http;

delivery over a network to a user specified host and port; and

invocation of a stored PL/SQL procedure.

21. The method as recited in claim 18, wherein said delivering does not require said client to be logged into said database system.

22. A computer readable medium having stored therein instructions that when executed by a processor implement a method of processing an event notification within an event notification infrastructure of a database system, said method comprising:

receiving an event registration, wherein said event registration specifies a client-compatible event notification format;

logging said event registration into an event queue of said database notification infrastructure;

accessing an event notification related to said event registration and having a format compatible with said database system;

transforming said event notification having a format compatible with said database system into a client compatible event notification of said client compatible event notification format using a client specific format conversion procedure, wherein said client specific format conversion procedure is stored on said database notification infrastructure.

23. The computer readable medium as recited in claim 22 further comprising:

delivering said client-compatible event notification to said client.

24. The computer readable medium as recited in claim 23, wherein said event registration also specifies a client-specific event notification delivery mechanism and wherein said delivery uses said delivery mechanism.

25. The computer readable medium as recited in claim 24, wherein said delivery mechanism is selected from the group comprising:

electronic mail;

http;

delivery over a network to a user specified host and port; and

invocation of a stored PL/SQL procedure.

26. The computer readable medium as recited in claim 23, wherein said delivering does not require said client to be logged into said database notification infrastructure.

27. The computer readable medium as recited in claim 22, wherein said client-compatible event notification format is a linear format.

28. The computer readable medium as recited in claim 27, wherein said linear format is selected from the group comprising:

text;

HTML; and

XML.

29. The computer readable medium as recited in claim 22, wherein said format compatible with said database system is an ADT format.

30. The computer readable medium as recited in claim 22, wherein said event registration also specifies said format conversion procedure.