Just saw this tweet from Oracle Product Manager Ashly Chen:
Get thee to the site and download away!
Did I say, it is FREE?
(Do remember it is BETA as use it accordingly)
Cheers!
Kent
The Oracle Data Warrior
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 🙂
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.
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.
I will ask Data Modeler to find me the foreign keys.
If I select…
View original post 390 more words
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.
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
Kent - The Data Warrior
Alumni
Kindle format on Amazon
Now in paperback!
Kindle format on Amazon
Learn Oracle Data Modeler from The Data Warrior
The Data Warrior 