Sharon L Scheffler

US Patent:

20060224613, Oct 5, 2006

Filed:

Mar 31, 2005

Appl. No.:

11/095699

Inventors:

Pamela Bermender - Leander TX, US
Hung Dinh - Austin TX, US
Teng Hu - Austin TX, US
Sharon Scheffler - Georgetown TX, US

International Classification:

G06F 7/00

US Classification:

707102000

Abstract:

Provided is a method for an administrative apparatus for creating a business rule set for dynamic transform and load. A business rule template definition is obtained. A source metadata defining a data source is obtained. A store metadata defining a data store is obtained. Output is displayed to a user based on the template definition, the source metadata, and the store metadata. Input is accepted from the user indicating desired correspondence between source metadata and the store metadata. A business rule set is created based on the business rule template definition and the input. The method may be encoded onto a computer-readable medium, providing an article of manufacture. A system for an administrative apparatus for creating a business rule set for dynamic transform and load is also provided.

US Patent:

20060106856, May 18, 2006

Filed:

Nov 4, 2004

Appl. No.:

10/981286

Inventors:

Pamela Bermender - Leander TX, US
Hung Dinh - Austin TX, US
Teng Hu - Austin TX, US
Sharon Scheffler - Georgetown TX, US

Assignee:

INTERNATIONAL BUSINESS MACHINES CORPORATION - ARMONK NY

International Classification:

G06F 17/00
G06F 7/00

US Classification:

707102000

Abstract:

Provided is a method for dynamic transform and load of data from a data source defined by metadata into a data store defined by metadata. A business rule set is created () based on (a) a business rule template definition, (b) metadata defining at least a portion of data of a data source, and (c) metadata defining a data store. Data from the data source is transformed () based on the business rule set. The data is loaded () into the data store based on the business rule set. The transforming and loading are repeated () until all desired transforming and loading of data from the data source to the data store has been accomplished. The method may be carried out through execution of a computer programming product containing suitable logic. A system () for dynamic transform and load is also provided.