Utility Management Database System
Designing a database warehouse and analytical reporting system that monitors environmental controls and energy usage to save energy and low costs.
RESPEC staff has worked closely with the University of New Mexico (UNM) to create and maintain a database warehouse for monitoring and reporting on environmental controls and energy usage in buildings across the campus. Using data extracted from the UNM’s integrated software system (a system that collects and manages data from the University Physical Plant, which provides electricity, steam, chilled water, and domestic water through its own distribution systems), the RESPEC-developed software provides a charge-back system to the campus for energy usage. The system has a sampling rate of every 5 to 15 seconds and returns a rapid response for analytic queries and reports, which were also developed by RESPEC. The UNM has approximately 90 buildings with various controls in each building that sends data to the system.