I can explain a couple of these:

On 8/18/12 12:15 AM, Ben Companjen wrote:

>
> in Edition:
> - full title; how does this relate to title?

I'd need to see a few of these to confirm this, but I believe that this 
relates to the need title_prefix, and would be the title without the 
title prefix removed.

> - name; are these 9 records that used to be Authors (which have name fields)?

no idea

> - work_title / work_titles; why would we use these when there is the
> title in Work?

Because they come in on library records, and it is probably a good idea 
to keep them as a way to re-cluster editions into works. These are 
needed for editions where the edition title \= work title, as in 
translations. Also, unless OL always exports the work title with an 
edition, that information will be lost for anyone downloading an edition 
record if it is removed from the edition record. In general, I see an 
advantage to keeping such fields in place as long as editions can be 
downloaded separately from works.

> - title_prefix; is this being used? If so, why is there no
> corresponding title_prefix in Work?

In the original MARC records there is a way to indicate a "non-sort" 
part of the title, using numbers. So:

non-sort=4
title=The catcher in the rye.

This means that you begin a title sort on "catcher" not "The ". Because 
the first records being processed came in as MARC records, there was an 
attempt to deal with this. By the time that the work records were being 
developed (which was a couple of years into the project), OL had given 
up on trying to manage this sorting issue. So my guess is that there are 
many records that still have this in them. For future applications it 
may not be such a bad idea to have captured the non-sort information 
that came in on the original records. But it isn't being used in OL 
today because OL does not present sorted displays.

Ben, do you know if these fields are exported by the API? I looked for 
examples but couldn't find them, however I was just looking at edit 
displays, and these fields may not be shown in those. If you have 
examples, then we could confirm if my memory is correct.

kc

p.s. the translated title in Works, I believe, is due to a desire on the 
part of one of the developers to allow folks to translate titles into 
different languages, even if the book itself has not been translated. It 
obviously hasn't been advertised, so it hasn't been used.

>
> Ben
>
> On 18 August 2012 06:25, Karen Coyle <[email protected]> wrote:
>>
>>
>> On 8/17/12 12:31 PM, Ben Companjen wrote:
>>
>>>
>>> Works have these fields with corresponding number of appearances at
>>> the end of July 2012:
>>> title, 15560144
>>> other_titles, 1
>>> translated_titles, 4
>>> subtitle, 578433
>>>
>>> Editions:
>>> title, 24841618
>>> subtitle, 9809990
>>> other_titles, 2225897
>>> full_title, 521383
>>> name, 9
>>> work_titles, 493101
>>> work_title, 261511
>>> translation_of, 2739
>>> title_prefix, 2945495
>>>
>>> title and subtitle speak for themselves, other_titles and
>>> translation_of are available in the edit form in librarian mode, but
>>> the others seem relics from previous system designs. Can anyone
>>> explain those? Are they used anywhere? Or can they safely be deleted?
>>
>> Ben, which are you thinking are left-overs? The only one that seems odd
>> to me is "name."
>>
>> kc
>>
>>>
>>> Thanks!
>>>
>>> Ben
>>> _______________________________________________
>>> Ol-tech mailing list
>>> [email protected]
>>> http://mail.archive.org/cgi-bin/mailman/listinfo/ol-tech
>>> To unsubscribe from this mailing list, send email to 
>>> [email protected]
>>>
>>
>> --
>> Karen Coyle
>> [email protected] http://kcoyle.net
>> ph: 1-510-540-7596
>> m: 1-510-435-8234
>> skype: kcoylenet
>> _______________________________________________
>> Ol-tech mailing list
>> [email protected]
>> http://mail.archive.org/cgi-bin/mailman/listinfo/ol-tech
>> To unsubscribe from this mailing list, send email to 
>> [email protected]
>

-- 
Karen Coyle
[email protected] http://kcoyle.net
ph: 1-510-540-7596
m: 1-510-435-8234
skype: kcoylenet
_______________________________________________
Ol-tech mailing list
[email protected]
http://mail.archive.org/cgi-bin/mailman/listinfo/ol-tech
To unsubscribe from this mailing list, send email to 
[email protected]

Reply via email to