[OAI-implementers] Beginners question

Tim Cole Tim Cole" <t-cole3@uiuc.edu
Thu, 17 Oct 2002 09:56:49 -0500


John-

And in addition to solutions offered by Heinrich and Jeff, see:

http://oai.grainger.uiuc.edu/ProviderTools/TemplateAReadme.htm

for an example of an OAI ver. 1.1 provider that uses ASP - ODBC - MS Access.
We've not yet posted the OAI 2.0 version of this, and of course your
database schema will undoubtedly be different, but this implementation may
give you some additional ideas.

Tim Cole
Mathematics Librarian
University of Illinois at Urbana-Champaign

----- Original Message -----
From: "John W. Horlock" <j.w.horlock@leeds.ac.uk>
To: <oai-implementers@oaisrv.nsdl.cornell.edu>
Sent: Thursday, October 17, 2002 4:20 AM
Subject: [OAI-implementers] Beginners question


> I have just started to look in making my databases OAI compliant.
> I am currently running an image search engine which users use to search
for
> images and return results via a web page. All the pages are ASP with
VBScript
> and JavaScript.
> The data is contained within a table in SQL server. What I am confused
about
> is, the table I am going to create for the metadata is going to contain
> duplicate data e.g. contributor, date added etc... as these are all
required
> to be displayed to user upon a search request.
>
> My basic understanding (which I think is wrong at the moment) is I'll have
my
> main table which houses all the data, then a smaller table which contains
> metadata about each record, which is in a valid XML format.
> Are there any other factors which I need to be aware of for my databases?
>
> I'm trying to comprehend the workings but it's not very clear.
>
> Thank you for you help.
> John
>
>
> _______________________________________________
> OAI-implementers mailing list
> OAI-implementers@oaisrv.nsdl.cornell.edu
> http://oaisrv.nsdl.cornell.edu/mailman/listinfo/oai-implementers
>