I would like to bring to your attention a significant issue that we face today in creating fully integrated systems for the government. Our current approach involves creating systems in silos, and then we try to integrate them. However, the more systems we have, the more impossible integration becomes. We must rethink how we create enterprise systems to overcome this challenge.
One of the significant weaknesses of our current approach is exposed when we attempt to aggregate data from multiple systems into a data warehouse for reporting and AI. While we try to stuff more functionality into a single system, there is only so much that these systems can handle before they become too complex.
To overcome this challenge, I believe that we need to create systems by business unit that have an inherent capability to exchange data and to aggregate data from many different systems for a data warehouse. I have created an open-source platform using Postgres that accomplishes this objective. The platform is designed to manage common types of data encountered by every organization, such as contact and financial data. It also includes a robust financial module, central audit logging mechanism, data exchange mechanism, and a mechanism for aggregating data from many different business systems.
The vision is that teams will download the core system and then extend it to meet the unique needs of a business unit. The business unit systems will be networked together so that data is only entered once and shared securely with every other business unit system that needs it.
This approach is ideally suited for a complex government that includes a public healthcare system and education system. To address this need, your teams would create systems by business unit, and then all the systems would be networked together so that data was only entered once and shared with every other business unit that needed access to it. The platform would also support aggregating data from many different business unit systems into a data warehouse for reporting.
I have created a proof of concept system to show how the systems would be constructed, and I have also published a book based on the platform (https://technicspub.com/breaking-bad/). Additionally, I have developed a website and moved the source code to Github.
I believe that this approach will revolutionize the way we create enterprise systems and enable us to create fully integrated systems for the government. I urge you to consider this approach and to explore how it can be implemented in your organization.
Please contact me if you have an interest in learning more about this approach.