[WEB4LIB] Database driven web pages - where to get "subject headdings"

[Bryan H. Davidson]

We've done something along those lines here at the University of Arkansas,
by grouping all of our databases into subcategories such as Agriculture,
Agricultural Economics, Poultry, etc. Our site is running on an Access
database rather than Cold Fusion, but the structure would still apply to
what you have in mind.

The database itself consists of two tables: one contains a single entry for
each subscription database with fields such as Title, TitleCode, on-campus
url, off-campus url, full-text (yes/no), description, keywords, note. The
description and keyword fields also come into play when a user performs a
keyword search.

The second table has four columns:
ID, TitleCode, Category, Weight -- this is where a database gets associated
with a particular discipline.

Check it out @ http://dante.uark.edu

If you find this general structure helpful, I'll be happy to discuss our
approach in more detail.

~~~~~~~~~~~~~~~~~~~~~
Bryan H. Davidson
Electronic Products Librarian / Webmaster
University of Arkansas Libraries, Fayetteville
Ph. 501-575-4665

----- Original Message -----
From: "Masters, Gary E" <GEM at CDRH.FDA.GOV>
To: "Multiple recipients of list" <web4lib at webjunction.org>
Sent: Wednesday, August 09, 2000 5:56 AM
Subject: [WEB4LIB] Database driven web pages - where to get "subject
headdings"


> I am also looking at databases to drive web pages.  Once everything is in
a
> database, there ought to be several things to help manage it that can not
be
> done with other systems.  Perhaps we can share some here as we learn what
> works and what does not.
>
> My solution for a web page (intranet) that has many links was to build it
on
> a Cold Fusion database.  We will have one database of all types of
journals
> and another of links.  Before I can turn it over to the programmer, I have
> been trying to come up with a list of "descriptors" that can be used to
> search and organize the links.  Since our Center is for medical devices
and
> radiological health we need  medicine, business and the hard sciences.
What
> looked like an afternoon's work has started to eat up my schedule when I
get
> into things like "bioengineering, biochemistry, biotechnology or something
> to combine or all three or more?"  We want to keep it to 50 or less terms
> that we can display in a table.  Can someone suggest a place that has done
> this or a list that I can beg or borrow?
>
>
> Thanks,
>
> Gary
>
>
> Gary E. Masters
> Librarian (Systems)
> CDRH - FDA
> (301) 827-6893
>