Corporate Edition - Oracle Database Size

[trcarch]

Hi
We are evaluating the corporate edition of EA and had a question re: the typical sizing when storing all the UML models, data dictionary including complete comments, user-level changes etc. inside the database.
Do you have typical sizing - e.g. is it 500 MB, 4GB, 10 GB, 40GB ?
Also, can you send us some documents / scripts that are used for the database? We want to check them to see if this needs its own instance or if it can live in a schema inside an existing instance. And what are the user-level security rights that need to be assigned inside the database? Does it use a common user-id? I am unable to access the documents since it seems you need to register and to register, you have to buy it first!
Thanks.

[mikewhit]

Well going from the EAExample.eap file - this is ~2.3 MB, my copy of our existing project is less than 5 MB, so it's likely that even a very big model would come in at less than 100MB, unless there was much image data etc.

I don't imagine that the external DB version is much different from the (Access-based) EAP file version.

[trcarch]

This is good!.
We are considering migrating from Rose - all our models are around 30 - 40MB and we are going to have around 60 users. The only difference is our current data dictionary models are all generated after reverse engineering using XML/XSL and then the models are laid out on the screen using Visio and generated as PDFs for printing. The VISIO models are all very large and the PDFs are huge as well.
After switching to EA, are these models and PDFs also stored in the database as blobs?
My initial estimate is going to be 4GB - the reason this is becoming an issue is because we use Solaris and disk space on Solaris comes with a premium! If it is 10GB or more, then we need to get this allocated and purchased etc.! Any typical usage scenarios from existing corporate customers who use Oracle would be great.
Thanks

[mikewhit]

With as many 60 users you should check the forums for any issues with DB locking, performance etc. and then see that they have been resolved satisfactorily.

Also, establish the best model locking procedures to avoid update clashes - I guess 'require user lock to edit' will be the one.

PDFs are huge ? Are you using the best creation/conversion tool, they differ in their efficiency !

[trcarch]

Managed to get hold of the schema SQL and it looks like all the tables can be created under one schema.
Questions:
1. Does each user need their own login into Oracle or does EA use a common login?
2. How are the schema tables accessed by a different user (public synonyms?)
Thanks.

[Bruno.Cossi]

There is no correlation between the EA application user and the database user. When a user sets up the database connection, they have to enter a username and a password (unless you use an integrated one), it is up to you whether you provide all of them with their own, or whether you will have them sharing the same db username.

Managed to get hold of the schema SQL and it looks like all the tables can be created under one schema.
Questions:
1. Does each user need their own login into Oracle or does EA use a common login?
2. How are the schema tables accessed by a different user (public synonyms?)
Thanks.

[trcarch]

Follow-on question then: if every user sets up their database connection using their own username and password, how will they be able to access the database tables created under a different schema? Do we not have to create public synonyms for each EA table then?

If all users use the same db username, then won't auditing show only the db username?
(i.e. are the EA users and their passwords maintained in a separate EA table)?

[Bruno.Cossi]

Hi,

if each EA user will use different DB username, you will have to ensure that they can access the tables. Public synonyms work, private synonyms work, too.
As far as audit goes, there is really no audit within EA. You can obviously implement your own (that is pretty much what we did).
EA usernames have nothing to do with the DB usernames - EA manages its own security, you can have a look at the table t_user (I think that is the name, I don't have it in front of me right now).

Bruno

Follow-on question then: if every user sets up their database connection using their own username and password, how will they be able to access the database tables created under a different schema? Do we not have to create public synonyms for each EA table then?

If all users use the same db username, then won't auditing show only the db username?
(i.e. are the EA users and their passwords maintained in a separate EA table)?

[analia]

Hello everyone!

We are performing some tests in order to move our  EAP file based project to an Oracle 10g repository. We want to have different Oracle users having access to a common schema, so we created a schema named ea_proto where we transfered the data our EAP file and a schema named ea_proto_user that has grants and synonyms pointing to ea_proto’s tables. If  ea_proto_user logs in and tries to create a new EA package , the following error message appears: ORA-00942: table or view does not exist.
We traced the database connection and found out that the database dictionary tables are queried with the condition table_schema = 'EA_PROTO_USER' instead of table_schema = 'EA_PROTO'

SELECT *
FROM (SELECT NULL table_catalog, idx.table_owner table_schema,
idx.table_name table_name, NULL index_catalog,
idx.owner index_schema, idx.index_name index_name,
NULL primary_key,
DECODE (idx.uniqueness, 'UNIQUE', -1, 0) unique_,
NULL clustered, NULL TYPE, NULL fill_factor,
idx.initial_extent initial_size, NULL NULLS,
NULL sort_bookmarks, -1 auto_update, 2 null_collation,
col.column_position ordinal_position,
col.column_name column_name, NULL column_guid,
NULL column_propid, 1 collation, NULL cardinality,
NULL pages, NULL filter_condition, NULL integrated
FROM all_indexes idx, all_ind_columns col
WHERE idx.owner = col.index_owner
AND idx.index_name = col.index_name
AND idx.table_owner = col.table_owner
AND idx.table_name = col.table_name) dbschema_indexes
WHERE table_schema = 'EA_PROTO_USER' AND table_name = 'T_OBJECTPROBLEMS'
ORDER BY 8, 10, 5, 6, 17

Does anyone know how we can solve this problem?

Thank you very much.