Patent ID: 7191183

Claim:
An analytics and data warehousing infrastructure and services system, said system comprising: a. at least one source data store; b. at least one extractor for extracting source data from said source data store; c. at least one staging data store having at least one staging data table, said at least one staging data table being populated with said source data; d. at least one analytic data store for storing transformed data; e. at least one interrogation engine for moving and transforming data from said staging data table into said at least one analytic data store, said interrogation engine providing at least a partial denormalization of said data; f. said at least one interrogation engine for supporting ad hoc analysis and data mining from a user interface, said at least one interrogation engine facilitating user independent definition and user generation of user defined query concepts, said interrogation engine generating computer programming to modify and query said at least one analytic data store or said at least one staging data store, said user defined query concepts being user independently defined and user independently generated analytic concepts, stratifications, or events created from variables in said at least one analytic data store or said at least one staging data store; and g. at least one analytic and report means for generating analysis and reports; h. wherein said system uses an analytic data model that allows said user to extract useful information from said at least one analytic data store or said at least one staging data store, find patterns in said at least one analytic data store or said at least one staging data store and interpret patterns in said at least one analytic data store or said at least one staging data store.