Patent ID: 8886591

Claim:
A computing system, comprising: a definition engine configured to: provide a core fact table for storing data for risk item attributes common to all lines of business (LOBs); provide an interface for collecting, from a user, user defined risk item attributes for a specific LOB; create corresponding user defined risk item attributes for the specific LOB; generate an adaptive database structure that includes an XML file containing metadata describing the user defined risk item attributes; with an ETL (Extract, transform, and load) tool, receive the XML file and identify the user defined risk item attributes in the XML file, and generate an ETL layer comprising interface rules for populating line of business extension fact tables with data for the user defined risk item attributes; create a data mart schema comprising the core fact table and the extension fact tables, where the core fact table does not store data corresponding to the user defined risk item attributes collected from the user; populate the line of business extension fact tables with data using the ETL layer; and integrate the adaptive database structure including the line of business extension fact tables and the core fact table to construct a data warehouse according to the data mart schema; where the core fact table and line of business extension fact tables include join keys that can be used to join the core fact table with the extension fact tables; and where the core fact table and the extension fact tables store records corresponding to transactions and further where the data mart schema comprises dimension tables that are keyed to columns of the core fact table and the extension fact tables and store records corresponding to attributes of the transaction; and a memory configured to store a populated adaptive database structure.