[Koha] some thoughts about cataloguing and acquisition (important)

[Enrico Silterra]

Hello
I have to agree with Albert on this:
MARC is simply so widespread that, even if you
think you don't want MARC, you will later discover
that
you must have it.

I certainly don't know the underlying data structures
of
koha, but the simplest thing, to me, seems to be,
maintaining fundamentally MARC based info, which can
have simple, or full interfaces.

I have not given this a lot of thought,
but would something like this work?

Table of valid record number.

create table records {
recordid number;
acquisid number;
};

The marc table uses the record id as the foreign key,
to pull together the field number, and the subfields.

create table marc    {
recordid number;
fieldid  number;
subfield  varchar;
idicator1 varchar;
indicator2 varchar;
};

Then various views can be used to construct
tables of titles, and authors based on selecting the
correct fieldid, and subfields from the records.

Just my 2 nanocents.
Rick


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com