[Biodevelopers] database schema of OMIM.

Eric Gundrum eric at macgroup.com
Wed Sep 17 18:17:16 EDT 2003


--- At 3:06 AM +0100 9/16/03, Dan Bolser wrote:
>> 1.2|9|25|01|1pter-p36.13|ENO1, PPH, MPB1|C|Enolase-1,
>> alpha||172430|S,
>> F, R, REa|||Enolase deficiency (1)| | |4(Eno1)|
>
>
>> 1  - Numbering system, in the format
>> Chromosome.Map_Entry_Number
>
>Either use a float, or split the two numbers and create an INT
>column for both.

Probably two integer columns is best, but you could do it with one by
shifting the decimal point right a fixed number of positions on import,
making all values integer.

Many computers cannot represent all possible float values in a floating
point register. While you may not encounter this limitation with the values
used for "Map_Entry_Number" the risk is unnecessary. Converting to integer
values also may provide better performance than using a float.

		Regards...eric



More information about the Biodevelopers mailing list