| Gliffy Diagram | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Tony Damiani, Jeff Christen and Sarah Christen met on 8/19/2011 to discuss options for reducing data redundancy. Notes for this meeting below.
after STARs go live there was a pilot project to allow campus developers to create 'shared functions'. These functions were developed in a development environment, migrated to and tested in test then voted on by a campus developer group. Those that were deemed useful to all were migrated to production for others to use and are still being used today. This pilot also allowed for local data to be brought into a shared environement. there were two ways for this to happen.1. If data was something that all campus groups could use, useful mapping tables or other commonly used data, these were brought in the production datamart as SVAT (Student Value Added Tables). 2. If the data was only used by one area it was often done in a private (personal) schema but only used in the test environment, which is a nightly copy of production. This met the needs for the pilot project. Along with this project there was a group of people from CIT, Central Student office and campus developers who met on a regular basis to facilitate this pilot project.
...