PERFORMING PREDICTIVE ANALYSIS

• US 20140067874A1
• Filed: 08/31/2012
• Published: 03/06/2014
• Est. Priority Date: 08/31/2012
• Status: Abandoned Application

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Girish Kalasa Ganesh Pai
• Inventors: Bhattacharjee, Arindam, Nagendra, Abhishek, Pai, Girish Kalasa Ganesh, Sreedharan, Unmesh
• Application Number:
  US13/600,265
• Publication Number:
  US 20140067874A1
• Time in Patent Office: Days
• US Class Current: 707/803
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases

Abstract

Various embodiments of systems and methods for performing predictive analysis are described herein. In one aspect, the method includes receiving a command for publishing a chain comprising a plurality of components connected together to perform predictive analysis. Based upon the command, a plurality of procedures corresponding to the plurality of components of the chain is generated. The generated procedures are integrated according to an order of connectivity of the components within the chain. A database object including the integrated procedures is generated. The database object is stored within a database. The stored database object is executable for performing predictive analysis.

Claims

1. An article of manufacture including a non-transitory computer readable storage medium to tangibly store instructions, which when executed by one or more computers in a network of computers causes performance of operations comprising:

receiving a command for publishing an analysis chain comprising a plurality of analysis components connected together to perform predictive analysis;

based upon the command, generating procedures for the plurality of analysis components;

integrating the generated procedures according to an order of connectivity of the plurality of analysis components in the analysis chain;

generating a database object comprising the integrated procedures; and

storing the database object within a database.

2. The article of manufacture of claim 1, wherein an analysis component comprises one of a data source component, an algorithm component, a data writer component, and a data preprocessor component.

3. The article of manufacture of claim 1, wherein each analysis component comprises a parameterized structured query language (SQL) script.

4. The article of manufacture of claim 3, wherein generating the procedures for the plurality of analysis components comprises:

reading the parameterized SQL script of the plurality of analysis components, wherein the parameterized SQL script includes one or more parameters;

reading a value of the one or more parameters, wherein the value of the one or more parameters is provided by a user; and

substituting the one or more parameters with their respective values.

5. The article of manufacture of claim 1, wherein the database comprises an in-memory database.

6. The article of manufacture of claim 1, wherein the analysis chain comprises:

a root component; and

a leaf component on which the command for publishing the analysis chain is initiated.

7. The article of manufacture of claim 6, wherein the analysis chain further comprises one or more analysis components between the root component and the leaf component.

8. The article of manufacture of claim 1, wherein the database is configured to perform the operations comprising:

receiving a command for executing the stored database object;

executing the stored database object to generate an output; and

displaying the output.

9. The article of manufacture of claim 8, wherein the command for executing the stored database object comprises a SELECT structured query language (SQL) statement.

10. The article of manufacture of claim 8, wherein generating the database object comprises generating an output view and wherein the command for executing the stored database object is provided using the output view.

11. A method for performing a predictive analysis, the method comprising:

receiving a command for publishing an analysis chain comprising a plurality of analysis components connected together to perform the predictive analysis;

based upon the command, generating procedures for the plurality of analysis components;

integrating the generated procedures according to an order of connectivity of the plurality of analysis components in the analysis chain;

generating a database object comprising the integrated procedures; and

storing the database object within a database.

12. The method of claim 11, wherein generating the procedures for the plurality of analysis components comprises:

reading the parameterized SQL script of an analysis component of the plurality of analysis components, wherein the parameterized SQL script includes one or more parameters;

reading a value of the one or more parameters, wherein the value of the one or more parameters is provided by a user; and

substituting the one or more parameters with their respective values.

13. The method of claim 11 further comprising identifying a leaf component of the analysis chain as a component where the command for publishing the analysis chain is initiated.

14. The method of claim 11 further comprising:

receiving a command for executing the stored database object;

executing the stored database object to generate an output; and

displaying the output.

15. A computer system for performing a predictive analysis, the computer system comprising:

a memory to store program code; and

a processor communicatively coupled to the memory, the processor configured to execute the program code to;

receive a command for publishing an analysis chain comprising a plurality of analysis components connected together to perform the predictive analysis;

based upon the command, generate procedures for the plurality of analysis components;

integrate the generated procedures according to an order of connectivity of the plurality of analysis components in the chain;

generate a database object comprising the integrated procedures; and

store the database object within a database.

16. The computer system of claim 15, wherein the program code to generate the procedures for the plurality of analysis components, further comprises program code to:

read the parameterized SQL script of an analysis component of the plurality of analysis components, wherein the parameterized SQL script includes one or more parameters;

read a value of the one or more parameters, wherein the value of the one or more parameters is provided by a user; and

substitute the one or more parameters with their respective values.

17. The computer system of claim 15, wherein the processor is further configured to execute the program code to identify:

a root component of the analysis chain; and

a leaf component of the analysis chain, wherein the leaf component of the analysis chain is identified as a component on which a command for publishing the chain is initiated.

18. The computer system of claim 17, wherein the processor is further configured to execute the program code to identify one or more branch components as one or more analysis components between the root component and the leaf component.

19. The computer system of claim 15, wherein the database is configured to:

receive a command to execute the stored database object;

execute the stored database object to generate an output; and

display the output.

20. The computer system of claim 19, wherein the command to execute the stored database object comprises a SELECT structured query language (SQL) statement.