Project
- Exhibitor search
Client
Requirement
Publically available search for companies which are represented in the Munich fairs as exhibitors. The presentation of the exhibitor data depends on the ordered services. Integration with fair portals. High efficiency. Applicable to different fair meetings/events. Based on an existing database structure.
Solutions
The biggest challenge was to ensure the appropriate efficiency - input of different search criteria to initiate a search based on different indexes with a great number of joins. This problem was solved by a dynamic structure of the queries, dependent on the search criteria selected in each case. In the Java version, common search queries are cached in static variables. The Java integration was reached by using wrappers and parametrized links. The PHP version integration problems were avoided by using common phpCube libraries.
The implementation of the application for different fair events while retaining the look & feel was accomplished by explicitly separating the design from the application logic.
Technology
In the first version JSP was used. Logic and database access was implemented using Java classes. In the second edition PHP with the framework phpCube was applied. Logic and data base access was implemented using PHP classes.
The system was based on the Oracle 8i data base.
