mlp.sql_in File Reference

SQL functions for multilayer perceptron. More...

Functions
float8 []	mlp_igd_transition (float8[] state, float8[] ind_var, float8[] dep_var, float8[] previous_state, float8[] layer_sizes, float8 learning_rate_init, integer activation, integer is_classification, float8 weight, float8[] warm_start_coeff, float8 lambda, float8 momentum, boolean is_nesterov)
float8 []	mlp_minibatch_transition (float8[] state, float8[] ind_var, float8[] dep_var, float8[] previous_state, float8[] layer_sizes, float8 learning_rate_init, integer activation, integer is_classification, float8 weight, float8[] warm_start_coeff, float8 lambda, integer batch_size, integer n_epochs, float8 momentum, boolean is_nesterov)
float8 []	mlp_alr_transition (float8[] state, float8[] ind_var, float8[] dep_var, float8[] previous_state, float8[] layer_sizes, float8 learning_rate_init, integer activation, integer is_classification, float8 weight, float8[] warm_start_coeff, float8 lambda, integer batch_size, integer n_epochs, integer opt_code, float8 rho, float8 beta1, float8 beta2, float8 eps)
float8 []	mlp_igd_merge (float8[] state1, float8[] state2)
float8 []	mlp_igd_final (float8[] state)
float8 []	mlp_minibatch_merge (float8[] state1, float8[] state2)
float8 []	mlp_minibatch_final (float8[] state)
float8 []	mlp_alr_merge (float8[] state1, float8[] state2)
float8 []	mlp_alr_final (float8[] state)
aggregate float8 []	mlp_igd_step (float8[], float8[], float8[], float8[], float8, integer, integer, float8, float8[], float8, float8, boolean)
aggregate float8 []	mlp_minibatch_step (float8[], float8[], float8[], float8[], float8, integer, integer, float8, float8[], float8, integer, integer, float8, boolean)
aggregate float8 []	mlp_alr_step (float8[], float8[], float8[], float8[], float8, integer, integer, float8, float8[], float8, integer, integer, integer, float8, float8, float8, float8)
float8	internal_mlp_igd_distance (float8[] state1, float8[] state2)
mlp_result	internal_mlp_igd_result (float8[] state)
mlp_result	internal_mlp_minibatch_result (float8[] state)
mlp_result	internal_mlp_alr_result (float8[] state)
void	mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights, boolean warm_start, boolean verbose, varchar grouping_col)
void	mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights, boolean warm_start, boolean verbose, varchar grouping_col)
void	mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights, boolean warm_start, boolean verbose)
void	mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights, boolean warm_start)
void	mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights)
void	mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation)
void	mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params)
void	mlp_classification (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes)
void	mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights, boolean warm_start, boolean verbose)
void	mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights, boolean warm_start)
void	mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation, varchar weights)
void	mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params, varchar activation)
void	mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes, varchar optimizer_params)
void	mlp_regression (varchar source_table, varchar output_table, varchar independent_varname, varchar dependent_varname, integer[] hidden_layer_sizes)
void	mlp_predict (varchar model_table, varchar data_table, varchar id_col_name, varchar output_table, varchar pred_type)
float8 []	internal_predict_mlp (float8[] coeff, float8[] independent_varname, float8 is_classification, float8 activation, float8[] layer_sizes, integer is_response, float8[] x_means, float8[] x_stds, integer array_dep_var_for_classification)
text	mlp_classification (text message)
text	mlp_classification ()
text	mlp_regression (text message)
text	mlp_regression ()
text	mlp_predict (text message)
text	mlp_predict ()

Detailed Description

Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Date

June 2012

Function Documentation

internal_mlp_alr_result()

mlp_result internal_mlp_alr_result

(

float8 []

state

)

internal_mlp_igd_distance()

float8 internal_mlp_igd_distance	(	float8 []	state1,
		float8 []	state2
	)

internal_mlp_igd_result()

mlp_result internal_mlp_igd_result

(

float8 []

state

)

internal_mlp_minibatch_result()

mlp_result internal_mlp_minibatch_result

(

float8 []

state

)

internal_predict_mlp()

float8 [] internal_predict_mlp	(	float8 []	coeff,
		float8 []	independent_varname,
		float8	is_classification,
		float8	activation,
		float8 []	layer_sizes,
		integer	is_response,
		float8 []	x_means,
		float8 []	x_stds,
		integer	array_dep_var_for_classification
	)

mlp_alr_final()

float8 [] mlp_alr_final

(

float8 []

state

)

mlp_alr_merge()

float8 [] mlp_alr_merge	(	float8 []	state1,
		float8 []	state2
	)

mlp_alr_step()

aggregate float8 [] mlp_alr_step	(	float8	[],
		float8	[],
		float8	[],
		float8	[],
		float8	,
		integer	,
		integer	,
		float8	,
		float8	[],
		float8	,
		integer	,
		integer	,
		integer	,
		float8	,
		float8	,
		float8	,
		float8
	)

mlp_alr_transition()

float8 [] mlp_alr_transition	(	float8 []	state,
		float8 []	ind_var,
		float8 []	dep_var,
		float8 []	previous_state,
		float8 []	layer_sizes,
		float8	learning_rate_init,
		integer	activation,
		integer	is_classification,
		float8	weight,
		float8 []	warm_start_coeff,
		float8	lambda,
		integer	batch_size,
		integer	n_epochs,
		integer	opt_code,
		float8	rho,
		float8	beta1,
		float8	beta2,
		float8	eps
	)

mlp_classification() [1/9]

void mlp_classification	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes,
		varchar	optimizer_params,
		varchar	activation,
		varchar	weights,
		boolean	warm_start,
		boolean	verbose,
		varchar	grouping_col
	)

mlp_classification() [2/9]

void mlp_classification	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes,
		varchar	optimizer_params,
		varchar	activation,
		varchar	weights,
		boolean	warm_start,
		boolean	verbose
	)

mlp_classification() [3/9]

void mlp_classification	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes,
		varchar	optimizer_params,
		varchar	activation,
		varchar	weights,
		boolean	warm_start
	)

mlp_classification() [4/9]

void mlp_classification	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes,
		varchar	optimizer_params,
		varchar	activation,
		varchar	weights
	)

mlp_classification() [5/9]

void mlp_classification	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes,
		varchar	optimizer_params,
		varchar	activation
	)

mlp_classification() [6/9]

void mlp_classification	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes,
		varchar	optimizer_params
	)

mlp_classification() [7/9]

void mlp_classification	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes
	)

mlp_classification() [8/9]

text mlp_classification

(

text

message

)

mlp_classification() [9/9]

text mlp_classification

(

)

mlp_igd_final()

float8 [] mlp_igd_final

(

float8 []

state

)

mlp_igd_merge()

float8 [] mlp_igd_merge	(	float8 []	state1,
		float8 []	state2
	)

mlp_igd_step()

aggregate float8 [] mlp_igd_step	(	float8	[],
		float8	[],
		float8	[],
		float8	[],
		float8	,
		integer	,
		integer	,
		float8	,
		float8	[],
		float8	,
		float8	,
		boolean
	)

mlp_igd_transition()

float8 [] mlp_igd_transition	(	float8 []	state,
		float8 []	ind_var,
		float8 []	dep_var,
		float8 []	previous_state,
		float8 []	layer_sizes,
		float8	learning_rate_init,
		integer	activation,
		integer	is_classification,
		float8	weight,
		float8 []	warm_start_coeff,
		float8	lambda,
		float8	momentum,
		boolean	is_nesterov
	)

mlp_minibatch_final()

float8 [] mlp_minibatch_final

(

float8 []

state

)

mlp_minibatch_merge()

float8 [] mlp_minibatch_merge	(	float8 []	state1,
		float8 []	state2
	)

mlp_minibatch_step()

aggregate float8 [] mlp_minibatch_step	(	float8	[],
		float8	[],
		float8	[],
		float8	[],
		float8	,
		integer	,
		integer	,
		float8	,
		float8	[],
		float8	,
		integer	,
		integer	,
		float8	,
		boolean
	)

mlp_minibatch_transition()

float8 [] mlp_minibatch_transition	(	float8 []	state,
		float8 []	ind_var,
		float8 []	dep_var,
		float8 []	previous_state,
		float8 []	layer_sizes,
		float8	learning_rate_init,
		integer	activation,
		integer	is_classification,
		float8	weight,
		float8 []	warm_start_coeff,
		float8	lambda,
		integer	batch_size,
		integer	n_epochs,
		float8	momentum,
		boolean	is_nesterov
	)

mlp_predict() [1/3]

void mlp_predict	(	varchar	model_table,
		varchar	data_table,
		varchar	id_col_name,
		varchar	output_table,
		varchar	pred_type
	)

mlp_predict() [2/3]

text mlp_predict

(

text

message

)

mlp_predict() [3/3]

text mlp_predict

(

)

mlp_regression() [1/9]

void mlp_regression	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes,
		varchar	optimizer_params,
		varchar	activation,
		varchar	weights,
		boolean	warm_start,
		boolean	verbose,
		varchar	grouping_col
	)

mlp_regression() [2/9]

void mlp_regression	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes,
		varchar	optimizer_params,
		varchar	activation,
		varchar	weights,
		boolean	warm_start,
		boolean	verbose
	)

mlp_regression() [3/9]

void mlp_regression	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes,
		varchar	optimizer_params,
		varchar	activation,
		varchar	weights,
		boolean	warm_start
	)

mlp_regression() [4/9]

void mlp_regression	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes,
		varchar	optimizer_params,
		varchar	activation,
		varchar	weights
	)

mlp_regression() [5/9]

void mlp_regression	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes,
		varchar	optimizer_params,
		varchar	activation
	)

mlp_regression() [6/9]

void mlp_regression	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes,
		varchar	optimizer_params
	)

mlp_regression() [7/9]

void mlp_regression	(	varchar	source_table,
		varchar	output_table,
		varchar	independent_varname,
		varchar	dependent_varname,
		integer []	hidden_layer_sizes
	)

mlp_regression() [8/9]

text mlp_regression

(

text

message

)

mlp_regression() [9/9]

text mlp_regression

(

)