Oracle SQL Developer Data Modeler (SDDM) is a free data modeling solution. It supports many types of modeling levels, including:
When I present overviews on our database tools, I have this slide that shows what SDDM is capable of:
I am not a real data modeler. However, I can fake my way pretty well through Logical and Physical modeling discussions and exercises. When it comes to the dimensional stuff, I tend to rely more on our lead developer, Philip, and our Oracle ACE Director Kent Graziano.
Philip has provided two excellent resources for you folks to learn more about dimensional modeling and to get more comfortable with it in SDDM.
A Sample Dimensional Model
In your SDDM install directory, navigate to the datamodeler\datamodeler\samples\Dimensional_model folder. In there, you’ll find a .ZIP – extract the contents of that, you’ll end up with ‘global11_demo.dmd’ Open that file, and you’ll see this:
Fire away! But please do so on our SDDM product forum on OTN. Philip and Kent are there, as well as many of our other users and developers.