Automatic electronic mail notification of database events

• US 5,548,753 A
• Filed: 09/14/1994
• Issued: 08/20/1996
• Est. Priority Date: 09/14/1994
• Status: Expired due to Term

• Current Assignee: Johnson Controls Technology Company (Johnson Controls International plc)
• Original Assignee: Johnson Service Company
• Inventors: James, Gregory B., Linstead, Steven A.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US08/305,773
• Time in Patent Office: 706 Days
• Field of Search: 395/600, 395/154, 364/419.17, 382/13
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/107 Computer-aided management of electronic mailing [e-mailing]

Abstract

The invention provides a method for providing an indication of the occurrence of events within a database system. The database system stores data accessible by a plurality of users and in a plurality of data formats. The method comprises the steps of periodically reading a storage location within the database, detecting a data structure stored in the storage location and reading the data structure. The method further includes the steps of converting the data structure from the first data format to a second data format and providing the indication to at least one user, the indication including at least a portion of the data structure.

Claims

1. A method for providing an indication of the occurrence of a predetermined event within a database system, said database system storing data, said data being accessible by a plurality of users, said data being stored in a plurality of data formats, said plurality of data formats including a first data format, the method comprising the steps of:

using a daemon process operating independently from said database system to automatically and repetitively read a predetermined storage location within said database;

detecting a data structure having said first data format stored in said predetermined storage location;

reading said data structure;

converting said data structure from said first data format to a second data format; and

providing said indication to at least one user of said plurality of users, said indication including at least a portion of said data structure.

2. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 1 wherein said data structure comprises a message and wherein said converting step comprises converting said message to message data having a text format.

3. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 2 wherein said message comprises enclosures and wherein said converting step comprises converting said enclosures to enclosure data having a PICT format.

4. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 2 wherein the method comprises the further step of storing said message data having a text format as a first picture.

5. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 4 wherein the method comprises the further step of storing said enclosure data having a PICT format as a second picture.

6. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 4 wherein the method comprises the further steps of extracting said message data from said first picture.

7. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 6 wherein the method comprises the further steps of creating an electronic mail message containing said indication and conveying said electronic mail message to said at least one user.

8. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 7 wherein said indication comprises said message data.

9. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 4 wherein the method comprises the further steps of extracting said enclosure data from said second picture.

10. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 2 wherein said message comprises one or more recipient addresses and wherein said converting step comprises converting said one or more recipient addresses to address data having a PICT format.

11. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 10 wherein the method comprises the further step of storing said address data having a PICT format as a second picture.

12. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 11 wherein the method comprises the further steps of extracting said address data from said second picture.

13. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 12 wherein the method comprises the further steps of creating an electronic mail message containing said indication and conveying said electronic mail message to said at least one user.

14. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 13 wherein said indication comprises said message data and wherein said electronic mail is conveyed to said at least one user in response to said address data.

15. A method for providing an indication of the occurrence of a predetermined event within a database system, said database system storing data on a server processing system, said data being accessible by a plurality of client processing systems coupled to the server processing system on a network, said data being stored in a plurality of data formats, said plurality of data formats including a first data format, the method comprising the steps of:

using a daemon process operating independently from said database system to automatically and repetitively scan a predetermined storage location within said database on said server processing system;

detecting a data structure having said first data format stored in said predetermined storage location;

reading said data structure;

converting said data structure from said first data format to a second data format;

providing said indication to at least one client processing system, said indication including at least a portion of said data structure.

16. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 15 wherein said data structure comprises a message and wherein said converting step comprises converting said message to message data having a text format.

17. A method for providing an indication of the occurrence of predetermined events within a database system as recited in claim 16 wherein said indication is provided to said at least one client system by the further steps of creating an electronic mail message containing said message data in said text format and conveying said electronic mail message to said at least one client processing system.