vasco

discover hidden correlations in your data with MIC

vasco : discover hidden correlations in your data with MIC

Overview

ID	Extension	Package	Version	Category	License	Language
4660	vasco	vasco	`0.1.0`	FUNC	GPL-3.0	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-d-r	No	Yes	No	Yes	yes	no

Relationships
See Also	weighted_statistics pg_math xicor fbsql

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PIGSTY	`0.1.0`	18 17 16 15 14	`vasco`	-
RPM	PIGSTY	`0.1.0`	18 17 16 15 14	`vasco_$v`	-
DEB	PIGSTY	`0.1.0`	18 17 16 15 14	`postgresql-$v-vasco`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
el8.aarch64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
el9.x86_64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
el9.aarch64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
el10.x86_64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
el10.aarch64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
d12.x86_64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
d12.aarch64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
d13.x86_64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
d13.aarch64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
u22.x86_64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
u22.aarch64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
u24.x86_64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
u24.aarch64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
u26.x86_64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0
u26.aarch64	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0	PIGSTY 0.1.0

Package	Version	OS	ORG	SIZE	File URL
`vasco_18`	`0.1.0`	el8.x86_64	pigsty	40.6 KiB	vasco_18-0.1.0-1PIGSTY.el8.x86_64.rpm
`vasco_18`	`0.1.0`	el8.aarch64	pigsty	39.4 KiB	vasco_18-0.1.0-1PIGSTY.el8.aarch64.rpm
`vasco_18`	`0.1.0`	el9.x86_64	pigsty	37.9 KiB	vasco_18-0.1.0-1PIGSTY.el9.x86_64.rpm
`vasco_18`	`0.1.0`	el9.aarch64	pigsty	37.0 KiB	vasco_18-0.1.0-1PIGSTY.el9.aarch64.rpm
`vasco_18`	`0.1.0`	el10.x86_64	pigsty	38.1 KiB	vasco_18-0.1.0-1PIGSTY.el10.x86_64.rpm
`vasco_18`	`0.1.0`	el10.aarch64	pigsty	37.1 KiB	vasco_18-0.1.0-1PIGSTY.el10.aarch64.rpm
`postgresql-18-vasco`	`0.1.0`	d12.x86_64	pigsty	53.6 KiB	postgresql-18-vasco_0.1.0-1PIGSTY~bookworm_amd64.deb
`postgresql-18-vasco`	`0.1.0`	d12.aarch64	pigsty	52.7 KiB	postgresql-18-vasco_0.1.0-1PIGSTY~bookworm_arm64.deb
`postgresql-18-vasco`	`0.1.0`	d13.x86_64	pigsty	53.7 KiB	postgresql-18-vasco_0.1.0-1PIGSTY~trixie_amd64.deb
`postgresql-18-vasco`	`0.1.0`	d13.aarch64	pigsty	52.9 KiB	postgresql-18-vasco_0.1.0-1PIGSTY~trixie_arm64.deb
`postgresql-18-vasco`	`0.1.0`	u22.x86_64	pigsty	55.5 KiB	postgresql-18-vasco_0.1.0-1PIGSTY~jammy_amd64.deb
`postgresql-18-vasco`	`0.1.0`	u22.aarch64	pigsty	54.1 KiB	postgresql-18-vasco_0.1.0-1PIGSTY~jammy_arm64.deb
`postgresql-18-vasco`	`0.1.0`	u24.x86_64	pigsty	54.2 KiB	postgresql-18-vasco_0.1.0-1PIGSTY~noble_amd64.deb
`postgresql-18-vasco`	`0.1.0`	u24.aarch64	pigsty	53.1 KiB	postgresql-18-vasco_0.1.0-1PIGSTY~noble_arm64.deb
`postgresql-18-vasco`	`0.1.0`	u26.x86_64	pigsty	53.9 KiB	postgresql-18-vasco_0.1.0-1PIGSTY~resolute_amd64.deb
`postgresql-18-vasco`	`0.1.0`	u26.aarch64	pigsty	52.9 KiB	postgresql-18-vasco_0.1.0-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`vasco_17`	`0.1.0`	el8.x86_64	pigsty	40.6 KiB	vasco_17-0.1.0-1PIGSTY.el8.x86_64.rpm
`vasco_17`	`0.1.0`	el8.aarch64	pigsty	39.4 KiB	vasco_17-0.1.0-1PIGSTY.el8.aarch64.rpm
`vasco_17`	`0.1.0`	el9.x86_64	pigsty	38.1 KiB	vasco_17-0.1.0-1PIGSTY.el9.x86_64.rpm
`vasco_17`	`0.1.0`	el9.aarch64	pigsty	37.1 KiB	vasco_17-0.1.0-1PIGSTY.el9.aarch64.rpm
`vasco_17`	`0.1.0`	el10.x86_64	pigsty	38.3 KiB	vasco_17-0.1.0-1PIGSTY.el10.x86_64.rpm
`vasco_17`	`0.1.0`	el10.aarch64	pigsty	37.2 KiB	vasco_17-0.1.0-1PIGSTY.el10.aarch64.rpm
`postgresql-17-vasco`	`0.1.0`	d12.x86_64	pigsty	53.6 KiB	postgresql-17-vasco_0.1.0-1PIGSTY~bookworm_amd64.deb
`postgresql-17-vasco`	`0.1.0`	d12.aarch64	pigsty	52.7 KiB	postgresql-17-vasco_0.1.0-1PIGSTY~bookworm_arm64.deb
`postgresql-17-vasco`	`0.1.0`	d13.x86_64	pigsty	53.7 KiB	postgresql-17-vasco_0.1.0-1PIGSTY~trixie_amd64.deb
`postgresql-17-vasco`	`0.1.0`	d13.aarch64	pigsty	52.9 KiB	postgresql-17-vasco_0.1.0-1PIGSTY~trixie_arm64.deb
`postgresql-17-vasco`	`0.1.0`	u22.x86_64	pigsty	57.8 KiB	postgresql-17-vasco_0.1.0-1PIGSTY~jammy_amd64.deb
`postgresql-17-vasco`	`0.1.0`	u22.aarch64	pigsty	56.3 KiB	postgresql-17-vasco_0.1.0-1PIGSTY~jammy_arm64.deb
`postgresql-17-vasco`	`0.1.0`	u24.x86_64	pigsty	54.3 KiB	postgresql-17-vasco_0.1.0-1PIGSTY~noble_amd64.deb
`postgresql-17-vasco`	`0.1.0`	u24.aarch64	pigsty	53.0 KiB	postgresql-17-vasco_0.1.0-1PIGSTY~noble_arm64.deb
`postgresql-17-vasco`	`0.1.0`	u26.x86_64	pigsty	54.0 KiB	postgresql-17-vasco_0.1.0-1PIGSTY~resolute_amd64.deb
`postgresql-17-vasco`	`0.1.0`	u26.aarch64	pigsty	53.0 KiB	postgresql-17-vasco_0.1.0-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`vasco_16`	`0.1.0`	el8.x86_64	pigsty	40.6 KiB	vasco_16-0.1.0-1PIGSTY.el8.x86_64.rpm
`vasco_16`	`0.1.0`	el8.aarch64	pigsty	39.4 KiB	vasco_16-0.1.0-1PIGSTY.el8.aarch64.rpm
`vasco_16`	`0.1.0`	el9.x86_64	pigsty	38.1 KiB	vasco_16-0.1.0-1PIGSTY.el9.x86_64.rpm
`vasco_16`	`0.1.0`	el9.aarch64	pigsty	37.1 KiB	vasco_16-0.1.0-1PIGSTY.el9.aarch64.rpm
`vasco_16`	`0.1.0`	el10.x86_64	pigsty	38.3 KiB	vasco_16-0.1.0-1PIGSTY.el10.x86_64.rpm
`vasco_16`	`0.1.0`	el10.aarch64	pigsty	37.2 KiB	vasco_16-0.1.0-1PIGSTY.el10.aarch64.rpm
`postgresql-16-vasco`	`0.1.0`	d12.x86_64	pigsty	53.6 KiB	postgresql-16-vasco_0.1.0-1PIGSTY~bookworm_amd64.deb
`postgresql-16-vasco`	`0.1.0`	d12.aarch64	pigsty	52.7 KiB	postgresql-16-vasco_0.1.0-1PIGSTY~bookworm_arm64.deb
`postgresql-16-vasco`	`0.1.0`	d13.x86_64	pigsty	53.7 KiB	postgresql-16-vasco_0.1.0-1PIGSTY~trixie_amd64.deb
`postgresql-16-vasco`	`0.1.0`	d13.aarch64	pigsty	52.9 KiB	postgresql-16-vasco_0.1.0-1PIGSTY~trixie_arm64.deb
`postgresql-16-vasco`	`0.1.0`	u22.x86_64	pigsty	57.8 KiB	postgresql-16-vasco_0.1.0-1PIGSTY~jammy_amd64.deb
`postgresql-16-vasco`	`0.1.0`	u22.aarch64	pigsty	56.3 KiB	postgresql-16-vasco_0.1.0-1PIGSTY~jammy_arm64.deb
`postgresql-16-vasco`	`0.1.0`	u24.x86_64	pigsty	54.3 KiB	postgresql-16-vasco_0.1.0-1PIGSTY~noble_amd64.deb
`postgresql-16-vasco`	`0.1.0`	u24.aarch64	pigsty	53.0 KiB	postgresql-16-vasco_0.1.0-1PIGSTY~noble_arm64.deb
`postgresql-16-vasco`	`0.1.0`	u26.x86_64	pigsty	54.0 KiB	postgresql-16-vasco_0.1.0-1PIGSTY~resolute_amd64.deb
`postgresql-16-vasco`	`0.1.0`	u26.aarch64	pigsty	53.0 KiB	postgresql-16-vasco_0.1.0-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`vasco_15`	`0.1.0`	el8.x86_64	pigsty	41.0 KiB	vasco_15-0.1.0-1PIGSTY.el8.x86_64.rpm
`vasco_15`	`0.1.0`	el8.aarch64	pigsty	39.9 KiB	vasco_15-0.1.0-1PIGSTY.el8.aarch64.rpm
`vasco_15`	`0.1.0`	el9.x86_64	pigsty	40.2 KiB	vasco_15-0.1.0-1PIGSTY.el9.x86_64.rpm
`vasco_15`	`0.1.0`	el9.aarch64	pigsty	39.7 KiB	vasco_15-0.1.0-1PIGSTY.el9.aarch64.rpm
`vasco_15`	`0.1.0`	el10.x86_64	pigsty	40.5 KiB	vasco_15-0.1.0-1PIGSTY.el10.x86_64.rpm
`vasco_15`	`0.1.0`	el10.aarch64	pigsty	40.1 KiB	vasco_15-0.1.0-1PIGSTY.el10.aarch64.rpm
`postgresql-15-vasco`	`0.1.0`	d12.x86_64	pigsty	54.2 KiB	postgresql-15-vasco_0.1.0-1PIGSTY~bookworm_amd64.deb
`postgresql-15-vasco`	`0.1.0`	d12.aarch64	pigsty	53.4 KiB	postgresql-15-vasco_0.1.0-1PIGSTY~bookworm_arm64.deb
`postgresql-15-vasco`	`0.1.0`	d13.x86_64	pigsty	54.3 KiB	postgresql-15-vasco_0.1.0-1PIGSTY~trixie_amd64.deb
`postgresql-15-vasco`	`0.1.0`	d13.aarch64	pigsty	53.6 KiB	postgresql-15-vasco_0.1.0-1PIGSTY~trixie_arm64.deb
`postgresql-15-vasco`	`0.1.0`	u22.x86_64	pigsty	59.4 KiB	postgresql-15-vasco_0.1.0-1PIGSTY~jammy_amd64.deb
`postgresql-15-vasco`	`0.1.0`	u22.aarch64	pigsty	58.5 KiB	postgresql-15-vasco_0.1.0-1PIGSTY~jammy_arm64.deb
`postgresql-15-vasco`	`0.1.0`	u24.x86_64	pigsty	56.0 KiB	postgresql-15-vasco_0.1.0-1PIGSTY~noble_amd64.deb
`postgresql-15-vasco`	`0.1.0`	u24.aarch64	pigsty	55.7 KiB	postgresql-15-vasco_0.1.0-1PIGSTY~noble_arm64.deb
`postgresql-15-vasco`	`0.1.0`	u26.x86_64	pigsty	56.0 KiB	postgresql-15-vasco_0.1.0-1PIGSTY~resolute_amd64.deb
`postgresql-15-vasco`	`0.1.0`	u26.aarch64	pigsty	55.4 KiB	postgresql-15-vasco_0.1.0-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`vasco_14`	`0.1.0`	el8.x86_64	pigsty	41.0 KiB	vasco_14-0.1.0-1PIGSTY.el8.x86_64.rpm
`vasco_14`	`0.1.0`	el8.aarch64	pigsty	39.9 KiB	vasco_14-0.1.0-1PIGSTY.el8.aarch64.rpm
`vasco_14`	`0.1.0`	el9.x86_64	pigsty	40.1 KiB	vasco_14-0.1.0-1PIGSTY.el9.x86_64.rpm
`vasco_14`	`0.1.0`	el9.aarch64	pigsty	39.7 KiB	vasco_14-0.1.0-1PIGSTY.el9.aarch64.rpm
`vasco_14`	`0.1.0`	el10.x86_64	pigsty	40.5 KiB	vasco_14-0.1.0-1PIGSTY.el10.x86_64.rpm
`vasco_14`	`0.1.0`	el10.aarch64	pigsty	40.1 KiB	vasco_14-0.1.0-1PIGSTY.el10.aarch64.rpm
`postgresql-14-vasco`	`0.1.0`	d12.x86_64	pigsty	54.3 KiB	postgresql-14-vasco_0.1.0-1PIGSTY~bookworm_amd64.deb
`postgresql-14-vasco`	`0.1.0`	d12.aarch64	pigsty	53.4 KiB	postgresql-14-vasco_0.1.0-1PIGSTY~bookworm_arm64.deb
`postgresql-14-vasco`	`0.1.0`	d13.x86_64	pigsty	54.4 KiB	postgresql-14-vasco_0.1.0-1PIGSTY~trixie_amd64.deb
`postgresql-14-vasco`	`0.1.0`	d13.aarch64	pigsty	53.6 KiB	postgresql-14-vasco_0.1.0-1PIGSTY~trixie_arm64.deb
`postgresql-14-vasco`	`0.1.0`	u22.x86_64	pigsty	59.4 KiB	postgresql-14-vasco_0.1.0-1PIGSTY~jammy_amd64.deb
`postgresql-14-vasco`	`0.1.0`	u22.aarch64	pigsty	58.5 KiB	postgresql-14-vasco_0.1.0-1PIGSTY~jammy_arm64.deb
`postgresql-14-vasco`	`0.1.0`	u24.x86_64	pigsty	56.0 KiB	postgresql-14-vasco_0.1.0-1PIGSTY~noble_amd64.deb
`postgresql-14-vasco`	`0.1.0`	u24.aarch64	pigsty	55.6 KiB	postgresql-14-vasco_0.1.0-1PIGSTY~noble_arm64.deb
`postgresql-14-vasco`	`0.1.0`	u26.x86_64	pigsty	56.0 KiB	postgresql-14-vasco_0.1.0-1PIGSTY~resolute_amd64.deb
`postgresql-14-vasco`	`0.1.0`	u26.aarch64	pigsty	55.4 KiB	postgresql-14-vasco_0.1.0-1PIGSTY~resolute_arm64.deb

Source

Repository

github.com/Florents-Tselai/vasco

Source Tarball

vasco-0.1.0.tar.gz

pig build pkg vasco;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install vasco;		# install via package name, for the active PG version

pig install vasco -v 18;   # install for PG 18
pig install vasco -v 17;   # install for PG 17
pig install vasco -v 16;   # install for PG 16
pig install vasco -v 15;   # install for PG 15
pig install vasco -v 14;   # install for PG 14

Create this extension with:

CREATE EXTENSION vasco;

Usage

vasco: Maximal Information Coefficient (MIC) extension for PostgreSQL

Discover hidden correlations in your data using the Maximal Information Coefficient (MIC) and the MINE family of statistics.

CREATE EXTENSION vasco;

Aggregate Functions

Function	Description
`mic(x, y)`	Maximal Information Coefficient – detects any relationship
`mas(x, y)`	Maximum Asymmetry Score – deviation from monotonicity
`mev(x, y)`	Maximum Edge Value – degree of continuous function sampling
`mcn(x, y)`	Minimum Cell Number – complexity of association
`mcn_general(x, y)`	MCN with `eps = 1 - MIC`
`tic(x, y)`	Total Information Coefficient
`gmic(x, y)`	Generalized Mean Information Coefficient

Utility Functions

Function	Description
`vasco_corr_matrix(table_name, output_table)`	Compute MIC for all column pairs and store as a correlation matrix table

Configuration

SET vasco.mic_estimator = 'ApproxMIC';  -- or 'MIC_e'
SET vasco.mine_c = ...;
SET vasco.mine_alpha = ...;

Examples

-- Compute MIC between column pairs
SELECT mic(x, cubic), mic(x, periodic), mic(x, rand_y)
FROM vasco_data;
-- 1, 1, 0.15

-- Create a full correlation matrix
SELECT vasco_corr_matrix('my_table', 'mic_my_table');
SELECT * FROM mic_my_table;