pca.sql_in File Reference

Principal Component Analysis. More...

Functions
void	pca_train (text source_table, text pc_table, text row_id, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table, float8 variance)
void	pca_train (text source_table, text pc_table, text row_id, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table)
void	pca_train (text source_table, text pc_table, text row_id, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation)
void	pca_train (text source_table, text pc_table, text row_id, integer k, text grouping_cols, integer lanczos_iter)
void	pca_train (text source_table, text pc_table, text row_id, integer k, text grouping_cols)
void	pca_train (text source_table, text pc_table, text row_id, integer k)
void	pca_train (text source_table, text pc_table, text row_id, float8 variance, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table)
void	pca_train (text source_table, text pc_table, text row_id, float8 variance, text grouping_cols, integer lanczos_iter, boolean use_correlation)
void	pca_train (text source_table, text pc_table, text row_id, float8 variance, text grouping_cols, integer lanczos_iter)
void	pca_train (text source_table, text pc_table, text row_id, float8 variance, text grouping_cols)
void	pca_train (text source_table, text pc_table, text row_id, float8 variance)
text	pca_train (varchar usage_string)
varchar	pca_train ()
void	pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table, float8 variance)
void	pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table)
void	pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation)
void	pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, integer k, text grouping_cols, integer lanczos_iter)
void	pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, integer k, text grouping_cols)
void	pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, integer k)
void	pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, float8 variance, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table)
void	pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, float8 variance, text grouping_cols, integer lanczos_iter, boolean use_correlation)
void	pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, float8 variance, text grouping_cols, integer lanczos_iter)
void	pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, float8 variance, text grouping_cols)
void	pca_sparse_train (text source_table, text pc_table, text row_id, text col_id, text val_id, integer row_dim, integer col_dim, float8 variance)
text	pca_sparse_train (varchar usage_string)
text	pca_sparse_train ()
void	_pca_union (text source_table, text pc_table, text pc_table_mean, text row_id, integer k, text grouping_cols, integer lanczos_iter, boolean use_correlation, text result_summary_table, text result_summary_table_temp, float8 variance, integer grp_id, text grouping_where_clause, text sparse_where_condition, text select_grouping_cols, text temp_table_columns, boolean is_sparse, text col_id, text val_id, integer row_dim, integer col_dim)

Detailed Description

See also

For a brief introduction to Principal Component Analysis, see the module description Dimensionality Reduction.

Function Documentation

_pca_union()

void _pca_union	(	text	source_table,
		text	pc_table,
		text	pc_table_mean,
		text	row_id,
		integer	k,
		text	grouping_cols,
		integer	lanczos_iter,
		boolean	use_correlation,
		text	result_summary_table,
		text	result_summary_table_temp,
		float8	variance,
		integer	grp_id,
		text	grouping_where_clause,
		text	sparse_where_condition,
		text	select_grouping_cols,
		text	temp_table_columns,
		boolean	is_sparse,
		text	col_id,
		text	val_id,
		integer	row_dim,
		integer	col_dim
	)

pca_sparse_train() [1/13]

void pca_sparse_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		text	col_id,
		text	val_id,
		integer	row_dim,
		integer	col_dim,
		integer	k,
		text	grouping_cols,
		integer	lanczos_iter,
		boolean	use_correlation,
		text	result_summary_table,
		float8	variance
	)

pca_sparse_train() [2/13]

void pca_sparse_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		text	col_id,
		text	val_id,
		integer	row_dim,
		integer	col_dim,
		integer	k,
		text	grouping_cols,
		integer	lanczos_iter,
		boolean	use_correlation,
		text	result_summary_table
	)

pca_sparse_train() [3/13]

void pca_sparse_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		text	col_id,
		text	val_id,
		integer	row_dim,
		integer	col_dim,
		integer	k,
		text	grouping_cols,
		integer	lanczos_iter,
		boolean	use_correlation
	)

pca_sparse_train() [4/13]

void pca_sparse_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		text	col_id,
		text	val_id,
		integer	row_dim,
		integer	col_dim,
		integer	k,
		text	grouping_cols,
		integer	lanczos_iter
	)

pca_sparse_train() [5/13]

void pca_sparse_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		text	col_id,
		text	val_id,
		integer	row_dim,
		integer	col_dim,
		integer	k,
		text	grouping_cols
	)

pca_sparse_train() [6/13]

void pca_sparse_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		text	col_id,
		text	val_id,
		integer	row_dim,
		integer	col_dim,
		integer	k
	)

pca_sparse_train() [7/13]

void pca_sparse_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		text	col_id,
		text	val_id,
		integer	row_dim,
		integer	col_dim,
		float8	variance,
		text	grouping_cols,
		integer	lanczos_iter,
		boolean	use_correlation,
		text	result_summary_table
	)

pca_sparse_train() [8/13]

void pca_sparse_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		text	col_id,
		text	val_id,
		integer	row_dim,
		integer	col_dim,
		float8	variance,
		text	grouping_cols,
		integer	lanczos_iter,
		boolean	use_correlation
	)

pca_sparse_train() [9/13]

void pca_sparse_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		text	col_id,
		text	val_id,
		integer	row_dim,
		integer	col_dim,
		float8	variance,
		text	grouping_cols,
		integer	lanczos_iter
	)

pca_sparse_train() [10/13]

void pca_sparse_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		text	col_id,
		text	val_id,
		integer	row_dim,
		integer	col_dim,
		float8	variance,
		text	grouping_cols
	)

pca_sparse_train() [11/13]

void pca_sparse_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		text	col_id,
		text	val_id,
		integer	row_dim,
		integer	col_dim,
		float8	variance
	)

pca_sparse_train() [12/13]

text pca_sparse_train

(

varchar

usage_string

)

pca_sparse_train() [13/13]

text pca_sparse_train

(

)

pca_train() [1/13]

void pca_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		integer	k,
		text	grouping_cols,
		integer	lanczos_iter,
		boolean	use_correlation,
		text	result_summary_table,
		float8	variance
	)

pca_train() [2/13]

void pca_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		integer	k,
		text	grouping_cols,
		integer	lanczos_iter,
		boolean	use_correlation,
		text	result_summary_table
	)

pca_train() [3/13]

void pca_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		integer	k,
		text	grouping_cols,
		integer	lanczos_iter,
		boolean	use_correlation
	)

pca_train() [4/13]

void pca_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		integer	k,
		text	grouping_cols,
		integer	lanczos_iter
	)

pca_train() [5/13]

void pca_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		integer	k,
		text	grouping_cols
	)

pca_train() [6/13]

void pca_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		integer	k
	)

pca_train() [7/13]

void pca_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		float8	variance,
		text	grouping_cols,
		integer	lanczos_iter,
		boolean	use_correlation,
		text	result_summary_table
	)

pca_train() [8/13]

void pca_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		float8	variance,
		text	grouping_cols,
		integer	lanczos_iter,
		boolean	use_correlation
	)

pca_train() [9/13]

void pca_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		float8	variance,
		text	grouping_cols,
		integer	lanczos_iter
	)

pca_train() [10/13]

void pca_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		float8	variance,
		text	grouping_cols
	)

pca_train() [11/13]

void pca_train	(	text	source_table,
		text	pc_table,
		text	row_id,
		float8	variance
	)

pca_train() [12/13]

text pca_train

(

varchar

usage_string

)

pca_train() [13/13]

varchar pca_train

(

)