Extracting data cell transformable to model object

Abstract

Embodiments relate to systems and methods for extracting a data cell transformable to a model object. Aspects relate to object-based modeling using modeling objects that can be extracted from spreadsheet cells, database entries, or other sources. A modeling client can host modeling logic and an application programming interface (API) to create, access, manipulate, and import/export modeling objects used in modeling applications, such as engineering, medical, financial, and other modeling platforms. In aspects, the source data can be accepted into the modeling client from consumer or business-level applications, whose cell, database, or other data content can be extracted and encapsulated in object-oriented format, such as extensible markup language (XML) format. Modeling operations can therefore be performed on or incorporate data that was not originally strictly configured for object-based modeling applications. The extracted model object can also be exchanged with other applications or platforms.

What is claimed is: 
     
       1. A method comprising:
 invoking an instance of a relational database, the relational database comprising a plurality of data elements; 
 receiving input indicative of a selection of a portion of the relational database from a user via the instance of the relational database, the selection comprising a first data element of the plurality of data elements having a first value and a second data element of the plurality of data elements having a second value; 
 identifying a functional relationship between the first value and the second value; 
 encapsulating the functional relationship between the first value and the second value in a functional object; 
 encapsulating, by a processor, the first value, the second value, and the functional object in a predictive database model object; 
 invoking a modeling application to perform a modeling operation on the predictive database model object to predict an output and create a first modified first value and a first modified second value; 
 locking the first modified first value, the first modified second value, and the functional object in the predictive database model object in view of performing the modeling operation on the predictive database model object; 
 sending the predictive database model object, comprising the portion of the relational database, to a mainframe platform via a secure channel over a network, wherein the mainframe platform performs a modeling operation using the first modified first value, the first modified second value, and the functional object in the predictive database model object to create a second modified first value, a second modified second value, or a changed functional object in the predictive database model object; 
 receiving a modified predictive database model object from the mainframe platform via the secure channel over the network, wherein the modified predictive database model object comprises the second modified first value, the modified changed second value, or the changed functional object; and 
 converting the modified predictive database model object to a non-object oriented format, wherein the relational database performs an operation using the second modified first value, the second modified second value, or the changed functional object from the converted modified predictive database model object. 
 
     
     
       2. The method of  claim 1 , wherein the portion comprises at least one of spreadsheet data or database data. 
     
     
       3. The method of  claim 1 , further comprising storing the predictive database model object in storage of the client machine. 
     
     
       4. The method of  claim 1 , wherein the predictive database model object is encapsulated in extensible markup language (XML) format. 
     
     
       5. The method of  claim 1 , wherein the functional relationship comprises at least one of a function call parameter or a linkage parameter. 
     
     
       6. The method of  claim 1 , wherein the predictive database model object is extensible via an appending of at least one of a third value of a third data element or an additional functional relationship to the predictive database model object. 
     
     
       7. The method of  claim 1 , wherein the predictive database model object is importable into at least one application. 
     
     
       8. The method of  claim 1 , where the relational database is hosted in at least one of local storage coupled to the processor or remote storage. 
     
     
       9. A system comprising:
 a memory to store a relational database; and 
 a processor, operatively coupled to the memory, to:
 invoke an instance of the relational database, the relational database comprising a plurality of data elements; 
 receive input indicative of a selection of a portion of the relational database from a user via the instance of the relational database, the selection comprising a first data element of the plurality of data elements having a first value and a second data element of the plurality of data elements having a second value; 
 identify a functional relationship between the first value and the second value; 
 encapsulate the functional relationship between the first value and the second value in a functional object; 
 encapsulate the first value, the second value, and the functional object in a predictive database model object; 
 invoke a modeling application to perform a modeling operation on the predictive database model object to predict an output and create a first modified first value and a first modified second value; 
 lock the first modified first value, the first modified second value, and the functional object in the predictive database model object in view of performing the modeling operation on the predictive database model object; 
 send the predictive database model object, comprising the portion of the relational database, to a mainframe platform via a secure channel over a network, wherein the mainframe platform performs a modeling operation using the first modified first value, the first modified second value, and the functional object in the predictive database model object to create a second modified first value, a second modified second value, or a changed functional object in the predictive database model object; 
 receive a modified predictive database model object from the mainframe platform via the secure channel over the network, wherein the modified predictive database model object comprises the second modified first value, the second modified second value, or the changed functional object; and 
 convert the modified predictive database model object to a non-object oriented format, wherein the relational database performs an operation using the second modified first value, the second modified second value, or the changed functional object from the converted modified predictive database model object. 
 
 
     
     
       10. The system of  claim 9 , wherein the portion comprises at least one of spreadsheet data or database data. 
     
     
       11. The system of  claim 9 , wherein the memory is further to store the predictive database model object. 
     
     
       12. The system of  claim 9 , wherein the predictive database model object is encapsulated in extensible markup language (XML) format. 
     
     
       13. The system of  claim 9 , wherein the functional relationship comprises at least one of a function call parameter or a linkage parameter. 
     
     
       14. The system of  claim 9 , wherein the predictive database model object is extensible via an appending of at least one of a third value of a third data element or an additional functional relationship to the predictive model object. 
     
     
       15. The system of  claim 9 , wherein the predictive database model object is importable into at least one application. 
     
     
       16. The system of  claim 9 , where the memory comprises at least one of local storage or remote storage. 
     
     
       17. A non-transitory computer-readable medium having instructions encoded thereon that, when executed by a processor, cause the processor to:
 invoke an instance of a relational database, the relational database comprising a plurality of data elements; 
 input indicative of a selection of a portion of the relational database from a user via the instance of the relational database, the selection comprising a first data element of the plurality of data elements having a first value and a second data element of the plurality of data elements having a second value; 
 identify a functional relationship between the first value and the second value; 
 encapsulate the functional relationship between the first value and the second value in a functional object; 
 encapsulate, by the processor, the first value, the second value, and the functional object in a predictive model object; 
 encapsulate the functional relationship between the first value and the second value in a functional object; 
 encapsulate, by the processor, the first value, the second value, and the functional object in a predictive database model object; 
 invoke a modeling application to perform a modeling operation on the predictive database model object to predict an output and create a first modified first value and a first changed modified value; 
 lock the first modified first value, the first modified second value, and the functional object in the predictive database model object in view of performing the modeling operation on the predictive database model object; 
 send the predictive database model object, comprising the portion of the relational database, to a mainframe platform via a secure channel over a network, wherein the mainframe platform performs a modeling operation using the first modified first value, the first modified second value, and the functional object in the predictive database model object to create a second modified first value, a second modified second value, or a changed functional object in the predictive database model object; 
 receive a modified predictive database model object from the mainframe platform via the secure channel over the network, wherein the modified predictive database model object comprises the second modified first value, the second modified second value, or the changed functional object; and 
 convert the modified predictive database model object to a non-object oriented format, wherein the relational database performs an operation using the second modified first value, the second modified second value, or the changed functional object from the converted modified predictive database model object. 
 
     
     
       18. The computer system readable medium of  claim 17 , wherein the predictive database model object is importable into at least one application.