|
The Engineering and Construction Group of one of the world's
largest providers of oil field services and has operations in more than 100
countries.
The client planned to re-engineer and enhance their existing system developed
with a 2-tier architecture into a 3-tier, which would be scalable and reliable
to withstand the heavy network traffic. They also intended to segregate their
business process layer of the application into separate modules. Further the
client also asked for a methodical case study of the existing systems failure
on design and development and incorporate those feature limitations into the
re-engineered system.
The technical analysts’ of SCMC studied the entire working
process of the system and came up with the causes for the failure of the
system. It was found that the system had lots of architectural limitations.
It was found the existing system architecture didn’t fully
adhered to Microsoft’s Enterprise Development Strategy, combining Internet and
three-tier client/server applications. With the present limitations, both with
design and implementation of the business logics it was very remote to achieve
high performance and scalability.
Further the existing system used number of connections to the
database from the COM and as the network traffic increased or when the users
accessing the system came under concurrency (more than one user accessing the
resources at the same instance of time), the existing system was unable to
handle the bottleneck. Further the system maintained, “connected record sets”
which were carrying the overload of active connections to the database.
SCMC came with a plan to develop and re-engineer the existing
system through Microsoft Solutions Framework (MSF), adhering to “ACID” during
Transaction and Microsoft's Enterprise Development Strategy, combining Internet
and 3-tier client/server applications architecture. The existing system was
fully re-engineered with the new design and architecture and the entire
business logic was encapsulated in COM+ components and deployed in Component
services / MTS so as to avail the benefits of Transaction services,
Statelessness and Database connection pooling and disconnected record sets.
And it was found in the final analysis of the re-engineered
system; 2,000-user using this stateless system with a think time of one minute
would require (on average) fewer than 40 database connections only. As the
number of clients rise into the hundreds and thousands, the newly built
stateless components conserved server resources and produced maximum
performance out put against a compressed database size of 14.8 GB.
Some of the key features of the new system are:
-
Better performance
-
Scalable
-
Careful usage of system resource
-
Stateless system Components
-
Disconnected record sets
-
Optimal memory usage
-
Maintainable and upgradeable
| Operating System |
Windows 9x,NT, 2000,XP |
| Programming languages |
VB 6.0 |
| Middleware |
COM, COM+, ADO 2.5 |
| RDBMS |
MS SQL Server 2000 |
| IDE |
Visual Studio 6.0 |
| Scripting languages |
Java script, VB script |
| Web technology |
ASP 3.0 |
| Middle-tier framework |
MTS, Component Services, IIS |
| Analysis / Design |
Visual Modeler, VISIO |
| Development Methods |
Object Oriented |
|