Hello, folks. My name is Robert Pound and I'm a product technologist from Quest. In this video, I'd like to talk to you about the database diagrammer in Toad Data Point. Understanding and combining data are two of the major endeavors at the front end of any data analysis task.
Toad Data Point addresses these issues in a number of ways. However, the focus of this video will be on how the database diagrammer assists in understanding of your data and your database. Highlights of the database diagrammer include the ability to interact with your objects through a visual interface, which allows you to understand your relationships in the database easily, and the power to analyze and visualize the joins in that database.
Now let's walk through a more detailed example. So first off, to open a database diagrammer you have several options. From the Start page, from the right click menu on an object, or from the ribbon bar. I'm going to go ahead and open the ribbon bar. And when a new diagrammer tab is opened, the instructions on how to interact with it are actually on the page itself. So as you can see, you can drag and drop objects onto the pane. You can create relationships if they are not already there. And you can add notes as you see fit.
So the first thing I'm going to do is just drag and drop an item to the canvas. And as you can see, it has already drawn out the primary foreign key relationship. So here the referenced objects point to primary keys in both, in this case, the inventory table and the staff table.
You can also, as I mentioned, create references. So for instance, if we wanted to go from the last update on this table to the last update on this table, if we wanted to create that reference we could simply click and hold on last update and drag it over to last update on this table, and it will create a reference in the diagrammer itself. I'm going to go ahead and remove this. And it will ask me whether I want to remove it from the cache as well, and I do.
So from here we can also analyze the current joins as we talked about in the highlights. So if I want to see this join, I can simply click when the eyeglass appears and it will give me a Venn diagram of the join itself letting me know, in this case, there are no values that are only in staff or only in rental. But this just gives you a breakdown of the join itself.
So looking at the toolbars on top, so you have tools to organize your diagram. So if you had a large number of tables, you could come up here and click this icon, and it will auto arrange. Let me go ahead and move this out of the way.
And you can also resize your tables so that way you don't have to scroll through the tables if that's desirable. And you also have the ability to change the zoom. So you can zoom in and out. If you have Toad Intelligence Central server, you can publish this file up to Toad Intelligence Central server.
And then the depth. So currently at a depth of 1, it's showing everything that's connected to the rental table at one level of depth. Meaning if there was another table referenced to the staff table, it will not show up here now.
But if I change the depth level to 2 and then click on the canvas, it's going to update the diagrammer and it will show, in this case, one more table. And if you only want to see the table that you brought into the diagrammer originally, you can bring the depth level down to zero and you will only see the rental table at this point. Let me move it back up to 1.
So other things on the toolbar. So if you wanted to look at the details of a specific table, you could highlight it and then click this icon and it'll bring up the details view to get a better look at the table itself. And then you can bring in all views and tables from this connection or the current database with this icon.
The bottom toolbar has the same publish file to Toad Intelligence Central server. It also allows you to look at tutorials open, previously saved diagrams, add this diagram to the project manager for those familiar with the project manager, and you also have the ability to send this to the Query Builder. So the advantage of that is you can pull in a single table and see what it is all related to and then send this directly to the Query Builder, and you can start creating your query with a few simple clicks. And the relationships have already been established.
But moving back to the diagrammer, in the right click menu you can also send it to the Query Builder. If you right click on the tables, you have many of the same abilities as you would right clicking in the Object Explorer for a given table. But you can also add details to the tables themselves. So you can show things like Data Types, Nullable and Comments, and Show All.
And you also have the ability to hide columns. So I can show all or I can hide certain columns in this table. So if there was a large number of columns for a given table, you could hide a few of them just so you could better visualize the relationships.
And that pretty much wraps up the database diagrammer. Hopefully, this helped you understand a little bit more about how you can use database diagrammer to understand your data in Toad Data Point. To get more information on this or other topics, you