I have an oracle database namely xe which I have spatially enabled. using the Create Enterprise Geodatabase geoprocessing tool.
The application I am going to implement has an already created database/schema containing entitities which have gps data. For example it contains stations that I Have to project on the map.
I want my the application to use, through the arcSDE, this non spatial information, as well as spatial information, layers, geometries, etc.
I have also created an sde and one schema-user (owner of a geodatabase).
How will I integrate these two schemas? should I create my non spatial enterprise schema inside of the schema-user schema and connect them with a sort of foreign keys? Or use the CREATE DATABASE LINK, CREATE MATERIALIZED VIEW, and CREATE VIEW privildges provided to the schema-user?
I am trying to understand the mentality behind the use of a geodatabase in accordance with a non spatial database.