Options

Out of Memory problem in outlier Detection

AnkiAnki Member Posts: 39 Contributor II
edited November 2018 in Help
Hi All,

I am reading data from SQL Server 2005 Database with "Read Database" operator with query and I am giving it for "Outlier Detection (Distance based)" operator. The Query retrieving around 9000 examples and 2 attributes. TRAN_ID and TRAN_AMT.  I am using TRAN_AMT for Outlier Detection.
But It is giving "out of memory problem saying that This process need more memory than available.............".

I am using Windows XP 32 bit. 2 GB Ram. In  RM's system window it is Inittially at the staring time of the process it showing Available: 1GB, and MAX:1 GB.
After some time, when the process is going on all the memory used and giving out of memory problem.
Here is the code
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.1.006">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="5.1.006" expanded="true" name="Process">
    <process expanded="true" height="564" width="746">
      <operator activated="true" class="read_database" compatibility="5.1.006" expanded="true" height="60" name="Read Database" width="90" x="45" y="210">
        <parameter key="connection" value="anki"/>
        <parameter key="query" value="SELECT &quot;TRAN_ID&quot;, &quot;TRAN_AMT&quot;&#13;&#10;FROM &quot;CUST_TRANDbk&quot;&#13;&#10;WHERE CUST_ID=319021623"/>
        <parameter key="table_name" value="ACCOUNTS"/>
        <enumeration key="parameters"/>
      </operator>
      <operator activated="true" class="set_role" compatibility="5.1.006" expanded="true" height="76" name="Set Role" width="90" x="246" y="210">
        <parameter key="name" value="TRAN_AMT"/>
        <list key="set_additional_roles">
          <parameter key="TRAN_ID" value="id"/>
          <parameter key="TRAN_AMT" value="regular"/>
        </list>
      </operator>
      <operator activated="true" class="detect_outlier_distances" compatibility="5.1.006" expanded="true" height="76" name="Detect Outlier (Distances)" width="90" x="380" y="120">
        <parameter key="number_of_outliers" value="900"/>
      </operator>
      <connect from_op="Read Database" from_port="output" to_op="Set Role" to_port="example set input"/>
      <connect from_op="Set Role" from_port="example set output" to_op="Detect Outlier (Distances)" to_port="example set input"/>
      <connect from_op="Detect Outlier (Distances)" from_port="example set output" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
    </process>
  </operator>
</process>
Is there any other way to solve this problem? Whether I need to take higher configuration system?

Thank you for your answers.

Yours
Anki
Sign In or Register to comment.