The Data Warrior

Changing the world, one data model at a time. How can I help you?

Archive for the tag “Data Model Design Reviews”

Better Data Modeling: An Easter Present

In celebration of Easter this year, I have a present for everyone.

A book sale!

I am putting my first Kindle ebook, A Check List for Doing Data Model Design Reviews, on Sale starting on Easter Sunday, April 5, 2015,  for five days!

The sooner you act, the better deal you will get:

Easter Sunday April 5, 2015 at 8:00 AM (PST) the price will be just 99 cents!

The next day April 6, 2015 at 11:00 AM (PST) the price will go up to $1.99

On  April 7, 2015 at 2:00 PM (PST) the price will go up to $2.99

On  April 8, 2015 at 5:00 PM (PST) the price will go up to $3.99

On  April 9, 2015 at 8:00 PM (PST) the price will go up to $4.99

On  April 10, 2015 at 11:00 PM (PST) the price will go up back to the regular price of $5.99

So if you don’t have a copy yet, buy yourself one for Easter.

If you have a copy, buy a copy for a friend as an Easter present.

Either way go here to buy one!

Happy Easter!


The Data Warrior (and Easter Bunny)

P.S. This promotion is also available on (where it start at 8:00 AM GMT).

My Data Model Checklist book is now available in Spanish – Just in time for #OOW14!

Exciting news!

I just got this email from Amazon:

Congratulations, your book “UNA LISTA DE VERIFICACIÓN PARA REALIZAR REVISIONES A LOS DISEÑOS DE MODELOS DE DATOS” is live in the Kindle Store and is currently enrolled in KDP Select. It is available for readers to purchase here.

If you are in Mexico, you can get the book here.

If you are in Spain, you can get it here.

Now, truth is I do NOT speak, read or write Spanish. But my good friend, and Oracle expert, Galo Balda does!

I am very grateful to Galo for putting in the effort to translate my little book so other data professionals around the world could read it in their native language.

You can (and should) follow Galo on Twitter, and on his personal blog in either English or Spanish.

BTW – Galo is speaking at OOW14 too, so if you are going, please drop into one of his excellent sessions on Pattern Matching (Session UGF4482) and Regular Expressions (Session CON4493).

Muchas Gracias Galo!

See you all at OOW!


The Oracle Data Warrior

P.S. Don’t forget you can still get this book in English on Amazon. Get it here.

Better Data Modeling: Color Code Your Data Model Diagrams using #SQLDevModeler

One of the standards I recommend in my book  Check List for Doing Data Model Design Reviews is to use color in your diagrams to visually differentiate types of entities or tables.

As luck would have it, Oracle SQL Developer Data Modeler has a feature that makes this very easy. It is Classification Types.

In the latest version. 4.0, you set these up by going to the context menu on the Design level. From that menu pick Properties. Once on the property dialog go to Settings -> Diagram -> Classification Types. (In 3.x look under Tools -> Preferences)

The default install comes with a bunch already – fact, dimensions, logging, summary, and temporary. Each has a pre-set color assigned. You can change that color by clicking on the color and selecting another option from the pallet. You can also set a prefix for each type. (Note – if you are already using a classification and change the color, when you hit apply the new color will be applied in all existing diagrams within the design.)

You add new types by clicking the green plus (+) sign and then just add in whatever you want and save.

For Data Vault modeling, I add three new types: Hub, Link, and Satellite with the colors you see in the screen shot here.

Using Classification Types to Color Code Your Diagrams

Using Classification Types to Color Code Your Diagrams

To apply a classification type to an existing table, open the table property dialog and look for the classification types node in the tree (in 4.0). In 3.x, there is a simple classification type drop down on the main property page.

Once applied, the first letter of the classification type will appear in the upper left corner of the table (see screen shot).

Another way I have used this recently was in my current data warehouse project where I have source, stage, and dimensional tables all in one design. I found I often want to show all three tiers in on diagram (sub view) for a sprint (we are using a SCRUM approach) to help the ETL programmers and QA folks have one place to go where they can see how these layers are related. So for this project, I also added a source and stage classification type.

So if you have been color coding you diagrams by hand, this tip should save you a bunch of time since you won’t have to pick the colors by hand on each table. Plus the color selection will be more consistent.

If you aren’t color coding, now would be a great time to start!

Bonus Tip: If, like me, you want to be consistent across all your designs with the types and colors, I just figured out I can hack the dl_settings.xml file to copy my classification type customizations from one design to another. Just be sure to exit and then restart SDDM after you update the file for it to take effect.

Have fun coloring your diagram! (Maybe more people will read them)


The Oracle Data Warrior


Better Data Models: Early Black Friday Data Model Book Sale!

I am truly thankful for the career I have in Oracle, data modeling and data warehouse design.

And I am thankful for you, my loyal readers and followers!

So, in honor of American Thanksgiving and our crazy Black Friday and Cyber Monday insane shopping addiction, I am putting my Kindle ebook on SALE!

Get my book A Check List for Doing Data Model Design Reviews for 34% off starting 8 AM PST Thanksgiving Day (November 29th).

Just go here on

This is a limited time sale which ends next week on December 5th.

Get a copy for your favorite data modeler!

Happy Thanksgiving and Happy Shopping!


P.S. For all my overseas friends attending the #UKOUG_Tech13 event next week, you can go here for a similar sale from Sunday December 1st though December 7th.

Post Navigation

%d bloggers like this: