Mailing-List: contact couchdb-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: couchdb-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of sho.fukamachi@gmail.com
 designates 64.233.166.179 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:from:to:in-reply-to:content-type:mime-version:subject
         :date:references:x-mailer;
        b=H49+36ZeIDGLr1PwQRW41NOz7owZnIMTDTMuL48H1Us1EKELwwxUmP1vnmg6T4r93A
         Xm9rjA1NBODMJ2lQHUcwCYkZeprM+4nbTg+lYd0jlAP0kt6/ZwcMgAbNNzI/d91aU3KM
         Ypu/SOslRYOOPBer1ef+Iku1VyLzlv4hQYVgE=
Message-Id: <B2CD78AD-4AE7-49DE-8A07-2D726810CC09@gmail.com>
From: Sho Fukamachi <sho.fukamachi@gmail.com>
To: couchdb-user@incubator.apache.org
In-Reply-To: <13ae4dd50808060647v26e6bd14r709fc0aff72aa5b8@mail.gmail.com>
Content-Type: multipart/signed; boundary=Apple-Mail-78--787453396;
 micalg=sha1; protocol="application/pkcs7-signature"
Mime-Version: 1.0 (Apple Message framework v926)
Subject: Re: when to use another document and when not to?
Date: Thu, 7 Aug 2008 01:51:54 +1000
References: <6b6419750807141546q63431cfek69184295a1cb25b0@mail.gmail.com>
 <4E5620A8-7ACD-4ADB-8FFD-424EEA289E21@apache.org>
 <6b6419750807141654x5b548706i1290367ca84acd27@mail.gmail.com>
 <66471514-BF70-4EFC-A258-CEC5C4799924@gmail.com>
 <e282921e0807200647o45ea98ddt5420fd1180a6149d@mail.gmail.com>
 <DB9384FB-25ED-42F5-B4BA-FA1B1B2CFD60@gmail.com>
 <0EEE59DA-C752-43E0-A605-31865F6E020F@apache.org>
 <3F8F49C2-EC5C-4E6D-AFC9-854C42F7FC6D@gmail.com>
 <13ae4dd50807271018t66ec2e78r6285c575ae16eddb@mail.gmail.com>
 <1C0517A9-69C9-441A-A2FB-37062A76FE0A@gmail.com>
 <13ae4dd50808060647v26e6bd14r709fc0aff72aa5b8@mail.gmail.com>

--Apple-Mail-78--787453396
Content-Type: text/plain;
	charset=US-ASCII;
	format=flowed;
	delsp=yes
Content-Transfer-Encoding: 7bit


On 06/08/2008, at 11:47 PM, Paul Carey wrote:

> +1 for all the reasons you list, except perhaps the fourth, for which
> I think I'm on the fence.

Ha, I'm on the fence about pretty much everything when it comes to  
data structures in CouchDB : )

> It looks like multi key GETs / bulk_load (I got horribly confused
> following yesterday's IRC discussion) is on the horizon which will
> presumably make one of the original suggestions in this thread - a
> simple join document - feasible.

I am sure that people will start throwing rotten fruit at me for my  
endless harping on about this - but that's not a JOIN. It's a two- 
stage query. It's a good way of doing things, and in many ways  
preferable to a JOIN even in an SQL database where we have JOINs - but  
it's not a JOIN!  However, it does get rid of the n+1 GETs from the  
previous example so it's a big improvement and probably fine for most  
cases.

I think the really exciting thing is the possibility of the re-mapping  
as alluded to by Chris Anderson yesterday. Not a feature of CDB  
(yet?), but a single remap would give us the ability to do all this  
kind of thing in one query. If the problems with expiries and  
consistency could be solved and remapping added to Couch then that  
would open the door to a whole new range of uses, this one included.

thanks,

Sho
--Apple-Mail-78--787453396
Content-Disposition: attachment;
	filename=smime.p7s
Content-Type: application/pkcs7-signature;
	name=smime.p7s
Content-Transfer-Encoding: base64

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGLzCCAugw
ggJRoAMCAQICEBSIX9MtV1ZEa0RApBcv2rAwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx
JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ
ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA3MTExODIzMTczNloXDTA4MTExNzIzMTcz
NlowSTEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEmMCQGCSqGSIb3DQEJARYXc2hv
LmZ1a2FtYWNoaUBnbWFpbC5jb20wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC4VztI
LAmaS1WLCldsyC8eTG9bLMGvYEwRoJXYnyqJZPXMhQHdzAbw3VTtiqZB8qaWs2QbU/UuioP0zL0N
NAdCVHOORhGq59/u7obOxZOkR94yRllz5ofwpbOfTpC2u0Q6sms9ViukqumPuix2XTs3coe2VPAX
lPFzyQlNOXRD0K7JLUxff3YfM1sIZTHEosNVQWIWtyw+3Hb6ZhpGLuaxqe8jYKSJ+RnE1cX0/lI8
btdT7PyNapyz8m/sGEeMf/a+O+aDRr/cv50GVQWD98CM3a1tvUob3v9iH7L/wFEGyR4V7NLuhbYr
6sqktCzICnjkrCblAIpZnWWBPbvzuJZtAgMBAAGjNDAyMCIGA1UdEQQbMBmBF3Noby5mdWthbWFj
aGlAZ21haWwuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEFBQADgYEATlDmSJ8egBeeoqwO
HCxUloxGqK+hbn7EVNv21XBa0p3l8qHMoVY4IG5Uo3PmmfbtICWw9akuo1kRbhalcwLJK0Cxb32W
Vs0hQMyBrlpHIJJHDfuQ5A1WHW7An20Qdp2CU8WV03TbjdrJw0K7DvwZo6FX65fMiqdDhswP0NTA
HfEwggM/MIICqKADAgECAgENMA0GCSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UE
CBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25z
dWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQD
ExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZy
ZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYD
VQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMj
VGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0A
MIGJAoGBAMSmPFVzVftOucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJj
WiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHF
KlSFD0gEf6e20TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNV
HR8EPDA6MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFp
bENBLmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJl
bDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2
H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V
2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VPMYIDEDCCAwwCAQEwdjBiMQsw
CQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UE
AxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBSIX9MtV1ZEa0RApBcv2rAw
CQYFKw4DAhoFAKCCAW8wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcN
MDgwODA2MTU1MTU1WjAjBgkqhkiG9w0BCQQxFgQU7Y7YplbAlfQAhP/Lbu9TN0yJEFIwgYUGCSsG
AQQBgjcQBDF4MHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQ
dHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhAU
iF/TLVdWRGtEQKQXL9qwMIGHBgsqhkiG9w0BCRACCzF4oHYwYjELMAkGA1UEBhMCWkExJTAjBgNV
BAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25h
bCBGcmVlbWFpbCBJc3N1aW5nIENBAhAUiF/TLVdWRGtEQKQXL9qwMA0GCSqGSIb3DQEBAQUABIIB
AFUgrYHT9PlsHuJ6Abn/8t9DxSAEryHrxUMfwIZp6/9+Dpc3dunFBkKlG3GfhESBjqs8iPRl2GE3
8ZmQJwiM2A/CiqiLl//mB0/YKUfuEZkOPNoKVavnUEdUp3oAtGZLRB3VQpZ4GQQP6bfEmV2kqSaT
JIPV13i6BiNv3vpfSuCENGI5JSEmxkUy8TJxviQ8Vzc/6DmVo9ifqzGSl/TB5IfLKJIsiXJsWrz5
5W7MEgKOCP8xOcy26GdWc0dPUDb5mLhAM+XhMkDvLU1N1/PPuW54soPaVqXEX1qFUb1Pzd1Nc9LO
gEfwNnr+8KKDFAZeb4ATvsYTU/Q3RUzxB/oSLEwAAAAAAAA=

--Apple-Mail-78--787453396--