[BioSQL-l] null title and CRC

[David Scott]

we are currently using "<undef>" in the crc calculation for the case 
where the title is empty (or null) - i can extend that for authors and 
location - what should we be storing the the table: "<undef>", empty, or 
null?

thanks-
david

p.s. fog for sale:
http://www.sfgate.com/liveviews/


Hilmar Lapp wrote:
> The CRC for references uses the authors, title, and location  
> attributes in Bioperl-db, and empty (or null) strings default to the  
> string "<undef>".
>
> If title is empty and authors and location do not distinguish two  
> references, then why do you want to have two rows for those  
> references? Basically, there are identical for all intents and  
> purposes, or are they not?
>
> 	-hilmar
>
> On Jul 9, 2006, at 11:03 PM, mark.schreiber at novartis.com wrote:
>
>   
>> Hi -
>>
>> We are having a problem in biojava parsing some genbank records that
>> contain references with no title. These cannot have a CRC value  
>> which is
>> required in BioSQL. If we make the title an empty string then we  
>> quickly
>> get non-unique CRC numbers.
>>
>> What does BioPerl do in these cases?
>>
>> - Mark
>>
>> Mark Schreiber
>> Research Investigator (Bioinformatics)
>>
>> Novartis Institute for Tropical Diseases (NITD)
>> 10 Biopolis Road
>> #05-01 Chromos
>> Singapore 138670
>> www.nitd.novartis.com
>>
>> phone +65 6722 2973
>> fax  +65 6722 2910
>>
>> _______________________________________________
>> BioSQL-l mailing list
>> BioSQL-l at lists.open-bio.org
>> http://lists.open-bio.org/mailman/listinfo/biosql-l
>>
>>     
>
>