Scenario : Signet provides web based project management application for their customers. The application uses JSP/Servlet - PL/SQL combination running on Tomcat Server and Oracle database. The system is an ASP model maintained by Signet for the past 4 years.Due to increase in number of customers, Signet wants to host the project management application in one of the reseller's server in New York for USA customers alone. One of the legal statement from Signet resellers privacy policy states that all software licenses should be purchased by the reseller to avail the reseller scheme. The issue here is, New York reseller does not have oracle license, so Signet decided to use MySQL database at New York hosting.The business team states that the application will be deployed on most of the reseller's server to increase the performance of the application. Signet is not interested any more to add any infrastructure software apart from web server and database. |
|
What is the best solution you would recommend for Signet architecture by considering business forecast? |
Choice 1 | Use Signet hosting for all customers and do not use reseller's server. |
Choice 2 | Move all the business logics into Java layer and avoid PL/SQL, so that the application can support database portability. |
Choice 3 | Implement PL/SQL for MySQL database and deploy it in New York′s reseller server. |
Choice 4 | Use EJB components for business logic and remove PL/SQL from database. |