About the Client
The University of Alberta Museums has 29 unique collections, with millions of items.
About the Project
For years, the university's collections were dispersed across 29 stand-alone websites, making it incredibly difficult for researchers to find the information they were looking for with ease. The websites were unresponsive and were all built and designed in isolation from one another, so the experience in accessing information varied widely.
One Web Search Database to Rule Them All
We began work to provide a single source of all online items with a seamless browsing and search experience. A database was constructed to query U of A’s museum collection management database system (MIMSY), the backbone of their impressive collection.
Through our familiarization with MIMSY and multiple focus groups with staff, students, researchers, and faculty, we determined all collections could be amalgamated into a single web search database.
Challenges with field mapping
With such a wide variety of collections consisting of items with very distinct properties, mapping fields from MIMSY into fields within a single database table presented a unique challenge. For instance, the fields associated with a painting from one collection and a meteorite from another collection:
- Creation Date
- Where it is stored
- Discovery Date
- Where it was discovered
Managing Performance and Uptime
With web integrations that import or export information, there is a higher processing demand that can result in slow load responses and even downtime. To build a search site that was consistently available, fast, and optimized, three databases were required. Two databases hold all the imported catalogue information and the third database is solely for storing all the field mapping and configurations. This database set-up doesn’t just reduce risks associated with downtime, it eliminates it completely.
The website brings in traffic from all over the world. We have identified the off-peak hours to run the daily import which takes somewhere between five to six hours to complete. Because of our dual catalogue database system, site visitors experience no lapse or change in what they are browsing through during their session.
Sustainability and Scalability
The Museums Team has full control over the collections displayed on the website with a simple configuration panel that allows them to tell our system which MIMSY collections to map and import to our web collections and fields.
Northern Lakes College
A custom student registration system that's made simple for Students and Admissions Staff.
Grant MacEwan University Faculty Association
Helping to promote a collegial and exceptional working and learning environment.