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.