Archives for July 2013

New on DBTA.com: Database Benchmarking Tools, the final article in the database benchmarking series

In the last several articles on Database Trends & Applications, I've been describing the benefits of reading and analyzing the benchmarking case studies released by the Transaction Processing Council. I've given you from a broad overview of the TPC benchmarks and shown ways that the vendor-published TPC benchmarks can help you save money and how the vendor-published TPC benchmarks must explain in disclaimers how they tweak their workloads. I have described how to run your own benchmarks and explained how to properly prepare your environment for a benchmark test. Pictured (L-R): Scott … [Read more...]

The New PASS Executive Committee of 2014

I'm sure you can understand the high level of interest I have in the internal affairs and governance of PASS.  After all, I was one of the founders of the organization way back in 1999 and was president for four years from 2003 through 2006 (fondly remembered as "the hardest fricken years of my life"). So I was keenly interested when the latest press release from PASS named the incoming PASS Executive Committee to take their seats on January 1st, 2014. The executive committee is composed of the officers of the organization, that is, directors who are empowered to sign contracts and to speak … [Read more...]

My Advice About Growing as an IT and Data Professional

First off, I should apologize for not blogging in quite a while. I've been traveling extensively and, because traveling can be so exhausting, I usually have to queue up blog posts to hit while I'm traveling in order to remain active while on the road.  I didn't do that for these most recent trips.  And, as you can see, there's quite a gap between this post and my last few posts. On the other hand, I've experienced an unexpected surge in requests for mentoring and advice from friends and colleagues about career growth.  I'm always happy to help out a friend and, in fact, there's little in my … [Read more...]

MySQL, NoSQL, and NuoDB

I've been keen on MySQL ever since I first started using it heavily more than a decade ago.  In fact, I liked it well enough to include it as one of the four main database platforms, over and above the ANSI-ISO SQL standard, in my popular book SQL in a Nutshell. However, with the advent of NoSQL data platforms in the last few years, the waters have been muddied.  It's no longer a quick easy decision as to which database platform you should use, both because there are many new platforms to choose from and because the old, easy choices aren't as cut and dried as they used to be.  MySQL, for … [Read more...]

What’s the Data Modeling Standard for Business Intelligence Systems?

I had the good fortune to overhear some of my good friends and fellow MVPs discussing the process of data modeling for business intelligence systems.  So what are the industry standard approaches for modeling dimensional data modelling? The short answer is that Kimball's dimensional modeling is the most widely adopted standard for any sort of data warehouse. Inmon is also well respected. But the consensus is to stick with Kimball, especially if you're looking for something an enterprise standards team is going to recognize as "standard". The book on my shelf and which I most … [Read more...]