Author: Robert Hamel

Increase your data visualization/reporting velocity and performance with proper semantic layers

We have all seen it before.  You finally get access to new data sources and want to extract insight from that data. You open your favorite reporting or data visualization tool, connect and start updating the tool’s semantic layer. The…

Read More >

MySQL Conference 2010 – Last day

The morning’s keynotes again were quite good especially the one from Ubunto. I attend another packed Facebook session and one from Ronald Bradford. It was the first time I head him speak and he is very good. I didn’t attend many of the afternoon events because of customer commitments but the remain group at the hotel had a passionate discussion on Oracle role in the MySQL community so its far from over and Oracle has one year to fix it. See you all next year

Read More >

MySQL 2010 Conference – Day 2

We started with the morning keynotes again today and I was a little surprised at the snipping going on. The first session that I attended today were around MySQL partitioning in the beta releases and beyond. The next set of sessions were on IO bottlenecks, MySQL data warehousing and finally Danil’s Security session. Finally there was the Ignite session that just finished a few minutes ago which was quite entertaining with lots of nice rapid fire topics. That’s all for today…Last day tomorrow

Read More >

MySQL Conference 2010 – Day 1

Well the first day has come and gone and I really enjoyed my first day as a newbie. The keynote from Oracle was well received, they touched on the new Beta version of MySQL and the new mysql enterprise which to a trained oracle eye is looking more and more like Grid Control. The end result is providing more instrumentation to help the DBA but I am a little disappointed that a lot of that instrumentation is not actually in the database itself which forces you to buy the product.

Read More >

Book Review of Guy Harrison’s Oracle Performance Survival Guide

This is the first time I have read one of Guy’s books and I was very impressed at the breadth of topics that are addressed and especially the approach that is followed starting from the application design rather than trying to find the elusive fast=true setting that resolves every problem.

Read More >

Simple MySQL Auditing

Simple auditing can save you tons of time while troubleshooting. I came up with some simple stored procedure that will compare two data sets and keep track of the changes historically. It’s loosely based on slowly-changing dimension type 2 in the data warehouse world. This method tracks only changes, so you should be able to keep historical rows forever, unless you are constantly dropping and creating whatever you are tracking.

Read More >

Date Dimension vs. Function-Based Indexes: Is the Date Dimension Still Relevant?

The purpose of this post is to verify if a date dimension is better in regards to performance and functionality than a series of function-based indexes on a date column in the fact table.

Read More >

Oracle 11g: New Pivot Table Feature

I was very pleased when I heard about Oracle adding pivot functionality in select statements. Finally — we wouldn’t have to copy the data to a spreadsheet or code a ton of sum(case when col1 = ‘X’ then amount else 0 end) total_X for each column we would want to display. I am basically looking for three things in a pivot-style query: the ability to specify which column will be pivoted as one or more columns in the resulting query, row subtotals, and column subtotals. The first item is the only one that really matters. I can work around the other two, so let’s get started.

Read More >

Implementing Many-to-many Relationships in Data Warehousing

This article will discuss how to make many-to-many relationships in data warehousing easily queried by novice SQL users using point-and-click query tools.

Read More >