The Data Warrior

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

Archive for the tag “Oracle”

Oracle ACE Director Meeting: Day 2

So the 2nd day was as filled with brainiac conversations as day one…and most hush hush under NDA.

However, I was able to get shots of a few more slides today that were not under NDA.

First, here is the agenda. Sadly the Exadata session got canceled. 😦

Day 2 Agenda

Oracle has been recognized in the Gartner Magic quadrants in several areas related to integration & SOA.

You will see this as a major theme at OOW2012 – “Integration Everywhere”. Lots of sessions related to apps and the cloud.

Well, you have to have something about Big Data. What is Big Data? Opinions vary. At OOW you will hear that there is Big and there is Fast. Oracle believes they have constructed solutions that handle both.

Have you heard about Oracle Golden Gate? I have. My current client even did a pretty decent POC on it. Basically it is the newest approach to streaming and replicating data for a variety of use cases. It does replace Oracle Streams as the approach of choice for real and near-real time data movement.

The evolution of Oracle Portal – meet Oracle WebCenter.

My good friend JP came an talked to us about Big Data and did this great drawing about the architectures and where all the parts, tools, and engineered systems fit in the overall picture. Pretty cool. As you see below – no PowerPoint slides were used. Instead he used a tool called Paper Show and drew as he talked (like the old days with transparencies).

JP and his Big Data Picture

Here is just a shot of all the ACE Directors hard at work listening to a session, asking questions, pondering, taking notes, pictures, and of course Tweeting up a storm.

Oracle ACE Directors at Work

So that is it for my very first ACE Director meeting. Thanks to OTN and Oracle for putting this on and letting me participate. Quite the learning experience.

On to OOW and the Oracle Music Festival (with a rest for my brain first on Saturday).

I’ll give you another update in a few days (and maybe fill in a few blanks)

Cheers.

Kent

ACE Director and Oracle Data Warrior

If I tell ya…Oracle ACE Director meeting: Day 1

Wow.

This is my first time at an ACE Director product briefing and it is pretty amazing. It is a who’s who of Oracle talent from around the globe getting updated by Oracle execs and product management.

I feel very privileged to be part of it.

Lots of cool things coming your way, but until it is all public next week at OOW 2012, well…I can’t tell you much. NDA and all. Sorry.

I think I am safe showing you the topics and presenters:

Agenda Day 1

And here is a picture of me and my longtime friend and colleague Rich Niemiec, world-class DBA extraordinaire. This was in front of the main Oracle buildings in California, and the old Oracle racing yacht early this morning before the meeting started. I had not been on the Oracle campus in a very long time.

Kent and Rich at Oracle HQ

Here is one cool slide I can share. It shows the oracle Fusion Apps that Red Robin has implemented. Not that I care that much about Oracle Apps, but I do like to eat at red Robin. 🙂

It was a great day. My brain is tired.

More stuff tomorrow. Then downtown to prep for OOW 2012.

Stay tuned to this bat channel…

Kent

P.S. Check out this infographic about Oracle OpenWorld. Huge!

ODTUG KScope12: Day 2

So another extraordinary, information filled day in San Antonio, with a bit of pathos thrown in for depth.

Started the day again with Morning Chi Gung. Another nice group of folks dropped by to try it out and a few hardy souls returned to try again. I think they are all getting the hang of it and enjoying it. We will do it again in the morning.

First session of the day from me was OBIEE Answers vs BI Publisher from Borkur Steingrimsson of Rittman-Mead.

image

Borkur did a great job of highlighting the pros and cons of each toolset and outlining some of the use cases for the two tools. While there is some overlap, there are definitely some best practices to follow to help decide which to use for what.

One tool does not fit all.

Next session was mine: Introduction to Data Vault Modeling for an Oracle BI Environment.

I had a good crowd (below) to pitch data vault modeling to. Talked about where it fits and how this modeling approach can be leveraged in OBIEE and with Oracle’s Exalytics platform. The audience was small but I think they got a lot out of the talk.

Lots of note taking going on!

Next another information packed session from Tom Kyte about the various options in the Oracle database for securing your data.

He talked about many things including Oracle Total Recall, Audit Vault, and Database Vault (not to be confused with Data Vault Modeling), and Oracle Advanced Security option. Yes most of these cost more money for licenses but you really do need to think about how you protect your data and from whom.

Tom gave us a lot to think about.

Next, my favorite, lunch! Sort of a cook out style lunch with hamburgers, slaw and the fix’ns just in the exhibit hall.

In the picture you have some of the BI crowd (Stewart and Kevin) chatting with the Optimizer Queen (Maria). Lunch at Kscope is where many questions get answered and problems solved.

After lunch we had the official KScope12 (or was it 2022?) General Session complete with “special” effects and time travel.

Edward did a “this is your life” style interview with ODTUG President Mike Riley. Along with some good-natured ribbing, we also got some serious announcements:

  1. Mike Riley stepped down as President
  2. Monty Latiolais was appointed the new President
  3. Edward got “fired” as conference chair
  4. Mike got named conference chair for 2013
  5. Our long time executive director Kathleen McCasland handed the reins over to Crystal Walton so she could focus more on managing the great meeting company she has built, YCC.

There were many awards given including a Lifetime Achievement award to Kathleen (bravo!) and one to Mike for all he has done as President. Oracle Contributor of the year went to Kris Rice; volunteer of the year to Karen Cannel; editors choice award to Peter Koletzke and Duncan Mills.

And the BIG announcement was that KScope13 will be in New Orleans. Registration is open at http://kscope13.com

But wait there is more… I attended more great sessions in the afternoon and evening including another session from Tom Kyte on SQL secrets.

And Steward Bryson’s riveting session on how to use OBIEE against a transactional schema. (I did have a hard time getting a good picture because he NEVER STOPPED MOVING!)

Yes, that is Stewart in a suit…

He has nailed the approach to making OBIEE treat just about any schema design like a dimensional model. Very cool, a bit tricky. Next year we may do a joint session about making a data vault model work in OBIEE without having to instantiate a star schema data mart first. Stay tuned…

To end the day (sort of), we had an excellent and inspiring keynote from Cary Millsap (@carymillsap).

He had lots of inspiring and  insightful things to tell us based on his own life experiences as a father, husband, and business man. I can’t really do it justice so I will give you a few quotes from his slides:

Thinking clearly is more important than the right answer

To teach, test the code path, not just the memory

The goal of a parent: Kids who are interested in figuring out how to use what they are learning

Life is not linear (one of my favorites)

And the biggy:

Happiness is not a state. Happiness is a state change.

So do something BIG.

It really was a great talk.

And to finish out the day (for me anyway) I went to the BI Mad-Dashboard networking event. With Kevin McKinley as the host and Rittman-Mead providing the adult beverages, we had a good time networking and playing some interesting games.

There are actually even more networking events going on into the wee hours but that is it for me today (or I would not have gotten this blog post done).

But that is one of things that makes ODTUG and KScope so great is the opportunity to network and bond with colleagues old and new from around the globe in a relaxed setting.

More tomorrow…

Kent

ODTUG KScope12: Day 1 Symposium Sunday

Wow. What a day!

Started off with leading a Chi Gung class at 7 AM to about 18 attendees. Great start to the day.

Then it was off to the races with the kick off of the BI Symposium, chaired by Kevin McGinley. I got to be “interviewed” about my  Data Vault Modeling session on Monday ( I will report on that tomorrow) , along with several other presenters. That was followed by a lively talk show-style discussion led by Kevin and Stewart
Bryson. Below see the room and audience in attendance at 9:00 AM on a Sunday. (pretty good turn out – way better than last year!)

image

The panel discussion was followed by a series of talks from Oracle BI product management. There was lots of talk about mobile BI, Oracle’s acquisition of Endeca and of course BI in the Cloud.

(At this point I switched tracks to the Db development symposium chaired by Chet Justice aka @Oraclenerd)

The next talk I attended was by Kris Rice (@krisrice) who gave an intro to Oracle SQL Developer Data Modeler. (Nicely he plugged my Data Modeler talk on Thursday)

Some review (for me) and some new stuff too. I learned his trick for showing the joins between views – use the view to table utility to convert the views to tables, add PKs, then use the Discover Foreign Keys feature. This creates FKs based on column names and know PKs.

Cool trick. Just gotta remember to set “generate DDL” to “No”.

Quick switch back to the BI Symposium to see some screen shots of a new look and feel for OBIEE with modern mobile themes.

More coolness…especially if you are an iPad sort of geek.

Back to DB dev land (is it lunch yet?) to hear Oracle product manager Jeff Smith (@thatjeffsmith) take about full lifecycle development using SQL Developer.

Lots of great tips from Jeff about generating table api’s, using version control, doing schema diffs, and unit testing.

SQL Developer definitely has lots of features I did not know about. Being able to define unit tests inside the tool seems like a valuable option. I will be getting folks at my client site to try it out next week!

Oh yeah – he also mentioned DB Doc for creating HTML documentation  on your code because code is never really self-documenting. Gotta check into that more too…

<Lunch break – yummy Italian selection of salads and food>

Post-lunch back to BI and Mike Donohue from Oracle talking about reporting on data from “beyond the data warehouse.”

Heaven forbid! (well I guess we gotta deal with it now)

So, Mike talked a bit about how Endeca Information Discovery can be used to gain understanding and build analytics on big and unstructured data. Mentioned “faceted data model” and generating a key value store. Sounds cool. Have to look into that too.

Mike also discussed using BI Publisher to allow users access to local data (in Excel, XML, OLAP, etc)  so they can build their own reports. Scary thought but, in some businesses it will make sense because in reality not all data is in an ERP system or a well built RDBMS.

Whata gonna do?

<Back to DB Dev>

No to hear the world-famous Tom Kyte (of Ask Tom fame) talk about his approach to tuning. It was, as expected, a full house.

Tom’s main point was not to necessarily tune the specific problem query but more holistically to look at the overall algorithm (or approach) that was taken to solve the problem in the first place.

In his experience many queries can’t be tuned all that much when what was written was not even the best way to solve the problem. He gave quite a few eye-opening examples where there was simply a much better way to accomplish a task than the SQL that was originally written. Seems many situations really require re-engineering the solution.

A nice take away (that makes you go “duh”):

More code = More bugs

Less code = Less bugs

Moral of the story – find the simplest solution. If the code is really complex, you are probably wrong (or at least over complicating it). Try again.

Last symposium session for the day (for me) was Maria Colgan (Oracle) talking about tips to get the most out of the Oracle Cost Based Optimizer.

Maria is the queen of the optimizer. She explained what the optimizer will do in several situations and why and if it is wrong, what you need to change to get it right.

Okay – already on brain overload (and it is just day 1!).

Need sleep.

Have my own presentation tomorrow.

And Chi Gung at 7AM.

C ‘ya

Kent

P.S. There were lots of tweets all day with more pictures of the event. To see them look for #kscope and @ODTUG on Twitter (or follow me @kentgraziano).

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!).

Post Navigation