Paul,
I think if you are running a cluster then the sys admin will have
already considered this and perhaps implemented GFS so a filesystem is
available.
Looking at the version table
CREATE TABLE VERSIONS (
AID INTEGER NOT NULL,
VN INTEGER NOT NULL,
CONTENT BLOB,
AUTHOR VARCHAR (500),
UPDATED_TIME TIMESTAMP,
UNIQUE (AID,VN),
FOREIGN KEY (AID) REFERENCES ARTIFACTS (AID));
even if the DB implements diff I am not sure how this schemas takes
advantage of this.
Not being deliberately argumentative here, but the whole geospatial
use case is based on imagery (large) and this just isn't stored in the
DB.
Norman
On Jan 4, 2008 10:00 AM, Paul Fremantle <[EMAIL PROTECTED]> wrote:
> Norman
>
> We discussed the use of a separate store for the content. However, many
> databases (DB2, Oracle) implement this already. Also, there is then a
> significant problem in deployment. For example, if you have a cluster,
> you now have to have a clustered file system as well as database.
>
> I like the idea of doing diffs as a pluggable idea.
>
> Paul
>
>
> Norman Barker wrote:
> > Hi,
> >
> > again correct me if I am wrong since I am new to the code, but looking
> > at the database schema I see that the complete content of the resource
> > is being stored in the artifact table, and in the version table.
> >
> > Really I would prefer the content to be stored outside of the DB (and
> > this what I am putting into the ORM version) as use case for data is
> > large (potentially gigabytes per resource). For the version table is
> > it on the road to support xdelta type diffs (as in Subversion). I see
> > there is a library called JRCS which was in Apache Commons and is now
> > LGPL.
> >
> > I mention this since it isn't just applicable to the ORM version, and
> > does impact the scalability of the registry.
> >
> > Norman
> >
> > _______________________________________________
> > Registry-dev mailing list
> > [email protected]
> > http://wso2.org/cgi-bin/mailman/listinfo/registry-dev
> >
>
> --
> Paul Fremantle
> Co-Founder and VP of Technical Sales, WSO2
> OASIS WS-RX TC Co-chair
>
> Office: +1 646 290 8050
> Cell: +44 798 447 4618
>
> blog: http://pzf.fremantle.org
> [EMAIL PROTECTED]
>
> "Oxygenating the Web Service Platform", www.wso2.com
>
> _______________________________________________
> Registry-dev mailing list
> [email protected]
> http://wso2.org/cgi-bin/mailman/listinfo/registry-dev
>
_______________________________________________
Registry-dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/registry-dev
