Saluton Mondo

My name is Jacob Mastel.

I'm an Analyst Programmer at Oregon State University. For the last 7 years I've worked as a member of the CORE team. As a member of this team, I've worked on a wide variety of projects including:

  • Canned reporting
  • Data visualization
  • Dashboard design
  • ETL operations
  • Database administration
  • Data analytics

Outside of work I like to play every shiny computer toy I can get my hands on, be a photographer, and occationally see the scary orb in the sky. This site is still under construction, so check again soon to see if anything has changed.

Recent Blog Posts

Aggregating Using Unpivot

A common task when analyzing data concerning a population is to determine how various subpopulations compare to one another. If the sub populations are nonoverlaping populations, a simple group by clause will usually solve your problem. When they overlap however, you have to find other solutions.

Read All
When Join Order Matters

It's a popular belief that the order of a SQL query's join order doesn't matter so long as the joins are done as an inner join [1]. In a simple world, this is true. Unfortunately, life is rarely so simple.

Read All