bibliographic schema

hello

we're looking for a SQL database schema for bibliographical references.
the goal is to extract all the bibliographical references contained in
our various existing pgsql scientific databases in only one specific
database and to interconnect them with external keys and perl scripts.

database schema of existing free projects (refdb, refbase, etc.) are not
satisfactory.

any link or suggestion will be welcome.

(I hope this is the good list)
thanks

Guillaume


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Re: bibliographic schema

Guillaume,

> we're looking for a SQL database schema for bibliographical references.
> the goal is to extract all the bibliographical references contained in
> our various existing pgsql scientific databases in only one specific
> database and to interconnect them with external keys and perl scripts.

I'm afraid that bibliographic references is a rather esoteric need in the OSS
community. I personally haven't seen such a thing. You may have to create
your own.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: bibliographic schema

> > we're looking for a SQL database schema for bibliographical references.
> > the goal is to extract all the bibliographical references contained in
> > our various existing pgsql scientific databases in only one specific
> > database and to interconnect them with external keys and perl scripts.
Your best bet might be to take a look at OSS library
management solutions and see whether that fits your
needs or is suitable as a starting point.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Re: bibliographic schema

Karsten Hilbert wrote:
>>>we're looking for a SQL database schema for bibliographical references.
>>>the goal is to extract all the bibliographical references contained in
>>>our various existing pgsql scientific databases in only one specific
>>>database and to interconnect them with external keys and perl scripts.
>
> Your best bet might be to take a look at OSS library
> management solutions and see whether that fits your
> needs or is suitable as a starting point.

I'm not interested in manage a library. That kind of projects schema are
mostly complex and lending and storing oriented. I just want to store
scientific references in a satisfactory way. I'm surprised that all the
scientific databases schema are simplistic for references, and that
no-one has published or produced such a database schema, probably useful
and reusable.

so, I may have to create it, as said Josh, and publish it :-)

thanks

Guillaume




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Re: bibliographic schema

Try googling for:

bibtex sql

That should provide some pointers that may help produce an effective
sql schema for storing bibliographic references.

-JimC
--
James H. Cloos, Jr.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org