Having Oracle dbms with ArcSDE and ArgGIS Pipeline Database Model (APDM), I would like to best describe the system with a diagram. In MS SQL each db is autonomous, I think, meaning ArcSDE(using dbo schema) has the SDE business tables in each db and further using a database model, each database has the database model implemented within??
For Oracle (oracle has a schemas instead of db's??), the Oracle instance that has the sde business tables and the database model..assigns users to participate in those tables as a sort of view (schema??) and sde manages those schemas??
My question: I would like to draw a picture showing how sde and the database model relate as well as how they sit in relation to the rdms on Oracle and on MS SQL Server. Thanks.
Best Answer
There are some tools that might help.
GDBtoolset
domain tools
And maybe search arcscripts for others.
There may also be an addin. Here's how to use those. And find goeprocessing addins here
Find Geodatabase addins Here
If you have Visio here is a good one called geodatabase diagrammer
The model deals with feature types, field names, types, definitions, and relationships. As well as any special cases (i.e. networks, topology, "linear referencing systems").
Which you would have with APDM.
The schema relate to these.
However when you say "system" and "autonomous". I begin to picture network and connectivity diagrams.
Model diagrams for PPDM are available on the PPDM website here.
And APDM Here.
OK that is clearer (from comment). Here is a technical link to all you need to know to draw it correctly...
esri resource center
This may be the type of graphic you are looking for.
Also here is a good section with some graphics for ideas