Skip to main content

The reports printed in 1991 on dot matrix printers are no different to today's dashboards on flat screen monitors

No alt text provided for this image

My first job was for the Railways. It was fun working there until I was told that I could not be a member of their pension fund because I was disabled. I didn't stay around to argue the point and moved on to work for a little networking company known as Network Interface Consultants founded by Andre Maree.

There was a two-year probation before an employee was allowed to join the railway pension fund and I slaved away in blissful ignorance in what was to come. I wrote programs in Cobol with embedded SQL. The database was DB2 which was hosted on IBM and Amdahl mainframes. I was assigned to the Information Centre and my boss delegated me to program some MIS systems.

Top 20

The railway wanted some simple reports which they hadn't been able to obtain from the Information Centre for years. Little did I realize that the existing team had attempted and failed to deliver. The report requests were simple. They wanted:

  • Top 20 senders of goods per station
  • Top 20 receivers of goods per station
  • Consolidated Top 20 senders and receivers of goods per station
  • Top 20 types of goods send per station
  • Top 20 types of goods received per station
  • Consolidated Top 20 types of goods per station
  • Everything that wasn't in the Top 20 was aggregated into a 21st item named other.

I disappeared into the sunset trying to write these reports with a few hiccups along the way. One memorable run had a logical flaw that resulted in a run of 23 hours and a bill of R250k. Ouch! Finally, I delivered the program.

The next day they phoned me and said great but they wanted additional reports. They wanted the report not by count but by financial value. Within an hour that was done and dusted.

Branch reports

The next request was to group all the stations into branches, i.e. stations were assigned a branch line number and the reporting was done per branch. The program took longer than what I envisaged as I had made a programming fault and couldn't spot it. It was a whole month before I had it working!

After I had delivered this version I never heard from these guys again. A good many years later I was in a remote railway office and immediately recognized my reports laying on a table. I was impressed that my program was still being used!

The lessons I learnt are:

  • You do not know what it means to be humiliated or discriminated against unless you experience it!
  • The most important things are limited to a small set. Although there were 12 million shipments per year, most people were interested in only a limited amount which translated to their logistical and financial concerns.
  • You can stare for ages at a problem and miss seeing it. It was only when I showed someone else the program to explain the problem, that I was able to fix it.
  • The life cycle of technology is longer that what you are led to believe! I assume the program would still exist and be used if the railways hadn't been state captured and screwed up

Traffic analytics

No alt text provided for this image

Now in modern network the reports we require are no different than these railway reports. The shipping transactions are network flow data, the senders and receivers are IP addresses, the goods are application types, the stations are routers and the branches are groups of locations or regions. I have seen a number of network flow applications but none seem to mimic the railway format and although they report on count, none have a concept of reporting on financial value.


Popular posts from this blog

Why Madge Networks, the token-ring company, went titsup

There I was shooting the breeze with an old mate. The conversation turned to why Madge Networks which I wrote about here went titsup. My analysis is that Madge Networks had a solution and decided to go out and find a problem. They deferred to more incorrect strategic technology choices. The truth of the matter is that when something goes titsup, its not because of one reason only, but a myriad of them all contributing to the negative consequence. There are the immediate or visual ones, which are underpinned by intermediate ones and finally after digging right down, there are the root causes. There is never a singular root cause for anything but I'll present my opinion and encourage everyone else to chip in. All of them together are more likely the reason the company went titsup. As far as technology brainfarts go there is no better example than Kodak . They invented the digital camera that killed them. However, they were so focused on milking people in their leg

Flawed "ITIL aligned"​ Incident Management

Many "ITIL aligned" service desk tools have flawed incident management. The reason is that incidents are logged with a time association and some related fields to type in some gobbledygook. The expanded incident life cycle is not enforced and as a result trending and problem management is not possible. Here is a fictitious log of an incident at PFS, a financial services company, which uses CGTSD, an “ITIL-aligned” service desk tool. Here is the log of an incident record from this system: Monday, 12 August: 09:03am (Bob, the service desk guy): Alice (customer in retail banking) phoned in. Logged an issue. Unable to assist over the phone (there goes our FCR), will escalate to second line. 09:04am (Bob, the service desk guy): Escalate the incident to Charles in second line support. 09:05am (Charles, technical support): Open incident. 09:05am (Charles, technical support): Delayed incident by 1 day. Tuesday, 13 August: 10:11am (Charles, technical support): Phoned Alice.

Updated: Articles by Ron Bartels published on iot for all

  These are articles that I published during the course of the past year on one of the popular international Internet of Things publishing sites, iot for all .  These are articles that I published during the course of the past year on one of the popular international Internet of Things publishing sites, iot for all . Improving Data Center Reliability With IoT Reliability and availability are essential to data centers. IoT can enable better issue tracking and data collection, leading to greater stability. Doing the Work Right in Data Centers With Checklists Data centers are complex. Modern economies rely upon their continuous operation. IoT solutions paired with this data center checklist can help! IoT Optimi