Patent Document ID: 20090112927
Application ID: 11924840
Patent Flag: 0

Claim One:
1. In a process of transforming data residing in databases into forms suitable as input to data analysis tools, the process including the steps of defining a business process problem to be solved and identifying data requirements, the improvement of computer implemented method for automatically transforming data for use in data analysis tools comprising the steps of: accessing database metadata that describe at least one of database tables, their interrelationships, dimensional information, hierarchies, fact tables, and measures; creating a mining transformation profile metadata to encapsulate at least one of aggregation and transformation on data stored in databases in order to convert the data to forms suitable for data analysis tools, said mining transformation profile specifying at least one of aggregation and transformation on data relative to said database metadata; generating executable data transformation code from the database metadata and the mining transformation profile, execution of said code producing at least one of aggregation and transformation of data residing in a database for input to a data analysis tool; and executing the data transformation code by said data analysis tool to generate an output that provides a solution to the business process problem.