J2EE Management System Outsourcing Project Development

 

The Client

Our customer is a major supplier in light industry in Japan. As our client’s corporate size is expanding rapidly and they need a stronger control system over the external sub-companies, they desire a new system to satisfy the business demand.

Requirements

The customer required a much more advanced Supply Chain Management system to implement the information transmission between different directions. For instance, transferring messages from supply phase to manufacture stage. This project will focus on the management with efficiency, speediness, high-quality and low-cost to realize obtaining feedback and master corresponding information timely from transmitting coordination instructions in each department.

RayooTech integrates different separate systems to supply raw material transformation real-time tracking and fluent operation flow. And the system is expected to work in different areas include technical department, sales department, and distribution department.

There are two points in this software development. Firstly, it must provide a fluency work flow between different departments. In addition, it should implement a tracking function of products and materials transformation.

Key Points

1- As the project combines several separate systems, the different existing databases cause the biggest problem. One is that we could not change the database construction. Another difficult point is that the link between original databases in these independent departments is seldom.

2- The project should accomplish the 0database migration to meet the customer need, using Oracle database replace SQL Server afterwards.

3- A limited project period.

4- The requirements were mutable, and we should continue to complete it through development.

5- The business process contains several separate departments, it increase the complexity of software.

6- RayooTech would maintain this product after the Alpha published.

Solution

RayooTech participated from the analysis section to design, implementation and long-distance support. In basis of the Functional Specification which given by client, we completed the design effort by delivering the System Design Specification Document involved architecture chart, class chart, sequence chart, data flow chart, and solution architecture as well as software component design. RayooTech accomplished the development with the database offered by customers.

Considering the maintain work and the hierarchy legible, this project used 3 layers B/S structure based on J2EE standard and built data transformation between the presentation tier and the business logic tier under the standard of open source framework Struts.

In the system we adopted a mainstream framework in Java Web Application development, Struts, to achieve the below functions:

1- Routing: distribution of every page and the related logic processes.

2- Validation: on both customer terminal and data end. In Struts, we implemented some business logic include data type and value scope. We make good use of Validation module in the Struts framework.

3- Presentation: we successfully refrained from the confliction between UI design and coding and enhanced the maintainability of system through the Taglib of Struts.

There is one debate that how to integrate the existing databases into one project. We thought Hibernate which is a strong and efficient Object/Relational mapping method in data layer construction is the best solution of this issue. Under this approach we achieved the data-groups involved some independent databases, and strengthened the flexibility and expansibility to the logic layer.

Achievement

1- Increase the software’s control ability.

2- Decrease the project cost in maintenance and operation area.

3- Improved communication among different departments expediting the real-time transaction.

4- A flexible and expandable system.

5- Timely and accurate stock reporting.

6- Convenient database migration.

Read More