[Registry-dev] binary xdiff

[Paul Fremantle]

Norman

I only meant that the DB would store the BLOB in a separate file, not 
that it would automatically do diffs.

I agree that we need to implement the diffs.

Paul

Norman Barker wrote:
> 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 <paul at wso2.com> 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
>>> Registry-dev at wso2.org
>>> 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
>> paul at wso2.com
>>
>> "Oxygenating the Web Service Platform", www.wso2.com
>>
>> _______________________________________________
>> Registry-dev mailing list
>> Registry-dev at wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/registry-dev
>>
> 
> _______________________________________________
> Registry-dev mailing list
> Registry-dev at wso2.org
> 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
paul at wso2.com

"Oxygenating the Web Service Platform", www.wso2.com