Well, its not as cold as it was in Moscow, but the welcome was just as warm.
We're here in Prague delivering the Oracle Develop event.
I'm here talking about our new modelling tool. Oracle SQL Developer Data Modelling which is available as an early adopter release on OTN.
Oracle SQL Developer Data Modelling is the latest product offering to join our Oracle Database Tools. SQL Developer Data Modelling has Entity Relationship modeling, Relational (Database Design), Data Type and Multidimensional modeling, full forward and reverse engineering and code generation. It includes importing from and exporting to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of Design Rules.
All in all, fills in one of last pieces of the database development cycle allowing us to model our databases before we go ahead and physically lay them out and create them. My personal favourite is the multidimensional modelling features.
Years ago, I was involved in a huge implementation of a warehouse which was all defined by hand; the fact tables, the dimensions and all the aggregates. This was fine at the time, but being able to go the database and extract the structure of it and show it as a model would have been great. Have a look at the image and the way the fact, dimension and aggregate objects are laid out.
Anyway, the talk today was great with loads of questions around how we'd handle Designer, Erwin and other formats, and why we just didn't use Rational or JDeveloper. There are a lot of answers for this in the FAQ.
For now, we have a couple more hands on labs where the attendees can get their hands on the software and ask questions about what they are doing.
Download it and try it and if you have questions, ping the forums and we'll help you get going.
SQLcl custom Input prompt and validations
1 week ago