On Sun, May 09, 2010 at 09:32:53PM -0700, Mark Diggory wrote: > 1.) Create separate tables to maintain the authors and organizations > wholly independent from the metadatavalue table. I would create a > service in DSpace to maintain the data expressed within that model. > > Entity tables > authors (id, firstname, lastname, email, ...) > organizations (id, orgname, description, url, contact, ....) > > Relation tables > authors2organizations (is, authorid, organizationid)
Well, maybe authors2organizations (id, authorid, organizationid,
relationship, startdate, enddate, ...). Authors may form and dissolve
multiple overlapping relationships with a variety of organizations
througout their careers. A given item will represent a point in a
space: (time, extant relationships).
I will ask again whether maintaining a complete picture of an author's
relationships with various organizations is properly a part of DSpace,
or rather an external service that DSpace (and other products) could
use to considerable advantage. It seems to me like something that
will be essentially duplicated across various similar products.
--
Mark H. Wood, Lead System Programmer mw...@iupui.edu
Balance your desire for bells and whistles with the reality that only a
little more than 2 percent of world population has broadband.
-- Ledford and Tyler, _Google Analytics 2.0_
pgpJ0mrxksRwy.pgp
Description: PGP signature
------------------------------------------------------------------------------
_______________________________________________ Dspace-devel mailing list Dspace-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-devel
