Machine Learning in Ocient

the {{ocienthyperscaledatawarehouse}} has {{ocientml}} functionality that enables machine learning training and model execution within the database whether you are training a model or using machine learning functionality to do scoring or prediction, ocientml enables machine learning in the sql syntax directly you can use the create mlmodel sql statement to create models this step is for model training and is referred to as model creation similarly, you can use the model on new input data to generate new predictions by executing the scalar function that has the same name as the model this action is typically referred to as executing the model machine learning in {{ocient}} depends upon linear algebra functionality that is built into the ocient system ocientml provides machine learning capabilities that you can invoke in sql statements with some application logic linear algebra in ocient matrixes are a first class data type in the ocient system create a matrix using a simple sql select statement select {{1, 2}, {3, 4}}; {{1,2},{3,4}} \ \[\[1 0, 2 0], \[3 0, 4 0]] fetched 1 row select {{c1 1, c1 2}, {c1 3, c1 4}} from sys dummy2; make matrix 2x2((2), (2), ((1)) (c1), ((2)) (c1), ((3)) (c1), ((4)) (c1)) \ \[\[1 0, 2 0], \[3 0, 4 0]] \[\[2 0, 4 0], \[6 0, 8 0]] fetched 2 rows you can also use shorthand notations to create row r or column vectors c for example, r{1,2,3} creates a row vector with values 1 0 , 2 0 , and 3 0 select r{1,2,3}; r{1,2,3} \ \[\[1 0, 2 0, 3 0]] fetched 1 row select c{1,2,3}; c{1,2,3} \ \[\[1 0], \[2 0], \[3 0]] fetched 1 row you can execute functions using the values in the vectors this query does some matrix arithmetic, finds the inverse matrix, and then returns the two eigenvalues and eigenvectors of the inverse select eigen(inverse(2 {{1,2},{3,4}} + {{5,6},{7,8}} / 2)); eigen(inverse((((2)) ({{1,2},{3,4}}))+(({{5,6},{7,8}})/((2))))) \ \[<< 1 3780529228406495, \[\[0 8013353799887076, 0 5982153531783962]]>>, <<0 05805292284064968, \[\[0 48196559267508465, 0 8761901434491]]>>] fetched 1 row machine learning models ocient supports regression, classification, and clustering models also, ocient supports models for dimensionality reduction for guides on using the different {{ocientml}} models, see regression analysis docid\ bbvzcuwpvmpg3z8g cgjz classification analysis docid\ arizmx22vuz75smj3quru clustering analysis and dimensionality reduction docid\ qdlbummdywqkcv4gc rt9 related links machine learning model functions docid\ dsqzzzggetdfwh5qasvhg regression models docid\ pfnkdj1fwsevxoondal9k