Canadian Cultural Mosaic Foundation — Hate Incident Tracker
Canadian Cultural Mosaic Foundation (via Data for Good Calgary)
The Canadian Cultural Mosaic Foundation tracks race-based hate incidents across Canada, drawn from English-language media reports, and publishes what the data shows. Census figures are used for one thing only: turning counts into rates per 100,000 people so provinces can be compared fairly.
Where it started
The Foundation’s data lived in an Oracle 19c database with an APEX 24.2 entry application of 74 pages, and its public analysis had been rebuilt more than once by volunteers: R Shiny in 2020, then Dash and Streamlit dashboards. Each tool worked; together they meant four places to maintain and three overlapping ways to enter an incident.
A migration you can prove
DB Realm moved all 443 database objects (55 tables, 32 packages, 30 triggers and the rest) to Oracle AI Database 26ai with zero invalid objects at the end. Row counts were compared table by table against the source, and text and binary columns were compared byte for byte. The legacy application was inventoried down to its regions, items and buttons so that nothing was retired by accident.
Security, rebuilt to fail closed
The legacy pages checked permissions in a way that let a user through if a check was missing. The rebuild inverts that: role-based access per feature, refusing by default, with hardened password storage, lockout after repeated failures, and audit logs for sign-ins and user administration. During the work a public page was found to expose incident-level rows; it now sits behind sign-in, and the public sees aggregates only.
News monitoring with a human in the loop
Every six hours the database checks 28 Canadian news feeds and queues new articles for review. A reviewer approves an article into an incident record, through the same table APIs as manual entry, or rejects it with a reason. The pipeline is ready for AI classification and duplicate detection, but ships in manual mode: the Foundation decides if and when a model is involved.