Re: [GUSDEV] [CBIL] forgot this Re: sres.author table

[Marie-Adele R. <ma...@sa...>]

Thanks for checking.  The PSU no longer has a need for these tables.

Marie-Adele Rajandream

Pathogen Sequencing Unit

-----Original Message-----
From: gus...@li...
[mailto:gus...@li...] On Behalf Of Trish
Whetzel
Sent: 10 October 2006 17:34
To: Junmin Liu
Cc: gus...@li...; cb...@pc...
Subject: Re: [GUSDEV] [CBIL] forgot this Re: sres.author table

As I recall, these 'redundant' tables were left in the schema because
they=20
were requested by PSU based on how they handle this type of information.

Does PSU still have a need for these tables?

Trish


> Looks like these are the ghost tables, people never use it since 2002.
> ---junmin
>
> On Mon, 9 Oct 2006, Junmin Liu wrote:
>
>> Hi, all
>> By looking at gus schema browser, I just realized that we have couple
new
>> tables in SRes: sres.author, sres.bibRefAuthor. I searched the GUS
tracker to
>> find the cause for this, but couldn't find any.
>>
>> I have couple questions:
>> 1. why we need this? what are the use cases? I understand the
"authors"
>> column in biblographRefernce may not be optimized, but I think
practically it
>> works well, even you want to search for authors.
>>
>> 2. what the difference between this author table and sres.contact
table? Why
>> we cann't use sres.contact table?
>>
>> 3. where is the documentation saying "when we use sres.contact and
when we
>> use sres.author"? I don't find any difference between these two,
except the
>> names.
>>
>> 4. please note in the FuGE uml model, or MAGE model, the developers
simply
>> user "authors" column too, and don't borther to create this author
and
>> linking table.
>>
>> Thanks,
>> ---junmin

------------------------------------------------------------------------
-
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=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
Gusdev-gusdev mailing list
Gus...@li...
https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev