Chado documenation key

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Chado documenation key

Karl O. Pinc
Hi,

Where is the documentation on the notation
and symbols used in the chado docs?
Stuff like "UNIQUE#1" notations in
the column definitions and the line termination
symbols used in the ER diagrams?

Thanks.

Karl <[hidden email]>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Gmod-schema mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-schema
Reply | Threaded
Open this post in threaded view
|

Re: Chado documenation key

Scott Cain
Hi Karl,

I don't think such a document exists.  The ER diagrams are automatically generated with SQLFairy (ie, SQL::Translator) and don't (I think) provide insight into the cardinality of the relationships.

Scott


On Thu, Mar 13, 2014 at 5:30 PM, Karl O. Pinc <[hidden email]> wrote:
Hi,

Where is the documentation on the notation
and symbols used in the chado docs?
Stuff like "UNIQUE#1" notations in
the column definitions and the line termination
symbols used in the ER diagrams?

Thanks.

Karl <[hidden email]>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Gmod-schema mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-schema



--
------------------------------------------------------------------------
Scott Cain, Ph. D.                                   scott at scottcain dot net
GMOD Coordinator (http://gmod.org/)                     216-392-3087
Ontario Institute for Cancer Research

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Gmod-schema mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-schema
Reply | Threaded
Open this post in threaded view
|

Re: Chado documenation key

Karl O. Pinc
On 03/17/2014 01:39:42 PM, Scott Cain wrote:
> Hi Karl,
>
> I don't think such a document exists.  The ER diagrams are
> automatically
> generated with SQLFairy (ie, SQL::Translator) and don't (I think)
> provide
> insight into the cardinality of the relationships.

Can you tell me what "UNIQUE#1" means?  I'm looking at

http://gmod.org/wiki/Chado_General_Module#Table:_dbxref

and the dbxref.db_id column is clearly not unique.  It's
a foreign key on db.


In the FWIW category, if I have to do a "Babase" module
for some unknown reason I'd likely do the ER diagram in
Dia (and commit the diagram into revision management etc.)
Would this be an issue?  Or should we just worry about it
come the day?

> On Thu, Mar 13, 2014 at 5:30 PM, Karl O. Pinc <[hidden email]> wrote:
>
> > Hi,
> >
> > Where is the documentation on the notation
> > and symbols used in the chado docs?
> > Stuff like "UNIQUE#1" notations in
> > the column definitions and the line termination
> > symbols used in the ER diagrams?




Karl <[hidden email]>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Gmod-schema mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-schema
Reply | Threaded
Open this post in threaded view
|

Re: Chado documenation key

Karl O. Pinc
In reply to this post by Scott Cain
On 03/17/2014 01:39:42 PM, Scott Cain wrote:
> Hi Karl,
>
> I don't think such a document exists.  The ER diagrams are
> automatically
> generated with SQLFairy (ie, SQL::Translator) and don't (I think)
> provide
> insight into the cardinality of the relationships.

Also in the FWIW category, with Babase we've
found that annotated ER diagrams are really important
to understanding the system.  In many cases that's
all that people use.  There's a big poster with
all the diagrams tacked up on the lab wall.

(Seems like nobody actually _reads_ the documentation,
but they will look at a picture.  ;-)


E.g.:

http://papio.biology.duke.edu/diagrams/lifeevents.png


And they help with views too:

http://papio.biology.duke.edu/diagrams/actor_actees.png


The key is here:

http://papio.biology.duke.edu/diagrams/tableguide.png


Karl <[hidden email]>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Gmod-schema mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-schema