Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 58777 invoked from network); 26 Apr 2007 19:29:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 26 Apr 2007 19:29:55 -0000 Received: (qmail 26554 invoked by uid 500); 26 Apr 2007 19:30:01 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 26535 invoked by uid 500); 26 Apr 2007 19:30:01 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 26526 invoked by uid 99); 26 Apr 2007 19:30:01 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Apr 2007 12:30:01 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of stefan.kurla@gmail.com designates 64.233.166.181 as permitted sender) Received: from [64.233.166.181] (HELO py-out-1112.google.com) (64.233.166.181) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Apr 2007 12:29:51 -0700 Received: by py-out-1112.google.com with SMTP id h31so986286pyc for ; Thu, 26 Apr 2007 12:29:30 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=P1W4XQnoqk49wGdyWafdGBZJcTnd3EO8zKTob7x8L9O/3quT0SzU7VHyyoqSv2cArZMCcMco9nS5M28JPeKGqDTIaGO3/WBcMS9CbK7N2Aaeus9TVpIgHk12aeoy+gHaMiuNHIooy+UGHgQ1YGxNI9ZU65Qc0rBzH0QGJdUC+uU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=iuqN6xtJoDyQ+uCRPVn1N0LOt4QzSDpyXxQDmBOC698raJpVQDsRxaLXuM6RhWXGAwegS2m2CiMBXa453HMoqqhImwIKR7GqIrz+e+5COW+KlF3iB5yInUdy9RoEqln+EWs3U+o/9yazeQfFzSrWB0YOORq7diJsXZgVkuRYkWo= Received: by 10.65.121.9 with SMTP id y9mr4738156qbm.1177615770714; Thu, 26 Apr 2007 12:29:30 -0700 (PDT) Received: by 10.65.75.18 with HTTP; Thu, 26 Apr 2007 12:29:30 -0700 (PDT) Message-ID: <86d42bef0704261229g33be5acev89604d0e3825bda6@mail.gmail.com> Date: Thu, 26 Apr 2007 14:29:30 -0500 From: "Stefan Kurla" To: users@jackrabbit.apache.org Subject: understanding jackrabbit datastorage MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Checked: Checked by ClamAV on apache.org I realize that these are beginner level questions. 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.