|
|
|
Application Development & Performance Optimization
From defining requirements, planning and design to implementation, integration, and testing,
SATS delivers robust, cost-effective solutions in record time.
Our approach makes the process transparent to your team with precise control all the way through.
We use industry standard tools and methodologies, as well as our own tools developed over the
years to save time and minimize cost.
Our experts honed their advanced skills by creating complete and partial solutions for banking,
financial, e-commerce, news/media, entertainment, and many other industries.
Case Studies
Problem: Initial installation of a vendor application was not planned for growth and required
capacity. With DB growth at 1GB/month, users complained about slow reporting speed and screens
speed. Client, a city transportation agency, contracted SATS to assist with the problem.
Requirements: Preserve business continuity and assure future growth
SATS Solution: Speeds increased 5 -15; capacity assured for 12 month growth
Approach:
-
Based on analysis accomplished with Cerberus Technology, performed complete instance rebuild,
space management of all objects, and upgraded to current Oracle version.
-
Tuned parameters and tuned SQL.
-
Implemented high availability with standby instance.
Problem: Vendor of Banking Credit Application was notified that its client
a European Bank - was unable to accept and process more than 200K Credit Cards
transactions a day, which resulted in loss of revenue and reputation for the Bank.
Vendor engaged SATS to solve the problem as quickly as possible.
SATS Solution: Increase credit card transactions to 500K /day with capacity to
grow to 1mln/day on existing hardware and applications. Increase speed 3-5 times.
Approach:
-
Database structure optimization
-
Optimization of Application code
-
Application partitioning
-
Capacity planning
Problem: After one year of using a vendor's Customer Reservation
Software, a
Cruise Line was unable to complete transaction within required time, nor to run
consolidation reports and other vital processes. Vendor approached SATS for help.
SATS Solution: Configure DB to handle cruise reservations volume growth, and
restore performance to original speeds and 100% functionality.
Approach:
-
Optimized Oracle database (init parameters, block size, tablespaces, parallel processing)
-
Implemented efficient space management of database objects.
For more information please call 650 288-1701
or fill out SATS Services contact form.
|
|