Dear all, I would like to clarify whether we have understood something about the database correctly. Is is right that all calculations with galaxy are stored as a link in the database. And the data are stored somewhereelse? Is it possible to store the data only in the database? For some advice, I am very grateful. Best regards, Christin -- Christin Weinberg Institute for Applied Computer Science (IACS) FH Stralsund - University of Applied Sciences Phone: +49 3831 456948 E-Mail : Christin.Weinberg@fh-stralsund.de
Hi Christin,
I would like to clarify whether we have understood something about the database correctly. Is is right that all calculations with galaxy are stored as a link in the database. And the data are stored somewhereelse?
Yes, kind of :)
Is it possible to store the data only in the database?
No and its advisable to do so. Galaxy operates on files and they can be huge. It does not make much sense to store such data in a database. Best, Bjoern
For some advice, I am very grateful.
Best regards, Christin
-- Björn Grüning Albert-Ludwigs-Universität Freiburg Institute of Pharmaceutical Sciences Pharmaceutical Bioinformatics Hermann-Herder-Strasse 9 D-79104 Freiburg i. Br. Tel.: +49 761 203-4872 Fax.: +49 761 203-97769 E-Mail: bjoern.gruening@pharmazie.uni-freiburg.de Web: http://www.pharmaceutical-bioinformatics.org/
Hi, thanks for the answer. I have one more question. Is there one main table (in the database), which creates one key for one job and this key is allocated over other tables? Thank you! Best, Christin Am 08.03.2012 16:40, schrieb Björn Grüning:
Hi Christin,
I would like to clarify whether we have understood something about the database correctly. Is is right that all calculations with galaxy are stored as a link in the database. And the data are stored somewhereelse? Yes, kind of :)
Is it possible to store the data only in the database? No and its advisable to do so. Galaxy operates on files and they can be huge. It does not make much sense to store such data in a database.
Best, Bjoern
For some advice, I am very grateful.
Best regards, Christin
-- Christin Weinberg Institute for Applied Computer Science (IACS) FH Stralsund - University of Applied Sciences Phone: +49 3831 456948 E-Mail : Christin.Weinberg@fh-stralsund.de
Yes, see the table 'job'. You may or may not find this helpful, but here's a big database schema from our wiki: http://wiki.g2.bx.psu.edu/DataModel?action=AttachFile&do=view&target=galaxy_schema.png -Dannon On Mar 9, 2012, at 8:00 AM, christin weinberg wrote:
Hi,
thanks for the answer. I have one more question. Is there one main table (in the database), which creates one key for one job and this key is allocated over other tables?
Thank you!
Best, Christin
Am 08.03.2012 16:40, schrieb Björn Grüning:
Hi Christin,
I would like to clarify whether we have understood something about the database correctly. Is is right that all calculations with galaxy are stored as a link in the database. And the data are stored somewhereelse? Yes, kind of :)
Is it possible to store the data only in the database? No and its advisable to do so. Galaxy operates on files and they can be huge. It does not make much sense to store such data in a database.
Best, Bjoern
For some advice, I am very grateful.
Best regards, Christin
--
Christin Weinberg Institute for Applied Computer Science (IACS) FH Stralsund - University of Applied Sciences
Phone: +49 3831 456948 E-Mail : Christin.Weinberg@fh-stralsund.de
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at:
participants (3)
-
Björn Grüning -
christin weinberg -
Dannon Baker