Make a mountain out of a molehill

That could be your business, and should be. Your company started from a seed, an idea. If it is worthy, it should grow larger. The soil supporting that growth is your information, your business data. However, and sorry for more analogies, think of all your hard work as the watering can. Without the soil to... Continue Reading →

Advertisements

It really is lonely at the top

Let's say you have a dozen employees, you're  making and selling 300 widgets per week, but you want to sell 500 and open a second location. Are you ready? Aside from the logistics issues associated with expanding, you have to duplicate a few things. First, yourself. You can't be in two places at once. You... 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 →

I’ma gonna schema to helpa you succeed

My apologies to the Italian community. I mean no disrespect. I just needed a lead in. Anyway, rather than describing what a Schema is in database terms I will borrow a definition courtesy of Wikipedia: "In psychology and cognitive science, a schema (plural schemata or schemas) describes a pattern of thought or behavior that organizes categories of... 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 →

How to secure your 45s and LPs

It's called Record Locking, and one of the main benefits of using a Relational DataBase as opposed to spreadsheets. With spreadsheets sharing among users is tenuous at best. In order to ensure any data integrity, the whole file must be locked when one person is making a change, and it won't matter if it was... Continue Reading →

And now for a triple threat, the RFQ.

This should be easy for a business person to remember, however, in this case it doesn’t mean Request For Quotation. Let’s say you are using a spreadsheet, and you don’t want to see all of the client list, but only those who live in Albany, NY. You invoke the Filter option. In addition, you can... 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 →

Let`s Lookup something

The Lookup Table is a list of frequently used attributes that help qualify records of a more significant status. Let`s see what I mean by using lookup tables to help complete a customer record. The record will have the client name, street address, city, state or province, zip or postal code and perhaps, country. There... Continue Reading →

Powered by WordPress.com.

Up ↑