first geo++ pipeline : analysis of the database. soma mukherjee aei-mpg, geo da workshop feb. 21,...

First GEO++ pipeline : analysis of the database.

Soma Mukherjee

AEI-MPG, GEO DA Workshop Feb. 21, 2002

http://www.aei.mpg.de/~soma/dcr_res.html

Soma Mukherjee, 20.02.02 11:47:12 AM

Soma Mukherjee20.02.02 / 2

Working in the Matlab environment

Database transported to the local machine from Hannover (130.75.117.76, /tmp/dcrdbase.tar.gz)

ODBC (Open DataBase Connectivity) driver installed.

Modes of commands : Visual Query Builder, Matlab database toolbox commands in association with SQL queries.

Database Toolbox

JDBC/ODBC Bridge

ODBC Driver

For MySQL

Database

VQB snapshot

Soma Mukherjee 21.02.02

Matlab script :

conn=database('dcr','ODBC','') % Connect to database

Curs=exec(conn,’SELECT ALL start_time FROM sngl_burst WHERE ifo= …‘SEI _NBC_SEIS-X’ ORDER BY snr ASC; % execute SQL command

curs=fetch(curs,5);

Close(conn)___________________________________________________________

>>curs.Data = [6943333500] [6943556721]

[6945123456] [6946123456] [6948213456]

2/20/2002

Conclusions :

•Matlab database exercised.•Scripts written.•Simple data mining exercises accomplished.•Data exploration •Entire hardware/software chain in place to start answering questions from experimentalists.•Getting ready for DCR !

Soma Mukherjee 21.02.02

MATLABJDBC/ODBC

Bridge. ODBC Driver

Database

Access to database in Matlab :

Soma Mukherjee, 21/02/02