Branch Management System
A world leading hardware manufacturing company located in Central Europe.
The client required performance improvement and user interface re-design of the Branch Management System, which was initially developed by an Indian team. The client’s main concern was fixing a number of bugs, which had a great impact on the overall functionality of the application. Also, there were more than 70 change requests from end-users that had to be addressed as soon as possible. The main weaknesses of the existing system were:
- Limited capacity. The system was unable to meet a sudden increase in load.
- The all-in-one server approach didn't allow maximizing available resources as the computer couldn’t be optimized for a specific purpose.
As a result of business analysis, Alierra Software decided to migrate the existing Branch Management System from ASP to ASP.NET and improve existing architecture design.
A firewall/load balancer, which is used instead of the firewall, allows distributing load and provides transparent failover for the Web servers. Application logic and static content are separated and put on different computers, which allows the computers to be specifically optimized for the content they deliver. User information in the database can be replicated to an LDAP server. As a result, the load on the database is reduced (particularly, when authenticating a user, which typically results in the computationally expensive operation of a full table scan of the user table on a character column).
Tiers 1 and 2 are independently scalable;
Tiers 1 and 2 can now use hardware appropriate to the task, which is more flexible and cost-effective, especially when using a commercial application server that requires a lot of resources to run;
A standby database is added for redundancy. The primary database is replicated to the standby database, which will take over if the primary fails.
Significant savings due to the flexibility and scalability of the system
Updated user interface, more convenient for the end-users
Increased reliability of the system
Easier system support and maintenance
Localization of the management system & development of a facility for faster translation into any language.
Tools and Technologies
ASP.NET modules based on Web Forms and Web Controls operating on the .NET framework
ADO.NET for MS SQL Server 2000 connection
9 experts: 1 project manager, 1 designer, 2 testers, 5 application developers
7 months project duration