Data mining and model generation using an in-database analytic flow generator

摘要

Embodiments are described for a system and method of providing a data miner that decouples the analytic flow solution components from the data source. An analytic-flow solution then couples with the target data source through a simple set of data source connector, table and transformation objects, to perform the requisite analytic flow function. As a result, the analytic-flow solution needs to be designed only once and can be re-used across multiple target data sources. The analytic flow can be modified and updated at one place and then deployed for use on various different target data sources.

主权项

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.