Hi Rachel
Have a look at MeerKat (which our company developed some time ago and
which is freely available from the Cochrane Collaboration) and the
Meerkat user group
http://www.cochrane.co.uk/en/meerkatsupportpages.htm
Meerkat is an Access database and designed to cope with large numbers of
references.
You might also want to try to refine the search strategy somehow - 40
000 seems like an awful lot!
Yours ever
Rachel
Rachel Stancliffe Tel: +44 1865 513902 ext 222
Update Software Fax: +44 1865 516918
Summertown Pavilion, email:[log in to unmask]
Middle Way
Oxford OX2 7LG
UK
www.update-software.com
-----Original Message-----
From: UK medical/ health care library community / information workers
[mailto:[log in to unmask]] On Behalf Of Rachel Gick
Sent: 07 June 2007 09:54
To: [log in to unmask]
Subject: managing large nos of refs - databases
Dear all,
I am involved in a systematic review and have produced a large no of
results - about 40,000 in all. I have found that Endnote is not suited
to the purpose of coping with large numbers of references in a
concentrated burst but rather, building up a library over a period of
time and (as a
librarian) dealing with a smaller no of hits. The company who makes
Endnote assures me that it should take 1000 hits at a time and I have
tried smaller and smaller batches (100, 500 up to the download max.
permitted by Ovid which is 1000). However, I am thinking that an
access
database would be better. I tested the 'transfer' capacity in a rather
rough and ready database (which was fine) but can't quite seem to get
the field structure cracked.
So, I wonder if anyone could share
(1) Their experiences of coping with this volume of results; how did you
store them in a database and distribute them (say in a text files)? I
would need to get rid of duplicate refs. of course.
(2) Has anyone constructed an Access database for this already and would
you be willing to share the design with me? I am not getting paid for
this but I would ensure credit would be given where it is due!
(3) Any other information/advice whatsoever relating to these issues!
With gratitude in advance and anticipation
Rachel Gick
Dr R.C. Gick
Assistant Librarian
Medical Library
Hope Hospital
Salford Royal NHS Foundation Trust
Stott Lane
Salford
M6 8HD
Tel 0161 206 5971 (x65971)
This email and any attachments are confidential and are intended solely
for the use of the named addressee. If you have received this email in
error please contact the sender and delete the original. Update Software
Ltd cannot guarantee that attachments to this e-mail are free of
viruses, and recommend that you check for viruses before opening any
attachments.
Update Software Ltd, Registered number: 3380959, Registered address:
Summertown Pavilion, Middle Way, Oxford OX2 7LG
This email and any attachments are confidential and are intended solely for the use of the named addressee. If you have received this email in error please contact the sender and delete the original. Update Software Ltd cannot guarantee that attachments to this e-mail are free of viruses, and recommend that you check for viruses before opening any attachments.
Update Software Ltd, Registered number: 3380959, Registered address: Summertown Pavilion, Middle Way, Oxford OX2 7LG
|