Visualization of S5R2 / S5R3 difference

hoarfrost
hoarfrost
Joined: 9 Feb 05
Posts: 207
Credit: 92407747
RAC: 109045

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)

Bikeman (Heinz-Bernd Eggenstein)
Bikeman (Heinz-...
Moderator
Joined: 28 Aug 06
Posts: 3522
Credit: 686046746
RAC: 579703

Hi! Same here :-)

Hi!

Same here :-)

Not just 720 Hz but all harmonics of 60 Hz will show this pattern.

CU
Bikeman

hoarfrost
hoarfrost
Joined: 9 Feb 05
Posts: 207
Credit: 92407747
RAC: 109045

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?

Bikeman (Heinz-Bernd Eggenstein)
Bikeman (Heinz-...
Moderator
Joined: 28 Aug 06
Posts: 3522
Credit: 686046746
RAC: 579703

RE: Another fake

Message 74787 in response to message 74786

Quote:

Another fake signal?

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

hoarfrost
hoarfrost
Joined: 9 Feb 05
Posts: 207
Credit: 92407747
RAC: 109045

RE: Isn't TOPCAT a nice

Message 74788 in response to message 74787

Quote:
Isn't TOPCAT a nice tool for the would be "amateur GW astronomer" ? :-)


Yes, TOPCAT is a really nice tool!

But work with connection to RDBMS cause a several questions... :D

Quote:
Nevertheless the fact that we see these instrument artefacts in our result demonstrates the sensitivity of the software.


And, may be, necessity of Einstein@Home project! ;-)

Bikeman (Heinz-Bernd Eggenstein)
Bikeman (Heinz-...
Moderator
Joined: 28 Aug 06
Posts: 3522
Credit: 686046746
RAC: 579703

RE: But work with

Message 74789 in response to message 74788

Quote:

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

hoarfrost
hoarfrost
Joined: 9 Feb 05
Posts: 207
Credit: 92407747
RAC: 109045

RE: RE: But work with

Message 74790 in response to message 74789

Quote:
Quote:

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.

Oracle
java -classpath topcat-full.jar:ojdbc14.jar \\
-Djdbc.drivers=oracle.jdbc.driver.OracleDriver \\
uk.ac.starlink.topcat.Driver

This "start command line" need for using JDBC drivers in TOPCAT?

Continue reading... ;-)

Bikeman (Heinz-Bernd Eggenstein)
Bikeman (Heinz-...
Moderator
Joined: 28 Aug 06
Posts: 3522
Credit: 686046746
RAC: 579703

RE: I try to store data in

Message 74791 in response to message 74790

Quote:

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.

Oracle
java -classpath topcat-full.jar:ojdbc14.jar \\
-Djdbc.drivers=oracle.jdbc.driver.OracleDriver \\
uk.ac.starlink.topcat.Driver

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.

Good Luck!

Bikeman

hoarfrost
hoarfrost
Joined: 9 Feb 05
Posts: 207
Credit: 92407747
RAC: 109045

RE: RE: I try to store

Message 74792 in response to message 74791

Quote:
Quote:

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.

Oracle
java -classpath topcat-full.jar:ojdbc14.jar \\
-Djdbc.drivers=oracle.jdbc.driver.OracleDriver \\
uk.ac.starlink.topcat.Driver

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.


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

Quote:
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!

jowr
jowr
Joined: 19 Feb 05
Posts: 55
Credit: 1947636
RAC: 0

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.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.