Many to many, A Data party!

The Relational Database structure has a certain elegance about it. When performing data modelling, you do not want to run into a many to many relationship. Thankfully, in my 20 years of building databases for businesses of all types, I never ran into a relationship I couldn't tame. Most every collection of data can be... Continue Reading →

Advertisements

Learn to Walk before you can Run

There may be a concern regarding any new undertaking, especially one that is not in your primary area of expertise. Let me assure you that I understand this, having been a business owner myself, and that there are ways to structure efforts according to your appetite. Here are the steps we would tackle for any... Continue Reading →

Were two birds in the bush worth it?

"My business buddy, Bob, had a team of programmers in to build the database for their company. Between them, a new server and software licenses, they spent a fortune!" That is not what I am proposing. I am speaking to businesses that are in the spreadsheet love-affair phase, so I can use an existing data... Continue Reading →

This expression was common in offices around the turn of the millennium. It referred to the notion that even with a ¬†database system running (in) your business, if the wrong data is entered, the result will be erroneous, misleading, corrupted or just plain garbage! This is where the novice gets into trouble. Even a simple,... Continue Reading →

Logically Speaking…

Logic came from the Greek work Logos meaning 'word' and 'reason'. In the process taken by the Data Modeler to arrive at the best Schema for a Relational Database,¬† Logic plays a heavy role. Aside from using observation, interviews, market orientation and simulations, the Data Modeler uses problem solving via logic and deductive reasoning. A... Continue Reading →

Programming your DVR is not the same

Aside from a language strictly used for semi-layperson access to most relational databases, which is called Structured Query Language (SQL), custom database systems and any systems involving a user interface, use Programming. Programming Languages come in many forms and have steep learning curves, but their common purpose is to calculate, direct computer resources, manipulate the... Continue Reading →

You should be on a Cloud, not under one.

I searched a long time for a product that could help transition the 'wandering' small-business owner from spreadsheets to Relational Databases, in The Cloud. Having worked in Information Management for decades, it was several business owners who had hit a brick wall and reached out to me. Automating their firms was vital and paid them... Continue Reading →

Large institutions are not always better

Around 2003 I was introduced to a government agency where the staff routinely used spreadsheets to store a myriad of information. Unfortunately the data was often way to wordy, used colours prolifically and would have far to many columns to be useful. Only a few people could update the files since sharing was not an... Continue Reading →

Don’t Fear The Cloud

I have spoken to many clients, especially pre-2000, who were deathly afraid of having their computers or networks attached to the Internet. "Oh no. My competitors will steal my information!" Yesterday's Internet was pretty solid and very useful. Today's Internet is something no one can do without. We use it even when we don't think... Continue Reading →

Powered by WordPress.com.

Up ↑