Patent ID: 7451137

Claim:
A computer implemented system that facilitates querying a data store, comprising a processor and computer readable storage medium having stored thereon components: a component receiving a query statement from a client; at the client, converting the query statement into an encapsulated statement by processing the query statement with embedded rowset parameters and binding corresponding data structures to sections of data represented by the rowset parameters, the encapsulated statement includes encapsulated data and data operations information in a form of the rowset parameters, wherein the rowset parameters include a polymorphic typed parameter that comprises a valid pointer to an interface; a component replacing OPENROWSET description of a relational connection with syntax for operating the data to an analysis server, the data is in-lined in the query statement queries with rowsets as parameters; a component passing the encapsulated statement to the analysis server; a component inputting the encapsulated statement into a transform pipeline for processing against the data store; a execution component executing the encapsulated statement against the data store to return a result set such that data to be loaded into the data store is in-lined in the query statement, wherein execution of the query statement is accomplished without knowledge that the parameter was employed in place of a relational statement; a component searching the encapsulated statement for parameter named rowsetidentifier; a component verifying if the rowsetidentifer of the encapsulated statement is supported for execution against the data store, loading a parameter of the encapsulated statement into a same data structure used for loading relational data; a component loading the result set into the data store operatively coupled to the analysis server; and a component processing one or more of training or modeling statements by the server against the result set loaded into the data store.