Toad Data Modeler 3.0 Preview

Toad Data Modeler 3.0 Preview

This installment I thought I'd write about the exciting and soon to debut Toad Data Modeler 3.0 release rather than simply yet another boring academic or technical topic on data modeling. TDM 3.0 is quite exciting. While it has not yet been available for public beta – it will be very soon (so please email the product manager to get signed up). And once you’ve used it – I fully expect that like me, you'll never ever look back. Come along as I demonstrate just the top ten new features that make the upcoming TDM 3.0 release a “no brain'er” J

1.  Logical Modeling: Toad Data Modeler 3.0 add full support for logical data modeling! This is a major addition which facilitates both true business and technical modeling needs. Thus now one can model their true business requirements and then transform that data model into a perfectly matching technical implementation – without loosing any of the business context in the process!

2.  Robust Undo/Redo: This may seem like a minor feature, but it’s darn useful – especially after you press autolayout and don’t like the results. Now you can simply choose the Main Toolbar’s Edit menu or press the hot keys. Furthermore, you get to set how many levels of undo & redo to support via the options. This feature is lightning fast – and makes organizing large and complex data models much easier.

3.  On-Screen Editing: A very cool and excieted new feature is the ability to do on screen edits of objects. See how below I can easily select the “Customer ID” column in my physical model and simply change it on screen! This is a real time saver. Plus – you can copy, cut and paste items such as attributes and columns across objects – and models too! You just use the standard MS Windows grad-and-drop shortcuts like you do in Windows Explorer. This is a huge productivity enhancer – especially on large models where objects may need to share common items.

4.  Changeable Notation – IE & IDEF1X: TDM 3.0 offers the ability to switch display styles between the very common Information Engineering (IE) and IDEF1X, a quite popular US government standard. This is possible due to a new and flexible architecture withiun TDM 3.0, so we’ll be able to add other notations as time goes on – possibly even the Oracle CASE tool’s “Barker” notation. Bleow is an example of IDEF1X display mode. You simply need to open the Main Menu’s “Notation” choice and select which you prefer.

5.  Improved Reverse Engineering Wizard: TDM 2.0’s reverse engineering interface did not work well for very large databases due to substantial time delays necessary to populate the database object name drop-downs. So TDM 3.0’s reverse engineering wizard was designed from the ground up to work with large collections of objects. Plus it’s more intuitive to boot.

6.  Model Comparison & Merge Wizards: New for TDM 3.0 are intuitive yet robust model compare and merge wizards shown below. Modelers will now be able to easily compare and sync-up separate models – with complete visual representations of the key differences.

7.  Alter DDL Script Generation: This has probably been the single most requested feature enhancement – namely, the ability to generate SQL scripts with “ALTER” commands to synchronize the data model and database. This is not yet in the beta – but it’s coming J

8.  Unlimited Sub-Modeling: Most logical and physical data models these days are quite complex and very, very large. So how does one organize so much content in a meaningful fashion? With TDM 3.0 you simply create workspaces (i.e. sub models) for whatever organization or grouping you desire. Note that the data model below has four workspaces. The first one is the “All Items” workspace, which simply houses the entire data model. Often this workspace will be simply too crowded to be of much visual value. This model also has three workspaces that are subsets of the “All Ietms” – and are usually chosen to reperesent key business, functional or application breakdowns. So here we see that “Borrowing” is a subset we need to split out.

9.  View Support – and much, much more: It’s not uncommon to desire the physical data model to graphically show and record the meta-data for many different types of specialized database constructs – such as views. Look at the screen snapshot below, at the explorer on the right. I can see many such objects now – and some even show up on the diagram (and this list will grow over time). Plus each object now has a property edit screen – with lots of additional meta data, like the view properties window shown below.

10.  Editable Screens – customize TDM to taste: Have you ever just not liked the way some software’s screen was designed? Wish you could fix it? With TDM 3.0 you can – and it’s dirt easy. You simply right hand mouse click on the screen you want to change and choose “edit”. Then if you like the resulting screen design you save it – and from now on that’s exactly the way TDM 3.0 will look and feel. Look at the default entity screen below: I did not like the way things were laid out with lots of empty space, and I wanted to add some information of my own for data entry. Viola – the result is shown below! And it only took me just five minutes to make TDM 3.0 look and feel the way I prefer – which to me is the only correct way (my way) J