Case Studies
Department of Justice: Web-enable a national database
Project: Web-enable a national database
Technologies: Active Server Pages (ASP), Microsoft SQL, Microsoft IIS, XML, XSLT
Services: Software Development,Software Interface Design
Domains: Web Applications
Situation. Individual Canadian law enforcement departments each have their own rules and methods for creating chargeable crimes based on the guidelines of Federal and Provincial statutes. The Department of Justice wanted to create an electronic “common offence table” database that would replace the current paper system across Canada and be more accessible to remote locations and more responsive to changes in the Criminal Code.
Solution. Macadamian teamed with Ajja Information Technology Consultants Inc. to deliver a state-of-the-art Internet application prototype. The Common Offense Table, a proposed common repository of the country’s federal and provincial statute information and chargeable offences would be publicly accessible by stakeholders in Canada’s criminal justice system.
Benefits. The new Common Offence Table automates the process used to create chargeable offences, freeing resources by reducing the paperwork for law officers and reducing the margin for error.
"The Common Offense Table is a ground-breaking e-Government initiative. Our alliance with Macadamian combines Ajja’s 20 years of IT management experience with Macadamian’s ability to manage and deliver complex software projects."
— Armand Guillemette, Vice-President of eBusiness Solutions at Ajja
Profile. The people of the Department of Justice work to ensure that Canadians enjoy a justice system that is fair, accessible and efficient. They help the federal government to develop policy and to make and reform laws as needed. At the same time, they serve Canadians by acting as the Government's law firm.
