ArcGIS Data Store or eGDB Oracle

Question

Hello Everyone

For an up and coming project, we have to decide to put editable data in ArcGIS Data Store or eGDB Oracle. I have read all the ESRI document including the white paper Data in ArcGIS: User Managed and ArcGIS Manage and was hoping from the community people could offer some advice based on their practical experiences.

The data is quite simple. One polygon feature class (FC1). Three Tables (T).

The idea is a user can add a polygon and give it a unique extent id. This extent id will be related 1:m with information added in the other tables: FC1 will have a relationship to T1...T1...with T2...T2...with T3.

So there is a primary - foreign key relationship between FC1 and T1. T1 and T2. T2 and T3.

I hope you get the picture.

I realise that perhaps its like asking how long is a piece of string but would it be ok to put the data in ArcGIS Data Store or in or eGDB Oracle?

The data will be edited with ArcGIS Pro or Web Map with a Edit Widget.

I always thought data with relationships would best be handled in eGDB.

Advice appreciated.

VinceAngelo · Answer

Yeah, that was huge missing piece of the puzzle.  If you've already got the database and the experience, then you can enforce data standards as you see fit (as long as you're a velociraptor, you can be as dinosaur-like as you want).

- V

JamesMorrison1 · Answer

Thanks Marcelo and Vince for the feedback on the limited information I provided.

We already have Oracle eGDB and I've been working with it since 2004. So creating a new Schema in Oracle and loading the data, setting privileges etc is a 15 minute job. However, I have to provide answers to the "young guns" who come into my office with their data and say just load it into ArcGIS Data Store and with ArcGIS Experience builder we can use the Edit Widget to edit the data over a Hosted Feature Service. etc

Sorry if I sound like a database dinosaur here.....

The data itself will have very little edits perhaps 3-5 new polygon features per day. Same in the related tables. My main concern is keeping the data relationships between FC1, T1, T2 and T3 and providing constraints and validations that fields can only contain certain values.

Again thanks for your feedback to data.

MMBR · Answer

Indeed, data size matters, and also important to determine if you want to take advantage of Geodatabase functionality, e.g., geodatabase domains, subtypes, featuredatasets, topology, relationship classes, etc. and also important to find out which data will be read only (edited less frequently) and which data will be read-write (edited frequently), also have an estimate of the number of edits per featureclass/table per miniute/hour/day. This will help decide if you should use ArcGIS Server Data Store, FileGeodatabase or an Enterprise Geodatabase (Oracle/SQL Server/PostgreSQL), caveat depending on the geodatabase functionality you need then some are available in FileGeodatabase but the majority of advanced geodatabase features are only available in an Enteprise Geodatabase ( Oracle / SQL Server / PostgreSQL ). I hope this helps with this discussion.