Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@jackrabbit.apache.org
Received-SPF: pass (herse.apache.org: domain of stefan.kurla@gmail.com
 designates 64.233.166.181 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=GYD2vzQU1TMdQdRWKGX/qEMg7mPPqI1hy3VrZdyEorwmf+TQlLz9r2Ggh+FBgupZloYHUpf+FN1NBdpmFTy/Baj+PCrLtjywXjLYL4mXjRVEZsEAthn4kwHE31l8c5WD6/3MRoAWYQJ5UatG+tHctwQWdu6gX7TuPZHGWMjsYAE=
Message-ID: <86d42bef0704270800v6e971594s5f5d5887aab46511@mail.gmail.com>
Date: Fri, 27 Apr 2007 10:00:05 -0500
From: "Stefan Kurla" <stefan.kurla@gmail.com>
To: dev@jackrabbit.apache.org
Subject: Fwd: understanding jackrabbit datastorage
In-Reply-To: <86d42bef0704261229g33be5acev89604d0e3825bda6@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <86d42bef0704261229g33be5acev89604d0e3825bda6@mail.gmail.com>

I guess this is more suited for the dev list. Also, I could figure
this out by tracing the code, but I would appreciate if someone who
has already worked on this could explain. Would help in understanding
the system a little bit better and save a little bit time.

How is the data actually stored in jackrabbit say using mysql for
example and we are just using the default workspace.

Say the structure is
/
--folderA:nt:folder (propertyX:references fileB)
----fileA:nt:file
--fileB:nt:file

There is the default_binval which has binval_id and binval_data.
### Is this table used to store binary data, where binval_id is the
uuid of the jcr:content that this is referring to and binval_data is
the actual bytestream blob data

There is default_node which has node_id and node_data.
###How is this used?

default_prop with prop_id and prop_data
###How is this used?

default_refs with node_id and refs_data
###How is this used?

My question then is how would the database store the uuids or nodes of
the structure that is defined above. Very simple structure but to
understand how this structure is actually translated to be stored in
the database would be helpful.

Thanks.