Technological Case Studies

J2EE Case Study – Construction Company


A major international airport was constructing a new 900,000 square foot terminal. This $600 million dollar construction project was managed on an application that Solutions Through Understanding and its sister company, Aptude, created. Through initial design and requirement analysis, it was determined that an enterprise-wide application that supported every detail of airport construction management was to be included with this system. One of our most challenging tasks was to integrate data among disparate systems.


Working with the client, we built a robust Oracle-based data warehouse and intranet application that supports contractors, city employees, architects, Department of Aviation employees and a number of other individuals who at any time desire information from this application. With thoughtful design and planning, this application has blossomed. Utilizing a three-tiered architecture and object oriented design methodologies, it has become relatively easy to add or enhance modules. In addition, because careful attention was paid to database design and data mart considerations, meaningful and strategic data mining could occur regardless of a user’s technical expertise. Today, a central repository houses all of the airport construction information.

Profit Improvement & Customer Satisfaction Benefits

The major construction project was completed on time and within budget. Improved management decision making via the one integrated database.


  • Oracle11i
  • PL/SQL
  • J2EE
  • Business Objects
  • Oracle Reports

Gain Time, Increase Currency, Contact Us

It’s amazing how one quick email can change your life. Give us a shout! We’ll get back to you right away with the right person for what you’re looking to accomplish.

You don't have to go into a lot of detail now, we'll dial it in later.

Aptude provides onsite and offshore Oracle DBA support, which includes troubleshooting, back-up, recovery, migration, upgrades, and daily maintenance of Oracle database servers. Aptude has been working with our team for the past four years and we continue to use them and are satisfied with their work

Warren E., Schneider National

Aptude provided us with Oracle DBA migration support, including an upgrade from Oracle 11.1 to Oracle 11.2, and the project was completed on time and to specifications. The project manager and project consultants were responsive and proactive, resulting in a successful conclusion to the work. I would definitely contract with them again, and have recommended them to other technical offices at the University of Georgia.

David C., University of Georgia