[greenstone-devel] Using SQLite

From Diego Spano
DateSat May 30 02:07:26 2009
Subject [greenstone-devel] Using SQLite
In-Reply-To (C0065BA84E23FC49A7DF8B98C81A080C81EF0B6A17-NSQ165EX-enterprise-internal-city-ac-uk)
Alex, about taxonomy. I was thinking in something similar to waht you wrote.
I think that we can associate a table with terms related with a table that
holds all the document□s url in greenstone.

Suppose, you have a table A with one record for each word of the taxonomy,
and each record points to multiple url (one record for each document tagged
with this taxonomy).

I.e:

□Knowledge□

□ □/gsdl/collect/demo/index/assoc/hash0872/doc.pdf□

□ □/gsdl/collect/books/index/assoc/hashcd54/doc.pdf□

□Internet resources□

□ □/gsdl/collect/demo/index/assoc/hash421a/doc.pdf□

□ □/gsdl/collect/demo/index/assoc/hasheec3/doc.pdf□

□ □/gsdl/collect/photos/index/assoc/hash3ddd/photo.jpg□

What do you think?

Regards.

Diego

De: greenstone-devel-bounces@list.scms.waikato.ac.nz
[mailto:greenstone-devel-bounces@list.scms.waikato.ac.nz] En nombre de
PG-PG-Kriwaczek, Alexander
Enviado el: Martes, 26 de Mayo de 2009 07:55 a.m.
Para: greenstone-devel@list.scms.waikato.ac.nz
Asunto: [greenstone-devel] Using SQLite

Hi,

I'm a student on the MSc in Library and Information Studies course at City
University London and for my individual project will be building a small
digital library, based on a special collection of Victorian magazines held
by our library. There is already an index to the articles, including
keywords.

I will be teaching myself Perl and CGI scripting so that I can customise the
Greenstone interface, but would in addition like to offer some kind of
faceted search. However, I do not have a computer science background, have
no knowledge at all of C++ and doubt that I will have time to become
competant in this language in the time available.

I notice that the latest release of Greenstone 2 allows you to store the
metadata in a SQLite database. Would it be possible, in theory, to add extra
tables to the SQLite database to hold a keyword taxonomy and write one's own
Perl code to query the database and produce a search interface to the
digital library, whose results are based on joint queries to the metadata
and taxonomy tables?

Regards,

Alex.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://list.scms.waikato.ac.nz/mailman/private/greenstone-devel/attachments/20090529/07634ff9/attachment-0001.html