Auto schema evolution capability for OLTP cloud-based, multi-companies financial application
Ability to respond to customers' needs in very timely fashion
Challenges
The financial application is an OLTP system requiring ACID compliance. Required the capability for rapid deployment and refactoring of database structural modifications and database installation software build, regardless of the complexities of the change.
Approach
- Established standards, security patterns and the business logic.
- Design the database infrastructure with abstraction layers for the frontend/UI tier of the SaaS.
- Installed an automated generator that builds/rebuilds the database infrastructure, maintaining the complete integrity of the data APIs at all times.
- Ongoing design and development of database objects and the database installation software.
Outcome & Impact
- Application version upgrades: 90% faster than the industry average
- Capabilities to deploy richer application features quickly
- Agile ability to respond to customers' enhancement requests
-
Join me in a virtual coffee chat!
Any data and/or technology question you feel doesn't sit right? Do you have a challenge at hand you need to resolve or seek direction? I can help you. Schedule a free 30-minute discussion now.