University of
ConnecticutAbout the Data Warehouse
The Data Warehouse is a repository of University data from campus transaction systems. Some examples of transactional systems are Student Administration System and the FRS system. Data is extracted from the campus transactional systems, put into the Data Warehouse, and is then retrieved and analyzed at the customer's desktop.
The Data Warehouse is built from the transactional systems. Data is identified for inclusion, checked for redundancy, and restructured if necessary (using a combination of fields to create a new field). Once the data is identified, it is put into the Data Warehouse. The data is periodically refreshed, determined by the static/nonstatic nature of the data, need, etc. Some Data Marts are refreshed nightly, others not as frequently. This data is for queries only, any changes to data must be made in the transactional system.
Updated:08.22.2007:ldg