How to organize data in SDE (feature datasets or not)

TylerHomrich1 — Thu, 03 Nov 2011 18:03:53 GMT

Hi, my company is planning to migrate all of our data to ArcSDE 10 soon. We are trying to decide if we should organize our data in feature datasets or not. I have heard that in the past feature datasets slowed down performance and where only recommended if using topology or networks.

So should we plan on organizing our data in feature datasets or have all the data in the root of the SDE database and use a naming convention to help locate the data? Any information would be helpful.

Re: How to organize data in SDE (feature datasets or not)

anthonysanchez — Fri, 04 Nov 2011 12:39:44 GMT

Hi,
Feature data sets are not folders. Using them for organization will add administrative limitations, especially when it comes to permissions.

For data in a feature data set:
Read/Editing permissions are all or nothing. No granularity.
Register as versioned are all or nothing. No granularity.
If one feature class is opened in a fds, they are all "locked" from an administrative perspective.

Feature data sets should only be used for data that will participate in geometric networks,topologies, etc.

If you want to organize your data for users I'd suggest using layer files and folders.

Good luck!

Anthony

topic How to organize data in SDE (feature datasets or not) in Data Management Questions

How to organize data in SDE (feature datasets or not)

Re: How to organize data in SDE (feature datasets or not)