Data Architecture

Mr. Anderson has acted as Data Architect on several projects for ministries of the Province of British Columbia.

Typical Responsibilities

Develop Conceptual, Logical, and Physical data models.

Design physical databases that provide not just a place to store data, but that also contain mechanisms that:

  • meet high-security accessibility requirements
  • meet performance requirements
  • execute data-integrity rules that must be enforced regardless of the application accessing the data

These databases include:

  • application-specific views to be used by developers to access enterprise data
  • data-access procedures and functions that enforce enterprise data-integrity rules
  • virtual private databases

In 1999 Mr. Anderson pioneered in Victoria the use of Oracle’s Fine Grain Access Control capabilities for BC’s Freedom Of Informaion tracking system (CRTS).  He has re-used this high-security framework with both the Ministry of Public Saftety and Solicitor General's CORNET (2006) and Family Justice Services Division’s FIS2 system (2008).  His implementations ensure that, even if individuals manage to by-pass the normally appropriate front-end applications and gain direct access to Ministry data, they will see and be able to change only data to which they previously have been granted access.