Electronic mail interface for a network server

• US 5,826,269 A
• Filed: 06/21/1995
• Issued: 10/20/1998
• Est. Priority Date: 06/21/1995
• Status: Expired due to Term

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Hussey, Peter
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Corrielus, Jean M.
• Application Number:
  US08/493,095
• Time in Patent Office: 1,217 Days
• Field of Search: 395/600, 395/650, 395/200.8, 395/200.01, 395/200.11, 395/292, 395/500, 395/200.03, 395/200.3, 395/800.01, 707/10, 707/2, 707/3, 707/500, 707/526, 707/5, 707/9, 707/7, 707/104
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/06311 Scheduling, planning or task assignment for a person or group
• CPC Class Codes: G06Q 10/107 Computer-aided management of electronic mailing [e-mailing]
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99937 Sorting
• CPC Class Codes: Y10S 707/99939 Privileged access
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A networked system for processing queries for a server in a distributed processing environment is provided. The system includes a plurality of clients disposed for communication with a database server through an electronic mail system. The server includes an electronic mail interface for receiving queries submitted by the clients, and transmitting the corresponding response. A processor is also provided for processing the queries submitted from the clients, and submitting the queries on to the scheduler. The processor operates to provide bi-directional communication between the mail interface and the scheduler. In addition, the processor retrieves mail messages from the mail interface, translates them into a format recognized by the server, receives query results from the server, and returns the results with the appropriate user identification to the mail interface. A scheduler, provided in connection with the server, provides automated scheduled execution of the mail processor in accordance with a set of programmed tasks.

Claims

1. A networked system for processing queries on a networked database server in a distributed processing environment, comprising:

at least one client having an electronic mail interface for submitting a query via an electronic mail system and receiving a corresponding response therefrom; and

a networked database server interconnected with and adapted for intercommunication with the at least one client and the electronic mail system, wherein the networked database server processes the query received from the client to obtain a result, and transmits the result back to the electronic mail system, the networked database server having;

(a) an electronic email interface within the networked database server for receiving and transmitting messages in an appropriate format and protocol prescribed by the electronic mail system;

(b) processing means within the networked database server for extracting queries from a received mail message, the queries being executed by an execution means disposed in communication with the processing means and configured to generate responses to the executed requests, the processing means also being for building mail messages from responses; and

(c) a message queue means within the networked database server disposed for communication with the electronic mail interface, the message queue means configured to store both incoming messages received from the electronic mail system and outgoing messages built by the processing means.

2. The system according to claim 1, wherein the processing means controls the mail interface to delete messages from the message queue.

3. The networked system of claim 1 further comprising a scheduler for invoking, on a scheduled basis, the operation of the processing means for extracting the query from the email message.

4. The networked system of claim 3 further comprising:

a mail inbox for storing email messages retrieved by the electronic mail interface from the electronic mail system; and

the scheduler comprises a set of tasks performed by the processing means, and each task includes at least one filter for selectively processing ones of the stored email messages.

5. The networked system of claim 4 wherein the at least one filter includes a format code for instructing the execution means to submit the results of an executed query in a specified format.

6. The networked system of claim 5 wherein the query submitted by the client is a database query.

7. The networked system of claim 6 wherein the database query is a Structured Query Language (SQL) query.

8. The networked system of claim 5 wherein the query submitted by the client comprises a query to modify information associated with the networked database server.

9. The networked system of claim 8 wherein the query to modify information comprises a command to add information to the networked database server.

10. The networked system of claim 8 wherein the query to modify information comprises a command to delete information from the networked database server.

11. A networked system for processing commands on a server in a distributed processing environment, comprising:

at least one client having an electronic mail interface for submitting a command via an electronic mail system and receiving a corresponding response therefrom; and

a networked database server interconnected with and adapted for intercommunication with the at least one client and the electronic mail system, wherein the networked database server processes the command received from the client, the networked database server having;

(a) an electronic mail interface for receiving messages in an appropriate format and protocol prescribed by the electronic mail system;

(b) processing means for extracting commands from a received mail message, the command being executed by an execution means disposed in communication with the processing means; and

(c) a message queue disposed for communication with the electronic mail interface, the message queue configured to incoming messages received from the electronic mail system.

12. The networked system of claim 11 further comprising a scheduler for invoking, on a scheduled basis, the operation of the processing means for extracting the command from the email message.

13. The networked system of claim 12 further comprising:

a mail inbox for storing email messages retrieved by the electronic mail interface from the electronic mail system; and

the scheduler comprises a set of tasks performed by the processing means, and each task includes at least one filter for selectively processing ones of the stored email messages.

14. The networked system of claim 13 wherein the at least one filter includes a format code for instructing the execution means to submit the results of an executed command in a specified format.

15. The networked system of claim 14 wherein the command submitted by the client comprises a command to modify information associated with the networked database server.

16. The networked system of claim 15 wherein the command to modify information comprises a command to add information to the networked database server.

17. The networked system of claim 16 wherein the command to modify information comprises a command to delete information from the networked database server.