Hi,
I'm working on a drupal site with a very complicated taxonomy.
Backstory: A polisci professor and team of students designed this
project first as a theoretcal exercise as part of a senior thesis
double major in political science and computer science, and then as
the project of a very devoted and smart student using drupal. It's
both amazingly cool and technically complex. At this point, we are
trying to help rein it in to the library servers and help support it
so that new crops of students can maintain it without needing to be CS
majors, and also to help them address a few issues and problems that
have been discovered over the past year or so. My colleague and I are
totally new to Drupal, and to this database. While he's working on the
solr indexing, I'm trying to help figure out the taxonomy issue.

See here: http://gtrp.haverford.edu/aqsi/aqsi/statements/mustafa-abu-al-yazids-interview-al-jazeera
Basically, the site indexes the public statements of al-qaeda. Each
statements is assigned a bunch of terms by students who have studied
jihad and al-qaeda.

Each term is composed of two parts.
First part: a keyword from a controlled list of keywords - there are
many of these and they include places, people, theories, and other
things. So, "Afghanistan", "Barack Obama", and "media" are all
keywords.
Second part: a context from a much smaller (around 20) collection of
contexts, including I guess how the keyword figures in this statement.
Example include "area of jihad, enemy of islam, religious relations"
and others.

So, the full term would be "media - enemy of islam" for example. And
each record includes a large number of these.

Going forward, we'd ideally like to allow users of the site to find
all three of the following:
1. Records that contain a particular two part term. (easy - that's
what taxonomy is for)
2. A list of terms that begin with the first part so that they can
select the modifier for it (also easy, if we make the second term a
subterm or child of the first, this will work fine)
3. A list of terms that have the second part as a qualifier. So, for
example, show me all terms in which anything is called an "enemy of
islam" and then let me choose which keyword is referred to as an enemy
of jihad and show me that record.

It's that third one that we can't figure out. The only way we can
think to accomplish this is to basically duplicate each entry so that
we'd say "Haverford - enemy of islam" and "enemy of islam - Haverford"
I think that will work, but since there are many statements, and each
statement has many terms, this solution doesn't seem ideal. Do any of
you have ideas?
Thanks very much.
Laurie
-- 
Coordinator for Digital Scholarship and Services
Haverford College Library
370 Lancaster Ave
Haverford, PA 19041
610-896-4226
[log in to unmask]