welcome! academics and events in one database:
DESCRIPTION
Welcome! Academics and Events in One Database:. How publishing event data from a single source can enhance communication, minimize risk and assist in disaster preparedness. Tammy Miller Business Analyst / Application Administrator University of Idaho [email protected]. Opened in 1892 - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/1.jpg)
Welcome!
Academics and Events in One Database:
How publishing event data from a single source can enhance
communication, minimize risk and assist in disaster preparedness
![Page 3: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/3.jpg)
• Opened in 1892• Research-based, public land grant
institution• Main campus in Moscow, Idaho plus
three branch campuses• 12,000 students, including grad
students
![Page 4: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/4.jpg)
Why store academic and special events together?
![Page 5: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/5.jpg)
Lots of great reasonsSingle source for event data:– Basis for master calendar– Accurate space utilization analysis– Know where people are congregated on
campus– Avoid double-booking classroom space– Automate building controls and signage
![Page 6: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/6.jpg)
Academics integrated with Special Events in 2007
![Page 7: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/7.jpg)
Environment Changes over Time
• Contracted for event scheduling software to be delivered via SaaS late 2009
• Upgraded to new event scheduling tool that includes calendar publication
• Began creating event calendars for internal use:– Calendar for report production in RO– Calendar of smart rooms for Classroom
technology group
![Page 8: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/8.jpg)
2010 – The story behind this story
![Page 9: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/9.jpg)
It was a busy summer…
![Page 10: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/10.jpg)
I was on vacation…
![Page 11: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/11.jpg)
And sleeping soundly when…
![Page 12: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/12.jpg)
No chilled water was reaching the NOC
![Page 13: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/13.jpg)
July 2, 2010 in IdahoPipe break floods UI building with 6 feet of water
Damage in the ‘six-figure’ rangeMoscow-Pullman Daily News
The University of Idaho’s J.A. Albertson Building is closed indefinitely after a nearby water line broke late Tuesday or early Wednesday and flooded the building’s electrical room
with about 6 feet of water.
![Page 14: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/14.jpg)
Meanwhile, in another city in another state
• An application server stops functioning and doesn’t fail-over
• The server is restarted• But University of Idaho Citrix
permissions are somehow lost• And in the morning, no one is able to
sign in to the Events application
![Page 15: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/15.jpg)
Emergency + no data = very bad!
![Page 16: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/16.jpg)
What can we do…?
![Page 17: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/17.jpg)
We can leverage one of our new tools!
![Page 18: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/18.jpg)
Location calendars can serve as a source for redundant data:
• Application servers separate from Publisher servers (distinct data sources)
• Immediate access to event data• Data can be easily communicated
(shared)
![Page 19: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/19.jpg)
Constructing Location-based Calendars
![Page 20: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/20.jpg)
View what is happening in one room, on one floor, or in the entire building:
![Page 21: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/21.jpg)
Click on an event for details
![Page 22: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/22.jpg)
Select from all or any events to report
![Page 23: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/23.jpg)
Many options for data delivery!
![Page 24: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/24.jpg)
The data is shareable:
![Page 25: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/25.jpg)
Event detail in email:
![Page 26: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/26.jpg)
Download event data to another calendar:
![Page 27: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/27.jpg)
Key data elements in calendars that are critical to emergency response:
• Location• Head count• Event sponsor contact information
![Page 28: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/28.jpg)
Key elements of calendars useful for emergency management:
• Quick access to relevant data• No time consuming queries or reports
to produce• Multiple ways to communicate the
data
![Page 29: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/29.jpg)
Key elements of calendars useful for emergency management:
• Role in preparedness• Role in response• Role in recovery
![Page 30: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/30.jpg)
Expanding on the available key data:
![Page 31: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/31.jpg)
Add links to floor plans
![Page 32: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/32.jpg)
Add links to calendars for other buildings in proximity
![Page 33: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/33.jpg)
Event data flow and distribution:
![Page 34: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/34.jpg)
What makes these calendars private?
• Events are unfiltered, everything published
• Building plans are sensitive data• Web search for URL is not activated• Distributed to select audience• Option to protect with password
![Page 35: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/35.jpg)
Issues with location calendars• Data feeds are batched, not live• Duplicate events occasionally created• If event moves, old and new location
listed• Canceled reservations not always
removed• All campus events not accounted for
![Page 36: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/36.jpg)
How were location calendars received?
![Page 37: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/37.jpg)
Location calendar distribution:• Registrar’s staff• Building managers• Building schedulers• Landscape and Exterior Services• Emergency and Security Services• Facilities and Building Services
![Page 38: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/38.jpg)
Academic and Special Events in one place
Many reasons for taking this approach – the most compelling are:
– Ability to analyze space utilization– Ability to communicate where people are
congregated on campus at any time
![Page 39: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/39.jpg)
Caveats• Not all activities represented in event
database• Calendar data should be double-
checked against a standard query or report run against the event data source
• Publishing calendars for emergency use might inspire you to become a first responder
![Page 40: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/40.jpg)
Be Prepared!
![Page 41: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/41.jpg)
Questions?
![Page 43: Welcome! Academics and Events in One Database:](https://reader036.vdocuments.us/reader036/viewer/2022081604/56816874550346895ddee759/html5/thumbnails/43.jpg)
Thank you!