Databases

Parent-child, one to many and foreign keys in databases

Parent-child relationships, one to many relationships and foreign keys are the basics of databases.  What are they and how are they useful? Technically those names all represent the same thing yet why so many names?   This article looks from a business perspective at the power of this concept and how it can be harnessed. Whilst a very early concept …

Standard measures and the problems they pose

Standard measures are internationally approved amounts and counts to help countries inter-operate.  Yet for programmers they pose massive challenges. This article looks at some of the most common measures and how they pose challenges when internationally used. Based on over a decade of writing systems for international use here are some of the primary challenges I’ve encountered and how I …

Autopostbacks and the challenges of saving in real time

Autopostbacks are a great idea for ensuring information saves in real time until you get poor Internet connectivity.  How, why and where should they be used? The Internet is a blessing and a curse for programmers.  Autopostbacks address an operational challenge faced by web developers. However the reality of poor global connectivity and mobile connectivity introduces further challenges. This article …

Multilingual solutions and how to build them in software

Multilingual solutions require some basic planning and some forethought but how to go about it? More important how far can you go until “it’s not worth it.” This article examines some of the simplest principles in multilingual coding and examines some of the planning considerations. There is no perfect, one size fits all solution.  There are however good guiding principles …

Business Intelligence and the sexiness of data science

Business Intelligence is a part of the Information Systems Pyramid but what does it mean in the context of your business? Sexiness can be defined informally as “the quality of being exciting or appealing.” What could a branch of data science possible have that’s appealing or exciting?   It all depends on what you mean by exciting or appealing. Firstly …

Artificial Intelligence, an introduction in business language

Artificial Intelligence is a massive area which is currently growing at an incredible rate.  How and why is this happening? This article attempts in plain English to explain the major concepts of the area of AI and it’s associated fields. I’m going to do my best to explain this without using maths or using programming… good luck me! I will …

Technology Stacks and what they do for your business

Technology Stacks are grouped combinations of technical choices.  The influence on your business is significant.  What are the tech guys on about? Often abbreviated to single letters these phrases will influence your technical choices for years to come so it’s worth knowing what they are and how they will affect your business. This is a name dropping article under general …

Person-centric design, what is it?

Person-centric design is a way of perceiving systems and data that focuses on the people rather than the system. A person-centric approach is a strategic win for your business. This article introduces the area and its advantages and offers a way of updating your approach without throwing out the baby and the bathwater. Focused on solutions from a business / …