view counter

Data Warehousing Feed

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

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 [...]

Breaking a non-Fitness Habit

After writing about creating a new fitness habit yesterday, I had my own little ah-ha moment today about a bad habit I had formed.. For lunch today, I went downstairs to the building cafe and got a pretty healthy sandwich and some steamed broccoli (instead of fries) and headed outside to eat. There are a few shaded tables outside [...]

Do you have a Fitness Habit?

With my new assignment comes new opportunity. One of those opportunities is the time to exercise a bit more (I just eliminated a rather long commute). What to do and when to do it? How to arrange my new schedule efficiently to get in a work out , do my job, do my user group activities, write blog posts, [...]

view counter