Visual C# 2008 and MySQL using ODBC

1. Download MySQL 5.1 Server here
2. Download ODBC MySQL Connector here
3. MySQL Server Installation








4. ODBC Connector


5. ODBC Configuration






6. Here is a Sample Code.

For more information click here

Read More

Using the Geospatial Data Abstraction Library (GDAL) in Ubuntu

For a project, I need to process SRTM elevation data. GDAL is a software library that makes it easy to read and write raster geospatial data formats. I decided to give it a try since SRTM data uses the ESRI grid format supported by the library.

1. Install the the GDAL libraries and utilities

$ apt-get install libgdal1-1.5.0 gdal-bin

2. Sample code. The SRTM data file path is in the variable pszFilename. The code is based on the tutorial.

#include <stdio.h>
#include <gdal.h>>
int main()
{
    GDALDatasetH  hDataset;
    char *pszFilename = "/media/DATA/srtm_61_10.asc";
    GDALDriverH   hDriver;
    double        adfGeoTransform[6];
    GDALRasterBandH hBand;
    int             nBlockXSize, nBlockYSize;
    int             bGotMin, bGotMax;
    double          adfMinMax[2];
    float *pafScanline;
    int   nXSize;
    int i;

    GDALAllRegister();
    hDataset = GDALOpen( pszFilename, GA_ReadOnly );
    if( hDataset == NULL )
    {
        printf("Cannot open file.");
    }
    hDriver = GDALGetDatasetDriver( hDataset );
    printf( "Driver: %s/%s\n",
            GDALGetDriverShortName( hDriver ),
            GDALGetDriverLongName( hDriver ) );
    printf( "Size is %dx%dx%d\n",
            GDALGetRasterXSize( hDataset ), 
            GDALGetRasterYSize( hDataset ),
            GDALGetRasterCount( hDataset ) );
    if( GDALGetProjectionRef( hDataset ) != NULL )
        printf( "Projection is `%s'\n", GDALGetProjectionRef( hDataset ) );
    if( GDALGetGeoTransform( hDataset, adfGeoTransform ) == CE_None )
    {
        printf( "Origin = (%.6f,%.6f)\n",
                adfGeoTransform[0], adfGeoTransform[3] );
        printf( "Pixel Size = (%.6f,%.6f)\n",
                adfGeoTransform[1], adfGeoTransform[5] );
    }
    hBand = GDALGetRasterBand( hDataset, 1 );
    GDALGetBlockSize( hBand, &nBlockXSize, &nBlockYSize );
    printf( "Block=%dx%d Type=%s, ColorInterp=%s\n",
            nBlockXSize, nBlockYSize,
            GDALGetDataTypeName(GDALGetRasterDataType(hBand)),
            GDALGetColorInterpretationName(
            GDALGetRasterColorInterpretation(hBand)) 
    );
    adfMinMax[0] = GDALGetRasterMinimum( hBand, &bGotMin );
    adfMinMax[1] = GDALGetRasterMaximum( hBand, &bGotMax );
    if( ! (bGotMin && bGotMax) )
      GDALComputeRasterMinMax( hBand, TRUE, adfMinMax );
    printf( "Min=%.3fd, Max=%.3f\n", adfMinMax[0], adfMinMax[1] );
    if( GDALGetOverviewCount(hBand) > 0 )
      printf( "Band has %d overviews.\n", GDALGetOverviewCount(hBand));
    if( GDALGetRasterColorTable( hBand ) != NULL )
      printf( "Band has a color table with %d entries.\n", 
                 GDALGetColorEntryCount(
                 GDALGetRasterColorTable( hBand ) ) 
      );
    nXSize = GDALGetRasterBandXSize( hBand );
    pafScanline = (float *) CPLMalloc(sizeof(float)*nXSize);
    GDALRasterIO( hBand, GF_Read, 0, 0, nXSize, 1, 
                    pafScanline, nXSize, 1, GDT_Float32, 
                     0, 0 );
    for (i=0;i<20;i++){
      printf("%f\n", pafScanline[i]);
    }
}

3. Build the example

$ gcc -lgdal1.5.0 -I/usr/include/gdal -o testgdal.exe testgdal.c

4. Run

$./testgdal.exe
Driver: AAIGrid/Arc/Info ASCII Grid
Size is 6001x6001x1
Projection is `GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9108"]],AXIS["Lat",NORTH],AXIS["Long",EAST],AUTHORITY["EPSG","4326"]]'
Origin = (119.999583,15.000417)
Pixel Size = (0.000833,-0.000833)
Block=6001x1 Type=Int16, ColorInterp=Undefined
Min=-27.000d, Max=2375.000

Read More

On Research Methodologies

Last December 14, 2009 I attended the  Second CAS Student-Faculty Research Conference held at the CAS auditorium. The objective of the conference is to present the research output of the different departments and institutes of the College of Arts and Sciences. There were four plenary presentations in the conference from IMSP, DSS, IC and ICS, and IBS.  The parallel sessions held in the afternoon were divided into four clusters. 

• Social Sciences, Humanities, MST and Education Cluster
• Physics and Chemistry Cluster
• Mathematics, Statistics, and Computer Science Cluster
• Biology and Environment Cluster

I decided to attend at least one presentation from each cluster in order to know what methodologies are used by the researchers in their field and work. Based on my samples, majority of the researchers conducted some form of survey and performed statistical analysis (frequency analysis, regression, test of significance).  Conclusions were drawn from the result of the statistical analysis. Another methodology used is simulation and modeling (Kinetic-Monte-Carlo, Time Series Analysis, Neural Networks, Regression Models). The main justification for using modeling and simulation is that conducting the actual experiment is expensive and time consuming. Model validation, however, was lacking in some of the researches. Product development is another methodology employed. Researchers developed a system (hardware or software), a chemical product, or an experimental setup. The product addresses some problem in the field. A common keyword in the title of the research papers presented  is characterization. Based on my understanding, characterization is providing a quantitative(or qualitative) description of some entity, structure, substance, behaviour, problem, algorithm, etc. Thus, we can probably include characterization as one of the research methodologies. Although, characterization, I think is a broad term. Also, the validity of results of the researches are strengthened if statistical analysis was conducted.

Read More

Making a DOS-bootable USB disk from Ubuntu

It is again the start of a new semester. We need to prepare the laboratory computers for students use. We do this by creating a source disk and doing a disk-copy to the other computers. This approach works because computers in a laboratory have similar specifications.

Last weekend, I run into the problem of making a USB disk DOS-bootable for use in copying hard disks. I needed to create one because the floppy drives in the laboratory computers are not working. The Norton Ghost program needs to run in DOS. The following are the steps I followed to make the disk.

1. Downloaded a FreeDOS disk image from http://www.finnix.org/Balder.
2. Installed Qemu.
$sudo apt-get install qemu
3. Prepared the USB disk by creating a single FAT16 partition. In my Ubuntu box, my USB disk is /dev/sdb.
   $sudo gparted /dev/sdb
   
4. Ran Qemu using the FreeDOS image for the first floppy(A:)  and the USB disk as the second floppy (B:).
$qemu -fda balder10.img -fdb /dev/sdb
5. From within FreeDOS, I formatted drive B: and made it bootable.
   A:\>format /s b:
   
6. Tested if the USB disk is now bootable.
   $qemu -fda /dev/sdb
   
7. Copied the Norton Ghost program to the USB disk.
   

After changing some settings in the BIOS of the PCs in the laboratory, the DOS bootable USB disk from Ubuntu did its job.

Read More

UPLB now has full text online access to important sources of computing literature

As a novice researcher, a brilliant idea suddenly comes into your mind. You start your web browser and typed a few keywords on your favourite search engine to know if somebody has already thought of your brilliant idea. Then comes the results of the search. Somebody has already thought of your brililant idea and even published a journal article! You hurriedly click on the link, hoping to know more of the author's work. Unfortunately, what you get is only an abstract because you need to pay to access the entire article.

Yes, we have Wikipedia and Citeseer as sources for our literature review. But sometimes we just can't find the journal articles that are very important for our research from these two. In an effort to increase research productivity and output, UP obtained subscriptions of several journals delivered electronically. In the field of computing, the following are important sources of literature that we can use for our research.  They are accessible within the campus network. The question to ask now is: "Are we using these valuable resources?"

• ACM Digital Library 
• IEEE Xplore
• IEEE CS Digital Library 
• Elsevier 
• SpringerLink
• Computing Research Repository

There are also several bibliographies for computer science available online.

• DBLP
• The Collection of Computer Science Bibliographies 

Read More

How to succeed in your SP proposal defense

(Updated: January 2024)

Make sure you and your adviser HAVE AGREED on the Title, Statement of the Problem, Objectives, and Materials and Methods sections of your SP proposal before your defense.

What to say during the defense in 5-7 minutes?

• The title of your SP (memorized)
  
• 5 sentences background (memorized)
  
• 2 sentences Statement of the Problem (memorized)
  
• 1 sentence General Objective (memorized)
  
• 3-4 statements of Specific Objectives
  
• Scope and Limitations
  
• Materials and Methods (Use Case Diagram, ERD, Tech Stack, Evaluation Process, 12-week Gantt Chart)
  
• Expected output and sample screenshots (include sample reports that will be generated)
• Related work (those done in ICS if available)

(The best way is to write a script that you can memorize!)

Common comments from panelists

• Too simple/Too complex. Some panelists will suggest to add/remove features to make your SP simpler/more complex. Redirect this comment/question to your adviser.
• Novelty. You should be able to answer what is new in your work compared to previous work. If you can't, redirect this comment/question to your adviser.
• Quantify. If one of your objectives is to "speed up" something, you should be able to answer how you will measure this quantity. Also specify metrics and measurements to gather.
• Users and Stakeholders. Have you consulted them during the development of your proposal?
  
• Comparison and Evaluation. If your work is an improvement over previous approaches, include in your objectives a comparison of results of your work over them in terms of speed, performance, accuracy, etc. To be safe, include a usability evaluation using the System Usability Scale (SUS). 
• Specificity. Be VERY specific and careful in your statements. They should be easy to validate.
• Feasibility. Make sure that what you are proposing is feasible and doable in 12 weeks, implementation-wise.
• Initial experiments and results. If your work involves image processing and ImageLab, make sure you've made some initial trials (aside from binarization!). You should include in your defense the results, whether good or bad. This is also applicable for other types of SP, not just image processing.
• Interfaces. Make sure you discuss the connection of your module with the modules of your SP group mates, if you have any.
• Validation. State how you are going to validate your claims.
• ERD/DFD. If your SP needs a database, make sure you include an Entity-Relationship Diagram for the database design and Data Flow Diagram for data transformation. Include Use Case diagrams and wireframes.
• Reports. Information Systems projects might require reports (printable PDFs).  
• References. Make sure you have a good number of references (at least 10). Don't forget to cite them properly in your paper. Also include related work by past ICS students.
  
• Tech Stack. Be able to justify the choice of your tech stack.

Handling comments from panelists

• In general, always treat comments from the panelists as CONSTRUCTIVE. Their statements will help improve your SP and give you directions in your work.
  
• Panelists will be suggesting A LOT of things. Take note of ALL OF THEM and negotiate with your adviser later if you will consider SOME OF THEM in your SP.
• If you do not know the answer to the question from a panelist, just tell them that "I'll look into that.". Make sure you do later!

Practice

• It is important that you practice your defense. This can be done with your adviser or with some of your friends.
• Before the defense, make sure that your mind is clear and specific with what you are going to do in your SP. You can achieve this by repeating in your mind the General Objective of your proposal. Visualize your expected output so that you can tell a story about it to the panelists during the defense.

Read More