The Data Warrior

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

Archive for the tag “#SQLDevModeler”

25 Nov 2018
2 Comments

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.

 

Posted in Big Data, Data Modeling, Data Vault, Data Warehouse and tagged , , , , , ,
29 Dec 2017

Oracle SQL Developer Data Modeler 17.4

So for your last technical task of the year, as Heli recommends, go get the latest version of Oracle SQL Dev Data Modeler. Looks like a bunch of important fixes (including some “annoying behavior”).

Cheers!

Kent

The Data Warrior

HeliFromFinland

This is a version I have been waiting: so many important bug fixes! I downloaded it immediatelly the evening it was available and finished one of my projects using it.

If you have not downloaded it yet, do it today: http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html

Why did I waited for it? Because of, for instance, these bug fixes:

27245333 – IMPORT OF DDL AS ORACLE 12CR2 DOESN’T RECOGNIZE DATA TYPES
27182476 – SQL SERVER 2012 DDL GENERATION FAILS WITH CLASS CAST EXCEPTION
26985782 – STANDARD REPORT – COLUMN DATA TYPE IS NOT INCLUDED WHEN COLLECTION
27040952 – DESIGN PROPERTIES DIALOG DOESN’T WORK
26988362 – IMPORTING LEGACY PHYSICAL MODEL RESULTS IN TABLE ITEMS LISTED RED IN HIERARCHY
27041167 – REVERSE CLAUSE FOR INDEX IS NOT PROCESSED DURING IMPORT FROM DATABASE
26918584 – SYNC TO DB CANNOT RECOGNIZE TABLES WHEN PROXY USER IS USED
26919656 – PROBLEMS WHEN EDITING UDP FOR ATTRIBUTES IN ENTITY DIALOG
26750611…

View original post 32 more words

Posted in Oracle, SQL Developer Data Modeler and tagged , , , , | Leave a comment
26 Sep 2017

OOW is just around the corner

Yes it is indeed time for Oracle Open World. Unfortunately I will not be there speaking myself this year, but do not despair my friends, there is still plenty of goodness from the community such as these talks from my good friend Heli. She is coming all the way from Helsinki, Finland to share her knowledge. Go to one of her talks and tell her The Data Warrior sent you!

HeliFromFinland

I cannot believe how fast time flies! It has been an exceptionally busy year and that is the reason I have not had time to write blog posts either. I have been speaking in amazing events like BIWA Summit, APEX Connect, Riga DevDays 2017, OTNEMEA Tour in Baku and in Madrid, BGOUG, E4, KScope17, Oracle Code Bengaluru, the first ever APEX Day in Finland, Oracle Code Seoul, POUG, and Tajikistan TechDay. Next on my list is Oracle OpenWorld. As always it will be a busy week.

I will fly to San Francisco on Thursday to attend the ACE Director briefing on Friday at the Oracle HQ. I will have three talks:

OOW_session_catalog

And I will also have two short talks:

  • one at the EOUC trackEOUC.jpg
  • and another one at the WIT Lightning Storm sessionWIT

I will have several meetings, swimming, running and chocolate tasking

https://www.eventbrite.com/e/chocolate-tasting-at-oracle-openworld-2017-tickets-38069813838

Just to mention some of the…

View original post 57 more words

Posted in Data Modeling, Oracle, SQL Developer Data Modeler, User Groups and tagged , , , | Leave a comment
27 Jul 2017

#SQLDevModeler Tip: From Domain to Database… A Comment Conundrum

Great tip on creating a custom transformation script in SQL Developer Data Modeler (SDDM) from the awesome David Schleis:

Recently on the Data Modeler Forum, I came across this question:

Is it possible to mirror domain comments, from Domain Administration into attribute “Comments in RDBMS”?  Would like to mirror these to the ddl so they can be then available in column comments in the database.

I knew that one of the example transformation scripts provided with Data Modeler copies the column “Comments” property to “Comments in RDBMS”, so I thought I would point this out to the questioner, and that would be that.  But….

See the rest of the story… From Domain to Database… A Comment Conundrum

Model on!

Kent

The Data Warrior

Posted in Data Modeling, SQL Developer Data Modeler and tagged , , , , , , , ,
12 Jul 2017

New Version of SQL Developer Data Modeler is available!

It is now version 17.2!

Don’t worry, you have not missed 13+ releases!

A new versioning number system has been put in place and applies to both SQL Developer and SQL Developer Data Modeler (SDDM). A new version will come out about four times a year and the version number is created using the last two digits of the year and the number of the quarter.

So version 17.2 = Q2 2017

Data Modeler

You can get the newest version here:

http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html

SQL Developer

There is also a new version (17.2) for this tool as well. Get it here:

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

Download and have fun!

Kent

The Data Warrior

Posted in Data Modeling, Oracle, SQL Developer Data Modeler and tagged , , , , , , | Leave a comment

Post Navigation

← Older Entries
%d bloggers like this: