Hi Thanks for the reply.
The competition in my target market is fierce and our software price cannot be quite expensive. So it is better for us to choose a free open source database. I think it might be MySQL or PostgreSQL. I also notice there is Ozone OODB (http://www.ozone-db.org), which is open source. But I have not heard any serious business application of it. Another a project in sf.net, Prevayler* *(http://www.prevayler.org/)* *stores every object in the memory. It can run much faster than other DB. However I don't know how it deals with a system crush or power failure. That is why I choose OJB, which use RDBM, a proven technology. Best regards Cui Lu. [EMAIL PROTECTED] wrote: >Hello, > > > > > >>-----Original Message----- >> >> > > > >>From: Lu Cui [mailto:[EMAIL PROTECTED] >> >> > > > > > >>structure is terrifically complex with many levels of >> >> > > > >>inheritance and references. I might query the db using >> >> > > > >>some ODMG API like, a.b.c.d.e.f.g, which is seven >> >> > > > >>levels of references. The final results might contains >> >> > > > >Depending on the actual mapping to the relational > >database, the performance must be rather bad because > >of the many joins, I should say. > > > >I do not have experience with that level of complexity. > >Regarding your statement that your amount of data is fairly > >small (1 000 000 objects), I guess that OJB can do it. > > > >However, you might consider using an object-oriented > >database, which is optimized for complex class-hierarchies > >such as yours. > > > >Is it a customer's request to use a relational database and > >an O/R mapper? > > > >Olli > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
