The Data Warrior

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

Archive for the category “Data Modeling”

09 Nov 2014

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 🙂

Posted in Data Modeling, Data Warehouse, Oracle and tagged , , , , , , , | Leave a comment
31 Oct 2014

Reverse engineer and discover foreign keys with SQL Developer Data Modeler

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.

Helifromfinland's avatarHeliFromFinland

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 post 390 more words

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

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.

Posted in Data Modeling, Oracle and tagged , , , , , , , | Leave a comment
28 May 2014
1 Comment

Better Data Modeling: #DataVault 2.0 Virtualising your Data Vault – Satellites

Guest Blog Link: Virtualising your Data Vault – Satellites

This is a MUST READ for anyone wanting to get Agile in their DW/BI program and for anyone doing Data Vault 2.0.

Actually anyone doing Data Vault 1.0 can benefit from the technique as well.

Roelant Vos has done quite a bit on trying to virtualize and automate data warehouses using DV 2.0 (especially since the WWDVC in Vermont.). Please check out his blog and follow him on twitter too.

Cheers

Kent

The Oracle Data Warrior

Posted in Data Modeling, Data Vault, Data Warehouse and tagged , , , , ,
02 May 2014
1 Comment

Data Vault 2.0 Training: Upcoming Public Classes

After my well-attended talk at #EDW14 in Austin this week (which was a GREAT event), a lot of you asked about where you could find a public class on Data Vault 2.0.

At the time I knew of none, but on my drive back home I was talking to Dan Linstedt (inventor of Data Vault) and he had great news for all of us: Dan will be teaching not one, but two public classes this summer!

Woohoo!

So the first one will be for all our friends in Europe. It will be June 2-4 in Helsinki, Finland. This will be a full 3-day Data Vault 2.0 Bootcamp class where you will get all the details on DV 2.0 modeling and methodology. If you want there is even an option to get the coveted CDVP2 after the class via a private certification exam.

This will be the 1st DV 2.0 class in Europe. So if you are in Europe, or have friends there, head over here for more details: http://danlinstedt.com/news/2014dv2bootcampfinland/

Following the class, Dan will be giving a keynote at the Oracle User Group Finland event on June 5-6 (I will be presenting there too!). To find out about OUGF check in over here: https://www.eventbrite.com/e/ougf-2014-harmony-tickets-10410222255 (scroll down to see the description and the agenda).

For the folks in USA and North America, Dan’s second public class will be  in Cincinnati, Ohio later in the summer. Details on this are not final yet. I will update this post as they become available.

So there you have it – DV 2.0 classes coming your way.

Cheers!

Kent

P.S. If these do not work for you you can always talk to Dan or myself about scheduling a private onsite class for you organization.

Posted in Data Modeling, Data Vault and tagged , , , ,

Post Navigation

← Older Entries
Newer Entries →