Better Data Modeling: Tips for Enhancing Your Use of Oracle SQL Developer Data Modeler

If you were an Oracle Designer user and are looking for a replacement data modeling tool, or you are using one of the other mainstream, expensive modeling tools and want a more cost effective alternative, then you owe it to yourself to look at Oracle SQL Developer Data Modeler (SDDM). Data Modeler has been around for a few years now and is up to version 4.1. It really is an industrial strength data modeling tool that can be used for any data modeling task you need to tackle. I have been using it for over five years now.

SQL Developer Data Modeler (SDDM) is a fully functional tool provided for FREE by Oracle. It has many features built in that can be leveraged to capture the design of an existing (probably undocumented) database or you can use it to design a new database, even a data warehouse from scratch. There are a load of great features. This book will show you my favorite features along with detailed step by step instructions (with screen shots) on how to use them.

Tips include:
•How to easily color code your diagrams
•How to make hundreds of views really fast
•How to find missing foreign keys
•How to find missing unique keys
•How to connect to a SQL Server database
As a bonus, there are two appendices with my run down on common data modeling mistakes and my famous rant on why you need foreign keys in your data warehouse.

So, if you want to know my little secrets for effective use of SQL Developer Data Modeler, this book if for you.