view counter

Data Warehousing Feed

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

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

NaBloPoMo is here! Need some inspiration?

Reblogged from WordPress.com News: It's November 1st, and National Blog Posting Month--NaBloPoMo--is upon us. Time to put your thinking cap on, fire up the computer, chug some extra coffee, and get a-postin'! Bookmark these resources for days when you need a little something extra, and leave a link to your site in the comments so [...]

List of Top Data Vault Resources

As I finished out my latest contract, my team mates wanted to know where they could go to get their data vault questions answered (besides emailing me!). So I put together this list for them and figured the readers of my blog would probably like to see the same list. Here it is! My Stuff Introduction to Data Vault [...]

view counter