Apparatus and method for performing data transformations in data warehousing

  • US 6,014,670 A
  • Filed: 11/07/1997
  • Issued: 01/11/2000
  • Est. Priority Date: 11/07/1997
  • Status: Expired due to Term
First Claim
Patent Images

1. A computer implemented method for transforming data in a data warehousing application, comprising the steps of:

  • specifying at least one source table containing data, wherein the source table includes at least a first source table output port;

    storing metadata corresponding to a plurality of transformation objects, wherein the transformation objects have at least one transformation object input port for accepting data and at least one transformation object output port for outputting transformed data and particular transformation objects transform data according to the metadata corresponding to that particular transformation object;

    specifying a target table for storing manipulated data, wherein the target table includes at least a first target table input port;

    selecting at least one of the transformation objects;

    mapping data from the first source table output port to a first transformation object input port of a first selected transformation object, wherein the mapping is defined by a human user;

    transforming the data according to the metadata corresponding to the first selected transformation object;

    mapping the transformed data from a first transformation object output port to the first target table input port.

View all claims
    ×
    ×

    Thank you for your feedback

    ×
    ×