Patents by Inventor Paul Fernand Wilms

Paul Fernand Wilms has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Dynamically capturing data warehouse population activities for analysis, archival, and mining
    Patent number: 7941397
    Abstract: 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.
    Type: Grant
    Filed: February 25, 2004
    Date of Patent: May 10, 2011
    Assignee: International Business Machines Corporation
    Inventors: Paul Fernand Wilms, Cheung-Yuk Wu