how-to

DB Creator in SQLITE and C#

January 25, 2012 |

Author whaldsz

In one of my projects, there is a need to implement a server-less SQL database. The result of my exploration led me to SQLITE. I’m lucky to have found a good wrapper since I’m using C#. All is well until the need to re-create the database arises. This is required when the application is being readied for deployment. In my application, one of the requirements was to be able to reset the database or re create the database inside the application.

To serve this purpose, I developed a small C#console application to create the database for me. The code is quiet simple , far from optimized and buggy but of course it is up to you to improve it.


public static class Util
<pre> {
public static bool CreateDb(string db)
{
try
{
Console.WriteLine("Please wait creating database " + db);
SQLiteConnection.CreateFile(db);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return false;
}

return true;
}

public static bool ExecuteScript(string script, string connectionString)
{
try
{
if (!File.Exists(script)) throw new FileNotFoundException(script);

DbProviderFactory fact = DbProviderFactories.GetFactory("System.Data.SQLite");
using (DbConnection cnn = fact.CreateConnection())
{
cnn.ConnectionString = connectionString;

using (var cmd = cnn.CreateCommand())
{
var fileInfo = new FileInfo(script);
var sql = fileInfo.OpenText().ReadToEnd();

var tables = System.Text.RegularExpressions.Regex.Split(sql, "\r\n\r\n");

if (tables.Length > 0)
{
cnn.Open();

foreach (var table in tables)
{
Console.WriteLine("Writing TABLE: \n" + table);
cmd.CommandText = table;
cmd.CommandType = CommandType.Text;

cmd.ExecuteNonQuery();
}
}

cnn.Close();
return true;
}
}

}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return false;
}
}
}</pre>
<pre>

In your app.config, you need the following entry:

</pre>
<pre><?xml version="1.0"?>
<configuration>
  <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
  </startup>

  <system.data>
    <DbProviderFactories>
      <remove invariant="System.Data.SQLite"/>
      <add name="SQLite Data Provider" invariant="System.Data.SQLite"?
      description=".Net Framework Data Provider for SQLite"
      type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite"/></pre>
<pre>    </DbProviderFactories>
  </system.data>
<startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/></startup>
</configuration></pre>
<pre>

Finally, add a reference to the first file, the second file below should be in the same location as the executable:

System.Data.SQLite.dll
System.Data.SQLite.lib

Posted in how-to, software |

No Comments »

Background Subtraction in C#

November 14, 2008 |

Author whaldsz

I have been trying to learn OpenCV for a while now and I came across Emgu.CV, a C# wrapper. Although the Emgu.CV is still under development, it has a many features that will make your work a lot easier if you’re doing a project in computer vision and image processing areas. Some of its capabilities enable you to develop web applications that can do processing of video and images via TCP/IP.

My goal in this article is to demonstrate simple background segmentation techniques using Emgu.CV. Background segmentation is important if you are trying to extract features from an image and you want to remove or filter out unwanted objects. You may also find this technique important when the recovery of color information from foreground objects is important.

Our objective is to remove the background from the rice image below. We want to get the color information from the rice kernels and be able to extract features for for each kernel, maybe for shape analysis or classification purposes.

I am sure there are other ways to perform background subtraction but this article will cover three methods that .

Color filtering in Cielab color space
Image masking (as i call it)
Cielab + image masking

The three methods will be explained shortly and the link to the source code is available at the visioneer forum.

Color Filtering in Cielab Color Space

In this method, a copy of RGB image in Cielab space is obtained, and then process this image (in Cielab space) pixel by pixel. Each pixel is checked if its color value is within specified range, otherwise, the pixel in the corresponding RGB image is set to black color. An implementation is visible below:

// background subtraction in cielab color space
private void CielabColorFilteringBGSubtraction(string filename, bool displayResult)
{
    // create new image from file
    Image<Bgr, Byte> rgbimage = new Image<Bgr, byte>(filename);

    // make a copy of the image in lab color space
    Image<Lab, Byte> labimage = rgbimage.Convert<Lab, Byte>();

    // get the width and size
    int width = labimage.Width;
    int height = labimage.Height;

    // get the filter range for each channel in lab color space
    IntRange l = new IntRange(Byte.Parse(min1TextBox.Text), Byte.Parse(max1TextBox.Text));
    IntRange a = new IntRange(Byte.Parse(min2TextBox.Text), Byte.Parse(max2TextBox.Text));
    IntRange b = new IntRange(Byte.Parse(min3TextBox.Text), Byte.Parse(max3TextBox.Text));

    // process each row in the image
    for (int i = 0; i < width; i++)
    {
        // process each pixel
        for (int j = 0; j < height; j++)
        {
            if (
                (labimage[j, i].X >=l.Max ) || (labimage[j, i].X <= l.Min) ||
                 (labimage[j, i].Y >= a.Max) || (labimage[j, i].Y <= a.Min) ||
                 (labimage[j, i].Z >= b.Max) || (labimage[j, i].Z <= b.Min)
                )
            {
                // if outside the filter range, set the pixel to black color
                rgbimage[j, i] = new Bgr(0, 0, 0);
            }
        }
    }

    // display
    if (displayResult) this.NewImage("Cielab-based background segmented image", rgbimage);
}

The resulting image looks like this. In my PC, it took about 3.20 sec to perform background segmentation.

Image Masking

In this method, what we do is convert an RGB image into binary via binary thresholding. (The choice of threshold value depends on the image, so you have to experiment on this.) This binary image will serve as the mask image to copy pixels from the original image to the destination image, if the corresponding pixel in the mask image is nonzero. This is given by the following representation:

DestinatioImage(x,y) = SourceImage(x,y) if MaskImage(x,y) <> 0

where x and y is the pixel coordinates of the image. Source, destination and mask image have the same size.

Code implementation is as follows:

// background subtraction by converting the RGB image to binary to create the mask
// then use this mask to copy foreground objects in the image
private void RGBImageMaskBGSubtraction(string filename, bool displayResult)
{
    // load the threshold value for grayscale image
    double threshold = double.Parse(max2TextBox.Text);

    // create new image
    Image<Bgr, Byte> img = new Image<Bgr, byte>(filename);

    //convert to grayscale
    Image<Gray, Byte> gray = img.Convert<Gray, Byte>();

    //convert to binary image using the threshold
    gray = gray.ThresholdBinary(new Gray(threshold), new Gray(255));

    // copy pixels from the original image where pixels in 
    // mask image is nonzero
    Image<Bgr, Byte> newimg = img.Copy(gray);

    // display result
    if (displayResult) this.NewImage("Background segmented", newimg);

}

One thing we should be aware of is that, all channels in RGB image is used to convert the image in grayscale image, then eventually binary image. The output image is shown below:

Obviously, this is far worst then the first method. But the advantage of segmentation using this technique is the speed. The image was segmented for only 0.25 sec with more than 12X improvement, but we have to live with the quality. According to my tests, the performance improvement increases as the image size increased. If we are very much concerned with the pixels in foreground objects, then the Image Masking method will not satisfy our requirements.

However, there is another method to achieve the segmentation quality of cielab color filtering method, and the speed of the image masking method.

Cielab + Image masking

In this method, we combine the first two techniques to get the cream of both ice creams. What we do is to perform the processing as in image masking method, but instead of using 3 channels (in RGB format) to convert the image to grayscale, we convert the image into Cielab space, select the a*-channel of the image, and use this channel to derive the mask image.

Code implementation here:

// background subtraction by extracting one channel in cielab image to 
 // create binary mask, and use this mask to copy foreground objects in 
 // the original image
 private void CielabChannelMaskBGSubtraction(string filename, bool displayResult)
 {
     double threshold = double.Parse(max2TextBox.Text);

     Image<Bgr, byte> rgb = new Image<Bgr, byte>(filename);
     Image<Lab, Byte> img = rgb.Convert<Lab, Byte>();

     //get the a* channel 
     Image<Gray, Byte> gray = img[channel];

     //threshold and invert
     gray = gray.ThresholdBinary(new Gray(threshold), new Gray(255)).Not();

    // display the result
     if (displayResult) this.NewImage("Background segmented", image);
 }

Resulting output image here, note that it has almost the same quality as in the first method but with little performance penalty (processing takes around 0.03 sec longer than the second method).

Please note that you need to tweak the filter range(threshold value) for this to work in your problem area. Also,

In Method 1, all three channels are used as filter ranges.
Method 2, uses channel 1(maximum) for grayscale threshold value
In method 3, you can select among the radio buttons (on the right) which channels to choose as the source for the mask image. Then modify the filter range for that selected channel mask. You can also modify the source code to select one or more channels if it gives better performance.
I have included two images located in the source code folder for testing purposes.

Screenshot is given below:

[attachments force_saveas="0" logged_users="0"]

Posted in emgu, how-to, projects, software |

Tags: background subtraction, emgu.cv, opencv |

65 Comments »

How to Center MathType Equation in Microsoft Word

September 24, 2008 |

Author whaldsz

Writing technical reports and papers for conference or journal publication can be a challenging task specially when it involves a lot of equations. This is also true for those who are doing their thesis and dissertation. And sometimes centering an equation can be so frustrating. I myself, for one, have gone through this difficulty.

I’m using Microsoft Word 2003 with MathType 6.0. What we want to achieve is to center the equation within the margin of our document and align the equation numbers[ e.g., (1), (2), and (3)] to the right edge of the margin as shown below:

Now, here’s how we do it:

1. Make sure the STYLES AND FORMATTING is clicked so the pane at the right is visible (see the arrows).

2. Once visible, the STYLES AND FORMATTING can be edited by clicking the MODIFY menu item in the drop-down menu:

3. A dialog box appears, click Format -> Tabs, make sure that you are editing the MTDisplayEquation style. See the example below.

4. Clicking the TABS menu item pops up another dialog box. Assuming you are using A4-size paper with a left and right margin of 1.25″, you should edit the TAB STOP POSITION as shown, 0″ (left alignment), 3″ (center alignment) and 6 (right alignment).

5. Close the dialog boxes and try to insert an equation. You should have the result as shown. Tab stops being pointed by arrows are now visible at the ruler area:

Posted in general, how-to, software |

Tags: how-to, mathtype, microsoft word, software |

5 Comments »