it-state

Statistics estate before modernisation

Statistics estate before modernisation The estate as it runs today, in three zones read left to right. COLLECTION holds a CAPI survey tool on PostgreSQL, hand-maintained ASP.NET web portals, and an external civil registry outside the organisation's control. PROCESSING holds the Windows shared drive with no version control — the primary bottleneck and focal component — plus analyst workstations running SPSS, SAS, Stata and Excel, and an on-premises SQL Server tinted as a likely survivor of the migration. DISSEMINATION holds the legacy publishing portal, the second bottleneck, a static public website refreshed quarterly, and external ministry partners. Hand-offs are named by their real transport: CSV, EMAIL, COPY, LOAD, EXCEL, WEB and CSV download. Identity and observability footer bars span the canvas below the zones and emit no connectors. Collection Processing Dissemination CSV CSV EMAIL COPY LOAD EXCEL CSV WEB CSV DL CAPI survey tool PostgreSQL · field tablets sync on return no automated export schedule ASP.NET web portals hand-maintained by one developer no version control, no tests Civil registry external — outside our control extract arrives as an email attachment Windows shared drive no version control, no access log primary bottleneck — every hand-off passes here Analyst workstations SPSS · SAS · Stata · Excel, per-machine licences scripts live on desktops, never reviewed SQL Server on-premises, single node, nightly tape backup expected to survive the migration Legacy publishing portal releases assembled and uploaded by hand second bottleneck — six-week release lag Static public website quarterly refresh, hand-cut HTML tables no machine-readable endpoint Ministry partners external — consume published downloads re-key figures into their own reports Identity manager Active Directory · LDAP · SSO — covers the estate, wired to no single system Observability server logs · host metrics · email alerts — no data-pipeline coverage System that exists Bottleneck (focal) Likely survivor Outside our control File hand-off Touches a bottleneck External leg