초록 ▼

According to the invention, techniques for organizing information from systems in a data warehousing environment are provided. In a particular embodiment, the invention provides an apparatus for analyzing data in at least data source of an enterprise. The apparatus can include a meta model for an en

According to the invention, techniques for organizing information from systems in a data warehousing environment are provided. In a particular embodiment, the invention provides an apparatus for analyzing data in at least data source of an enterprise. The apparatus can include a meta model for an enterprise. The enterprise is typically a business activity, but can also be other loci of human activity. A data schema derived from the meta model can also be part of the apparatus. The apparatus can also include a database organized according to the data schema. The apparatus can translate data from a variety of sources to the data schema. The apparatus can incorporate data into the database and perform a variety of analyses on the data in the database.

대표청구항 ▼

1. A computer-based apparatus for data warehousing, comprising:a memory; and a processor, coupled to said memory, said processor operatively disposed to: select a template from a plurality of pre-defined ones, said templates embodying a plurality of characteristics of the business; select at least o

1. A computer-based apparatus for data warehousing, comprising:a memory; and a processor, coupled to said memory, said processor operatively disposed to: select a template from a plurality of pre-defined ones, said templates embodying a plurality of characteristics of the business; select at least one of a plurality of customer entities from a plurality of pre-defined ones to form a focal group of customer entities, said selecting based upon said template; define 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; define 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; select 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; determine at least one of a plurality of attributes based on data types of tables of said data source; determine for said attributes at least one of a plurality of primary keys; create a data warehouse database from said data schema; and create 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.