utils_regularization.sql_in

CREATE TYPE MADLIB_SCHEMA.__utils_scales AS (
    mean                DOUBLE PRECISION[],
    std                 DOUBLE PRECISION[]
);

--

CREATE FUNCTION MADLIB_SCHEMA.__utils_var_scales_result (
    in_state            DOUBLE PRECISION[]
) RETURNS MADLIB_SCHEMA.__utils_scales AS
'MODULE_PATHNAME', '__utils_var_scales_result'
LANGUAGE C IMMUTABLE STRICT;

------------------------------------------------------------------------

CREATE FUNCTION MADLIB_SCHEMA.__utils_var_scales_transition (
    state               DOUBLE PRECISION[],
    ind_var             DOUBLE PRECISION[],
    dimension           INTEGER
) RETURNS DOUBLE PRECISION[] AS
'MODULE_PATHNAME', 'utils_var_scales_transition'
LANGUAGE C IMMUTABLE STRICT;

--

CREATE FUNCTION MADLIB_SCHEMA.__utils_var_scales_merge (
    state1              DOUBLE PRECISION[],
    state2              DOUBLE PRECISION[]
) RETURNS DOUBLE PRECISION[] AS
'MODULE_PATHNAME', 'utils_var_scales_merge'
LANGUAGE C IMMUTABLE STRICT;

--

CREATE FUNCTION MADLIB_SCHEMA.__utils_var_scales_final (
    state               DOUBLE PRECISION[]
) RETURNS DOUBLE PRECISION[] AS
'MODULE_PATHNAME', 'utils_var_scales_final'
LANGUAGE C IMMUTABLE STRICT;

--

CREATE AGGREGATE MADLIB_SCHEMA.utils_var_scales (
    /* ind_var  */      DOUBLE PRECISION[],
    /* dimension*/      INTEGER
) (
    SType = DOUBLE PRECISION[],
    SFunc = MADLIB_SCHEMA.__utils_var_scales_transition,
    m4_ifdef(`GREENPLUM', `prefunc = MADLIB_SCHEMA.__utils_var_scales_merge,')
    FinalFunc = MADLIB_SCHEMA.__utils_var_scales_final,
    InitCond = '{0,0,0,0}'
);

------------------------------------------------------------------------

CREATE TYPE MADLIB_SCHEMA.__utils_scaled_data AS (
    scaled      DOUBLE PRECISION[]
);

--

CREATE FUNCTION MADLIB_SCHEMA.utils_normalize_data (
    x           DOUBLE PRECISION[],
    mean        DOUBLE PRECISION[],
    std         DOUBLE PRECISION[]
) RETURNS MADLIB_SCHEMA.__utils_scaled_data AS
'MODULE_PATHNAME', 'utils_normalize_data'
LANGUAGE C IMMUTABLE STRICT;