On Mon, May 10, 2010 at 10:24 AM, Mark H. Wood <mw...@iupui.edu> wrote: > 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).
No doubt, I was just providing a barebones concept. The point though is that the relationship be preserved, not caring too much about the level of detail. Likewise the more detail you want, the more complex you need to make your datamodel. You'll need Entities representing time in office etc for that author/institution relation... again not so sure thats DSpace's job... > 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. > Yes, but we also need to think about how we want to improve the Metadata Modeling capabilities of DSpace, its important to recognize that we do need to enhance the datamodel to support this level of Entity relationship... (1) so that DSpace can have more flexible Object types and (2) so that developers use entities and relations to extend the capabilities rather than trying to hack the existing core entities (Item etc). -Mark -- Mark R. Diggory Head of U.S. Operations - @mire http://www.atmire.com - Institutional Repository Solutions http://www.togather.eu - Before getting together, get t...@ther ------------------------------------------------------------------------------ _______________________________________________ Dspace-devel mailing list Dspace-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-devel
