Method of generating a logical data model, physical data model, extraction routines and load routines
First Claim
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.
2 Assignments
0 Petitions
Accused Products
Abstract
A logical data model is generated based on business rule metadata, data source characteristics, and cleansing, transformation, and householding metadata. A physical data model and extraction and loading routines are generated from the logical data model. A physical database design (PDD) and data description language (DDL) are created for constructing a data warehouse. The data warehouse is constructed according to the PDD and DDL. Data is moved from the data source to the system database for cleansing, transforming, and householding. The data is then loaded into the data warehouse.
148 Citations
16 Claims
-
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 Dependent Claims (2, 3, 4, 5, 6, 7, 8)
refining said business rule metadata; and
storing said refined metadata in said database management system.
-
-
5. The method as in claim 1, further comprising the steps of:
-
refining said characteristics of data; and
storing said refined characteristics in said database management system.
-
-
6. The method as in claim 1, further comprising the steps of:
-
refining said transformation, cleansing, and householding metadata; and
storing said refined transformation, cleansing, and householding metadata in said database management system.
-
-
7. The method as in claim 1, further comprising the steps of:
-
analyzing data warehouse performance; and
if the data warehouse performance fails to meet or exceed specified requirements, modifying at least one of said business rule metadata, said characteristics of data, and said transformation, cleansing, and householding metadata and storing said modifications in said database management system.
-
-
8. The method as in claim 7, further comprising the step of:
if the data warehouse performance fails to meet or exceed specified requirements, performing said creating, determining, selecting, storing, creating a logical data model, a physical data model, a physical database design and data description language, a data warehouse, moving, executing, and loading steps.
-
9. A computer system for generating a logical data model, a physical data model, extraction and loading routines for a data warehouse, comprising:
-
a processor;
a memory coupled to said processor, the memory having stored therein sequences of instructions which, when executed by said processor, cause said processor to;
create metadata corresponding to user input business rules;
store user input characteristics of data from one or more data sources in a database management system;
present existing transformation, cleansing, and householding metadata to user for selection by user;
store said user input business rule metadata and said user selected metadata and said transformation, cleansing and householding metadata, and said user input characteristics of data from one or more data sources in a database management system;
support user creation of and storage of a logical data model from said database management system;
create a physical data model from said logical data model;
create a physical database design and data description language for creating a data warehouse from said physical data model;
create said data warehouse;
move said data from said one or more data sources into said database management system;
execute said cleansing, transforming, and householding metadata on said loaded data in said database management system; and
load said cleansed, transformed, and househeld data into said data warehouse. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
create transformation, cleansing, and householding metadata.
-
-
11. The computer system as in claim 9 wherein said sequences of instructions for moving said data from said one or more data sources into said database management system is performed manually.
-
12. The computer system as in claim 9, further comprising sequences of instructions which, when executed by said processor, cause said processor to:
-
refine said business rule metadata; and
store said refined metadata in said database management system.
-
-
13. The computer system as in claim 9, further comprising sequences of instructions which, when executed by said processor, cause said processor to:
-
refine said characteristics of data; and
store said refined characteristics in said database management system.
-
-
14. The computer system as in claim 9, further comprising sequences of instructions which, when executed by said processor, cause said processor to:
-
refine said transformation, cleansing, and householding metadata; and
store said refined transformation, cleansing, and householding metadata in said database management system.
-
-
15. The computer system as in claim 9, further comprising sequences of instructions which, when executed by said processor, cause said processor to:
-
analyze data warehouse performance; and
if the data warehouse performance fails to meet or exceed specified requirements, modify at least one of said business rule metadata, said characteristics of data, and said transformation, cleansing, and householding metadata and store said modifications in said database management system.
-
-
16. The computer system as in claim 9, further comprising sequences of instructions which, when executed by said processor, cause said processor to:
if the data warehouse performance fails to meet or exceed specified requirements, perform said creating, determining, selecting, storing, creating a logical data model, a physical data model, a physical database design and data description language, a data warehouse, moving, executing, and loading instructions.
Specification