USER DEFINED FUNCTIONS FOR DATA LOADING
First Claim
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.
2 Assignments
0 Petitions
Accused Products
Abstract
Data loading with user defined functions is described in various implementations. An example system for data loading may include a structured query language (SQL) compiler to identify a call to a table valued user defined function (TVUDF) within a SQL statement that includes an insert statement; identify metadata associated with the TVUDF; validate and resolve a subclass type of the TVUDF 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 database based on the subclass type of the TVUDF. The system may also include a data loading engine in the database to execute the data loading plan, the data loading plan including the TVUDF to retrieve data from the external data source, and load the retrieved data into the table of the database in accordance with the data loading plan.
-
Citations
15 Claims
-
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 Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A computer-implemented method for data loading, the method comprising:
-
receiving, at a computing device, a call to a table valued user defined function within a structured query language (SQL) statement that includes an insert statement; processing the call, using the computing device, to validate and resolve a subclass type of the table valued user defined function based on metadata associated with the table valued user defined function; and generating, using the computing device, a data loading plan to retrieve and load data from a data source that is external to the computing device based on the subclass type of the table valued user defined function, the data loading plan including the table valued user defined function; and executing, using the computing device, the data loading plan to retrieve the data and load the retrieved data into a table in accordance with the data loading plan.
-
-
15. A non-transitory computer-readable storage medium Storing instructions that, when executed by a processor, cause the processor to:
-
receive a call to a table valued user defined function within a structured query language (SQL) statement that includes an insert statement; process the call to validate and resolve a subclass type of the table valued user defined function based on metadata associated with the table valued user defined function; and generate a data loading plan to retrieve and load data from an external data source based on the subclass type of the table valued user defined function, the data loading plan including the table valued user defined function; and execute the data loading plan to retrieve the data and load the retrieved data into a table in accordance with the data loading plan.
-
Specification