Everyone likes pictures. Generate a report without any pictures, graphs, or charts and see how many ‘likes’ you get at work.
Everyone gets excited about data modeling, and in some circles, folks think that data models are synonymous with diagrams. But really, the diagram is just the ‘pretty picture’ you add to your office report. Don’t get me wrong, these pictures CAN be very important.
There are lots of things you can do to customize the look and feel of your diagrams. You can change colors and fonts, add pictures (also new for 4.1), create subviews (which filter the objects shown), and displays (which allow you to have different visual versions of your diagrams.)
I had originally said this was new in version 4.1, umm no. Apparently it’s been in here since version 2.1 and I just haven’t been paying attention. So if you haven’t seen it before, it’s probably new to you 🙂
You can drag and drop a display, model, or subview to an existing diagram.
Those new visual artifacts now also act as hyperlinks. So I can quickly ‘jump to’ say a version of my diagram that only has comments. Or I can even link to a different model in my design.
Double-clicking on the diagram object immediately opens said display, subview, or model.
And I just happen to find this…
Now, I’m confused! 🙂
I guess we changed our minds since 2011. And I’m not sure MySQL had modeling support back when we first acquired this technology.
Is it in Oracle’s plan to include MySQL as an RDBMS to the SQL Developer Data Modeler tool? And if yes, what is the timeframe??
The MySQL team has their own modeling solution – for us to build one too wouldn’t make much sense.
Yeah, I am aware of SQL Workbench… not great! Several deficiencies…
I’m currently evaluating several data modeling tools, as part of a new platform, that would both work with Oracle and MySQL. So far, I’ve evaluated MySQL Workbench and Toad Data Modeler, with the latter coming on top. Navicat and Power Architect is also on my “to evaluate” list. But, as of now, SQL Developer Data Developer (or SDDM) is by far the best tool. I thought that, since Oracle acquired the MySQL technology, they would incorporate MySQL into the SDDM toolset. Oh well…
Off hand, would you know or are aware of a good data modeling tool that would both handle Oracle and MySQL?
Thanks for your input! Much appreciated…
It doesn’t make sense for us to have 2 modeling solutions for MySQL..have you shared your feedback with the MySQL team? If not, send it to me, and i’ll get it to the right people.