database redesign for Intellectual Property Table for permissions for embargoed data
#2 Updated by Michael Lee over 19 years ago
From the minutes of the Sept 12 Meeting in SBA, where this idea came from:
2-4-1 Intellectual Property and Confidentiality.
Brad Boyle and Jerry Cooper both pointed out that much plot data needs to remain
protected for some years if authors are to agree to post their data. There
followed a discussion of how to resolve this issue.
• The current data model contains the fields “confidentiality_status” and
“confidentiality_reason” within Plot as a mechanisms for handling T&E species
and private land issues.
• We need a new permissions layer. Ideally, this would be like UNIX permissions
with groups and individuals.
• The intent is to allow contributors of data to screen potential users for some
fixed period of time so as to protect their rights and opportunities to publish
based on the data. However, the same mechanism could be used for other reasons
such as rare species or landowner issues.
• The simple version is table of Permissions to see embargoed plots including
fields for plot number, party, & permission. Confidentiality status could be
maintained within Plot, but perhaps a separate table is need in the event that
more than one embargo applies to a particular plot.
• There could be a switch in embargo to allow both observation and plot, but we
have no choosen to separate the observations.
Embargo_ID = PK
Plot_ID = FK to Plot
Embargo_reason (need new list)
Landownership, Bad data
Embargo_start = Date
Embargo_stop = Date
Embargo_owner = FK to Party
Default_Status = Same list as in Permission_Status below
Permission_ID = PK
Embargo_ID = FK to Embargo
Party_ID = FK to Party
Permission_Status (use Confidentiality_Status list)
Public [Default if no embargo]
1 km radius location resolution
10 km radius [Default if landowner or rare species]
100 km radius
Public embargo on data [Default if reason = author]
Full embargo on data
• Business rules. The embargo owner should be able to lift the embargo for a
party or parties via a web form, as should the management team. Submitted plots
should be embargoable for up to x (5?) years, and the embargo should be renewed
twice. When a plot search reveals one or more embargoed plots, the searcher see
only accession # + email of owner