pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedbibliographic schema
5+ messages / 4 participants
[nested] [flat]
* bibliographic schema
@ 2004-10-18 15:18 Guillaume <gu1om@yahoo.fr>
2004-10-18 20:10 ` Re: bibliographic schema Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 5+ messages in thread
From: Guillaume @ 2004-10-18 15:18 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: bibliographic schema
2004-10-18 15:18 bibliographic schema Guillaume <gu1om@yahoo.fr>
@ 2004-10-18 20:10 ` Josh Berkus <josh@agliodbs.com>
2004-10-19 07:17 ` Re: bibliographic schema Karsten Hilbert <Karsten.Hilbert@gmx.net>
0 siblings, 1 reply; 5+ messages in thread
From: Josh Berkus @ 2004-10-18 20:10 UTC (permalink / raw)
To: Guillaume <gu1om@yahoo.fr>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: bibliographic schema
2004-10-18 15:18 bibliographic schema Guillaume <gu1om@yahoo.fr>
2004-10-18 20:10 ` Re: bibliographic schema Josh Berkus <josh@agliodbs.com>
@ 2004-10-19 07:17 ` Karsten Hilbert <Karsten.Hilbert@gmx.net>
2004-10-19 11:56 ` Re: bibliographic schema Guillaume <gu1om@yahoo.fr>
0 siblings, 1 reply; 5+ messages in thread
From: Karsten Hilbert @ 2004-10-19 07:17 UTC (permalink / raw)
To: pgsql-sql
> > 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: bibliographic schema
2004-10-18 15:18 bibliographic schema Guillaume <gu1om@yahoo.fr>
2004-10-18 20:10 ` Re: bibliographic schema Josh Berkus <josh@agliodbs.com>
2004-10-19 07:17 ` Re: bibliographic schema Karsten Hilbert <Karsten.Hilbert@gmx.net>
@ 2004-10-19 11:56 ` Guillaume <gu1om@yahoo.fr>
2004-10-25 10:36 ` Re: bibliographic schema James Cloos <cloos@jhcloos.com>
0 siblings, 1 reply; 5+ messages in thread
From: Guillaume @ 2004-10-19 11:56 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: bibliographic schema
2004-10-18 15:18 bibliographic schema Guillaume <gu1om@yahoo.fr>
2004-10-18 20:10 ` Re: bibliographic schema Josh Berkus <josh@agliodbs.com>
2004-10-19 07:17 ` Re: bibliographic schema Karsten Hilbert <Karsten.Hilbert@gmx.net>
2004-10-19 11:56 ` Re: bibliographic schema Guillaume <gu1om@yahoo.fr>
@ 2004-10-25 10:36 ` James Cloos <cloos@jhcloos.com>
0 siblings, 0 replies; 5+ messages in thread
From: James Cloos @ 2004-10-25 10:36 UTC (permalink / raw)
To: pgsql-sql
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. <cloos@jhcloos.com> <http://jhcloos.com;
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-10-25 10:36 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-18 15:18 bibliographic schema Guillaume <gu1om@yahoo.fr>
2004-10-18 20:10 ` Josh Berkus <josh@agliodbs.com>
2004-10-19 07:17 ` Karsten Hilbert <Karsten.Hilbert@gmx.net>
2004-10-19 11:56 ` Guillaume <gu1om@yahoo.fr>
2004-10-25 10:36 ` James Cloos <cloos@jhcloos.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox