[tcs-lc] Mispelling db response

[Roger Hyam]

If you were querying a db and requested a wrongly spelled name (you 
don't know it is wrongly spelled you are just passing a word) would you 
expect to get back:

1) An object for the correctly spelled name - perhaps with the 
misspelling as a note.
2) An object for the incorrectly spelled name with a pointer to where to 
get the correctly spelled object.
3) Objects for both the correctly and incorrectly spelled names and a 
link between them.

I think this is a matter for the db you are querying to decide *not* the 
schema. Some dbs will be capable of doing some kinds of response others 
capable of others. The schema is just the transport medium for this kind 
of thing.

Of course the db might think it is a correctly spelled name and return 
an object representation of it anyway.

Does this help in clarifying the debate on misspelling of names at all? 
i.e. which ones of them will be created as objects and which will be 
notes etc.

Roger


-- 

==============================================
 Roger Hyam
----------------------------------------------
 Biodiversity Informatics
 Independent Web Development 
----------------------------------------------
 http://www.hyam.net  roger at hyam.net
----------------------------------------------
 2 Janefield Rise, Lauder, TD2 6SP, UK.
 T: +44 (0)1578 722782 M: +44 (0)7890 341847
==============================================


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mercury.nceas.ucsb.edu/ecoinformatics/pipermail/tcs-lc/attachments/20050502/c439e635/attachment.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: roger.vcf
Type: text/x-vcard
Size: 275 bytes
Desc: not available
Url : http://mercury.nceas.ucsb.edu/ecoinformatics/pipermail/tcs-lc/attachments/20050502/c439e635/roger.vcf