EMAIL SERVICE ADAPTER

摘要

Accessing a database utilizing an email service adapter utilizing a computer is presented including: causing the computer to receive an email message from a user at an email server, the email server configured to respond to the email service adapter; processing the email message by the email service adapter, where the email message includes at least a database query; processing the database query with the database; and returning a result email message to the user via the email server, the result email message including at least a database response. In some embodiments, methods further include: when the email message is received by the email server, determining whether the email message is intended for accessing the database; if the email message is not intended for accessing the database, and processing the email message by the email server.

主权项

1. An email service adapter for accessing a database utilizing a computer, the email service adapter comprising:
a parsing component for parsing an email message containing a database query extracted from relevant information provided by elements included in the email message such that the database query may be processed; a mapping component for mapping the email message containing the database query to the database; and a query component for conforming the database query in accordance with a database query syntax, wherein conforming includes correcting an improperly formatted database query if the improperly formatted database query is not syntactically correct as required by the database, wherein the email service adapter processes only email messages containing the database query from a plurality of email messages routed by an email server.