From dev-return-2895-daniel=haxx.se@subversion.apache.org  Mon Mar 29 17:35:43 2010
Return-Path: <dev-return-2895-daniel=haxx.se@subversion.apache.org>
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by giant.haxx.se (8.14.3/8.14.3/Debian-9) with SMTP id o2TFZfqJ018111
	for <daniel@haxx.se>; Mon, 29 Mar 2010 17:35:42 +0200
Received: (qmail 22311 invoked by uid 500); 29 Mar 2010 15:35:41 -0000
Mailing-List: contact dev-help@subversion.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@subversion.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@subversion.apache.org>
List-Post: <mailto:dev@subversion.apache.org>
List-Id: <dev.subversion.apache.org>
Delivered-To: mailing list dev@subversion.apache.org
Received: (qmail 22303 invoked by uid 99); 29 Mar 2010 15:35:41 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 29 Mar 2010 15:35:41 +0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of horak.honza@gmail.com designates 209.85.220.228 as permitted sender)
Received: from [209.85.220.228] (HELO mail-fx0-f228.google.com) (209.85.220.228)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 29 Mar 2010 15:35:34 +0000
Received: by fxm28 with SMTP id 28so348084fxm.36
        for <dev@subversion.apache.org>; Mon, 29 Mar 2010 08:35:14 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from
         :user-agent:mime-version:to:subject:content-type
         :content-transfer-encoding;
        bh=+Lg3wr5ILSA4GE+B3qpd0JjPlJsC/MfnYS1M8+5xa9Y=;
        b=BE88B6sWyNou9wRdcnSdSACaLINW5ihC8CSgKUCATDyo4peiXR4lvVAOXFkT8KZLAD
         CLoJidIlTeN/B37bkkB2dIeVJN8XnHOhg7+eoC/VZSmd6ZVU+Q3ejlDRpJc9ipwx3H5l
         PzrUIIJUG9vmLSTZcFTjOlK80ei74INc04sSE=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject
         :content-type:content-transfer-encoding;
        b=hprgHwgQIGJ7XIDrvXUdXZ2iSLGyErNif6zjo3ppk8XLK3r5m3v4qe1AAzASYgMMWT
         LbJNlCdWKurRn7RkBb8ZkxIaU5o6nK3cmOcWPH9GS9CMok0vkKdp2jq2KqnaPOlNewaH
         7f7MmpVLN8zOlV4j6wsmb5oAoFg6pM0WW3/SM=
Received: by 10.103.81.38 with SMTP id i38mr2720835mul.112.1269876913833;
        Mon, 29 Mar 2010 08:35:13 -0700 (PDT)
Received: from [147.229.197.54] (b07-1021b.kn.vutbr.cz [147.229.197.54])
        by mx.google.com with ESMTPS id 23sm17514200mun.37.2010.03.29.08.35.13
        (version=TLSv1/SSLv3 cipher=RC4-MD5);
        Mon, 29 Mar 2010 08:35:13 -0700 (PDT)
Message-ID: <4BB0C8AF.1030303@gmail.com>
Date: Mon, 29 Mar 2010 17:35:11 +0200
From: =?ISO-8859-2?Q?Jan_Hor=E1k?= <horak.honza@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; cs; rv:1.9.1.8) Gecko/20100227 Thunderbird/3.0.3
MIME-Version: 1.0
To: dev@subversion.apache.org
Subject: SQL backend database scheme
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Hi everybody,

I've prepared a database scheme of the upcoming MySQL backend, it is 
avaible at:
http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100329_mysql_design_v1.png

I have arisen from BDB and FSFS backend design, some previous analyses:
http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100309_dag_structures_sql.pdf
http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100329_backend_operations_analysis.pdf

and from historic MySQL backend design:
http://homepages.paradise.net.nz/~ejrh/subversion/mysql/

Any ideas or comments will be appreciated.

Jan Horak
horak.honza@gmail.com