ASP OAI 2.0 Data Providers 1.4 Released

The following major changes were made in this release for the three ASP OAI 2.0 Data Providers:

For the DB Provider:
1. Added <description> node support in the response of the "Identify" request.
2. Performance improvement:
(a) Using one query to get all set information (setSpec) instead of querying the set information of each metadata record one by one.
(b) Added "TOP n" to important SELECT query statements for eliminating necessary data processing and transferring.
3. Thanks to Wei Dai (Fogler Library, University of Maine), a design error in the included sample database was identified. The sample database could not properly express the following two situations in MARC records:
(a) <datafield tag="650" ind1="" ind2="0">
<subfield code="a">A1 A2</subfield>
<subfield code="a">B</subfield>
<subfield code="a">C1 C2</subfield>
</datafield>
and
(b) <datafield tag="650" ind1="" ind2="0">
<subfield code="a">A1 A2</subfield>
</datafield>
<datafield tag="650" ind1="" ind2="0">
<subfield code="a">B</subfield>
</datafield>
<datafield tag="650" ind1="" ind2="0">
<subfield code="a">C1 C2</subfield>
</datafield>
It creates problems when generating oai_dc formatted metadata or recovering the original format of the MARC metadata. Therefore, fields "serialNo" and "serialNoSub" were added into table "metadata" for distinguishing different nodes and subfields in these nodes.

For the File/DB Provider:
1. Added <description> node support in the response of the "Identify" request.
2. Performance improvement:
(a) Using one query to get all set information (setSpec) instead of querying the set information of each metadata record one by one.
(b) Added "TOP n" to important SELECT query statements for eliminating necessary data processing and transferring.

For the File Sys Provider:
1. Added <description> node support in the response of the "Identify" request.

Posted by Ying-ping Chen 2004-02-02