On Tue, Jan 19, 2010 at 08:08:19AM +0900, Charles Plessy wrote:
> This is more or less what I meant by ???long??? format (in the sense of R???s
> reshape() function). In order to fit this information in a SQL table, I was
> more thinking about:
> 
> package       title   text
> package       authors text
> package       published-in    text
> package       year    text
> etc.

Hmmm, I'm not comfortable enough with R's reshape function, but I can
tell that the 'package' stuff you was putting in front of the column
definitions are not SQL conform.  I was thinking of the package name
as kind of a primary key.
 
> In a previous discussion (which I can not find for the moment), there was no
> objection to do the contrary: support only one reference.

One reference per package is fine, makes things simple and supports my
idea of using the package name as primary key.

> The web sentinel has
> currently the same limitation anyway.

... which is perfectly sufficient IMHO.

> In the case a package contains multiple
> programs to be cited with multiple articles, I was considering using a field
> with a name like ???Reference-List-URL???,

Sounds reasonable.

Kind regards

       Andreas. 

-- 
http://fam-tille.de


-- 
To UNSUBSCRIBE, email to debian-qa-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to