Patent ID: 6377934
Filing Date: 2002-04-23
Classification: G06F,G06Q,Y10S

Abstract:
A computer based method for data warehousing, comprising:selecting a template from a plurality of pre-defined ones, said templates embodying a plurality of characteristics of a business; selecting at least one of a plurality of customer entities from a plurality of pre-defined ones to form of focal group of customer entities, said selecting based upon said template; defining at least one of a plurality of customer transaction entities and at least one of a plurality of attributes of said customer transaction entities to form a customized group of customer activity components; defining at least one of a plurality of customer event types in said customer activity components, wherein said customer event types comprise attributes of said customer transaction entities in said customer activity components; selecting at least one of a plurality of data tables and at least one of a plurality of attributes of said data tables to form a data schema, wherein said data schema is a reverse star data schema; determining at least one of a plurality of attributes based on data types of tables of said data source; determining for said attributes at least one of a plurality of primary keys; creating a data warehouse database from said data schema; and creating at least one of a plurality of data mapping rules, said mapping rules providing translation information for tables and attributes of said data sources to said data warehouse.