The Data Warrior

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

Archive for the tag “data models”

Schema-on-what? How to model JSON

It seems hard to believe, but all year, around the world, I continue to have this conversation on whether or not we still need data modeling.

I know! Crazy!

Thought we were past that…

As I have said before,

Schema-on-read has the word SCHEMA in it!

So instead of continuing to rant about it, I decided to put together a talk to show people, graphically, what I meant by decomposing, step by step, a few JSON documents into real data models. For the sake of the talk I decided to go with 3NF and Data Vault styles to make my point.

This talk has been very well received so I decided I would share it a bit more publicly by posting it here on my blog.

 

Now that you can see how to model JSON, check out my Snowflake ebook on how to easily analyze JSON using SQL.

If you know any meet-ups or conferences that I should be giving this talk at, please let me know. Or check out my speaking schedule for 2019 and join me at one of the events already on my calendar. (1st up is ITOUG in Milano!)

Ciao!

Kent

The Data Warrior & Chief Evangelist at Snowflake

P.S. There was no magic, or built-in wizard, to creating the models. I did it all by hand using Oracle Sql Developer Data Modeler.

 

New Year, New Name, Same Mission

Happy New Year!

Looks like it will be another busy one. So, let’s get going!

Yes, I just changed the name of my blog from “Oracle Data Warrior” to “The Data Warrior.”

Why?

Well, for one, my company name is Data Warrior LLC, so it seemed to make sense.

Plus over the last few years quite a few of you that I see at conferences and such, simply call me “data warrior”. As in,

Hey, Data Warrior, how’s the battle going?

And after a some recent conversations and pondering, I realized that, while I am an Oracle ACE Director, and a fan of Oracle databases and tools, the things I write about and the work I do, is really database agnostic.

Think about it…

Regardless of the database, or data modeling tool, good design principles,  architecture, and standards transcend the technology.

Third normal form

Dimensional

Data Vault

Anchor

There are standards and best practices that are applied in developing all of these models that have nothing to do with technology. (Yes, implementing them efficiently is another story).

Some of my favorite topics, like FKs in data warehouses, and naming standards, are somewhat philosophical, and apply in many situations.

But never fear, you will still see posts on my favorite tool, SQL Developer Data Modeler,  and reports from all the main Oracle events (RMOUG, ODTUG, OOW).

And there will be the occasional rants about badly behaving data models and data modelers.

And of course Data Vault, Agile BI, and varying forms of virtualization.

Plus the occasion inspirational quote.

So while the name has changed, the content will not; the mission will not.

My mission is still to Change the World, One Data Model at a Time.

Let’s see what the year will bring us.

Kent

The Data Warrior

P.S. Look for future posts about upcoming talks I am giving, and at least one surprise new offering.

 

Post Navigation

%d bloggers like this: