Geodatabase ArcSDE/Oracle : PK and FK

Posted on 2004-08-12
Last Modified: 2011-04-14
I'm coming from ERD diagrams world and planned there geodatabase. Then I was about to create Oracle tables via ArcCatalog
(I had some non-graphic classes that I wanted to append to to the feature classes).
I was very surprised when I saw no choice to determine PK and FK I had designed for my tables?
Do you know it is necessary to have normal tables created via ArcCatalog or I can do it via e.g. Erwin?
(the existing feature class has an attribute that is FK, i.e. PK of one of my normal table and this normal ables is then related to other etc.)
The applications are going to use Map(Arc?) Objects to work with the geodatabase. Will they be able to access my normal tables if I create them via Erwin? (I investigated a bit and saw that all registered tables are put in one SDE system table).
But when I define the relation, no FK were established between the tables ?! Is this normal for hte geodatabase?
Question by:matejak
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 11840255
My only experience is in Visio and you can import from a repository.  Have you tried exporting to a repository then importing this into Erwin?

Author Comment

ID: 11860615
What do you mean by "exporting to repository" ? I created via ArcCatalog some tables and features classes and could saw them in Oracle - yes I can do then import into Erwin as well - but there are no FK for the relationships class that I specifed.

Expert Comment

ID: 11869086
Sorry, I wasn't very clear.  I have never messed with ERD.  All of my experience is in Visio.  Here is an article showing how to get the data out of Visio with all the supported primary and foreign keys.  I am sure that Erwin probably has a way of doing the same thing.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 11990988
It seems I have problems to explain my problem :-(.
The thing I do not understand is how to create classical FK in  ArcCatalog or Visio.
I want to have them as some application will access RDBMS via PL/SQL and integrity of data need to be provided via FK
I do not know whether it is possible to create FK via ArcCatalog (directly or via Visio not important).
What will happen to geoDB if I create FK directly in Oracle and that FK links two tables registered via SDE?
LVL 12

Expert Comment

ID: 11993493
my mistake... ignore that comment. sorry for the intrusion. :(

Expert Comment

ID: 12020742
Here is some more information on Data Models for you.  I am actually in the process of creating one for my department now and found this stuff very useful.

Hope it helps.
LVL 12

Accepted Solution

geotiger earned 500 total points
ID: 12044191

SDE obeys database integrity rules and constraints in RDBMS. So whatever PK or FK you create through PL/SQL will be enforced by the database.  I worked with ESRI products a few years back and did not get chance to use ArcCatalog. I do use ERwin extensively.  You can reverse engineering your database to ERwin and create FK and PK in ERwin, then update the database with constraints only. Be careful if you already have data in your database. You may not be able to create all the PKs and FKs if the existing data does not conform to the new data integrity.


Author Comment

ID: 12058590
Thanks for a hint, I agree with you but on ESRI forum someone said that it is not recommended to add an additional FK in Oracle. I could not get nay more info why. Maybe performance. I still cannot understand why SDE does not create and classical RDBMS relationships - why to have then RDBMS?

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I feel like more and more people want to know how to programmatically convert addresses into geospatial locations. So in this article, I will show you how you can do it with Bing Maps. I'm going to use PowerShell, which is a nice scripting language,…
Introduction This article is designed to assist GIS (Geographic Information System) and GPS (Global Positioning System) developers using ESRI ArcGIS and other spatial information management systems.   For the uninitiated the concept of projectio…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question