ThatJeffSmith

SQL Developer Data Modeler Navigator Can Get You There I Bet!

Just so you don’t think I’m crazy, you should know that I’m a father to a wonderful two year old daughter. She’s awesome, except when she wants to act her age. When we get desperate, we turn on her favorite show. I have seen about 200 different episodes of Dora the Explorer. My Spanish is getting better, but I’ve got these really bad songs stuck in my head. I’m going to share one of these with you right now.

If there’s a place you got to go
I’m the one you need to know
I’m the Map
I’m the Map
I’m the Map
If there’s a place you got to get
I can get you there I bet
I’m the Map!

Wouldn’t it be awesome if life were like this? Whenever you needed something, there was this magical talking map that told you exactly how to get what you wanted. Unfortunately life can’t be that simple, but sometimes our software can be.

Yes, I’m using Dora as a segue for a SQL Developer Tip and Trick post. Blogging is much cheaper than therapy, and the drugs are better!

SQL Developer Data Modeler Navigator Can Get You There I Bet!

Data models can be quite large. It’s a real challenge to take a workspace and evenly distribute the table and view objects in the diagram in such a way that it’s easy to read. Especially when everyone’s monitor and resolution setups are different. You can just about bet the default presentation of your model is going to be problematic. That’s why we have many different tools for helping re-arranging objects automatically, zooming in and out, and of course the ‘Go To Diagram’ function you can call directly from the object explorer.

But, sometimes in life, what you REALLY need is a map!

Let’s take a quick look at a big model:

Ok, so where are my darn tables and views already?!?

Tucked neatly in the upper-right-hand corner of the modeler is a panel labeled ‘Navigator.’ This will show us the way!

The Navigator is our Map

If you click on the panel and then on the ‘Restore’ button, you’ll get something like this –

The Navigator makes it easy to navigate your models

As you click around the navigator, the ‘red box outliner thingie’ (can you tell that I am college educated?) will auto-zoom/navigate the area in the main model space.

You might be wondering why I have dedicated 500+/- words to such a simple topic, and I’ll be honest with you – I did not notice this feature until just recently. The navigator by default is minimized in the application and it’s very easy to miss. Plus we are often very reticent to ask for help and directions – even when the map is right there for us to consult. I hope this helps save you at least a few seconds while you work with your data models.