Here’s a Random Thought

Computer Science and numbers go hand in hand, so it should be of no surprise that I look at things and see angles, counts, averages, probabilities and order. I also spend some time playing games of chance and slots, more as an escape than anything else. It amazes me how many superstitious players waste their... Continue Reading →


The New Normal

Here's another reason why spreadsheets don't make the grade. Normalization. This is the practice of analysing sample data to determine whether or not a particular column or field should be 'off-loaded' to what we call a lookup table. I'll provide examples, but don't confuse this with our discussion of Relational. Relational is addressing the parent-child... Continue Reading →

It’s my Field of Work

As a designer of database applications I have plenty of tools and techniques at my disposal. One such item is the field. One might think of it as a spreadsheet column, only far more. Columns have several data types, but a database field has those and so much more. Though they may have text and... Continue Reading →

Grow up to be a Big Boy

Or act like a big boy now. A bigger company. Think for a moment of some of those tech-like data exercises that big companies have but you don't. Larger companies collect information on some aspects that may seem needless, but they do it to keep employee needs and safety in mind. Have you considered a... Continue Reading →

Simple is better

It's one thing to go nose to the grindstone building a data repository, but it's another to make something that no one can understand or even maintain. One of the first steps a professional developer takes is to simplify what once appeared complex. We have an advantage here because we come from the outside. Your... Continue Reading →

We will be the Best

At this time I am working on a project, not initiated by myself, but imagined by my client. They are a commercial grower of a particular type of flower that is in high demand. Management there has a vision that they can push their extensive knowledge of growing, history, factors, techniques and controls into a... Continue Reading →

No Darkroom for Processing this Picture

I mentioned in an earlier post how important it is to capture data at every milestone in the process. It follows that this entails first identifying the steps that make up that process. A process is not the assembly line that makes the product. That might only be a manufacturing step. Where did the materials... Continue Reading →

They are so intellectual

Let's examine two small businesses in Niagara Falls Ontario. What might distinguish one from the other? The factors we find may tell us how they compete. OK, they each have a small unit, building or storefront. Hmmm, nothing different there. How about vehicles? No, they each have a small cargo van. Big deal. Staff size?... Continue Reading →

A different perspective

Aside from training in computer science and data management, my career has given me the opportunity to witness many companies and their underlying information. This affords me the ability to consider additional data items that would prove beneficial as well as others which are simply clutter. I can orchestrate capturing data input in a way... Continue Reading →

Powered by

Up ↑