The Data Warrior

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

Archive for the category “User Groups”

Woo hoo! New Oracle ACE Directors

Yup, I am one of them!

Thanks to Kris Rice (@krisrice) at Oracle for submitting my nomination.

Still getting used to the new “networked” world. I actually saw the announcement of my promotion on Facebook (on my new smart phone) which was a feed from Twitter, before I saw the official email in my inbox.

Weird.

Six degrees of separation from what????

Here’s the Tweet:

Oracle ACE Program Oracle ACE Program
@oracleace
Two more promotions to #ACED: Kent Graziano-@KentGraziano and Tingkun Yang. Congratulations!!
12:42 AM – 23 Jun 12 via TweetDeck

Also promoted today is my good buddy from Denver, Tim Gorman (@timothyjgorman). Tim is one of the best Oracle DBAs I know, a published author, great presenter/teacher, and is the current President of the Rocky Mountain Oracle Users Group (RMOUG).  He will be presenting a few session at KScope12 this comming week along with me and a bunch of other Oracle ACE and ACE Directors.

Congrats to all the newly minted ACE Directors!

Anyway, this was a good way to end the work week and start the weekend.

Cheers.

Kent

P.S. Stay tuned as I will be blogging and posting pictures from KScope12 in San Antonio starting Sunday (using WordPress on my smart phone, I hope!).

Countdown to KScope: Oracle Education, Fitness and More

It’s almost here: the best education event for Oracle developers – the Oracle Development Tools User Group KScope12 conference.

It starts Saturday June 23rd with the annual community service day helping out the Boy’s and Girl’s Club of San Antonio.

Then things really get rolling on Sunday June 24th with the famed all-day, in-depth symposiums.

One Monday, the main sessions kick things into high gear.

This year I am lucky enough to give two presentations on my favorite topics.

On Monday June 25 from 10:00 am – 11:00 am, I will present Introduction to Data Vault Modeling for an Oracle BI Environment. 

Then on Thursday June 28, from 10:30 am – 11:30 am, you can close out the conference by attending my presentation on SQL Developer Data Modeler: Reverse Engineering (and Re-engineer) an Existing Database Using Oracle SQL Developer Data Modeler.

If you are using the KScope app, don’t forget to add these sessions to your schedule and then check in during the sessions to be eligible for  some special ODTUG prizes.

Of course there will be networking events, a vendor hall, food and fun.

With all the good food and sitting in intense sessions all day, it is important that we all do our best to stay fit. To help with that, I will again be leading a 30 minute Chi Gung session every morning at 7 AM on the main lawn.

Really – anyone can do it. Read my article here for details.

Come out and join me to get your day off to a calming start so you can focus on getting the most out of your day at Kscope12.

And don’t forget to follow me on twitter @KentGraziano. I will be tweeting live and posting pictures all week from the conference.

See you in San Antonio. Giddy Up!

-Kent

Flexible Data Warehouse Architecture

My friend and colleague, Sanjay, just put up a new video discussing aspects of using the Data Vault as your data warehouse architecture.

It is really short – just barely 10 minutes.

You can jump over to see the video here.

Covers a nice little discussion comparing dimensional (star schema) models to data vault as a centralized data warehouse repository (as opposed to end-user facing data mart).

As a bonus, Sanjay also covers the basics of data vault modeling using an actual chalk board (okay so he is “old school”).

So why listen to Sanjay?

He is the co-founder with Dan Linstedt of LearnDataVault.com and has done tons of writing and consulting on Data Vault for quite a few years. He was behind the scenes helping us get the book out on the web, Amazon, and on Kindle.

He knows whereof he speaks.

Have a listen.

Be careful – you might learn something. 🙂

Later.

– Kent

P.S. Don’t forget to follow me on twitter @KentGraziano or subscribe to this blog (button at top of the right column) so you don’t miss out on my updates.

P.P.S. ODTUG KScope12 is just around the corner. I will be doing two talks and bunch of other stuff out there in San Antonio in a few weeks. Stay tuned!

Is Data Vault Agile?

You bet it is!

Years ago I wrote an article about Agile Data Warehousing and proposed using Data Vault Data Modeling as a way to get there. Dan Linstedt recently published an article with more details on how it fits. Here are the good parts:

1. Individuals and Interactions over processes and tools

The Data Vault is technology agnostic AND focuses VERY heavily on customer interaction. In fact it’s really the only methodology where I’ve seen a very heavy emphasis on the fact – The business owns the data.

Also, you have to start with the Hub entities and they require identification of the business keys as specified step-by-step on page 54 of Super Charge Your Data Warehouse

2. Working Software over Comprehensive Documentation

With the pattern based architecture in a Data Vault model and with the business rules downstream of the Data Warehouse, you can start building extremely fast and even use code-generation tools or scripts to get the first cut of your model.

I’ve in fact used code-generation for Data Warehouses that have been in production for quite a few years They’re even running today.

The Data Vault Model & Methodology in my opinion is the fastest way to get something delivered to a Data Warehouse and it dramatically reduces project timelines and risk.

3. Customer Collaboration over Contract Negotiation

The Data Vault Methodology emphasizes the ownership of the project and data by the business and makes them a partner on any Business Intelligence project.

And, the fact that it’s easy to address change makes them happy which interestingly enough, is the next one:

4. Responding to Change over Following a Plan

This makes some people cringe. But it’s a reality of most projects. The first time out neither you nor the business REALLY know what they want. It’s only after they see something, they realize the value of the information and their brains start churning.

In the traditional forms of Data Warehousing, it takes scoping, project budgeting, planning, resource allocation and other fun stuff before you can even get creative and give them what they think they want. The problem is, most business users don’t REALLY know. The DW team ends up thinking and even assuming for them often incorrectly. You can end up with something that is really fancy and beautiful and still … useless!

To add to the complication, If it’s in fact a bad idea, it will be money ill spent which can be as much of a big deal if it’s a great idea where the time to build will make them lose out on the competitive edge they’re looking for.

With the Data Vault, the model is built for change from the ground up. Since the core data NEVER ever changes, creating business level user-interface layers on top is just so easy – and many architects and modelers think it’s ideal.

Check out the full post – Agile Data Warehousing

(and don’t forget to buy the book).

BTW – if you are going to ODTUG KScope12 this June in San Antonio, be sure to stop by for a chat. I will be giving two talks, one on Data Vault and one on using SQL Developer Data Modeler.

See ya.

Kent

P.S. I am now on twitter! You can follow me there @KentGraziano.

Work is Killing You and 10 Ways to Stop It From Happening!

This has been a hot button for me for some time – if we don’t find a way to fit exercise, fitness, and some healthy eating into our sedentary lives (like we in IT tend have), we will not live as long as we hope. And life will not be as enjoyable as it could be.

This article really speaks to this all-to-common issue:

Every morning, you awaken to a new day and you launch into your familiar routines as you hustle to meet your daily obligations.

Ideally, your work excites you, energizes you, and brings joy to your life. If your work brings you more stress and fatigue than joy then now is the time to make some changes. You can introduce a renewed vigor into your work and upgrade your attitude.

You know that taking care of yourself should be your number one priority. Yet you often let your health and fitness levels fall by the wayside if you are consistently working 50 or more hours a week.

As a society, at what point did we take the wrong turn by focusing on work place productivity and relentless goal setting at the expense of our happiness and well-being?

Productivity does not have to be measured solely by the number of hours logged at work. Happiness will not be attainable when consistently working 50 hours a week. Furthermore, our choice, as a culture, to sacrifice fitness or physical play for other goals has had an impact on every part of our lives, including our fitness level and our overall happiness at work and outside of work.

The article goes on to detail 10 things you can do – today – to become more fit and healthy (and it is not just joining a health club). Check it out at  Work is Killing You and 10 Ways to Stop It From Happening! | Work Happy Now.

Get up and get moving! (after you read the article that is…)

If you want to get notified when I post articles like this, don’t forget to hit the Follow button at the top of the column to the right.

– Kent

P.S. If you are attending this years KScope conference next month in San Antonio, you can work on your fitness level by joining me each morning for some calming and energizing Chi Gung. We will meet on the lawn each morning at 7 AM.

Post Navigation