Graphical User Interface Generation

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.


The customer wanted a highly-functional solution, including:

  • Single and one-to-many table presentations
  • Transactional capabilities against individual and multi-table record sets while maintaining referential integrity and consistent application of complex business rules
  • Context-sensitive filtering and record navigation objects
  • Ability to navigate by tracing foreign keys from one presentation set to another

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.


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.


This case demonstrates how Codiscent’s Generative Engineering tools and methodology can:

  • Accelerate the design and delivery of prototype solutions
  • Support iterative solution definition and development, providing better functional coverage and promoting early error defect detection and removal
  • Provide agility, allowing the solution to be re-implemented in an alternative technology easily
  • Promote focus on solution architecture, rather than just implementation

Comments are closed.