Enhance the User Experience, Streamline Data Management
CIMA’s website was originally built to be static. Any change, even simple content, required a complex
The monolithic database architecture was too slow for modern user expectations, completely reloading site content with every user request.
While complying with the security and regulatory demands of their industry, CIMA needed to dynamically integrate data from Socrata, a third party API.
A Fresh Approach to Database Architecture
The Edrans solution prioritized agility. A multi-layer database architecture changed how the user interfaced with CIMA data. The data access layer (DAL) improved agility, reducing the time spent incorporating new metrics from days to minutes.
Edrans also created a data gateway between the CIMA and Socrata databases. Using a Unesco API, Edrans established a local cache of data, accelerating its delivery to the end user.
To decouple informational updates from platform development, Edrans used Drupal’s open source content management system (CMS), enabling publication of new content in real time, without the involvement of the development team.
The Technical Story
To create an efficient, stable workflow that can manage a large amount of data, we implemented microservices using SQS to consume data from a variety of third-party APIs. The results are stored
in the AWS DynamoDB NoSQL database.
Node.js microservices running on Docker in AWS Elastic Container Services (ECS) expose the data to the website.
Continuous, Efficient Improvement
Today, the CIMA user experience is greatly improved and the development team focuses on new features, not content updates.
The agile, multi-layer architecture makes it easier to add or improve specific modules without disrupting website performance. Workflows allow the content team to update content and respond faster to changing business priorities.
AWS EC2, AWS S3, Node.JS, Ember.JS 2.0, Redis, Drupal