Quoting Paul Merlin <[email protected]>:

Le 22 juil. 2010 à 06:26, Rickard Öberg <[email protected]> a écrit :

Hi!

On 2010-07-21 21.22, Paul Merlin wrote:
Stanislav and I have been working on a SQL based EntityStore lately. The
SQLEntityStore is working on Apache Derby and PostgreSQL for now.

What approach have you taken: split up entity props/assocs/manyassocs into columns, or dump blob into key-blob table?

The EntityStore use a single table with three columns: entity_pk, entity_identity and entity_state.


And the indexing generates a single table for each qualified-name. The structure of the table depends on what type it is - property (normal/collection/valuecomposite), asso, or multi-asso. Additionally it has a few fixed meta-information tables, and similar-kind of table as with ES. Currently we are working on synergy between SQL ES and SQL Indexing - mostly by making same entity appear with same entity_pk in both.



_______________________________________________
qi4j-dev mailing list
[email protected]
http://lists.ops4j.org/mailman/listinfo/qi4j-dev

Reply via email to