>30 million objects in a single file without some well-done access method are indeed a problem. 30 million objects in a RDBMS are probably just a common case at the high-end.
>Just my 2cc, because I think it is a very important basic question how to store objects for a big multi-tier application, such as Arianne. I personally think RDBMS are still the best solution. XML is a hype, and I do not see how, in this case, it would be efficient in any way.
Right! I am used of this kind of situation in the management of the
technical documents in production of complex systems.
I imagine a adapted solution for our case.
The base can contains a main table "sorted out in a intelligent way"
with all the objects (man, leg of lamb, knife, mountain...) and a very
few info as: kind of object, coordinates, cross-section or box-envelope,
full pathname (may be urn) of the doc (by exemple a xml doc).
We can use two methods to point towards the objects which one possesses:
either a double linking inside the main table, or a single linking on a
secondary table of extension.
The first method presents advantage of unicity of objects. But a lot of
objects have the same description (xml doc)
Serge Jadot, http://hodo.free.fr