-------- Original Message --------
Subject:        classification schemes in relational databases.
Date:   Fri, 23 Apr 2010 11:49:15 -0700
From:   Jon Jablonski <[log in to unmask]>
To:     [log in to unmask]


Having just moved to UCSB, I find myself now in charge of a local call
numbering scheme.

What I'd like to do is move the paper documentation and simple flat file
of the classification scheme into something that can display the
hierarchy built into the scheme, as well as update it into the future.
It's too big of a collection to re-class into LCC.

Basic Googling has failed me here:  is there a standard way of modeling
a classification scheme into a relational database?  I figured there
would be a template of some sort.  I feel it might be slightly more
sophisticated than a simple thesaurus (use/use for, broader term,
narrower term), but not much.

Any ideas?  Can a call number scheme like LCC be represented in a
relational database?  Is there another data structure that would be more
appropriate?


--
Jon Jablonski
Map & Imagery Laboratory
Davidson Library
UC Santa Barbara