Overview and Business Case A prominent financial services company maintains a large Oracle repository for which it has no online browsing or editing capability. Data maintenance involves downloading a filtered subset into Excel, editing it and then uploading the modified data. This is tedious, labor-intensive and error-prone. Solution Required The customer wanted a new application that would supplant the existing process and which would be easy to use and easy to maintain. Subsequent to receiving the initial POC, the customer requested that we expand the POC to include temporal filtering, the ability to present the data as it would have looked at any point in the past, as it appears currently or as it will appear at any point in the future. Challenges The customer wanted a highly-functional solution, including:
The SQL required to support temporal filtering and maintain transactional integrity was particularly involved and modifying and testing the plethora of components that were affected by the enhancement was substantial. The database contains more than 20 logical entities for which five or six presentation forms, each, were required. Codiscent Solution We built a POC on a Derby database with an HTML presentation. At the client’s request, we enhanced the HTML presentation layer with Dojo, to provide a more professional, finished interface. This required two weeks, followed by the extension that supports temporal filtering, which required an additional week. Results The customer now has a proven solution that will be reliable, easy to maintain, cost-effective and that obviates the laborious and effort-prone process used to maintain the application data. The customer is evaluating requirements to implement a production version of the solution and is anticipating expanding the scope of the solution to encompass a wider range of business processes. Takeaways This case demonstrates how Codiscent’s Generative Engineering tools and methodology can:
|