The Data Warrior

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

Archive for the tag “data warrior”

The Data Warrior Goes to Oracle Open World 2015 (#OOW15)

Yes boy and girls, it is that time of year again. Time for the BIG show in San Francisco – OOW15

I will as usual, attend, but only for a few days this year (been away from home too much).

My Talk

I will be presenting my session Worst Practices in Data Warehouse Design (UGF9985) on Sunday at 10:00 AM in Moscone South, room 274 (courtesy of ODTUG!).  This will be a quick one as I only have 45 minutes to do a one hour talk. Yikes!

If you will be in SF by Sunday, be sure to come by and say “hi.”

Morning Chi Gung?

As usual, I will try to gather some folks near either Union Square or maybe by Yerba Buena Gardens for a little morning relaxation with some Chi Gung (Qigong) . Most likely around 7 AM for 30 minutes. Probably Saturday, Sunday, and Tuesday, Follow me on twitter @kentgraziano and look for #MorningChiGung #OOW15 for final time and location.

Monday for sure though, I will be doing a shortened session on the beach at the 4th Annual OOW SF Bay Swim around 9:15 AM or so. Nothing like a little chi movement to warm you up before and after jumping in the bay.

The Rest of My Schedule

Much shorter than usual but here is what I plan to see so far:

Session Title Session Code Date Start Time End Time Room
Oracle Database 12c-Data Redaction UGF1513 10/25/2015 8:00 8:45 Moscone West-3011
Oracle Business Intelligence Best Practices: the Bad, the Worse, and the Really Ugly UGF7409 10/25/2015 9:00 9:45 Moscone South-301
Worst Practices in Data Warehouse Design (ME) UGF9985 10/25/2015 10:00 10:45 Moscone South-274
Oracle Database Security: Frustrating the Patient Intruder UGF10016 10/25/2015 11:00 11:45 Moscone South-274
Improving Analytics: Experiences Testing Oracle Database In-Memory 12c Feature UGF9936 10/25/2015 13:30 14:15 Moscone South-303
Fennia Two Years in Production with Oracle Exadata UGF5105 10/25/2015 14:30 15:15 Moscone South-305
Managing the Changes in Database Structures (Heli) UGF6317 10/25/2015 15:30 16:15 Moscone South-306
Oracle OpenWorld Welcome Keynote KEY10818 10/25/2015 17:00 19:00 Moscone North-Hall D
Oracle OpenWorld Monday Keynote Swim The Bay!
KEY10819 10/26/2015 9:00 10:00 Moscone North-Hall D The Dolphin Club
Oracle SQL Developer Tips and Tricks (Jeff Smith) CON8721 10/26/2015 16:00 16:45 Moscone South-304
Database Development for the Cloud and On Premises (Kris Rice) CON8779 10/26/2015 17:15 18:00 Moscone South-304

Other Fun Stuff

Along with the educational sessions is of course the opportunity to network with folks. I expect I will be doing that as much as possible. There is the annual Oracle ACE dinner, and who know what else. I am sure I will find plenty to keep me busy.

Since I arrive early for the Oracle ACE Directors annual briefing at HQ, I know I will be downtown Friday evening and all day Saturday. Drop me a note if you will be there too and want to hang out and see some of the sites and eat some top notch grub.



The Data Warrior

Do you want a Data Vault 2.0 Bootcamp in The Woodlands, Texas?

Survey time peeps!

Simple Yes/No question:

Would you like me to hold a DV 2.0 Bootcamp (and private certification) west of the Mississippi?

If I set one up a in “America’s Hometown” (really it is even trademarked), The Woodlands, Texas (20 minutes north of Houston Bush Intercontinental Airport), would you come?

The Woodlands Waterway and our concert venue The Pavillion

The beautiful Woodlands Waterway and our concert venue, The Pavilion. You can take a water taxi to a concert!

Since I am an authorized DV 2.0 Trainer, I figure it is time I actually teach a class. And why not in my hometown in Texas?

So what is in a DV 2.0 Bootcamp class?

Three days of intense training on all things DV (followed by a chance to become a Certified DV 2.0 Practitioner).  NOTE: If you are new to Data Vault, you must read the Super Charge book before attending the class.

This class covers what you need to know as a practitioner in the world of Data Warehousing and Business Intelligence.  This is our foundational course.  This is a 3 day (in person) course that covers end-to-end best practices.  Major topics for this class are:

  • Architecture – Including NoSQL, Big Data, Hybrid Systems and Relational stores
  • Methodology – Including CMMI, Six Sigma, Optimization, Automation, and Generation
  • Implementation – Including Performance and Tuning, Set Logic, ELT vs ETL, Parallelism
  • Modeling – Including replacing of surrogates with Hash Keys, data layout, data co-location

This class takes you through the why/what/how of Data Vault 2.0.  It includes the coverage of the business justifications, then follows with the technical descriptions of the architecture, implementation, methodology, and modeling.  Included in the topics are reaching agility, practicing Six Sigma, measuring and optimizing at CMMI level 5, the KPA’s and KPI’s of Data Warehousing, and more.

We also discuss the use of Hadoop, and NoSQL platforms along side the relational world.  The objective is to enrich your understanding of how and when to apply Big Data Solutions.  The course finishes with descriptions on ETL and ELT design time paradigms, including templates, best practices and working SQL.  This class is a prerequisite for anyone wishing to achieve DV2.0 Certified Practitioner status.


Late summer – early fall (depending on interest) of 2015


TBD based on how much the space costs me here!

But will definitely be less than $3,000.


Someplace nice and central in The Woodlands within walking distance to great food and drink.

Apartments over looking the waterway that flows to Lake Woodlands. A great natural setting. Not the usual suburban wasteland.

Apartments over looking the waterway that flows to Lake Woodlands. A great natural setting. Not the usual suburban wasteland.

So who is in?

Please respond in the comments so I can tell if I should start setting something up.



The Data Warrior

P.S. Since you know I am into fitness, we have great options here to exercise here too. MIles of running trails and even kayaking on the waterway.

The Riva Boathouse were you can rent single and double kayaks by the hour (look close and you find a picture of my son and & on the sign from when they first opened).

The Riva Boathouse were you can rent single and double kayaks by the hour (look close, when you are here, and you find a picture of my son and & I on the sign from when they first opened).

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.”


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


Data Vault


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.


The Data Warrior

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


Oracle User Groups: Are you a member?

I love user groups.

Getting introduced and involved in them has made a huge difference in my career. If it was not for all the people I have met in the last 22+ years, my career, and life, would have been very different.

I have met hundreds (maybe thousands) of amazing people both from within Oracle Corp and outside. Many of them became, and remain, my friends. Which is why we all love to get together several times a year at various user group and industry events to catch up, exchange wars stories, and learn new things.

Right now, I am starting to prepare for one of my favorites – ODTUG KScope. I will be there presenting in June and  running my popular Morning Chi Gung class for the 2nd year in a row.

If you have not registered, get to it! Rooms are going fast and you want to be sure to stay at the conference resort (yes – resort, not hotel!).

And on the ODTUG front, they have just announced you can now join for just $99 a year. That is the best value you can find for the world’s best Oracle user group for Developers.

So are you in? Are you at member of at least one user group?

What? You don’t know which one to join?

Then check out this new cool site Oracle just put up with videos from some of the user group leaders. After that, check out their new User Group Central with information about Oracle user groups around the globe.

So get out there and meet some new people and learn some new things.

Come to KScope12.

Join a user group.

See you in San Antonio.


P.S. Don’t forget to submit an abstract for Oracle OpenWorld before the deadline passes. It will get you a free pass to the show (worth over $2000). Tell’em ODTUG and the Oracle Data Warrior sent you.

Post Navigation


Get every new post delivered to your Inbox.

Join 1,288 other followers

%d bloggers like this: