One Web Search Database to Rule Them All
Box Clever began work to provide a single source of all objects and specimens online with a seamless browsing and search experience. A database was constructed to query the University of Alberta Museums 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
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.
Data Imports
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.