Patent ID: 7299216

Claim:
A method for the supervision of at least one extraction/transformation/loading (ETL) procedure of a first database to create a second data base comprising the steps of: logging procedure records for said ETL procedure detailing characteristics and scheduling of said ETL procedure; logging control records for said ETL procedure detailing status of said ETL procedure; logging a cleansing record for said ETL procedure detailing a cleansing schedule for said first database; logging errors associated with the logging of procedure records end control records; evaluating a severity of the errors for determining whether a personnel is to be notified, wherein logging control records for said ETL procedure comprises: recording the name for said ETL procedure; recording a trigger table for said ETL procedure, said trigger table defining a staging source table for said ETL procedure; recording a key field within said trigger table to provide a reference for said ETL procedure; recording a current time for said ETL procedure indicating that said ETL procedure is executed; recording an error message for an abnormal data transfer during said ETL procedure; and recording an error code for said abnormal data transfer during said ETL procedure.