blob: 203ea1f9bfba4a5d87260f32ab6f57a6851beb64 [file] [log] [blame]
<!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
&#160;<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&#160;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&#160;List</span></a></li>
<li><a href="globals.html"><span>File&#160;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">&#39;MODULE_PATHNAME&#39;</span>, <span class="stringliteral">&#39;__utils_var_scales_result&#39;</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">&#39;MODULE_PATHNAME&#39;</span>, <span class="stringliteral">&#39;utils_var_scales_transition&#39;</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">&#39;MODULE_PATHNAME&#39;</span>, <span class="stringliteral">&#39;utils_var_scales_merge&#39;</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">&#39;MODULE_PATHNAME&#39;</span>, <span class="stringliteral">&#39;utils_var_scales_final&#39;</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">&#39;, `prefunc = MADLIB_SCHEMA.__utils_var_scales_merge,&#39;</span>)
<a name="l00051"></a>00051 FinalFunc = MADLIB_SCHEMA.__utils_var_scales_final,
<a name="l00052"></a>00052 InitCond = &#39;{0,0,0,0}<span class="stringliteral">&#39;</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">&#39;</span>MODULE_PATHNAME<span class="stringliteral">&#39;, &#39;</span>utils_normalize_data<span class="stringliteral">&#39;</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">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</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>