We have an existing system with a non spatial database in Oracle and we want to add spatial capabilities to this system.
Should we keep separated spatial and non spatial databases?
Is there a way to add ArcSDE to an existing non-spatial database?
What are the common architecture in these cases?
Thank you!!!
Solved! Go to Solution.
You can add the Enterprise Geodatabase (EGDB) portion to your existing Oracle DB. All the contents will be held in a different schema within Oracle. You can also create a separate new Oracle DB for the EGDB, it really depends on the what the DBA's prefer and space available.
Here is some documentation to get you started with Oracle and the EGDB: Geodatabases in Oracle—Help | ArcGIS Desktop
https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=6d7c6ee8-b99b-4c0a-a91d-3... https://community.esri.com/groups/enterprise-architect?sr=search&searchId=727b25f2-2af5-45f3-a00c-8d...
You can add the Enterprise Geodatabase (EGDB) portion to your existing Oracle DB. All the contents will be held in a different schema within Oracle. You can also create a separate new Oracle DB for the EGDB, it really depends on the what the DBA's prefer and space available.
Here is some documentation to get you started with Oracle and the EGDB: Geodatabases in Oracle—Help | ArcGIS Desktop
https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=6d7c6ee8-b99b-4c0a-a91d-3... https://community.esri.com/groups/enterprise-architect?sr=search&searchId=727b25f2-2af5-45f3-a00c-8d...
Thank you George, this is very helpful!
You can also just add the ST_GEOMETRY data type to enable the database with spatial capabilities. You would need to manage the spatial data with ST_GEOMETRY functions, and this would be simple geometry storage...no topology, networks, domains, etc. The advanced GDB functionality requires full Enterprise GDB, simple spatial functionality can be accomplished with adding ST_GEOMETRY. This could also be stored in a separate SDE schema and managed separately from business data.
Add the ST_Geometry type to an Oracle database—Help | ArcGIS Desktop
Adam Z
Wow! thank you Adam, I didn't know that. This is probably a great solution for some of hour tables.
Or even use Oracle's native spatial data type(s): Spatial Data Types and Metadata .
When you state "add spatial capabilities to this system," it is a seemingly simple question that has more answers than you can imagine. If this is you or your organization's first foray into working with spatial data, I recommend working with an enterprise architect and business analyst to understand and document your requirements in a way that an IT shop or service provider can implement successfully.
Thank you Joshua, I agree with you. We were trying to know what are the possibilities to create the documentation. Thank you for you help.