From user-return-5476-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Fri Jul 10 11:44:57 2009 Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 7541 invoked from network); 10 Jul 2009 11:44:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 10 Jul 2009 11:44:56 -0000 Received: (qmail 87615 invoked by uid 500); 10 Jul 2009 11:45:05 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 87549 invoked by uid 500); 10 Jul 2009 11:45:05 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 87539 invoked by uid 99); 10 Jul 2009 11:45:05 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Jul 2009 11:45:05 +0000 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=SPF_HELO_FAIL,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of morbus@disobey.com designates 65.23.129.70 as permitted sender) Received: from [65.23.129.70] (HELO rm-1006-10.serve.com) (65.23.129.70) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Jul 2009 11:44:55 +0000 Received: (qmail 3640 invoked from network); 10 Jul 2009 07:44:28 -0400 Received: from c-75-67-50-34.hsd1.nh.comcast.net (HELO Apoptosis.local) (75.67.50.34) by rm-1006-10.serve.com with SMTP; 10 Jul 2009 07:44:28 -0400 Message-ID: <4A5729A1.8070703@disobey.com> Date: Fri, 10 Jul 2009 07:44:33 -0400 From: Morbus Iff User-Agent: Thunderbird 2.0.0.22 (Macintosh/20090605) MIME-Version: 1.0 To: user@couchdb.apache.org Subject: Re: Defining my document model when the source is entity-relationship References: <4A5632F8.5040406@disobey.com> <5D169AD5-A698-483B-B51C-BA1C61FB1D4B@dionne-associates.com> In-Reply-To: <5D169AD5-A698-483B-B51C-BA1C61FB1D4B@dionne-associates.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org > I think it might be useful to go with your first instincts, that a > book is a document, and then see how to best organize the information > you have about the book in support of some application, rather than But, in the FRBR model, the "book" (FRBR's "Manifestation") is not the "final" or "complete" document (CouchDB's "document"). Were I to strictly map "the book is a document", the CouchDB document would be a "Work" comprising *hundreds* of different Expressions and Manifestations and Items, forever spidering out. Consider "The Hobbit" (a famous thought-experiment for FRBR) - it'd be one mightily huge, single, JSON document, comprising every edition of every book, every CD, every Rankin-Bass iteration on TV, VHS, and DVD, the forthcoming 2011 movie, the two video games made for it, etc., etc. The singular artistic endeavor that is "The Hobbit" is a lot more than a single book - it's a very complex stress test for any FRBR application. http://www.frbr.org/2006/08/19 It would fit into CouchDB's model to have a JSON document this large? It would grow ever larger if a user ever used the application too - every user who owned a copy (an Item) of a "The Hobbit" Manifestation (a book, a CD, a VHS, etc.) would add on an FRBR Item to the existing JSON document, which itself may have numerous fields and tags and etc. It would be easily safe to say that, for an FRBR mockup of "The Hobbit" in a single JSON document, the JSON document would have thousands of objects, and then an additional object for each user who ever owned it. Is that "OK", whilst still allowing for quick lookups against it, and allowing me to load a particular "The Hobbit" Manifestation (or the entire Work, as necessary), without loading, say, all the Item objects? Ignoring FRBR entirely, I suppose the question is: how large can a CouchDB JSON document get before it stops being useful? -- Morbus Iff ( i subscribe to the theory of intellectual osmosis ) Technical: http://www.oreillynet.com/pub/au/779 Enjoy: http://www.disobey.com/ and http://www.videounderbelly.com/ aim: akaMorbus / skype: morbusiff / icq: 2927491 / jabber.org: morbus