Automated data mining runs

• US 20040215656A1
• Filed: 04/25/2003
• Published: 10/28/2004
• Est. Priority Date: 04/25/2003
• Status: Abandoned Application

• Current Assignee: SAP AG (SAP SE)
• Original Assignee: SAP AG (SAP SE)
• Inventors: Ecker, Bernd, Shankar, Lakshmi, Dill, Marcus, Weidner, Jens, Mahabal, Harish Hoskere
• Application Number:
  US10/423,011
• Publication Number:
  US 20040215656A1
• Time in Patent Office: Days
• US Class Current: 707/103R
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 2216/03 Data mining
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

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.

Claims

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.