jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Johan Stuyts" <j.stu...@hippo.nl>
Subject RE: Value records
Date Wed, 25 Apr 2007 07:49:39 GMT
> A value record would essentially be an array of bytes as defined in
> Value.getStream(). In other words the integer value 123 and the string
> value "123" would both be stored in the same value record. More
> ...

Storing all values as a binary field will prevent access to the content
using standard database tools. You won't be able to look at the values
in the database without starting Jackrabbit.

If the data ever needs to be transformed (migration between application
releases, consistency fixes, etc.) the SQL that has to be written will
be complex. In addition to having to work with vertically stored data,
you now also have to know how to convert a value to its binary
representation. E.g. you cannot work with native SQL dates but have to
work with hexadecimal strings.

Johan Stuyts

View raw message