This post is not a ‘How to Version Your Models’ tutorial. We have that in movie form in the Oracle Learning Library (OLL.) It’s about 13 minutes long and steps you through how to add a model to source control via Subversion, how to make changes, commit said changes, and how someone else can do [...]

Near the end of a product demonstration with a customer yesterday, someone asked how they could build physical models for each of their different environments using Oracle SQL Developer Data Modeler (SQLDev.) Imagine having a application and database setup ‘out of the box’ that adequately described your meta data. But, you might have one implementation [...]

There are many data types to choose from when defining your table columns. The eighty percent rule tells us we can probably get away with a smaller subset of data types eighty percent of the time. Here is what the ‘TYPE’ control looks like in the modeler when defining a column: I was curious to [...]

Just so you don’t think I’m crazy, you should know that I’m a father to a wonderful two year old daughter. She’s awesome, except when she wants to act her age. When we get desperate, we turn on her favorite show. I have seen about 200 different episodes of Dora the Explorer. My Spanish is [...]

Data models sure are handy. They tell a story – how does the information get stored as data? Just what is a ‘customer?’ Sometimes though our applications die and only leave legacy scripts behind. Or maybe you are a DBA and someone has given you a set of scripts to create some new objects in [...]