Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » Most mature Store for CDO?(We are looking for the most mature CDO Store (Hibernate, DB)?)
Most mature Store for CDO? [message #947080] Tue, 16 October 2012 15:59 Go to next message
Andrew Whelan is currently offline Andrew Whelan
Messages: 69
Registered: October 2012
Location: Syracuse NY
Member
Hello All.

My company and I are working on a fairly large EMF based project. We are currently researching data store solutions and are interested in checking out CDO.

In your honest opinion, which of the CDO Store technologies are the most mature?

Looking at the matrix on http://download.eclipse.org/modeling/emf/cdo/drops/I20120929-0501/help/index.html
it appears that the DB Store is the most feature rich. But I seem to see lots of documentation for Teneo-Hibernate.

So we are a little puzzled and decided to see what suggestions we can get from you folks on the Forums.

Although Oracle relational database support is very desirable it is not essential so we are interested in both Oracle/Non Oracle opinions.

Any advice would be greatly appreciated.
-Andrew
Re: Most mature Store for CDO? [message #947449 is a reply to message #947080] Wed, 17 October 2012 01:02 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5486
Registered: July 2009
Senior Member
Am 17.10.2012 00:35, schrieb Andrew Whelan:
> Hello All.
>
> My company and I are working on a fairly large EMF based project. We are currently researching data store solutions
> and are interested in checking out CDO.
>
> In your honest opinion, which of the CDO Store technologies are the most mature?
> Looking at the matrix on http://download.eclipse.org/modeling/emf/cdo/drops/I20120929-0501/help/index.html
> it appears that the DB Store is the most feature rich. But I seem to see lots of documentation for Teneo-Hibernate.
> So we are a little puzzled and decided to see what suggestions we can get from you folks on the Forums.
> Although Oracle relational database support is very desirable it is not essential so we are interested in both
> Oracle/Non Oracle opinions.
>
> Any advice would be greatly appreciated.
I know that Martin Taal puts a lot of effort in the HibernateStore. The Hibernate test suite does not run as part of our
automated builds but I think Martin ensures somehow that the specified functionality (a "little" less than CDO's overall
functionality) is tested locally in our test bed. You can also run these test suites if you want.

The DBStore is the most feature rich store and it's probably the most widely used store, too. Our automated build
executes more than 13.000 test cases for the DBStore, spread over 10 different configuration scenarios:
https://hudson.eclipse.org/hudson/job/emf-cdo-integration/2415/testReport

And there's support for some other backend types, such as DB4O, MongoDB or Objectivity/DB. My personal impression is
that some work has to be done to make those production ready (I've only implemented the MongoDB store myself).

I've recently developed a RandomAccessFile based journaling store, named LissomeStore. It still uses an RDB for a small
and fixed number of indexes into the random access file(s). For commits it uses a journal file and adjusts the index
tables asynchronously. The performance of large commits can typically be increased by 600% compared to the best DBStore
configurations.

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: Most mature Store for CDO? [message #947557 is a reply to message #947449] Wed, 17 October 2012 03:31 Go to previous messageGo to next message
Martin Taal is currently offline Martin Taal
Messages: 5326
Registered: July 2009
Senior Member
Hi Andrew,
The hibernate store is being used and maintained actively. But for sure the dbstore has much much more active users and
has many more features related to branching/revisions etc.
http://download.eclipse.org/modeling/emf/cdo/drops/I20120929-0501/help/org.eclipse.emf.cdo.doc/html/reference/StoreFeatures.html

Also the testcoverage for the dbstore is much better. For the hibernatestore there are about 900 testcases which are
being run.

The dbstore features are visible in the database schema. Which you might or might not like (see also the post
'Understanding CDO' from Christophe Bouhier). If you like hql and hibernate and have a straightforward business app to
develop (with grids and forms) then it can make sense to use the hibernate store (but the dbstore is also a valid choice
:-), if you need the advanced things like branching and revisions then for sure you should stick to the dbstore.

gr. Martin

On 10/17/2012 07:02 AM, Eike Stepper wrote:
> Am 17.10.2012 00:35, schrieb Andrew Whelan:
>> Hello All.
>>
>> My company and I are working on a fairly large EMF based project. We are currently researching data store solutions
>> and are interested in checking out CDO.
>>
>> In your honest opinion, which of the CDO Store technologies are the most mature?
>> Looking at the matrix on http://download.eclipse.org/modeling/emf/cdo/drops/I20120929-0501/help/index.html
>> it appears that the DB Store is the most feature rich. But I seem to see lots of documentation for Teneo-Hibernate.
>> So we are a little puzzled and decided to see what suggestions we can get from you folks on the Forums.
>> Although Oracle relational database support is very desirable it is not essential so we are interested in both
>> Oracle/Non Oracle opinions.
>>
>> Any advice would be greatly appreciated.
> I know that Martin Taal puts a lot of effort in the HibernateStore. The Hibernate test suite does not run as part of our
> automated builds but I think Martin ensures somehow that the specified functionality (a "little" less than CDO's overall
> functionality) is tested locally in our test bed. You can also run these test suites if you want.
>
> The DBStore is the most feature rich store and it's probably the most widely used store, too. Our automated build
> executes more than 13.000 test cases for the DBStore, spread over 10 different configuration scenarios:
> https://hudson.eclipse.org/hudson/job/emf-cdo-integration/2415/testReport
>
> And there's support for some other backend types, such as DB4O, MongoDB or Objectivity/DB. My personal impression is
> that some work has to be done to make those production ready (I've only implemented the MongoDB store myself).
>
> I've recently developed a RandomAccessFile based journaling store, named LissomeStore. It still uses an RDB for a small
> and fixed number of indexes into the random access file(s). For commits it uses a journal file and adjusts the index
> tables asynchronously. The performance of large commits can typically be increased by 600% compared to the best DBStore
> configurations.
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@xxxxxxxx - mtaal@xxxxxxxx
Web: www.springsite.com - www.elver.org
Re: Most mature Store for CDO? [message #948905 is a reply to message #947449] Thu, 18 October 2012 09:57 Go to previous messageGo to next message
Andrew Whelan is currently offline Andrew Whelan
Messages: 69
Registered: October 2012
Location: Syracuse NY
Member
Thanks Eike!
Can you give me some warm/fuzzies on which has been tested better with Oracle or which you think will lend itself better to an Oracle back end (DB Store or Hibernate Store)? That information would help a lot.
Thanks again
-Andrew
Re: Most mature Store for CDO? [message #948938 is a reply to message #948905] Thu, 18 October 2012 10:29 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5486
Registered: July 2009
Senior Member
Am 18.10.2012 15:57, schrieb Andrew Whelan:
> Thanks Eike!
> Can you give me some warm/fuzzies on which has been tested better with Oracle or which you think will lend itself
> better to an Oracle back end (DB Store or Hibernate Store)? That information would help a lot.
Sorry, I can't. Hopefully Oracle users can help with this piece of information...

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: Most mature Store for CDO? [message #949704 is a reply to message #948905] Fri, 19 October 2012 03:58 Go to previous message
Erdal Karaca is currently offline Erdal Karaca
Messages: 729
Registered: July 2009
Senior Member
As always that depends on what you need.
Hibernate has the fascinating query language (hql) that does the transformation into db specific sql and you can influence the generated target schema (table structures, etc.) in many ways (hibernate mapping model). But, of course, that is another (thick) layer between CDO and your back end.

If you know that you will just use the Oracle db, then, try the DB Store. If you are going to use db specific queries and if you need to switch between different RDBMs, then you would have to sync those queries for all dbs used...

Andrew Whelan wrote on Thu, 18 October 2012 09:57
Thanks Eike!
Can you give me some warm/fuzzies on which has been tested better with Oracle or which you think will lend itself better to an Oracle back end (DB Store or Hibernate Store)? That information would help a lot.
Thanks again
-Andrew

Previous Topic:DND with InputDialog
Next Topic:[Xcore] Bug? import ecore.EcorePackage; is generate is *PackageImpl
Goto Forum:
  


Current Time: Thu Jul 31 05:33:50 EDT 2014

Powered by FUDForum. Page generated in 0.02103 seconds