THE CHALLENGE
Over the past 40 years, the Aurum Group has grown to become one of Canada's leading suppliers of all aspects of restorative and cosmetic dentistry, with dentures being one of their most important products. Aurum had been relying on software that was nearly 15 years old and operated specifically on the original Macintosh Power PC, leaving Aurum with little room to upgrade the software to meet procedural and market changes.
Our challenge was to re-develop Aurum's software to create a fundamental tool for Aurum Ceramic's everyday business activities, with new functionality and cross platform capability.
THE SOLUTION
Aurum's original software allowed users to save information on patients who would be receiving dentures to a central database. The administrator could then draw out a denture diagram, save this diagram, and print out a copy to send to a dentist for approval. Unfortunately for being such an outdated software piece, the database was limited to a small amount of records and had to be cleared every so often to make room for new patients.
During the process of completing the profile of a patient, the user would often have to switch between software to accomplish a specific task. This often created confusion and resulted in lost data.
Through the technologies of Adobe Coldfusion MX, MYSQL, AJAX, Adobe Flash 8 and Flash Remoting MX, Media Dog produced a software solution that is far superior to Aurum's existing tools. Within the framework of a web-based application, administrators are able to log in from any computer located on their intranet, regardless of the platform of the computer.
Once logged in, administrators can view a large database of patients, which is easily searchable, and stored at a central location, ultimately consolidating Aurum's patient data. No longer will Aurum be deleting existing records to make room for new patients, as the new MYSQL database has enough room for millions of patients.
From there the administrator can view patient information, associate them to specific doctors, edit their diagrams, and even produce a web-ready PDF on-the-fly, without switching any program.
This solution went above and beyond what their existing software piece had done, all within one easy to use interface.
THE RESULTS
- Extensive database functionality increases access and number of patient records
- Flash-based denture diagram creation tool makes it easy to create custom patient diagrams
- Central database consolidates data and decreases the likelihood of patient error
- Easy to use software solution
- Extremely satisfied client
