Converting data models into in-database analysis models

• US 9,552,403 B2
• Filed: 02/08/2013
• Issued: 01/24/2017
• Est. Priority Date: 02/08/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Bhattacharjee, Arindam, Garimella, Srinivasa Raghu, Gupta, Ajay Kumar, Sreedharan, Unmesh, Pai, Girish Kalasa Ganesh
• Primary Examiner(s): Trujillo, James
• Assistant Examiner(s): Morris, John J
• Application Number:
  US13/762,546
• Publication Number:
  US 20140229491A1
• Time in Patent Office: 1,446 Days
• Field of Search: 707/748, 707/999.006
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

Data sets are analyzed to discover trends and determine predictive data models. A data model is determined based on analyzing the data set with a specific algorithm from a set of different analytical algorithms. The data model is stored in a structural file format. The data model is converted into an instantiated object model with the use of a predefined object model. The instantiated object model is converted into an in-database analysis model to score new data within a database system. The scoring is based on the logic in the data model. The in-database analysis model is stored on a database server part of a database system to provide analytical functionality defined in the data model. The new data can be scored with the in-database analysis model. The new data is not extracted from the database system and the scoring is accomplished in-memory.

Claims

1. A computer implemented method for converting a data model into an in-database analysis model to score data within a database system, the method comprising:

converting a data model into an instantiated object model, wherein the converting comprises;

parsing the data model in a standard structural format to receive content of the data model; and

generating the instantiated object model by instantiating a set of objects defined in a basic object model with the received content of the data model, wherein the set of objects of the basic object model are mapped to structural elements of the data model, and wherein the instantiated object model comprises logic implemented into the data model and suggested arithmetic operations from the data model, and wherein the basic object model corresponds to an algorithm for generating the data model;

converting the instantiated object model into the in-database analysis model to be stored in the database system, wherein the in-database analysis model comprises executable commands created in a database native language based on transforming the instantiated set of objects of the instantiated object model to include the logic implemented into the data model and the suggested arithmetic operations from the data model; and

storing the in-database analysis model as a stored procedure in a compiled form on a database server part of the database system.

2. The method of claim 1, further comprising:

receiving a data set from a data source;

analyzing the data set; and

generating the data model.

3. The method of claim 2, wherein analyzing the data set comprises:

defining the algorithm to be applied on the data set to generate the data model.

4. The method of claim 3, wherein the algorithm applied on the data set is selected from a set of algorithms provided by algorithm sources.

5. The method of claim 2, further comprising:

applying a filtering method and a sampling method on the data set to reduce the data set.

6. The method of claim 1, wherein the standard structural format is represented in Predictive Modeling Markup Language (PMML).

7. The method of claim 1, further comprising:

scoring the data with the in-database analysis model within the database system.

8. The method of claim 7, wherein the in-database analysis model is provided to a client to score the data with the in-database analysis model within the database system through a consuming service.

9. The method of claim 1, wherein the executable commands are combined according to logic implemented into the data model.

10. A computer system for converting a data model into an in-database analysis model to score data within a database system, the system comprising:

a processor;

a memory in association with the processor storing instructions related to;

an analyzing module to;

receive a data set from a data source to analyze the data set;

apply an algorithm on the data set to generate the data model; and

save the data model in a standard structural format;

a converting module to convert the data model into an instantiated object model, wherein the converting module is further operable to;

parse the data model in the standard structural format to receive content of the data model; and

generate the instantiated object model by instantiating a set of objects defined in a basic object model with the received content of the data model, wherein the set of objects in the basic object model are mapped to structural elements of the data model, and wherein the set of instantiated objects in the instantiated object model comprise logic implemented into the data model and suggested arithmetic operations from the data model, and wherein the basic object model corresponds to the algorithm for generating the data model; and

a database converting module to convert the instantiated object model into the in-database analysis model to be stored in the database system, wherein the in-database analysis model comprises executable commands created in a database native language based on transforming the instantiated set of objects of the instantiated object model to include the logic implemented into the data model and the suggested arithmetic operations from the data model; and

the database system comprising;

a database server to store the in-database analysis model as a stored procedure in a compiled form, wherein the in-database analysis model is executed within the database system.

11. The system of claim 10, wherein the algorithm applied on the data set is selected from a set of algorithms provided by algorithm sources.

12. The system of claim 10, wherein the standard structural format is represented in Predictive Modeling Markup Language (PMML).

13. The system of claim 10, wherein the database system is operable to provide the in-database analysis model to a client to score the data with the in-database model through a consuming service.

14. The system of claim 10, wherein the executable commands are combined according to logic implemented into the data model.

15. An article of manufacture for converting a data model into an in-database analysis model to score data within a database system, comprising a non-transitory computer readable medium including executable instructions, which when executed by a computer, cause the computer to:

convert a data model in a standard structural format into an instantiated object model by;

parsing the data model in the standard structural format to receive content of the data model; and

generating the instantiated object model by instantiating a set of objects defined in a basic object model with the received content of the data model, wherein the set of objects in the basic object model are mapped to structural elements of the data model, and wherein the set of instantiated objects in the instantiated object model comprise logic implemented into the data model and suggested arithmetic operations from the data model, and wherein the basic corresponds to an algorithm for generating the data model;

convert the instantiated object model into the in-database analysis model to be stored in the database system, wherein the in-database analysis model comprises executable commands created in a database native language based on transforming the set of instantiated objects of the instantiated object model to include the logic implemented into the data model and the suggested arithmetic operations from the data model; and

store the in-database analysis model as a stored procedure in a compiled form on a database server.

16. The article of manufacture of claim 15, further comprising instructions, which when executed by a computer, cause the computer to:

receive a data set from a data source;

define the algorithm to be applied on the data set to analyze the data set and to generate the data model; and

save the data model in the standard structural format.

17. The article of manufacture of claim 16, wherein the algorithm applied on the data set is selected from a set of algorithms provided by algorithm sources.

18. The article of manufacture of claim 15, further comprising instructions, which when executed by a computer, cause the computer to:

provide the in-database analysis model to be consumed by a client to score the data within the database system through a consuming service.