How to model data set for a bill of material ?

Hi again,

as already announced in my last post "process hang ..." I am having difficulties in modelling a Bill Of Material.

My approach was:

 struct object_header

 {

   uuid           uuid;

   uuid           parent_uuid; // relation

   wstring< OBJECT_HEADER_MAX_CLASSNAME_LEN > classname;

   version_info   version_info;

   boolean        is_versioned;

   timestamp      created_on;

   timestamp      last_modified_on;

   uuid           created_by_actor_uuid;

   uuid           last_modified_by_actor_uuid;

   timestamp      valid_from;

   timestamp      valid_until;

 };

struct item { ... many individual slots (around 60) };

const unsigned long MAX_NR_BOM_POS = 500000;

struct bom_pos {  ... items ...    };

struct bom_head { ... some header info ... };

struct bom { bom_head head; sequence< bom_pos, MAX_NR_BOM_POS > bom_positions; };

... Now, this does *NOT* work. Even having "relartions" in place (use uuid as a relation between bom and bom_pos does not work. Iinitialize_ex for the bom struct takes more than 15 minutes runtime to complete ... so - is DDS not suitable for transferring large, nested, hierarchical data structures ?

How would you do it? Thanks for sharing your ideas!

Regards

  Frank