Automated data mining runs

Abstract

A data mining run that includes special analyses is triggered directly after having loaded new data in a data warehouse environment, to enrich the newly loaded data by new attributes. The process automates replicating transaction data from a source system into a data warehouse, triggering a data mining procedure (such as a training or a prediction procedure) that enriches the data with new attributes, and triggering the upload of the enriched data back into the data warehouse.

What is claimed is:  
     
         1 . A method for conducting a data mining process, the method comprising: 
 triggering the data mining process wherein: 
 the data mining process includes an analytical process,  
 the triggering is based on the presence of data in a data source that is used for analytical processing, and  
 the analytical process uses a procedure that also is usable in a data extraction process;  
   creating a data attribute by performing the analytical process on data from the data source after the analytical process has been triggered; and    storing the created data attribute in the data source.    
     
     
         2 . The method of  claim 1  further comprising extracting data from a data source used for transaction processing.  
     
     
         3 . The method of  claim 2  wherein a person initiates at most the step of extracting data from the data source used for transaction processing.  
     
     
         4 . The method of  claim 2  further comprising loading the extracted data to the data source that is used for analytical processing.  
     
     
         5 . The method of  claim 4  wherein a person initiates at most the step of loading the extracted data.  
     
     
         6 . The method of  claim 1  further comprising: 
 extracting data from the data source that is used for analytical processing; and  
 loading the data extracted from the data source that is used for analytical processing to temporary data storage,  
 wherein performing the analytical process comprises performing the analytical process using data stored in the temporary data storage.  
 
     
     
         7 . The method of  claim 1  wherein triggering the analytical process based presence of data in the data source that is used for analytical processing comprises triggering an analytical process based on the completion of a computer program for loading data to the data source that is used for analytical processing.  
     
     
         8 . The method of  claim 1  further comprising triggering, based on an occurrence of a predetermined date and time, loading the data extracted from a data source used for transaction processing to the data source that is used for analytical processing.  
     
     
         9 . The method of  claim 1  further comprising triggering, based on an occurrence of a predetermined date and time, extracting data from a data source used for transaction processing and loading the extracted data to the data source that is used for analytical processing  
     
     
         10 . The method of  claim 1  wherein performing the analytical process comprises determining a relationship between two data values in the data source.  
     
     
         11 . The method of  claim 10  wherein performing the analytical process comprises determining a relationship between two data values that predict a likelihood of whether a particular customer will fail to purchase a service or product in the future.  
     
     
         12 . The method of  claim 10  wherein performing the analytical process comprises identifying products that are purchased in the same transaction.  
     
     
         13 . The method of  claim 10  wherein performing the analytical process comprises identifying services that are purchased in the same transaction.  
     
     
         14 . The method of  claim 10  wherein performing the analytical process comprises applying a previously-determined relationship between two data values to data in the data source.  
     
     
         15 . The method of  claim 14  wherein applying a previously-determined relationship comprises determining a likelihood of whether a particular customer will fail to purchase a service or a product in the future based on characteristics associated with customers who have been identified as failing to purchase a service or a product.  
     
     
         16 . The method of  claim 1  performing the analytical process comprises determining a relationship between two data values in the data source and applying the determined relationship to data in the data source.  
     
     
         17 . The method of  claim 16  wherein: 
 determining a relationship between two data values in the data source comprises determining a relationship between two data values that predict a likelihood of whether a particular customer will fail to purchase a service or product in the future, and  
 applying the determined relationship to data in the data source comprises determining a likelihood of whether a particular customer will fail to purchase a service or a product in the future based on the relationship determined between two data values that predict a likelihood of whether a particular customer will fail to purchase a service or product in the future.  
 
     
     
         18 . A method for conducting a data mining process, the method comprising: 
 triggering the data mining process wherein:    the data mining process includes an analytical process,    the triggering is based on the presence of data in a data source that is used for analytical processing, and    the analytical process uses a procedure that also is usable in a data extraction process;    extracting data from the data source that is used for analytical processing;    loading the data extracted from the data source that is used for analytical processing to temporary data storage,    creating a data attribute by performing the analytical process on data in the temporary data storage; and    storing the created data attribute in the data source that is used for analytical processing.    
     
     
         19 . The method of  claim 18  further comprising: 
 extracting data from a data source used for transaction processing, and  
 comprising loading the extracted data to the data source that is used for analytical processing.  
 
     
     
         20 . The method of  claim 19  wherein a person initiates at most the step of extracting data from the data source used for transaction processing.  
     
     
         21 . The method of  claim 18  wherein performing the analytical process comprises determining a relationship between two data values in the data source.  
     
     
         22 . A computer-readable medium or propagated signal having embodied thereon a computer program configured to conduct a data mining process, the medium or signal comprising one or more code segments configured to: 
 trigger the data mining process wherein: 
 the data mining process includes an analytical process,  
 the triggering is based on the presence of data in a data source that is used for analytical processing, and  
 the analytical process uses a procedure that also is usable in a data extraction process;  
   create a data attribute by performing the analytical process on data from the data source after the analytical process has been triggered; and    store the created data attribute in the data source.    
     
     
         23 . The medium or signal of  claim 22  wherein the one or more code segments are further configured to: 
 extract data from the data source that is used for analytical processing; and  
 load the data extracted from the data source that is used for analytical processing to temporary data storage,  
 wherein the one or more code segments configured to perform the analytical process comprise one or more code segments configured to perform the analytical process using data stored in the temporary data storage.  
 
     
     
         24 . The medium or signal of  claim 22  wherein the one or more code segments configured to trigger the analytical process comprise one or more code segments configured to trigger an analytical process based on the completion of a computer program for loading data to the data source that is used for analytical processing.  
     
     
         25 . The medium or signal of  claim 22  wherein the one or more code segments are further configured to trigger, based on an occurrence of a predetermined date and time, loading the data extracted from a data source used for transaction processing to the data source that is used for analytical processing.  
     
     
         26 . The medium or signal of  claim 22  wherein the one or more code segments are further configured to trigger, based on an occurrence of a predetermined date and time, extracting data from a data source used for transaction processing and loading the extracted data to the data source that is used for analytical processing.  
     
     
         27 . The medium or signal of  claim 22  wherein the one or more code segments configured to perform the analytical process comprise one or more code segments configured to determine a relationship between two data values in the data source.  
     
     
         28 . A system for conducting a data mining process, the system comprising a processor connected to a storage device and one or more input/output devices, wherein the processor is configured to: 
 trigger the data mining process wherein: 
 the data mining process includes an analytical process,  
 the triggering is based on the presence of data in a data source that is used for analytical processing, and  
 the analytical process uses a procedure that also is usable in a data extraction process;  
   create a data attribute by performing the analytical process on data from the data source after the analytical process has been triggered; and    store the created data attribute in the data source.    
     
     
         29 . The system of  claim 28  wherein the processor is further configured to: 
 extract data from the data source that is used for analytical processing;  
 load the data extracted from the data source that is used for analytical processing to temporary data storage; and  
 perform the analytical process using data stored in the temporary data storage.  
 
     
     
         30 . The system of  claim 28  wherein the processor is configured to trigger an analytical process based on the completion of a computer program for loading data to the data source that is used for analytical processing.  
     
     
         31 . The system of  claim 28  wherein the processor is further configured to trigger, based on an occurrence of a predetermined date and time, loading the data extracted from a data source used for transaction processing to the data source that is used for analytical processing.  
     
     
         32 . The system of  claim 28  wherein the processor is further configured to trigger, based on an occurrence of a predetermined date and time, extracting data from a data source used for transaction processing and loading the extracted data to the data source that is used for analytical processing.  
     
     
         33 . The system of  claim 28  wherein the processor is configured to determine a relationship between two data values in the data source.  
     
     
         34 . A method for defining an automated data mining process, the method comprising: 
 presenting a user interface for: 
 identifying a template for a type of automated data mining process for triggering an analytical process, the analytical process using a procedure that also is usable in a data extraction process, based on the presence of data in a data source that is used for analytical processing, creating a data attribute by performing the analytical process on data from the data source after the analytical process has been triggered, and storing the created data attribute in the data source; and  
 entering information for defining the automated data mining process;  
   associating the entered information with the identified template; and    storing the associated entered information with the identified template as a computer program configured to perform the automated data mining process.