view counter

Data Warehousing Feed

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

East Coast Oracle Users Conference (#ECOracle13) Review

This week I did a little travel and went to Durham, North Carolina to present at the 2013 East Coast Oracle Users Conference (aka ECO). While I have been aware of this event for over 20 years, it is the first time I have attended. It was worth the trip. (Thanks to Jeff Smith at […]

Agile Data Warehouse Modeling: How to Build a Virtual Type 2 Slowly Changing Dimension

One of the ongoing complaints about many data warehouse projects is that they take too long to delivery. This is one of the main reasons that many of us have tried to adopt methods and techniques (like SCRUM) from the agile software world to improve our ability to deliver data warehouse components more quickly. So, […]

Our greatest glory…

Our greatest glory is not in never failing, but in rising every time we fall. – ConfuciusFiled under: Quotes Tagged: Confucius, quote

Better Data Modeling: New and Improved Oracle SQL Developer Data Modeler (#SQLDevModeler)

Yup, my friends at Oracle have been hard at working enhancing what was already the best FREE data modeling tool out there. They just released SDDM R4 EA3! You can go get it right now: http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/... As always there are both new features and bug fixes. One of the coolest new features is the ability […]

Better Data Modeling: Finding Missing Unique Keys in Oracle #SQLDevModeler

One of the best practices I recommend is to always define unique business keys for every entity (or table) in a model. It is the only way to really understand what the data in that object represents. So what do you do when you inherit someone else’s model with hundreds of tables and few (if […]

Data Modeling for Fun and Profit: Are you ready to take the Database Design Challenge?

Are you up to publicly testing your database design chops? Want to improve your street cred? If so, then read on… Relational databases form the backbone of thousands, if not millions, of applications and systems around the globe. A key part of building these applications is designing and implementing the data structures they use. (Well […]

Let’s Review #OOW13 and #OTW13 in Pictures

Yes I have been derelict in my duty and not posted about the sessions I attended at Oracle OpenWorld (#OOW13) and OakTable World (#OTW). Well here are the high points with pictures! Monday Monday started off with the now annual Swim the Bay (so I missed the keynote). If you have Facebook, you can see […]

#OOW13 Oracle OpenWorld 2013: #Microsoft, #Cloud, Oh My!

Let me lead with the big stuff first, then I will report on some other sessions I attended later. Live at the #Cloud Keynote This should be interesting – joint keynote with Brad Anderson Corporate VP Cloud Enterprise from Microsoft. This is definitely a first! Brad says Oracle workloads running on Windows servers is one […]

#OOW13 – Oracle OpenWorld 2013: Pictures, Tweets and more

#OOW13 is well underway now with lots of tweets and blog posts already out on the web. Check the stream on twitter under #oow13 for all the news. I tried to see some of the Americas Cup race on Saturday but unfortunately the weather and wind did  not cooperate so the race was called for […]

At the mother ship: Oracle ACE Director Briefing

Well, I can’t really talk about the meeting (yet) as everything is under NDA until next week (at least), but I can say it is great to get together with the top Oracle practitioners in the world and chat and discuss the issues and solutions in our field. It is like returning to the mother […]

view counter