×

USER DEFINED FUNCTIONS FOR DATA LOADING

  • US 20120239612A1
  • Filed: 05/31/2012
  • Published: 09/20/2012
  • Est. Priority Date: 01/25/2011
  • Status: Abandoned Application
First Claim
Patent Images

1. A system for data loading comprising:

  • a structured query language (SQL) compiler to identify a call to a table valued user defined function within a SQL statement that includes an insert statement, identify metadata associated with the table valued user defined function, validate and resolve a subclass type of the table valued user defined function based on the metadata and the insert statement, and generate a data loading plan to retrieve and load data from an external data source into a table of a loading database based on the subclass type of the table valued user defined function; and

    a data loading engine in the loading database to execute the data loading plan generated by the SQL compiler, the data loading plan including the table valued user defined function to retrieve data from the external data source, and load the retrieved data into the table of the loading database in accordance with the data loading plan.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×