How to Size an EA DB Repository

[Steven Tuften]

Anyone have any guidelines on how to size an EA RDBMS Repository?
I've searched the Sparxsystems site but to no avail.

Any help most appreciated.
Steve

[Geert Bellekens]

Steve,

Could you explain a bit more detailed what you are trying to achieve?
Do you want to know the size of the database, and if so, to which end?

Geert

[Steven Tuften]

Hi Geert,

We are planning to deploy a central RDBMS EA repository to store all our project and baseline architecture models in the one location.

BAs and Solution Architects would connect to this repository to maintain their models and would use Subversion to version control packages within their project.

I'd like to know if there are some rules of thumb for how one would determine the size of the RDBMS. I understand of course that this would depend on the nature of the models however it would be useful to know , relative to the size of a project model what corresponding space would be required in the RDBMS repository.

For example there may be indexing on the relational model that isn't necessarily in place on the access(jet) model in the EAP file that may mean a 20Mb EAP would end up taking more than 20Mb when deployed into SQLServer or Oracle repository.

If I know the relativities of EAP vs RDBMS I can then do the rest in terms of estimating the size of the RDBMS.

Many thanks
Steve

[Geert Bellekens]

Steve,

Our database size on SQL Server is 671 MB (with 123 MB free).
When we transfer the whole model to an eap the eap file is about 200 MB large.

So I guess RDBMS_size = eap_size * 3 should be a reasonable estimation.

Geert

[Steven Tuften]

Thankyou Geert.  
Much appreciated.
At least I have something to base my sizing on now.

Cheers
Steve

[Steven Tuften]

I posted this question to sparx and they advised that as well as the size of the model consideration should be given to the the inclusion of RTF document artifacts and images as these can more significantly impact the size of the repository than the model data.

Cheers
Steve

[Geert Bellekens]

Steve,

Did they also mention auditing? IIRC the data produced by the auditing option can also be a multitude of that of the model itself, depending on the auditing options choosen.

Geert

[Steven Tuften]

Good point. I'll ask in  my reply and post back to this topic.
Cheers
Steve