Isn't TOPCAT a nice tool for the would be "amateur GW astronomer" ? :-)
I'm afraid that signal is due to suspension wires in the interferometers that tend to tremble at certain frequencies between 340 and 350 Hz, see this diagram from the S3 result paper that shows the affected frequencies:
.
Nevertheless the fact that we see these instrument artefacts in our result demonstrates the sensitivity of the software.
But work with connection to RDBMS cause a several questions... :D
I dump my results into a MySQL DB and access it via TOPCAT, works like a charm once you figure out how to make TOPCAT see the MySQL driver (which is fairly well documented => RTFM). For the most interesting queries you'd run repeatedly you can setup views in MySQL so that in Topcat you basically only configure a "select * from " most of the time. E.g. I have a view that filters out all the harmonics of 60 Hz and other known "noise".
But work with connection to RDBMS cause a several questions... :D
I dump my results into a MySQL DB and access it via TOPCAT, works like a charm once you figure out how to make TOPCAT see the MySQL driver (which is fairly well documented => RTFM). For the most interesting queries you'd run repeatedly you can setup views in MySQL so that in Topcat you basically only configure a "select * from " most of the time. E.g. I have a view that filters out all the harmonics of 60 Hz and other known "noise".
CU
Bikeman
I try to store data in Oracle Database and take a little wonder after reading of documentation:
Quote:
You have to specify a JDBC URL specifying the query to read/table to write as a string in the Location field of the normal table load/save dialogue boxes. The URL will look something like
jdbc:oracle:thin:@//hostname:1521/database#SELECT ...
When I connecting to database, as minimum, I must write login/password...
And what is a "database" in TOPCAT terminology? Scheme, alias or another sense?
Do not understand this "phrase":
Quote:
Here are example command lines to start up TOPCAT using databases known to work.
I try to store data in Oracle Database and take a little wonder after reading of documentation:
Quote:
You have to specify a JDBC URL specifying the query to read/table to write as a string in the Location field of the normal table load/save dialogue boxes. The URL will look something like
jdbc:oracle:thin:@//hostname:1521/database#SELECT ...
When I connecting to database, as minimum, I must write login/password...
And what is a "database" in TOPCAT terminology? Scheme, alias or another sense?
Must be the instance name or Oracle SID you configured for Oracle.
You open a table from a database also by File->Open Table , but in the dialog you select DataSources->SQL Query . The dialog that will appear now has dedicated fields for the components of the JDBC URL, including login/password.
Quote:
Do not understand this "phrase":
Quote:
Here are example command lines to start up TOPCAT using databases known to work.
This "start command line" need for using JDBC drivers in TOPCAT?
Continue reading... ;-)
Yes, if you want to use database connectivity with TOPCAT you must not start TOPCAT using the java -jar ... command, you must explicitly configure the CLASSPATH to include both the TOPCAT JAR and the Oracle JDBC driver JAR. In addition, you have to set a system property via the -D command line option, this will tell TOPCAT the class that implements the JDBC database driver.
So this is infact the command line to start TOPCAT with Oracle support (for Unix/Linux systems, on windows replace the colon with a semicolon as path separator.
I try to store data in Oracle Database and take a little wonder after reading of documentation:
Quote:
You have to specify a JDBC URL specifying the query to read/table to write as a string in the Location field of the normal table load/save dialogue boxes. The URL will look something like
jdbc:oracle:thin:@//hostname:1521/database#SELECT ...
When I connecting to database, as minimum, I must write login/password...
And what is a "database" in TOPCAT terminology? Scheme, alias or another sense?
Must be the instance name or Oracle SID you configured for Oracle.
:-) Of course! If we "speak" into listener port, we must write SID or one of service names. Atmosphere of selebration make me stupid! :D
Quote:
Quote:
Do not understand this "phrase":
Quote:
Here are example command lines to start up TOPCAT using databases known to work.
This "start command line" need for using JDBC drivers in TOPCAT?
Continue reading... ;-)
Yes, if you want to use database connectivity with TOPCAT you must not start TOPCAT using the java -jar ... command, you must explicitly configure the CLASSPATH to include both the TOPCAT JAR and the Oracle JDBC driver JAR. In addition, you have to set a system property via the -D command line option, this will tell TOPCAT the class that implements the JDBC database driver.
So this is infact the command line to start TOPCAT with Oracle support (for Unix/Linux systems, on windows replace the colon with a semicolon as path separator.
You open a table from a database also by File->Open Table , but in the dialog you select DataSources->SQL Query . The dialog that will appear now has dedicated fields for the components of the JDBC URL, including login/password.
But for Oracle it does not work... :
Quote:
9.3 JDBC Configuration
... Oracle
You can use Oracle with the JDBC driver that comes as part of its Basic Instant Client Package. However, you can't currently use the SQL load/SQL save dialogue boxes to do it. You have to specify a JDBC URL specifying the query to read/table to write as a string in the Location field of the normal table load/save dialogue boxes. The URL will look something like
jdbc:oracle:thin:@//hostname:1521/database#SELECT ...
In Oracle Installer (for client -> oracle jdbc -> thin interfaces) I see "Internal Name: oracle.dbjava.jdbc".
For
jdbc:oracle:thin:@//database11g:1521/orcl#SELECT ...
I have a message "Error making connection jdbc:oracle:thin:@//database11g:1521/orcl - no known JDBC drivers". (database11g - is a real host name, connection through sqplus is work well).
For
oracle.dbjava.jdbc:@//database11g:1521/orcl#SELECT ...
Ihave a message "Not extant file or valid URL: oracle.dbjava.jdbc:@//database11g:1521/orcl".
Funny "buttle with my current java understanding". ;-)
Thank you for explanation!
Happy New Year! Happy crunching!
Hello! 30 results +
)
Hello!
30 results + selection of points with col5 >= 6.8
If picture is not visible click here - may be help. :)
Frequency near 720.6 Hz. Fake signal? Interference? Or Candidate? 8)
Hi! Same here :-)
)
Hi!
Same here :-)
Not just 720 Hz but all harmonics of 60 Hz will show this pattern.
CU
Bikeman
Happy New Year! 1. Made a
)
Happy New Year!
1. Made a "data cut" by frequency range, to find max(f_stats) in current range for all my S5R3 results.
2. Bring data into table:
3. Select data near 345.8 Hz (between 345.7 and 345.9) and "construct" :) this spherical diagramm:
Another fake signal?
RE: Another fake
)
Isn't TOPCAT a nice tool for the would be "amateur GW astronomer" ? :-)
I'm afraid that signal is due to suspension wires in the interferometers that tend to tremble at certain frequencies between 340 and 350 Hz, see this diagram from the S3 result paper that shows the affected frequencies:
.
Nevertheless the fact that we see these instrument artefacts in our result demonstrates the sensitivity of the software.
CU
Bikeman
RE: Isn't TOPCAT a nice
)
Yes, TOPCAT is a really nice tool!
But work with connection to RDBMS cause a several questions... :D
And, may be, necessity of Einstein@Home project! ;-)
RE: But work with
)
I dump my results into a MySQL DB and access it via TOPCAT, works like a charm once you figure out how to make TOPCAT see the MySQL driver (which is fairly well documented => RTFM). For the most interesting queries you'd run repeatedly you can setup views in MySQL so that in Topcat you basically only configure a "select * from " most of the time. E.g. I have a view that filters out all the harmonics of 60 Hz and other known "noise".
CU
Bikeman
RE: RE: But work with
)
I try to store data in Oracle Database and take a little wonder after reading of documentation:
When I connecting to database, as minimum, I must write login/password...
And what is a "database" in TOPCAT terminology? Scheme, alias or another sense?
Do not understand this "phrase":
This "start command line" need for using JDBC drivers in TOPCAT?
Continue reading... ;-)
RE: I try to store data in
)
Must be the instance name or Oracle SID you configured for Oracle.
You open a table from a database also by File->Open Table , but in the dialog you select DataSources->SQL Query . The dialog that will appear now has dedicated fields for the components of the JDBC URL, including login/password.
Yes, if you want to use database connectivity with TOPCAT you must not start TOPCAT using the java -jar ... command, you must explicitly configure the CLASSPATH to include both the TOPCAT JAR and the Oracle JDBC driver JAR. In addition, you have to set a system property via the -D command line option, this will tell TOPCAT the class that implements the JDBC database driver.
So this is infact the command line to start TOPCAT with Oracle support (for Unix/Linux systems, on windows replace the colon with a semicolon as path separator.
Good Luck!
Bikeman
RE: RE: I try to store
)
:-) Of course! If we "speak" into listener port, we must write SID or one of service names. Atmosphere of selebration make me stupid! :D
It's help! TOPCAT successfully started as
java -classpath topcat-full.jar;ojdbc14.jar -Djdbc.drivers=oracle.jdbc.driver.OracleDriver uk.ac.starlink.topcat.Driver
But for Oracle it does not work... :
In Oracle Installer (for client -> oracle jdbc -> thin interfaces) I see "Internal Name: oracle.dbjava.jdbc".
For
jdbc:oracle:thin:@//database11g:1521/orcl#SELECT ...
I have a message "Error making connection jdbc:oracle:thin:@//database11g:1521/orcl - no known JDBC drivers". (database11g - is a real host name, connection through sqplus is work well).
For
oracle.dbjava.jdbc:@//database11g:1521/orcl#SELECT ...
Ihave a message "Not extant file or valid URL: oracle.dbjava.jdbc:@//database11g:1521/orcl".
Funny "buttle with my current java understanding". ;-)
Thank you for explanation!
Happy New Year! Happy crunching!
This is impressive. I
)
This is impressive.
I think it is very, very cool that we can use the processed data directly in some way as opposed to just sending it off never to be seen again.