Re: [Gmod-schema] identification of root term in cv

[Kevin M. <klm...@gm...>]

Thanks for the help guys.  Much appreciated.

Cheers!

On 7/21/06, chris mungall <cj...@fr...> wrote:
>
>
> This is indeed correct, I have changed the godb-chado bridge to use
> this call
>
> SELECT cvterm_id,name FROM cvterm WHERE NOT EXISTS (SELECT DISTINCT
> subject_id FROM cvterm_relationship WHERE subject_id=cvterm_id) AND
> is_obsolete = 0 AND is_relationshiptype = 0;
>
> On Jul 20, 2006, at 12:13 PM, Hilmar Lapp wrote:
>
> > some RDBMS may execute this faster if written as NOT EXISTS
> > (depending on optimizer, it may choose to rewrite as an outer join
> > that can use an index; NOT IN will typically use a full table scan).
> >
> > sorry if this is confusing just ignore, the NOT IN will do fine in
> > many cases ...
> >
> > On Jul 20, 2006, at 1:28 PM, chris mungall wrote:
> >
> >>
> >> Like this (from godb-bridge):
> >>
> >> SELECT * FROM cvterm WHERE cvterm_id NOT IN (SELECT DISTINCT
> >> subject_id FROM cvterm_relationship) AND is_obsolete = 0 AND
> >> is_relationshiptype = 0
> >>
> >> On Jul 20, 2006, at 1:39 AM, Kevin Manansala wrote:
> >>
> >>> Good day,
> >>>
> >>> I would like to know how to identify root cvterms of a cv in the
> >>> Chado schema?
> >>>
> >>> Thank you very much in advance.
> >>>
> >>> Cheers!
> >>>
> >>> --
> >>> Kevin L. Manansala
> >>> BS Computer Science
> >>> UP Diliman
> >>>
> >>> "I'm the best there is at what I do!" - wolverine
> >>> --------------------------------------------------------------------
> >>> --
> >>> ---
> >>> Take Surveys. Earn Cash. Influence the Future of IT
> >>> Join SourceForge.net's Techsay panel and you'll get the chance to
> >>> share your
> >>> opinions on IT & business topics through brief surveys -- and earn
> >>> cash
> >>> http://www.techsay.com/default.php?
> >>> page=join.php&p=sourceforge&CID=DEVDEV______________________________
> >>> __
> >>> _______________
> >>> Gmod-schema mailing list
> >>> Gmo...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/gmod-schema
> >>
> >>
> >> ---------------------------------------------------------------------
> >> ----
> >> Take Surveys. Earn Cash. Influence the Future of IT
> >> Join SourceForge.net's Techsay panel and you'll get the chance to
> >> share your
> >> opinions on IT & business topics through brief surveys -- and earn
> >> cash
> >> http://www.techsay.com/default.php?
> >> page=join.php&p=sourceforge&CID=DEVDEV
> >> _______________________________________________
> >> Gmod-schema mailing list
> >> Gmo...@li...
> >> https://lists.sourceforge.net/lists/listinfo/gmod-schema
> >>
> >
> > --
> > ===========================================================
> > : Hilmar Lapp  -:-  Durham, NC  -:-  hlapp at gmx dot net :
> > ===========================================================
> >
> >
> >
> >
> >
> >
>
>


-- 
Kevin L. Manansala
BS Computer Science
UP Diliman

"I'm the best there is at what I do!" - wolverine