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 ()

Detailed Description

See also

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

Function Documentation

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_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

(

)