Database Optimization Case Study .pdf
Original filename: Database-Optimization-Case-Study.pdf
This PDF 1.5 document has been generated by Adobe Illustrator CS3 / Adobe PDF library 8.00, and has been sent on pdf-archive.com on 14/07/2016 at 14:20, from IP address 121.242.x.x.
The current document download page has been viewed 216 times.
File size: 403 KB (2 pages).
Privacy: public file
Download original PDF file
The Digital Group
A leading provider of local community focused web applications with
sites in more than 32 countries and over 600 cities. They are one of the
fastest growing local community reach sites in the industry. Central to
their offering is a housing share service which offers users the ability to
post, search, and browse available units. The application performs a
comparison of profile needs and provides updated category matches which
users can view on demand or through automated emails. These services
are delivered through a membership driven web based application and
managed by local site administrators.
The core databases for the housing share solution were unstable and becoming more inconsistent as information and
demand continued to increase. As new cities, countries, and application features were being added, the database
integrity began to be noticeably affected and even resulted in frequent system downtime during critical peak activity
periods. The client was losing revenue.
The business objective was to engage in a focused database analysis and performance review that would deliver an
executable plan to make the databases more efficient and reliable while delivering in the fastest time to production
The Digital Group’s database performance experts reviewed the existing databases to capture a baseline from which
to measure stability and performance gains, as well as to create an optimization plan that identified top level issues.
The engineering team then executed an iterative process of performance tuning, indexing, and script optimization
while tracking measured results at the end of each milestone.
After stabilizing the system the team evaluated and implemented a database replication service that would significantly improve system performance while guaranteeing the platform’s stability without significantly impacting
After completing the performance and stability operation, The Digital Group took responsibility for ongoing monitoring support and high level issue resolution. This activity is performed on a weekly basis from their Australia
Through the use of the database monitoring and performance program, the client was able to achieve and deliver a
new level of service without having to make a heavy investment in an application re-write. As a result, their product
now offers its users an unmatched level of performance and usability which is now helping them to secure an even
stronger market position.
SOLUTIONS | SERVICES | CONSULTING
Some of the specific benefits achieved include:
Operational cost savings
» Utilizing high quality / low cost offshore resources
» Avoidance of application re-write
Reduced error rate and increased efficiency
» Increased performance through optimized scripts & queries
» Stability through replication
» Ongoing system monitoring identifies problems early
Headquartered in Princeton, New Jersey, The Digital Group was incorporated in 1999. Today
The Digital Group (T/DG) is the leading provider of a broad range of Information Technology
services. With offices in US, India, Australia, Fiji and Sri Lanka T/DG provide support from
the conceptualization phase, leading to development and operations. The team have been
consistently delivering industry leading solutions to its valued customers for over a decade.
The Digital Group is a certified SEI-CMMi Level 5 for Development (DEV) and CMMi Level 3
for Services (SVC) version 1.3 along with certifications in ISO 9001:2008, ISO 20000-1:2011,
ISO 27001:2013 and SSAE 16, Type II.
The Digital Group Inc.
121 Village Boulevard Princeton
Forrestal Village, Princeton,
NJ 08540 USA
Copyright © T/DG 2015. All rights reserved
SOLUTIONS | SERVICES | OUTSOURCING