Patent ID: 9043344
Filing Date: 2015-05-26
Classification: G06F

Abstract:
1. A method of defining an analytic flow within a database to be executed on data stored in a physical target data source and managed by a database management system, comprising: defining a data source connection object that is unique to the physical target data source as compared to a plurality of other data sources, the data source connection object being a data structure comprising a pointer to the physical target data source; defining a table object that references the data source connection object and interfaces between the physical target data source and the analytic flow within the database, wherein the analytic flow within the database is created using a template data source, wherein the template data source is different from the physical target data source, and the table object stores a mapping between the physical target data source and the template data source, the table object further storing attributes of the physical target data source and a connection name that points to a specific connection between the data source connection object and the physical target data source; defining a transformation object that maps the attributes of the physical target data source to template data attributes that are stored in the template data source, wherein the transformation object is defined to exist separate from the table object; and receiving the analytic flow by the database management system, the analytic flow operating within the database management system on data stored in the physical target data source that has been retrieved using the table object and transformed using the transformation object.