X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B637732A0EB for ; Tue, 19 Oct 2004 12:56:10 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 59840-05 for ; Tue, 19 Oct 2004 11:56:06 +0000 (GMT) Received: from shiva.jussieu.fr (shiva.jussieu.fr [134.157.0.129]) by svr1.postgresql.org (Postfix) with ESMTP id DB47E32A0E5 for ; Tue, 19 Oct 2004 12:56:08 +0100 (BST) Received: from drum.snv.jussieu.fr (drum.snv.jussieu.fr [134.157.190.2]) by shiva.jussieu.fr (8.12.11/jtpda-5.4) with ESMTP id i9JBu6EA017477 for ; Tue, 19 Oct 2004 13:56:07 +0200 (CEST) X-Ids: 166 Received: from yahoo.fr (jefferson.snv.jussieu.fr [134.157.138.164]) by drum.snv.jussieu.fr (8.12.1/jtpda-5.4) with ESMTP id i9JBu5mB043705 for ; Tue, 19 Oct 2004 13:56:05 +0200 (CEST) Message-ID: <417500D5.1060109@yahoo.fr> Date: Tue, 19 Oct 2004 13:56:05 +0200 From: Guillaume User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3.1) Gecko/20030428 X-Accept-Language: fr, en, en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: bibliographic schema References: <4173DEC5.4080509@yahoo.fr> <200410181310.34134.josh@agliodbs.com> <20041019091723.B570@hermes.hilbert.loc> In-Reply-To: <20041019091723.B570@hermes.hilbert.loc> X-Enigmail-Version: 0.73.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-1.5.8 (shiva.jussieu.fr [134.157.0.166]); Tue, 19 Oct 2004 13:56:07 +0200 (CEST) X-Miltered: at shiva.jussieu.fr with ID 417500D6.000 by Joe's j-chkmail (http://j-chkmail.ensmp.fr)! X-Antivirus: scanned by sophie at shiva.jussieu.fr X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/124 X-Sequence-Number: 19227 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