From owner-freebsd-hackers@FreeBSD.ORG  Mon May 14 12:01:41 2007
Return-Path: <owner-freebsd-hackers@FreeBSD.ORG>
X-Original-To: freebsd-hackers@freebsd.org
Delivered-To: freebsd-hackers@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id CF54B16A40A
	for <freebsd-hackers@freebsd.org>; Mon, 14 May 2007 12:01:41 +0000 (UTC)
	(envelope-from des@des.no)
Received: from tim.des.no (tim.des.no [194.63.250.121])
	by mx1.freebsd.org (Postfix) with ESMTP id 8F03713C46E
	for <freebsd-hackers@freebsd.org>; Mon, 14 May 2007 12:01:41 +0000 (UTC)
	(envelope-from des@des.no)
Received: from tim.des.no (localhost [127.0.0.1])
	by spam.des.no (Postfix) with ESMTP id F3AE420A7;
	Mon, 14 May 2007 14:01:37 +0200 (CEST)
X-Spam-Tests: AWL
X-Spam-Learn: disabled
X-Spam-Score: 0.0/3.0
X-Spam-Checker-Version: SpamAssassin 3.1.7 (2006-10-05) on tim.des.no
Received: from dwp.des.no (des.no [80.203.243.180])
	by smtp.des.no (Postfix) with ESMTP id 723F62088;
	Mon, 14 May 2007 14:01:37 +0200 (CEST)
Received: by dwp.des.no (Postfix, from userid 1001)
	id 454D95099; Mon, 14 May 2007 14:01:37 +0200 (CEST)
From: des@des.no (Dag-Erling =?utf-8?Q?Sm=C3=B8rgrav?=)
To: Thomas Sparrevohn <Thomas.Sparrevohn@btinternet.com>
References: <20070514082512.GA25544@lpthe.jussieu.fr>
	<200705141233.24767.Thomas.Sparrevohn@btinternet.com>
Date: Mon, 14 May 2007 14:01:37 +0200
In-Reply-To: <200705141233.24767.Thomas.Sparrevohn@btinternet.com> (Thomas
	Sparrevohn's message of "Mon\, 14 May 2007 12\:33\:24 +0100")
Message-ID: <86zm47sjfi.fsf@dwp.des.no>
User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/21.3 (berkeley-unix)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Cc: freebsd-hackers@freebsd.org, 'Michel Talon' <talon@lpthe.jussieu.fr>
Subject: Re: DPS Initial Ideas
X-BeenThere: freebsd-hackers@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Technical Discussions relating to FreeBSD
	<freebsd-hackers.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>, 
	<mailto:freebsd-hackers-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-hackers>
List-Post: <mailto:freebsd-hackers@freebsd.org>
List-Help: <mailto:freebsd-hackers-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>,
	<mailto:freebsd-hackers-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 14 May 2007 12:01:41 -0000

Thomas Sparrevohn <Thomas.Sparrevohn@btinternet.com> writes:
> That you table structure does not even full fill 1st normal form ;-) -
> You need to convert that into independent tables in order to get it on
> a reasonable normal form format

Yes, the dependency columns violate 1NF, but it's still pretty
impressive - especially the fact that sqlite imported the index file
directly without any form of preprocessing.

DES
--=20
Dag-Erling Sm=C3=B8rgrav - des@des.no