| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml"> |
| <head> |
| <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> |
| <title>MADlib: utils_regularization.sql_in Source File</title> |
| |
| <link href="tabs.css" rel="stylesheet" type="text/css"/> |
| <link href="doxygen.css" rel="stylesheet" type="text/css" /> |
| <link href="navtree.css" rel="stylesheet" type="text/css"/> |
| <script type="text/javascript" src="jquery.js"></script> |
| <script type="text/javascript" src="resize.js"></script> |
| <script type="text/javascript" src="navtree.js"></script> |
| <script type="text/javascript"> |
| $(document).ready(initResizable); |
| </script> |
| <link href="search/search.css" rel="stylesheet" type="text/css"/> |
| <script type="text/javascript" src="search/search.js"></script> |
| <script type="text/javascript"> |
| $(document).ready(function() { searchBox.OnSelectItem(0); }); |
| </script> |
| <script src="../mathjax/MathJax.js"> |
| MathJax.Hub.Config({ |
| extensions: ["tex2jax.js", "TeX/AMSmath.js", "TeX/AMSsymbols.js"], |
| jax: ["input/TeX","output/HTML-CSS"], |
| }); |
| </script> |
| </head> |
| <body> |
| <div id="top"><!-- do not remove this div! --> |
| |
| |
| <div id="titlearea"> |
| <table cellspacing="0" cellpadding="0"> |
| <tbody> |
| <tr style="height: 56px;"> |
| |
| |
| <td style="padding-left: 0.5em;"> |
| <div id="projectname">MADlib |
|  <span id="projectnumber">0.6</span> <span style="font-size:10pt; font-style:italic"><a href="../latest/./utils__regularization_8sql__in_source.html"> A newer version is available</a></span> |
| </div> |
| <div id="projectbrief">User Documentation</div> |
| </td> |
| |
| |
| |
| </tr> |
| </tbody> |
| </table> |
| </div> |
| |
| <!-- Generated by Doxygen 1.7.5.1 --> |
| <script type="text/javascript"> |
| var searchBox = new SearchBox("searchBox", "search",false,'Search'); |
| </script> |
| <script type="text/javascript" src="dynsections.js"></script> |
| <div id="navrow1" class="tabs"> |
| <ul class="tablist"> |
| <li><a href="index.html"><span>Main Page</span></a></li> |
| <li><a href="modules.html"><span>Modules</span></a></li> |
| <li class="current"><a href="files.html"><span>Files</span></a></li> |
| <li> |
| <div id="MSearchBox" class="MSearchBoxInactive"> |
| <span class="left"> |
| <img id="MSearchSelect" src="search/mag_sel.png" |
| onmouseover="return searchBox.OnSearchSelectShow()" |
| onmouseout="return searchBox.OnSearchSelectHide()" |
| alt=""/> |
| <input type="text" id="MSearchField" value="Search" accesskey="S" |
| onfocus="searchBox.OnSearchFieldFocus(true)" |
| onblur="searchBox.OnSearchFieldFocus(false)" |
| onkeyup="searchBox.OnSearchFieldChange(event)"/> |
| </span><span class="right"> |
| <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a> |
| </span> |
| </div> |
| </li> |
| </ul> |
| </div> |
| <div id="navrow2" class="tabs2"> |
| <ul class="tablist"> |
| <li><a href="files.html"><span>File List</span></a></li> |
| <li><a href="globals.html"><span>File Members</span></a></li> |
| </ul> |
| </div> |
| </div> |
| <div id="side-nav" class="ui-resizable side-nav-resizable"> |
| <div id="nav-tree"> |
| <div id="nav-tree-contents"> |
| </div> |
| </div> |
| <div id="splitbar" style="-moz-user-select:none;" |
| class="ui-resizable-handle"> |
| </div> |
| </div> |
| <script type="text/javascript"> |
| initNavTree('utils__regularization_8sql__in.html',''); |
| </script> |
| <div id="doc-content"> |
| <div class="header"> |
| <div class="headertitle"> |
| <div class="title">utils_regularization.sql_in</div> </div> |
| </div> |
| <div class="contents"> |
| <div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 |
| <a name="l00002"></a>00002 CREATE TYPE MADLIB_SCHEMA.__utils_scales AS ( |
| <a name="l00003"></a>00003 <a class="code" href="svec_8sql__in.html#a546b947319c9f48237120a31929bdfd9">mean</a> DOUBLE PRECISION[], |
| <a name="l00004"></a>00004 std DOUBLE PRECISION[] |
| <a name="l00005"></a>00005 ); |
| <a name="l00006"></a>00006 |
| <a name="l00007"></a>00007 -- |
| <a name="l00008"></a>00008 |
| <a name="l00009"></a>00009 CREATE FUNCTION MADLIB_SCHEMA.__utils_var_scales_result ( |
| <a name="l00010"></a>00010 in_state DOUBLE PRECISION[] |
| <a name="l00011"></a>00011 ) RETURNS MADLIB_SCHEMA.__utils_scales AS |
| <a name="l00012"></a>00012 <span class="stringliteral">'MODULE_PATHNAME'</span>, <span class="stringliteral">'__utils_var_scales_result'</span> |
| <a name="l00013"></a>00013 LANGUAGE C IMMUTABLE STRICT; |
| <a name="l00014"></a>00014 |
| <a name="l00015"></a>00015 ------------------------------------------------------------------------ |
| <a name="l00016"></a>00016 |
| <a name="l00017"></a>00017 CREATE FUNCTION MADLIB_SCHEMA.__utils_var_scales_transition ( |
| <a name="l00018"></a>00018 state DOUBLE PRECISION[], |
| <a name="l00019"></a>00019 ind_var DOUBLE PRECISION[], |
| <a name="l00020"></a>00020 dimension INTEGER |
| <a name="l00021"></a>00021 ) RETURNS DOUBLE PRECISION[] AS |
| <a name="l00022"></a>00022 <span class="stringliteral">'MODULE_PATHNAME'</span>, <span class="stringliteral">'utils_var_scales_transition'</span> |
| <a name="l00023"></a>00023 LANGUAGE C IMMUTABLE STRICT; |
| <a name="l00024"></a>00024 |
| <a name="l00025"></a>00025 -- |
| <a name="l00026"></a>00026 |
| <a name="l00027"></a>00027 CREATE FUNCTION MADLIB_SCHEMA.__utils_var_scales_merge ( |
| <a name="l00028"></a>00028 state1 DOUBLE PRECISION[], |
| <a name="l00029"></a>00029 state2 DOUBLE PRECISION[] |
| <a name="l00030"></a>00030 ) RETURNS DOUBLE PRECISION[] AS |
| <a name="l00031"></a>00031 <span class="stringliteral">'MODULE_PATHNAME'</span>, <span class="stringliteral">'utils_var_scales_merge'</span> |
| <a name="l00032"></a>00032 LANGUAGE C IMMUTABLE STRICT; |
| <a name="l00033"></a>00033 |
| <a name="l00034"></a>00034 -- |
| <a name="l00035"></a>00035 |
| <a name="l00036"></a>00036 CREATE FUNCTION MADLIB_SCHEMA.__utils_var_scales_final ( |
| <a name="l00037"></a>00037 state DOUBLE PRECISION[] |
| <a name="l00038"></a>00038 ) RETURNS DOUBLE PRECISION[] AS |
| <a name="l00039"></a>00039 <span class="stringliteral">'MODULE_PATHNAME'</span>, <span class="stringliteral">'utils_var_scales_final'</span> |
| <a name="l00040"></a>00040 LANGUAGE C IMMUTABLE STRICT; |
| <a name="l00041"></a>00041 |
| <a name="l00042"></a>00042 -- |
| <a name="l00043"></a>00043 |
| <a name="l00044"></a>00044 CREATE AGGREGATE MADLIB_SCHEMA.utils_var_scales ( |
| <a name="l00045"></a>00045 <span class="comment">/* ind_var */</span> DOUBLE PRECISION[], |
| <a name="l00046"></a>00046 <span class="comment">/* dimension*/</span> INTEGER |
| <a name="l00047"></a>00047 ) ( |
| <a name="l00048"></a>00048 SType = DOUBLE PRECISION[], |
| <a name="l00049"></a>00049 SFunc = MADLIB_SCHEMA.__utils_var_scales_transition, |
| <a name="l00050"></a>00050 m4_ifdef(`GREENPLUM<span class="stringliteral">', `prefunc = MADLIB_SCHEMA.__utils_var_scales_merge,'</span>) |
| <a name="l00051"></a>00051 FinalFunc = MADLIB_SCHEMA.__utils_var_scales_final, |
| <a name="l00052"></a>00052 InitCond = '{0,0,0,0}<span class="stringliteral">'</span> |
| <a name="l00053"></a>00053 <span class="stringliteral">);</span> |
| <a name="l00054"></a>00054 <span class="stringliteral"></span> |
| <a name="l00055"></a>00055 <span class="stringliteral">------------------------------------------------------------------------</span> |
| <a name="l00056"></a>00056 <span class="stringliteral"></span> |
| <a name="l00057"></a>00057 <span class="stringliteral">CREATE TYPE MADLIB_SCHEMA.__utils_scaled_data AS (</span> |
| <a name="l00058"></a>00058 <span class="stringliteral"> scaled DOUBLE PRECISION[]</span> |
| <a name="l00059"></a>00059 <span class="stringliteral">);</span> |
| <a name="l00060"></a>00060 <span class="stringliteral"></span> |
| <a name="l00061"></a>00061 <span class="stringliteral">--</span> |
| <a name="l00062"></a>00062 <span class="stringliteral"></span> |
| <a name="l00063"></a>00063 <span class="stringliteral">CREATE FUNCTION MADLIB_SCHEMA.utils_normalize_data (</span> |
| <a name="l00064"></a>00064 <span class="stringliteral"> x DOUBLE PRECISION[],</span> |
| <a name="l00065"></a>00065 <span class="stringliteral"> mean DOUBLE PRECISION[],</span> |
| <a name="l00066"></a>00066 <span class="stringliteral"> std DOUBLE PRECISION[]</span> |
| <a name="l00067"></a>00067 <span class="stringliteral">) RETURNS MADLIB_SCHEMA.__utils_scaled_data AS</span> |
| <a name="l00068"></a>00068 <span class="stringliteral">'</span>MODULE_PATHNAME<span class="stringliteral">', '</span>utils_normalize_data<span class="stringliteral">'</span> |
| <a name="l00069"></a>00069 <span class="stringliteral">LANGUAGE C IMMUTABLE STRICT;</span> |
| </pre></div></div> |
| </div> |
| <div id="nav-path" class="navpath"> |
| <ul> |
| <li class="navelem"><b>utils_regularization.sql_in</b> </li> |
| <!-- window showing the filter options --> |
| <div id="MSearchSelectWindow" |
| onmouseover="return searchBox.OnSearchSelectShow()" |
| onmouseout="return searchBox.OnSearchSelectHide()" |
| onkeydown="return searchBox.OnSearchSelectKey(event)"> |
| <a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Functions</a></div> |
| |
| <!-- iframe showing the search results (closed by default) --> |
| <div id="MSearchResultsWindow"> |
| <iframe src="javascript:void(0)" frameborder="0" |
| name="MSearchResults" id="MSearchResults"> |
| </iframe> |
| </div> |
| |
| |
| <li class="footer">Generated on Tue Apr 2 2013 14:57:03 for MADlib by |
| <a href="http://www.doxygen.org/index.html"> |
| <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.7.5.1 </li> |
| </ul> |
| </div> |
| |
| |
| </body> |
| </html> |