International Business Machines Corporation

Paul Fernand Wilms

Ningning Wang

Khalid Albarrak

Cheung-Yuk Wu

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.

Email service adapter

Methods for accessing a database utilizing an email service adapter utilizing a computer are 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.

Querying database clients utilizing email messages

A system comprised of trigger mechanisms, a staging area, and an archived warehouse metadata table is used to extract, store, and archive extract, transform, and load (ETL) tasks from operational metadata in a data-warehousing environment. Operational metadata is comprised of ETL information; ETL task execution statuses, run number, definitions, control flow, and execution schedules. Specified ETL information is monitored and captured so that it may be extracted from operational metadata and transformed every time a trigger mechanism activates an update of stored data. Administrator-specified ETL task information is then stored in staging table. At specified intervals a staging table is refreshed with changes in operational data for each of the administrator-specified monitored and captured ETL tasks. Overwritten data, or outdated ETL task information, is then moved and stored in an archived warehouse metadata table. In one embodiment, archives are queried to generate reports analyzing the status of ETL tasks.

Growing community of inventors

San Jose, CA, United States of America

Paul Fernand Wilms