SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Red Gate Dependency Tracker - Making Databases Into Moving Art

data structures are art

Red Gate Dependency Tracker - Making Databases Into Moving Art

If anyone thinks that working with complex data structures is boring... I don't know what world they live in. The problem is often that sql tables and data structures are just script files and lists of tables in an object explorer.

However, once you crack open the visual aspect of database diagramming and data architecture, you can see some interesting patterns emerge.

red gate dependency viewer tracker

I've long enjoyed playing around with Red Gate Dependency Tracker. I've found it a great tool for interacting with dependencies and visually working through their relationships.

I figured I'd share with others a more artistic side of database architecture, as I've never seen it done, and I found it uniquely beautiful.

visual review of data structures

This is the architecture of the application I work on everyday. I inherited care of a system that shows the attention and design that was put into it. The order of the key relationships is obvious. I've worked on some systems that this diagram would be completely different story without the order and structure.

The interesting part about the visual dependency view is you can often see orphaned objects that aren't correctly linked to their parent objects, so it can serve as a useful tool to help improve existing designs. My previous article about tools I've use for this is here...Documenting Your Database with Diagrams

Enjoy!

Red Gate Dependency Tracker - Making Databases Into Moving Art

Red Gate Dependency Tracker - Making Databases Into Moving Art

Red Gate Dependency Tracker - Making Databases Into Moving Art

Red Gate Dependency Tracker - Making Databases Into Moving Art

SQL Barbarian

After working in the mortgage industry for 7 years, I transitioned into Business Intelligence and began learning SQL and .NET. My goal is to integrate my business knowledge into my development to intelligently analyze and find solutions to problems. Blogging offers me an option to share what I've learned as well as receive feedback on better practices and solutions.

Comments

Leave a comment on the original post [feedproxy.google.com, opens in a new window]

Loading comments...