[redland-dev] Triple storage overhead

[Morten Frederiksen]

Hi,

On Tuesday 01 June 2004 10:03, Sébastien Pierre wrote:
> What do you precisely call "normalisation" ?
I was referring to the database theory concept, re functional dependencies 
etc. My major point is, that e.g. a URI is only stored once, with 8-byte 
identifiers identifying them.

You can see the current schema at 
http://www.wasab.dk/morten/2004/04/redland-mysql-schema.sql (even though 
that's not what's supported by the code in CVS yet).

> I may store between 10 000 and 100 000 triples, so your MySQL storage
> seems interesting. 
No problem with that, I'm holding 0.5M triples without problems, and have 
been experimenting with 6.7M.

> However, I would like to know if it is possible to
> migrate a storage from the BDB backend to your MySQL backend ? This
> would be interesting as I don't want to force people to install MwSQL to
> use my software.
Interesting indeed.

I actually have a tool/script for that on my list, but haven't gotten around 
to it yet. When I do, would Perl be allright for you?


Regards,
Morten