Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (athena.apache.org: domain of rrc7cz@gmail.com designates
 74.125.46.28 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=OpI44TXSWcY3c2E04tA9j9xyC5DKgRxKNgEaOcsqHTQ11D/2h5ZSMbsi7swoUgKnWB
         uP8b5IGIO+vlvUBZ8Cb1oo/+uUi6Z8mEIN8aXhReIf9lS4ZyuWxo1Q/VxPDvlJtEexWT
         ztalj8tHZDo7crwyBE4aNRa43EPDcpuFp4UsU=
Message-ID: <b57c4e1c0811090737w5cec56bfi21b76b389a2b764a@mail.gmail.com>
Date: Sun, 9 Nov 2008 16:37:50 +0100
From: "Robert Campbell" <rrc7cz@gmail.com>
To: users@jackrabbit.apache.org
Subject: Re: Node relationships?
In-Reply-To: <4916E982.4030606@gmx.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <b57c4e1c0811090530y1486f63cx60f0cf90b1a1f770@mail.gmail.com>
	 <4916E982.4030606@gmx.de>

Thanks Julian; I've started reading JSR-283 and this Shareable Node is
exactly what I need. I looked at the Jackrabbit roadmap, and support
for JCR 2.0 is in the "medium term". Does anyone know what this means
(generally)? Are we talking months or years?

I'm in a bit of a tough spot because if I go forward with my
multivalue Category UUID plan, I think that it will be hard to convert
the CR to use Sharable Nodes in the future once there are thousands of
nodes in there. On the flip side, using the DB option isn't really any
better, and it's another entire system.


On Sun, Nov 9, 2008 at 2:45 PM, Julian Reschke <julian.reschke@gmx.de> wrote:
> Robert Campbell wrote:
>>
>> I'm almost done ready the JCR spec, but I don't see any mention of
>> this particular problem:
>>
>> A product node can be the child of multiple category nodes (for
>> example). In a RDBMS you can express relationships between entities
>> however you wish, in this case I would have a cross-reference table
>> with product_id and category_id, resulting in products being mapped to
>> as many categories as you want. The JCR, however, lays out a pretty
>> strict tree hierarchy preventing multiple parents.
>>
>> One thought is that I keep the RDBMS for relationship data, and just
>> have a column in the products table for UUID pointing to the JCR
>> (which would probably just be flat, each node having a UUID, and not
>> utilizing the tree structure). This means the DB would have
>> relationship data, and the JCR would have entity data.
>>
>> The other thought is scrap the DB and just have a multivalue Category
>> property on all Product nodes containing the UUID of the Category they
>> reside in. This feels a bit like a hack, however, and while removing
>> the need for the DB to store relationships, it still doesn't make use
>> of the tree structure.
>>
>> I can't be the first one to encounter this problem, but I can't find
>> any design patterns to address it.
>
> I think a multivalued category property should work just fine; but yes, it
> doesn't take advantage of hierarchical storage.
>
> If you *do* want to use that, the Shareable Nodes feature specified in
> JSR-283 may be the right thing for you; essentially it allows a single node
> to appear below multiple parent nodes (it's almost a one to one match to the
> WebDAV BIND specification).
>
> Best regards, Julian
>
>