×

Method of generating a logical data model, physical data model, extraction routines and load routines

  • US 6,490,590 B1
  • Filed: 02/14/2000
  • Issued: 12/03/2002
  • Est. Priority Date: 02/14/2000
  • Status: Active Grant
First Claim
Patent Images

1. A method of generating a logical data model, a physical data model, extraction and loading routines for a data warehouse, the method comprising the steps:

  • creating business rule metadata;

    determining characteristics of data from one or more data sources;

    selecting transformation, cleansing, and householding metadata in accordance with said characteristics of data;

    storing said metadata and said transformation, cleansing and householding metadata in a database management system;

    creating a logical data model from said metadata;

    creating a physical data model from said logical data model;

    creating a physical database design and data description language for creating a data warehouse from said physical data model;

    creating said data warehouse;

    moving said data from said one or more data sources into said database management system;

    executing said cleansing, transforming, and householding metadata on said loaded data in said database management system; and

    loading said cleansed, transformed, and househeld data into said data warehouse.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×