Archive

Archive for March, 2011

Connect MS-Access database from MATLAB


Already I’ve shared the way and source code how to connect MySQL data base from MATLAB. In this post I want to share how to connect to MS-Access. I initially thought of using the MySQL as database but due to some issues of reinstalling the OS and being MySQL not getting installed properly, I went for MS-Access. I hope this post will be very helpful to you if you have come here searching for connecting MS-Access from MATLAB.

function db=insertdb(name, imagePath, ICC)
dbpath = 'C:\Users\MyWindows7\Documents\abc.mdb';
conurl = ['jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=' dbpath];
con = database('','','','sun.jdbc.odbc.JdbcOdbcDriver', conurl)

%insertQuery=['insert into Image values(' name ',' imagePath ',' ICC ');' ]
%e = exec(con,insertQuery);
colnames={'imgName', 'imagePath', 'iCC'};
values={name, imagePath, ICC};
insert(con, 'Image',colnames, values ) %This statement inserts the values which are contained by values %array variables
%e = fetch(e);
%data = e.Data

In the above program % represents comments you can ignore them if you want. I included them to say that there are several other ways to insert a row into the MS-Access database. In the above code  if you specify the path of database(ie.,        .mdb file) then its enough there is no need for you to specify DSN name and other things. similarly you can also work with other SQL statements. I hope this helps. If you have any more queries or clarifications you can feel free to comment here.

Semantic Web 3.0 Professional seminar ppt


Here I want to share Semantic Web Mining PPT that I have prepared for my Professional Seminar. I’ve already shared my abstract and report here. If you have any queries or clarification you can feel free to leave a comment. I hope the ppt would have given some insight into What Semantic Web is?

What is a mashup?


Here is a nice video I found on the youtube. The author explains nicely what a mashup is? by giving analogy from the conventional operating system APIs. Read more…

Data Mining project proposal


As part of Data Mining course work in this semester, we have Data mining mini project component. I choose a project which is currently one of the hot topics in the data mining research. This topic is related to Software Engineering Mining area. The topic name goes as follows  “Applying Data mining for Bug Discovery from Source code”. I’ve contacted one of the author of related papers, he himself admitted that this area is very new and requires considerable amount of time for implementing it, because it requires several data mining tasks before arriving at the final goals.

First I’ve to get the patterns from the source code and then I’ve to apply some classification to that.  In particular I’m more interested in finding, how to find the deadlock detection in Java Threads using Data mining. The following link is the abstract Applying Data mining for Bug Discovery from Source code.

The initial project proposal seminar ppt Applying Data mining for Bug Discovery from Source

Google Maps assignment (WST)


The below are the assignment questions

PAGE 1 (drawpath.html) [70]

—————————————————————————————————

1. Frame showing the google map. Add necessary zoom and move controls. — [5]

2. Add Pushpin button – marking a starting, ending, or intermediate important locations with at

text box for notes that pop up on mouse over…  —–[30]

—————————————————————————————————

3. Add dot button – Marking a custom route between starting and ending points. (make the dot small)

— [5]

—————————————————————————————————

4. Undo button – to go back to previous states. —– [10]

—————————————————————————————————

5. Frame for logging the operations performed (enable hide option) — [10]

Can just be a text Area (for Debug)

—————————————————————————————————

6. Save the logged information in a file or render a html/txt/xml with instructions on how to  process it and insert it into render.html  — [5]
—————————————————————————————————

7. Clear all button — [5]
===========================================================================

PAGE 2 (render.html) [30]

1. Render the custom path on the map using the information stored in log automatically. — [20]

2.  Direction must be displayed along with map as a text for corresponding path. — [5]
3.  A button to go back to drawpath.html — [2]

4.  Pop up of text entered in Page-1 on mouse over push pins. — [3]

Note: Google Map API key for the server is,

ABQIAAAA1ikXYp_OM0YNWMEKgNZusRSW42mfecZUORQiSaKw_7npagyVWxRQR8bHLIO8Fcjib_cjLjoGScd1rA

Use this key for all the assignments related to google maps

=====================================================================

This assignment is mainly designed to make aware the Google Maps API. Google Maps has given many services including direction, geographical information and many other handy features. Just we have to use API. The assignment was designed keeping in mind the situation of many countries not having exact location address.

Google maps Assignment

Google maps Assignment

Reder Page

For Render page I’ve used Activex Control because as per the question I’ve to show previously saved log information in the XML format.

If you want work much faster use Google Code Play Ground.

PAGE 1 (drawpath.html) [70]

—————————————————————————————————

 

1. Frame showing the google map. Add necessary zoom and move controls. — [5]

 

—————————————————————————————————

 

2. Add Pushpin button – marking a starting, ending, or intermediate important locations with at

text box for notes that pop up on mouse over… —–[30]

 

—————————————————————————————————

 

3. Add dot button – Marking a custom route between starting and ending points. (make the dot small)

— [5]

—————————————————————————————————

 

4. Undo button – to go back to previous states. —– [10]

 

—————————————————————————————————

 

5. Frame for logging the operations performed (enable hide option) — [10]

Can just be a text Area (for Debug)

 

—————————————————————————————————

 

6. Save the logged information in a file or render a html/txt/xml with instructions on how to process it and insert it into render.html — [5]

 

—————————————————————————————————

 

7. Clear all button — [5]

 

===========================================================================

PAGE 2 (render.html) [30]

 

 

1. Render the custom path on the map using the information stored in log automatically. — [20]

 

2. Direction must be displayed along with map as a text for corresponding path. — [5]

 

3. A button to go back to drawpath.html — [2]

 

4. Pop up of text entered in Page-1 on mouse over push pins. — [3]

 

Note: Google Map API key for the server is,

 

ABQIAAAA1ikXYp_OM0YNWMEKgNZusRSW42mfecZUORQiSaKw_7npagyVWxRQR8bHLIO8Fcjib_cjLjoGScd1rA

Use this key for all the assignments related to google maps

=====================================================================

Professional Seminar report for Semantic Web


Research on Semantic Web Mining

Seminar Report

Submitted in partial fulfillment of the requirements for the second semester course

PROFESSIONAL PRACTICES/SEMINAR of

MASTER OF TECHNOLOGY in

INFORMATION TECHNOLOGY

by

CHITTAMPALLY VASANTH RAJA

(10IT05F)

DEPARTMENT OF INFORMATION TECHNOLOGY

NATIONAL INSTITUTE OF TECHNOLOGY KARNATAKA

SURATHKAL, MANGALORE-575025

March, 2011

D E C L A R A T I O N

I hereby declare that the Report of the P.G. Seminar Work entitled “Research on Semantic Web Mining” which is being submitted to the National Institute of Technology Karnataka Surathkal, in partial fulfillment of the requirements for the second semester PROFESSIONAL PRACTICES/SEMINAR course of the Master of Technology Degree in Information Technology in the Department of Information Technology, is a bonafide report of the study carried out by me. The material contained in this report has not been submitted to any University or Institution for the award of any degree.

___________________________________

(Register Number, Name and Signature of Student)

Department of Information Technology

Place: NITK, SURATHKAL

Date:


CERTIFICATE

This is to certify that the P.G Seminar Report entitled “Research on Semantic Web Mining” submitted by CHITTAMPALLY VASANTH RAJA (Register Number: 10IT05F) as the record of the work carried out by him, is accepted as the P.G Seminar Report submission in partial fulfillment of the requirements for the award of degree of second semester PROFESSIONAL PRACTICES/SEMINAR course of the Master of Technology Degree in Information Technology in the Department of Information Technology, National Institute of Technology Karnataka, Surathkal.

Dr. Prakash Raghavendra

Assistant Professor

Department of Information Technology

NITK Surathkal

Mr. Biju R Mohan

Assistant Professor

Department of Information Technology

NITK Surathkal


ACKNOWLEDGEMENT

I take this opportunity to express my deepest gratitude and appreciation to all those who have helped me directly or indirectly towards the successful completion of this project.

Foremost, I would like to express my sincere gratitude to my guides Dr. Prakash Raghavendra and Mr. Biju R Mohan, Department of Information Technology, NITK Surathkal. Their advice, constant support, encouragement and valuable suggestions throughout the course of my work helped me successfully complete the seminar. Without their continuous support and interest, this report would not have been the same as presented here.

I am thankful to Dr. Ram Mohan Reddy, Head, Department of Information Technology for his co-operation and for providing necessary facilities throughout the course.

Besides my guides, I would like to thank entire teaching and non-teaching staff in the Department of Information Technology, NITK for all their help during my tenure at NITK. Kudos to all my friends at NITK for thought provoking discussion and making stay very pleasant.

Last but not least, I am thankful to my parents to whom I am greatly indebted for their support and encouragement to pursue my interests.

CHITTAMPALLY VASANTH RAJA


ABSTRACT

Following the rapid development and wide application of the Internet, Web has become an exchange, sharing of information and effective tool for collaborative work. People’s attention and frequent use of the Web promote the development of this technology, but also make the Web information resources on the rapid growth. However, there are flood of information resources distribute on Web, to Convenient to bring the people at the same time, also makes the network very difficult to in-depth application. On the one hand a person is only concerned about small information of Web, and user is not interested in the rest of the Web. Content mining is used to extract the text, image, or other information and knowledge component of the web content.

A semantic-based Web mining is mentioned by many people in order to improve Web service levels and address the existing Web services which is supported by the lack of semantic problem. Semantic-based Web data mining is a combination of the semantic Web and Web mining. Web mining results help to build the semantic Web. The knowledge of Semantic Web makes Web mining easier to achieve, but also can improve the effectiveness of Web mining.

Read more…

Connect MATLAB with MySQL database


Here is the code to connect MATLAB with MySql.

%database url
url = ‘jdbc:mysql://localhost:3306/’;
%test is a database, root is a user, admin is a password,
%com.mysql.jdbc.Driver is a driver name which was included into the folder
%and accordingly written the [matlabroot]/toolbox/local/classpath.txt
%$matlabroot/java/jar/mysql-connector-java-5.0.8-bin.jar
conn = database(‘test’, ‘root’, ‘admin’, ‘com.mysql.jdbc.Driver’, url);

curs = exec(conn,’SELECT * FROM emp’);
curs = fetch(curs);
curs.data

For the above program to work, you need to have Mysql Driver and you need to specify the path in the matlab path file. Once the above settings are made you can use mysql database from matlab.

How to set and what to set I’ve mentioned in the above program as comments. I hope this helps you.