Commentaries
What you should know about the AHPETC-AIM saga
With the elections coming, I decided to pen this article about the whole AHPETC saga. So far the articles that have been written have always been about the accounting lapses and what not. But none of them were written from an IT perspective. (Maybe no more SG IT professionals since all of them are replaced by FT, including me)
This is what we know so far.
The town council system that was used previously by the old Aljunied is a S$24 million software solution and it was sold to AIM for S$140,000.
I wasn’t involved in the project nor am I a member of WP. But anybody who has done Application Development projects with the government will know this is a huge project and it will probably involve hundreds of developers and testers, a couple of Project Managers and more Business Analysts. The size of the project tells me that they are using Oracle database (its license can easily reach $1million at least).
The type of servers it is running on should be very high end, always turn on and has to be constantly kept cool (Air con is always on. Redundant air cons must be on standby in case the main one failed). This should be at least a 16 months project. I will not be surprised if it is 24 months.
However this is not the main issue. The main issue is the information from the database. And there are lots of it.
For example, these are the scenarios that I can think of.
Who has paid S&CC fees for last month? Who hasn’t? If you haven’t paid, is this your first time? Any reminders send? If so when? If this isn’t the first time, then how many times haven’t paid? If this isn’t the first time, then what are the months that have missed payments?
What type of flat? Based on flat type, penalty fees can be calculated.
Whether you are a PR or a citizen? Because the rates may be calculated differently.
If you have moved to a new flat within the GRC and you have missed the payments, what is the new address? How to ensure that the bill will be send to the new address and not the old?
These are just the tip of the iceberg. For a S$24 million project, there will be hundreds of scenarios more.
So if AHPETC was given 1 month to migrate the data, it will be an impossible task. Because to migrate, you need a new system for the migration to work. You need to migrate from the old to new system.
If there is no new system, then you have to export the data out. Given the time constraint, most likely to Excel files. And it will not be to 1 file. There will be hundreds/thousand of Excel file because of the way relational databases are designed. With Excel, it is very difficult to sort, filter and analyse the huge amount of data.
However that is only half the story.
When the export is done, you will need to import the data to the new system. And you can only do it after the new system is developed. Most likely the new system will be a subset of the old system.
Therefore with the removal of the system from AHPETC, all this information is gone. They will need to manually extract the information from the exported files. Definitely no easy task.
In short, I hope everyone will know the significance of what AIM has done.
Yours Sincerely,
Underemployed
The above article was first published on TR Emeritus.
-
Singapore1 week ago
Purported resignation message from Li Hongyi as Singpass director goes viral; GovTech yet to confirm authenticity
-
Community6 days ago
PAP MP Edward Chia: ‘Sanctions on Israel do not work’ when confronted by Holland-Bukit Timah resident
-
Singapore1 week ago
Lee Hsien Yang alleges rising repression and corruption in Singapore; government calls claims a ‘personal vendetta
-
Comments2 weeks ago
8World News anchor Zhang Haijie faces criticism for labelling Lee Hsien Yang as ‘unfilial son’
-
Politics2 weeks ago
Singapore govt accuses Lee Hsien Yang of creating ‘false urgency’ over 38 Oxley Road demolition
-
Opinion2 weeks ago
Where does Lee Hsien Loong stand on the future of 38 Oxley Road as the government revisits the issue?
-
Opinion2 weeks ago
Where is the iron in Lawrence Wong? Hiding from direct response to Lee Hsien Yang?
-
Politics1 week ago
Charles Yeo claims Singapore is seeking his extradition from UK; AGC remains silent