Patent ID: 6490590
Filing Date: 2002-12-03
Classification: G06F,Y10S

Abstract:
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.