Dear Members,
We are creating relational database (MySQL) to map DC Metadata schema. We
need to indicate the holding for some journals. Holdings may be a range
(ex. 1995 - 2005) when we started and stopped subscription or, most often,
the date from resource became available till the present time. According
to the specifications at
http://dublincore.org/documents/2005/11/07/usageguide/qualifiers.shtml,
the DC Element "Date" has following possible refinements (qualifiers)
Created
Valid
Available
Issued
Modified
Date Accepted
Date Copyrighted
Date Submitted
Available seems to be a good choice, as per
http://dublincore.org/documents/usageguide/qualifiers.shtml#available,
"Available" is a date (often a range) that the resource will become or did
become available.
My question, however, is:
While entering the Date.available to MySQL table, we could use the text
column and enter it simply as "Available 1995 - 2005" or "Available from
1995 -- ", etc.
But I think everyone agrees that is not the best approach. Date element
should be represented by "Date" MySQL (or other Database) column data
type. We are tempted to add our own qualifiers, such as "availableStart"
and "availableEnd", but wish to use standard qualifiers only for
interoperability reason.
I am sure that the problem we are facing is not unique. If someone is
willing to share, we will greatly appreciate it,
Many thanks in advance,
Vlad
----------------------------------------------------------------
Vladimir Makarov
Memorial Sloan-Kettering Cancer Center Library
1275 York Ave
New York, NY 10021
Tel: 212-639-7422
Fax: 212-717-3048
eMail: [log in to unmask]
----------------------------------------------------------------
|