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 () |
float8 internal_linear_svm_igd_distance | ( | float8 [] | state1, |
float8 [] | state2 | ||
) |
linear_svm_result internal_linear_svm_igd_result | ( | float8 [] | state | ) |
float8 [] linear_svm_igd_final | ( | float8 [] | state | ) |
float8 [] linear_svm_igd_merge | ( | float8 [] | state1, |
float8 [] | state2 | ||
) |
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 [] 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 | ||
) |
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 | ||
) |
text svm_classification | ( | text | message | ) |
text svm_classification | ( | ) |
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 | ||
) |
text svm_one_class | ( | text | message | ) |
text svm_one_class | ( | ) |
void svm_predict | ( | text | model_table, |
text | new_data_table, | ||
text | id_col_name, | ||
text | output_table | ||
) |
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 |
text svm_predict | ( | text | message | ) |
text svm_predict | ( | ) |
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 | ||
) |
text svm_regression | ( | text | message | ) |
text svm_regression | ( | ) |