Network of foreign key constraints in Oracle Transportation Management

  If you’ve ever worked under the hood with OTM, you’ll know that there’s some pretty serious normalization.  As I recently explained, deleting a single order can involve traversing over a hundred tables.  So, what does this network of table relationships look like?  After some quick SQL and a few minutes in Gephi, we get the visualization below:

OTM foreign key constraint network.

  If you’re interested, download a PDF copy of this OTM foreign key network here.