Oracle VM Site Review - Oracle VM Health Check
view counter

Data Warehousing Feed

Oracle Data Warehousing, reporting, online analytics, and data mining resources, news, and support articles.

RMOUG Training Days 2013 – Day 1

Unlike many conferences, today started off not with the keynote but with an actual session (probably some advanced psychology at work here). I started off with John King’s session on Oracle 11g features that developers should know about. (He was going to talk about 12c but since it has not been released yet, he could [...]

RMOUG Training Days 2013 – OTN Lab Day

Today  I arrived in Denver to attend the annual Rocky Mountain Oracle Users Group (RMOUG) Training Days conference. It is one of, if not the, most successful local Oracle user group events in the United States (and has been for many years). For the past few years it has been held at the Denver Convention [...]

Rocky Mountain High and Some Chi Gung

Are you ready? Are you coming? The annual Rocky Mountain Oracle Users Group Training Days kicks off next Monday, February 11 at the Denver Convention Center. I can hardly wait! I love the beautiful surroundings and vibe of Denver and the mountains. It is a great place to hang out, relax, and sharpen your skills. I will be there attending sessions, networking with some old friends, [...]

Data Vault vs.The World (3 of 3)

So far in this series I have compared and contrasted the Data Vault approach to that of  using a replicated ODS or a dimensional Kimball-style structure for an enterprise data warehouse repository. Let me thank everyone who has replied or commented for taking these posts as they were intended, keeping the conversation professional and not starting any flame wars. So [...]

Data Vault vs. The World (2 of 3)

In the first post of this series, I discussed advantages of using a Data Vault over a replicated ODS. In this post I am going to discuss Data Vault and the more classical approach of a Kimball-style dimensional (star schema) design. To be clear upfront, I will be comparing using Data Vault to using dimensional for [...]

Data Vault vs. The World (1 of 3)

Okay, maybe not “the world” but is does sometimes seem like it. Even though the Data Vault has been around for well over 10 years now, has multiple books, video, and tons of success stories,  I am constantly asked to compare and contrast Data Vault to approaches generally accepted in the industry. What’s up with that? When was the last time you got [...]

Tech Tip: Connect to SQL Server Using Oracle SQL Developer

I spend a lot of time reverse engineering client databases to see what kind of design they are working with or to simply create a data model diagram for them (so they know what they have). Along the way I often need to actually look at the data as well to do some analysis and profiling. Often [...]

Happy 2013! What will you do this year?

Happy New Year! Welcome to year #2 of the Oracle Data Warrior. I hope everyone is looking forward to a bright, happy, and successful year (however you measure it). For me it will be a year of figuring out my long term business model (maybe?), writing a few more short ebooks (stay tuned), doing my Oracle ACE Director thing, continuing to work as [...]

2012: Year in the Life of an Oracle Data Warrior

Hard to believe it is nearly the end of the year. But…it is here. I will be taking time until the end of the year so I am doing my “year-end” post now. It was a significant year for me with many new things, events, conferences, and clients. Here is a list, by month of [...]

Have you lost your keys?

Has this ever happened to you: You are starting a new project working on an existing database or data warehouse. Being the great data architect that you are, you of course ask to see the data model. The response: Data model? What data model? Or maybe: Why do you need to see that? Sigh. So you fight your way through getting [...]

view counter