Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: ApelManu on April 04, 2013, 03:01:38 am

Title: Recommended DBMS System
Post by: ApelManu on April 04, 2013, 03:01:38 am

Hi all,

what's the recommended DBMS System for EA?
- MS SQL Server
- MySQL
- Postgres
- Oracle

Hope someone has any experience about the DBMS systems. I would prefer MS SQL Server.

Thanks Manu

Title: Re: Recommended DBMS System
Post by: qwerty on April 04, 2013, 04:32:05 am

Take what your DBA recommends.

MySQL is working nicely, though I heard Postgres seems to be okay too. Only for Oracle I have heard a couple of complaints about performance.

q.

Title: Re: Recommended DBMS System
Post by: Sunshine on April 04, 2013, 07:08:06 am

I've used SQL with no problems. Heard MySQL works well from a colleague in another organisation. Had some issues with Oracle which is my organisation's preferred database. You'll need a good DBA to ensure everything works okay so take what they are skilled in unless its Oracle  :)

Title: Re: Recommended DBMS System
Post by: ApelManu on April 04, 2013, 05:20:20 pm

Thanks for the fast reply. Think im going to use MS SQL.

Title: Re: Recommended DBMS System
Post by: Geert Bellekens on April 04, 2013, 05:52:51 pm

We use MS SQL as well, and a former client of me used Oracle.
I guess it all boils down to the quality of the DBA, not of the DBMS ;D

Geert

Title: Re: Recommended DBMS System
Post by: SomersetGraham on April 04, 2013, 06:16:22 pm

+1 for MS SQL

Title: Re: Recommended DBMS System
Post by: Helmut Ortmann on April 04, 2013, 10:38:02 pm

Oracle has at least one nasty error.

Title: Re: Recommended DBMS System
Post by: alvarodal11 on April 21, 2013, 11:42:05 am

Could you please expand your comment on EA x Oracle issues ?

Title: Re: Recommended DBMS System
Post by: Helmut Ortmann on April 22, 2013, 01:33:18 am

When EA makes a query with more than 1,000 elements in an 'in' (in 1,2,3,4,...) clause Oracle fires an error (Oracle 10,11).

In our caste it's nasty because this happens within a Checkout operation of EA.

According to Oracle this is to prevent the system from unpredictable performance. They don't intend to change this feature.

By the way: Other DBMSs like SQL Server are a lot faster than Oracle in an environment with EA. Projects which wanted a DBMS checked performance of Oracle in detail and after a while they convinced the IT not to use Oracle (wasn't easy).


Best regards,

Helmut

Title: Re: Recommended DBMS System
Post by: Geert Bellekens on April 22, 2013, 04:38:59 pm

In general EA will fire lots and lots of small queries to the database when you are doing modelling.
It is interesting to setup some kind a logging/tracing to get an idea, it sometimes goes up to more then 10 queries a second.

Whatever DBMS deals best with this type of usage will be best for EA.

Geert

Title: Re: Recommended DBMS System
Post by: KP on April 22, 2013, 04:45:15 pm

Quote

When EA makes a query with more than 1,000 elements in an 'in' (in 1,2,3,4,...) clause Oracle fires an error (Oracle 10,11).

We split Oracle queries wherever necessary to avoid this 'in clause' limitation, but if you find one that we have missed, please report it and we will fix it up.

Title: Re: Recommended DBMS System
Post by: Ian Mitchell on April 22, 2013, 05:56:04 pm

Also, the EA Schemas for SQL Server and Oracle are slightly different. In general, the Oracle seems to be stricter (for no obvious reason - probably just a typo in the Sparx creation script), which causes problems for us poor Extension writers.
So I'm voting for SQLServer as well.