Oracle Data Warrior

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

Live from #OTW14: Worst Data Warehouse Design Practices

Back in September at the now annual OakTable world (OTW) at Oracle OpenWorld, I was privileged to give a talk where I ranted a bit about some of the worst data warehouse design mistakes that I have seen.

Well, if you missed out, now you can see that talk thanks to Kyle Hailey who had all the OTW talks videoed. This week, he tweeted that the video was ready for viewing.

So if you missed the talk, or just want to see it again, check it out!

Kent

The Oracle Data Warrior

P.S. If you would like to have me do this very fun presentation at your company or meeting, I would be happy to discuss arrangements with you. You know how to find me so drop me a comment, email, tweet, FB, DM, or even call :-)

Reverse engineer and discover foreign keys with SQL Developer Data Modeler

Kent Graziano:

This is a nice piece of functionality that Oracle added to SQL Developer Data Modeler some time ago. Heli gives a nice step by step guide on how to use it.

Originally posted on HeliFromFinland:

You can easily document your database with Data Modeler: just reverse engineer the database with File-> Import -> Data Dictionary. But what if the database has no foreign keys? What’s the point of documenting then? Just tables that has nothing to do with each other….

Well, Data Modeler can help with that too: you can use “Discover Foreign Keys” functionality to find the foreign keys that should be in the database and even generate the DDLs for them if needed…

There are two ways Data Modeler can guess the foreign keys for you: the column has the same name as a primary key column in parent table or using the naming templates. And combinations of those.

Select the relational model from the Browser. Right-click and select “Discover Foreign Keys”. I have two tables: CUSTOMER and ORDER.

Tables

I will ask Data Modeler to find me the foreign keys.

If I select…

View original 390 more words

Say “Big Data” One More Time (I dare you!)

This is quick. Saw it on Twitter this morning and it is just too funny to not share:

Have a great day!

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!

Kent

The Oracle Data Warrior

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

It’s almost time! #OOW14 and #OTW14 – the biggest gathering of Oracle experts anywhere

Hi gang!

As you can guess by my lack of recent posts, I have been very busy this fall. Along with client work, home life, and editing a really cool book on SQL Developer Data Modeler, I have also been prepping for my annual pilgrimage to Moscone Center in San Francisco for Oracle Open World and OakTable World 2014.

As usual, there will be much to see, do, and learn at what is arguably the largest (60k+ people) gathering of Oracle users and experts in the world. Expect big news from Oracle Corp, great sessions from Oracle ACEs and ACE Directors, and of course the annual customer appreciation event.

So here is my short list of what to check out this year:

Annual ODTUG Sunday Symposiums: http://www.odtug.com/oracleopenworld2014Sunday

ODTUG’s best speakers during the week: http://www.odtug.com/oracleopenworld2014

OOW Executive Keynotes: https://www.oracle.com/openworld/keynotes/index.html

For all the sessions by day, check the main Content Catalog (over 2028 sessions): https://oracleus.activeevents.com/2014/connect/search.ww#loadSearch-event=null&searchPhrase=&searchType=session&tc=0&sortBy=&p=&i%2810009%29=10105

OakTable World 2014: http://www.oraclerealworld.com/oaktable-world/agenda/

This year I will again have the honor or presenting at OakTable World on Tuesday, September 29. I will give a data warehouse design session in the morning, then do a short TED-style talk over lunch about a Data Vault 2.0 innovation using MD5 hash functions.

If you have not heard of OTW, it is a FREE event co-located with OOW (http://www.oraclerealworld.com/oaktable-world/location/). It was organized by members of the elite OakTable and is in its third (or fourth?) year. Be sure to stop by and say hi!

As for special events, I plan to participate in the Run/Walk the Bridge on Sunday morning,  the 3rd annual Swim the Bay on Monday and I will again do some Morning Chi Gung with a few friends (follow me on Twitter for where and when).

So there are lots of opportnities to meet up.

See you there!

Kent

The Oracle Data Warrior

p.s. Later next week I will be at Oracle HQ at the annual ACE Directors briefing. Watch my Twitter feed for pictures and updates.

Post Navigation

Follow

Get every new post delivered to your Inbox.

Join 959 other followers

%d bloggers like this: