Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] Performances: Relationnal DB or Object DB ?
[CDO] Performances: Relationnal DB or Object DB ? [message #874576] Mon, 21 May 2012 07:20 Go to next message
Christophe MOINE is currently offline Christophe MOINEFriend
Messages: 34
Registered: February 2012
Member
Hi there,

Some of you will notice that all of my post mostly deals with performance: indeed I consider that the advantage of CDO layer over EMF is performances (& multi-users).

My question is: did some person make the test of comparing CDO performance using RelationnalDB such as MySQL, and an ObjectDB such as MongoDB or DB4O: is there significant differences ? Since CDO is object, I guess the mapping to an Object DB is more direct, and thus has less "calculations" overhead. There is no reference to that on the Wiki: is it simply because there is almost no reference ?

Last questions that is a bit related: it there any way to migrate a repository mapped on a given DB, to a repository mapped on another kind of DB ?
I would have thought to create a second connection "/repo2" in the cdo-server.xml config, and to copy all resources from old repo to the new one ?


Thank you in advance,

Kind regards,

Christophe.
Re: [CDO] Performances: Relationnal DB or Object DB ? [message #874597 is a reply to message #874576] Mon, 21 May 2012 08:06 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6683
Registered: July 2009
Senior Member
Hi Christophe,

Stefan Winkler (cc'ed) has published his EclipseCon slides:
http://www.eclipsecon.org/2012/sessions/there-and-back-again-%E2%80%93-quick-flash

Stefan, would you like to link them from http://wiki.eclipse.org/CDO/Tweaking_Performance or an even more prominent page?

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper




Am 21.05.2012 09:20, schrieb Christophe MOINE:
> Hi there,
>
> Some of you will notice that all of my post mostly deals with performance: indeed I consider that the advantage of CDO
> layer over EMF is performances (& multi-users).
>
> My question is: did some person make the test of comparing CDO performance using RelationnalDB such as MySQL, and an
> ObjectDB such as MongoDB or DB4O: is there significant differences ? Since CDO is object, I guess the mapping to an
> Object DB is more direct, and thus has less "calculations" overhead. There is no reference to that on the Wiki: is it
> simply because there is almost no reference ?
>
> Last questions that is a bit related: it there any way to migrate a repository mapped on a given DB, to a repository
> mapped on another kind of DB ?
> I would have thought to create a second connection "/repo2" in the cdo-server.xml config, and to copy all resources
> from old repo to the new one ?
>
>
> Thank you in advance,
>
> Kind regards,
>
> Christophe.


Re: [CDO] Performances: Relationnal DB or Object DB ? [message #874599 is a reply to message #874576] Mon, 21 May 2012 08:11 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6683
Registered: July 2009
Senior Member
Am 21.05.2012 09:20, schrieb Christophe MOINE:
> [...] My question is: did some person make the test of comparing CDO performance using RelationnalDB such as MySQL,
> and an ObjectDB such as MongoDB or DB4O: is there significant differences ? Since CDO is object, I guess the mapping
> to an Object DB is more direct, and thus has less "calculations" overhead. There is no reference to that on the Wiki:
> is it simply because there is almost no reference ?
Please also compare http://download.eclipse.org/modeling/emf/cdo/drops/S20120508-1424/help/index.html (will be included
in Juno help center).

>
> Last questions that is a bit related: it there any way to migrate a repository mapped on a given DB, to a repository
> mapped on another kind of DB ?
> I would have thought to create a second connection "/repo2" in the cdo-server.xml config, and to copy all resources
> from old repo to the new one ?

Sounds as if you are looking for this:

330235: Add Backup/Restore Functionality
https://bugs.eclipse.org/bugs/show_bug.cgi?id=330235

See https://bugs.eclipse.org/bugs/show_bug.cgi?id=330235#c3 for a code example or use the respective OSGi console
commands interactively.

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper


Re: [CDO] Performances: Relationnal DB or Object DB ? [message #874841 is a reply to message #874599] Mon, 21 May 2012 16:31 Go to previous messageGo to next message
Christophe MOINE is currently offline Christophe MOINEFriend
Messages: 34
Registered: February 2012
Member
Thank you a lot Stepper as usual,

I am pretty surprised that MongoDB is not so efficient in the benchmarks, even if it seems to support natively object ids... It looks like the object approach has a performance impact soon or late Smile

Very interesting slides anyway, even if with sound it would be much better I guess Smile

Anyway, I must say I am getting more and more interested with CDO, and believe it really rocks, but all thoses facilities offered by EMF/CDO necessarily create a performance overhead... So it is probably not my last post on it Very Happy IMHO, this is the crucial point when dealing with industrial projects.

Cheers,

Christophe.

[Updated on: Mon, 21 May 2012 16:32]

Report message to a moderator

Re: [CDO] Performances: Relationnal DB or Object DB ? [message #874854 is a reply to message #874841] Mon, 21 May 2012 17:14 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6683
Registered: July 2009
Senior Member
Am 21.05.2012 18:31, schrieb Christophe MOINE:
> Thank you a lot Stepper as usual,
>
> I am pretty surprised that MongoDB is not so efficient in the benchmarks, even if it seems to support natively object
> ids... It looks like the object approach has a performance impact soon or late :)
I'm not sure what numbers you're referring to, but it's most probably a result of the way we're using MongoDB. Its lack
of transactionality caused our MongoDBStore to be the first delta-store, i.e. each commit is persisted in a single
MongoDB document and all reads have to query for a number of docs that are used to reconstruct objects of a specific time.

>
> Very interesting slides anyway, even if with sound it would be much better I guess :)
>
> Anyway, I must say I am getting more and more interested with CDO, and believe it really rocks, but all thoses
> facilities offered by EMF/CDO necessarily create a performance overhead... So it is probably not my last post on it :d
> IMHO, this is the point when dealing with industrial projects.
;-)

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper


Previous Topic:[CDO]
Next Topic:Can I make an Ecore metamodel that enables references to Java classes?
Goto Forum:
  


Current Time: Sat May 11 09:10:05 GMT 2024

Powered by FUDForum. Page generated in 0.04100 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top