ALEG
Weekly Report - Week 11, 13 July 2001
What I've done
- Dataloading
SA Women Bib: Finished manually checking periodical details for the minor publications,
and wrote program to create the necessary new periodicals (324) and periodical issues
(1449). Then, the minor pubs with journal sources were finally linked to
their source - 2203 new sources were created, 1073 existing sources where
matched (and not duplicated). There were 148 minor pub sources which could
not be handled (no author or source title typically) which have been passed to Anne.
The SAWW minor pubs database had additional sources in a note, but these are
too difficult to parse so have just been added as a note on the work.
- Many new miscellaneous queries and adhoc data analysis reports, mainly
associated with 11,000+ works without worktype/form/genre classification and
other cleanup issues.
- Changed agent detail display to separate work counts for an agent where there
role was not creator or author. Hence, now shows "As editor", "As translator" (etc)
counts.
- Changed agent detail display for agents using other writing names (formerly known
as "pseudonyms") so that the entire output of an agent using multiple writing names
is shown by default, and details for just that one writing name can be displayed.
This was a significant change because it meant creation events could not be
searched just against the agent, but had to be searched for the agent and
their "pseuds". This caused some performance problems which were finally
addressed by introducing a new hidden agent attribute which links an agent
to all its pseuds as well as to itself (making the SQL join as simple as
possible).
- Mounted Megan's doco and linked it to the agent maintenance help prompts.
- Data cleanups:
- Changed [and] in titles to & (123)
- Removed [by] and trailing string from (most - 3174) titles
- Removed single-work attribute from anthologies, collected works, selected works (few dozen)
- Changed creators of anthologies (16) to editors
- Changed creators of bibliographies (298) to compilers
- Changed single creators of single works to authors (hundreds of thousands of these)
- Moved public notes for WA authors without a bio to a bio attribute (421), hid public notes
for WA Authors with a bio (32)
- System
Applied Oracle software patch (8.1.7.1.0) with a few (but fewer than expected!)
problems.
Performed tuning to identify and fix some antisocial database access statements (SQL).
Next Week
- To Do list. Work through the (mostly) minor issues on the to-do
list provided by Annette/Kerry/Marie-Louise.
- More time on planning session on the new user interface with Marie-Louise
and Annette.
- The new thesaurus arrived on last week - start processing it and converting
current subject terms.
Next few weeks
- First known dates.
- Pick up the ball I dropped regarding the Z39.50 interface to NLA
holdings.