Home >> Case Studies >> Customized Forums/Message Boards Application Software Development

Customized Forums/Message Boards Application Software Development & Outsourcing

Client:
The client is a leading IT software consulting company in Europe. Its parent company is located in the US. The client is specialized in providing ERP implementation and software development outsourcing services to large, medium and small European companies.

Software Platforms: Perl, Linux, Apache Webserver, Oracle 8i

Brief Description:
The target was to use an existing in-house (formerly open-source) message board system and improve it to have industrial strength features and functionality as well as stability. The previous system was running on mySQL database and considering the extremely high message traffic, the system needed improvements in the areas of speed, stability and features.

The eventual system had a very comprehensive message board system which was truly threaded, exhaustive searching capabilities, had an optimized database which included an upgrade to Oracle 8i database system. The existing database table structure was slightly modified, all types of integrity was enforced, a fair amount of SQL queries were modified in order to optimize the database performance using SEQUENCES, TRIGGERS, & PROCEDURES.

After conversion, very extensive testing was conducted since we were about to replace a live system. We also wrote a number of scripts to import the existing mySQL data into Oracle just before the switchover. As expected, the transition was smooth and painless.

Duration
2003

<< back

<% ' [an error occurred while processing this directive] %> [an error occurred while processing this directive]