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

[Trish W. <wh...@pc...>]

As I recall, these 'redundant' tables were left in the schema because they 
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