svm.sql_in File Reference

SQL functions for SVM (Poisson) More...

Functions
float8 []	linear_svm_igd_transition (float8[] state, float8[] ind_var, float8 dep_var, float8[] previous_state, integer dimension, float8 stepsize, float8 reg, boolean is_l2, integer n_tuples, float8 epsilon, boolean is_svc, float8 tuple_weight)
float8 []	linear_svm_igd_merge (float8[] state1, float8[] state2)
float8 []	linear_svm_igd_final (float8[] state)
aggregate float8 []	linear_svm_igd_step (float8[] ind_var, float8 dep_var, float8[] previous_state, integer dimension, float8 stepsize, float8 reg, boolean is_l2, integer n_tuples, float8 epsilon, boolean is_svc, float8 tuple_weight)
float8	internal_linear_svm_igd_distance (float8[] state1, float8[] state2)
linear_svm_result	internal_linear_svm_igd_result (float8[] state)
void	svm_regression (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params, text grouping_col, text params, bool verbose)
void	svm_regression (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params, text grouping_col, text params)
void	svm_regression (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params, text grouping_col)
void	svm_regression (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params)
void	svm_regression (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func)
void	svm_regression (text source_table, text model_table, text dependent_varname, text independent_varname)
void	svm_classification (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params, text grouping_col, text params, bool verbose)
void	svm_classification (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params, text grouping_col, text params)
void	svm_classification (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params, text grouping_col)
void	svm_classification (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func, text kernel_params)
void	svm_classification (text source_table, text model_table, text dependent_varname, text independent_varname, text kernel_func)
void	svm_classification (text source_table, text model_table, text dependent_varname, text independent_varname)
void	svm_one_class (text source_table, text model_table, text independent_varname, text kernel_func, text kernel_params, text grouping_col, text params, bool verbose)
void	svm_one_class (text source_table, text model_table, text independent_varname, text kernel_func, text kernel_params, text grouping_col, text params)
void	svm_one_class (text source_table, text model_table, text independent_varname, text kernel_func, text kernel_params, text grouping_col)
void	svm_one_class (text source_table, text model_table, text independent_varname, text kernel_func, text kernel_params)
void	svm_one_class (text source_table, text model_table, text independent_varname, text kernel_func)
void	svm_one_class (text source_table, text model_table, text independent_varname)
void	svm_predict (text model_table, text new_data_table, text id_col_name, text output_table)
	Scores the data points stored in a table using a learned linear support-vector model. More...
text	svm_predict (text message)
	Help function. More...
text	svm_predict ()
text	svm_classification (text message)
text	svm_classification ()
text	svm_one_class (text message)
text	svm_one_class ()
text	svm_regression (text message)
text	svm_regression ()

Detailed Description

Date

July 2015

See also

For a brief introduction to SVM (Poisson), see the module description Support Vector Machines.

Function Documentation

internal_linear_svm_igd_distance()

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

internal_linear_svm_igd_result()

linear_svm_result internal_linear_svm_igd_result

(

float8 []

state

)

linear_svm_igd_final()

float8 [] linear_svm_igd_final

(

float8 []

state

)

linear_svm_igd_merge()

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

linear_svm_igd_step()

aggregate float8 [] linear_svm_igd_step	(	float8 []	ind_var,
		float8	dep_var,
		float8 []	previous_state,
		integer	dimension,
		float8	stepsize,
		float8	reg,
		boolean	is_l2,
		integer	n_tuples,
		float8	epsilon,
		boolean	is_svc,
		float8	tuple_weight
	)

linear_svm_igd_transition()

float8 [] linear_svm_igd_transition	(	float8 []	state,
		float8 []	ind_var,
		float8	dep_var,
		float8 []	previous_state,
		integer	dimension,
		float8	stepsize,
		float8	reg,
		boolean	is_l2,
		integer	n_tuples,
		float8	epsilon,
		boolean	is_svc,
		float8	tuple_weight
	)

svm_classification() [1/8]

void svm_classification	(	text	source_table,
		text	model_table,
		text	dependent_varname,
		text	independent_varname,
		text	kernel_func,
		text	kernel_params,
		text	grouping_col,
		text	params,
		bool	verbose
	)

svm_classification() [2/8]

void svm_classification	(	text	source_table,
		text	model_table,
		text	dependent_varname,
		text	independent_varname,
		text	kernel_func,
		text	kernel_params,
		text	grouping_col,
		text	params
	)

svm_classification() [3/8]

void svm_classification	(	text	source_table,
		text	model_table,
		text	dependent_varname,
		text	independent_varname,
		text	kernel_func,
		text	kernel_params,
		text	grouping_col
	)

svm_classification() [4/8]

void svm_classification	(	text	source_table,
		text	model_table,
		text	dependent_varname,
		text	independent_varname,
		text	kernel_func,
		text	kernel_params
	)

svm_classification() [5/8]

void svm_classification	(	text	source_table,
		text	model_table,
		text	dependent_varname,
		text	independent_varname,
		text	kernel_func
	)

svm_classification() [6/8]

void svm_classification	(	text	source_table,
		text	model_table,
		text	dependent_varname,
		text	independent_varname
	)

svm_classification() [7/8]

text svm_classification

(

text

message

)

svm_classification() [8/8]

text svm_classification

(

)

svm_one_class() [1/8]

void svm_one_class	(	text	source_table,
		text	model_table,
		text	independent_varname,
		text	kernel_func,
		text	kernel_params,
		text	grouping_col,
		text	params,
		bool	verbose
	)

svm_one_class() [2/8]

void svm_one_class	(	text	source_table,
		text	model_table,
		text	independent_varname,
		text	kernel_func,
		text	kernel_params,
		text	grouping_col,
		text	params
	)

svm_one_class() [3/8]

void svm_one_class	(	text	source_table,
		text	model_table,
		text	independent_varname,
		text	kernel_func,
		text	kernel_params,
		text	grouping_col
	)

svm_one_class() [4/8]

void svm_one_class	(	text	source_table,
		text	model_table,
		text	independent_varname,
		text	kernel_func,
		text	kernel_params
	)

svm_one_class() [5/8]

void svm_one_class	(	text	source_table,
		text	model_table,
		text	independent_varname,
		text	kernel_func
	)

svm_one_class() [6/8]

void svm_one_class	(	text	source_table,
		text	model_table,
		text	independent_varname
	)

svm_one_class() [7/8]

text svm_one_class

(

text

message

)

svm_one_class() [8/8]

text svm_one_class

(

)

svm_predict() [1/3]

void svm_predict	(	text	model_table,
		text	new_data_table,
		text	id_col_name,
		text	output_table
	)

Parameters

model_table	Name of table where the learned model to be used is stored
new_data_table	Name of table/view containing the data points to be scored
id_col	Name of column in new_data_table containing the integer identifier of data points
output_table	Name of table to store the results

Returns

Textual summary of the algorithm run

svm_predict() [2/3]

text svm_predict

(

text

message

)

svm_predict() [3/3]

text svm_predict

(

)

svm_regression() [1/8]

void svm_regression	(	text	source_table,
		text	model_table,
		text	dependent_varname,
		text	independent_varname,
		text	kernel_func,
		text	kernel_params,
		text	grouping_col,
		text	params,
		bool	verbose
	)

svm_regression() [2/8]

void svm_regression	(	text	source_table,
		text	model_table,
		text	dependent_varname,
		text	independent_varname,
		text	kernel_func,
		text	kernel_params,
		text	grouping_col,
		text	params
	)

svm_regression() [3/8]

void svm_regression	(	text	source_table,
		text	model_table,
		text	dependent_varname,
		text	independent_varname,
		text	kernel_func,
		text	kernel_params,
		text	grouping_col
	)

svm_regression() [4/8]

void svm_regression	(	text	source_table,
		text	model_table,
		text	dependent_varname,
		text	independent_varname,
		text	kernel_func,
		text	kernel_params
	)

svm_regression() [5/8]

void svm_regression	(	text	source_table,
		text	model_table,
		text	dependent_varname,
		text	independent_varname,
		text	kernel_func
	)

svm_regression() [6/8]

void svm_regression	(	text	source_table,
		text	model_table,
		text	dependent_varname,
		text	independent_varname
	)

svm_regression() [7/8]

text svm_regression

(

text

message

)

svm_regression() [8/8]

text svm_regression

(

)