Complex Business Rule Implementation

A client approached Oasis Digital with a system already under development which implemented a set of complex interrelated business rules for a sales data calculation process. Their existing implementation accessed a RDMBS in a very granular way, running hundreds of thousands of queries, and taking hours to complete. It was a solid start, but not suitable for large scale use.

To accommodate their rapid growth in data volume, Oasis Digital created a next-generation solution for this problem. Our solution elevated the business rules out of the data access code and out of database queries, into a “domain specific language” form suitable for direct review and validation by our client’s business experts. To make it possible to validate the rules, we created a test-suite mechanism. With that in hand to ensure correctness, we optimized the processing extensively, eventually making it possible to complete the calculations in minutes even with a very large transaction volume.

Technologies: Delphi, Interbase, DSL

Next: Data Access Architecture Consulting