7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
GMMFit Example 3 Output Message Table
property value
Output Table dpgmm_output_ex3
Algorithm Used Dirichlet Process GMM
Stopping Criterion Algorithm converged with tolerance 0.001
Delta Log Likelihood 0.000494
Number of Iterations 9
Number of Clusters Found 1
Covariance Type full
Number of Data Points 120
Global Mean [5.866, 3.055, 3.770, 1.205]
Global Covariance [[0.7197, -0.04204, 1.326, 0.5265], [-0.04204, 0.1916, -0.3241, -0.1213], 1.326, -0.3241, 3.167, 1.298], [0.5265, -0.1213, 1.298, 0.5708]]
Log Likelihood 1550.435
Akaike Information Criterion -3012.870 on 44 parameters
Bayesian Information Criterion -2890.220 on 44 parameters

The following query returns the output shown in the table dpgmm_output_ex3:

SELECT * FROM dpgmm_output_ex3 ORDER BY cluster_id;
GMMFit Example 3 Output Table dpgmm_output_ex3 (Columns 1-6)
cluster_id points_assigned covariance_type weight sepal_length sepal_width
0 120 full 0.999991735613739 5.7341932211886 3.01843399034949
1 0 full 8.25613837088043e-06 0 0
2 0 full 8.24789043818501e-09 0 0
GMMFit Example 3 Output Table dpgmm_output_ex3 (Columns 7-11)
petal_length petal_width cov_11 cov_12 cov_13
3.61166170612114 1.14486231099299 1.66229689039324 -0.214185091078124 1.69427436339271
0 0 0.166666666666667 0 0
0 0 0.166666666666667 0 0
GMMFit Example 3 Output Table dpgmm_output_ex3 (Columns 12-16)
cov_14 cov_22 cov_23 cov_24 cov_33
0.693859013357687 1.14410673773899 0.0262470085044228 0.0196024370046391 4.00032158430361
0 0.166666666666667 0 0 0.166666666666667
0 0.166666666666667 0 0 0.166666666666667
GMMFit Example 3 Output Table dpgmm_output_ex3 (Columns 17-20)
cov_34 cov_44 determinant prec
1.27929539653395 1.50738875289365 6.57941093165913 [[0.7824065815292398, -0.04166719847723184, -0.2990852200079339, -0.10577545748404801], [-0.09328114699788496, 0.8754360535621004, 0.03258314800179726, 0.00390066150799786], [-0.16999962390216933, 0.13304206710705144, 0.4009441383070519, -0.26375290851001104], [-0.04690499550266552, 0.04519483233542283, -0.2524462687807997, 0.898648654482997]]
0 0.166666666666667 0.000771604938271605 [[6.0, 0.0, 0.0, 0.0], [0.0, 6.0, 0.0, 0.0], [0.0, 0.0, 6.0, 0.0], [0.0, 0.0, 0.0, 6.0]]
0 0.166666666666667 0.000771604938271605 [[6.0, 0.0, 0.0, 0.0], [0.0, 6.0, 0.0, 0.0], [0.0, 0.0, 6.0, 0.0], [0.0, 0.0, 0.0, 6.0]]