tag:blogger.com,1999:blog-71365154461055664252024-03-19T04:31:15.268-07:00Database Migration a Cost-effective StandardizationSigmahttp://www.blogger.com/profile/03805283771675224528noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7136515446105566425.post-88955696758724944302012-07-06T02:57:00.001-07:002012-07-06T06:54:38.618-07:00Case Studies :<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="separator" style="clear: both; font-family: "Trebuchet MS",sans-serif; text-align: center;">
</div>
<br />
<br />
<div class="separator" style="clear: both; font-family: "Trebuchet MS",sans-serif; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXQPR672ka35g4GEPyiCJk3DDnM5Qye3TSHWqPFrfdjyj5JY05tLWgmWjp3vt-JuVJpjE18gKjKRUrDjRZvGpB0wVdyMRy8gCrqbwGUSHhLzhTRfh4xPEVRtAk28dgPO9vEXAWB0uJnxU/s1600/7.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="330" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXQPR672ka35g4GEPyiCJk3DDnM5Qye3TSHWqPFrfdjyj5JY05tLWgmWjp3vt-JuVJpjE18gKjKRUrDjRZvGpB0wVdyMRy8gCrqbwGUSHhLzhTRfh4xPEVRtAk28dgPO9vEXAWB0uJnxU/s640/7.JPG" width="640" /></a></div>
<br />
<div style="font-family: "Trebuchet MS",sans-serif;">
<br /></div>
<div style="font-family: "Trebuchet MS",sans-serif;">
<br /></div>
<div style="font-family: "Trebuchet MS",sans-serif;">
<b><span style="font-size: large;"><span style="color: #274e13;">Executive Summary </span></span></b> </div>
<div style="font-family: "Trebuchet MS",sans-serif; text-align: justify;">
Client since its inception has been at the forefront of technology and has steered the course of the telecom sector in the country with its world class products and services. </div>
<div style="font-family: "Trebuchet MS",sans-serif; text-align: justify;">
<br /></div>
<div style="font-family: "Trebuchet MS",sans-serif; text-align: justify;">
Client’s DSL subscriptions were growing at rapid pace in Tamil Nadu circle. The Operations Support System (OSS) is buckling down and is not able to scale up to the growing needs. The OSS was built in-house 5 years back and was developed on primitive version of one of the free database - MySQL. In order to meet the growing needs, as a first step, Client decided to migrate the database of OSS from MySQL 3.x to Oracle 10g, a leading database for enterprise applications. The key to making this operation efficient Client approached Sigma Infosolutions.</div>
<div style="font-family: "Trebuchet MS",sans-serif; text-align: justify;">
<br /></div>
<div style="color: #274e13; font-family: "Trebuchet MS",sans-serif; text-align: justify;">
<b><span style="font-size: large;">The Client</span></b></div>
<div style="font-family: "Trebuchet MS",sans-serif; text-align: justify;">
Client is a leading global telecommunications company with operations in 19 countries across Asia and Africa. The company offers mobile voice & data services, fixed line, high speed broadband, IPTV, DTH, turnkey telecom solutions for enterprises and national & international long distance services to carriers. Client has been ranked among the six best performing technology companies in the world by business week. Client had 200 million customers across its operations.</div>
<div style="font-family: "Trebuchet MS",sans-serif; text-align: justify;">
<br /></div>
<div style="font-family: "Trebuchet MS",sans-serif; text-align: justify;">
<b><span style="color: #274e13; font-size: large;">Business Case</span></b></div>
<div style="font-family: "Trebuchet MS",sans-serif; text-align: justify;">
<br /></div>
<div style="font-family: "Trebuchet MS",sans-serif; text-align: justify;">
OSS for TN region has several limitations relating to its database such as:</div>
<ul style="text-align: left;">
<li><span style="font-family: "Trebuchet MS",sans-serif;">Maintaining application is tedious as one needs to know quite older version of database and which doesn’t support some of the basic operations like sub-queries, stored functions etc. and thus in order to maintain the application,programmer needs to apply some of the workarounds which makes<span style="font-family: "Trebuchet MS",sans-serif;"> application more fragile.</span></span></li>
<li style="font-family: "Trebuchet MS",sans-serif;">Carrying out enhancements and tweaks to application are more effort intensive and error prone as MySQL 3.x has lot of limitation in various SQL syntax like Stored Procedures, sub-query etc. support is not there in 3.x version.</li>
<li><span style="font-family: "Trebuchet MS",sans-serif;">90% of reports can not be generated or take a very long time, making </span><span style="font-family: "Trebuchet MS",sans-serif;">application unusable at times. Due to erroneous data model and slow query </span><span style="font-family: "Trebuchet MS",sans-serif;">retrieval engine of MySQL 3.x, this issue is being faced right now.</span><span style="font-family: "Trebuchet MS",sans-serif;"> </span></li>
<li><span style="font-family: "Trebuchet MS",sans-serif;">With the growing number of subscriptions, scalability of OSS is big </span><span style="font-family: "Trebuchet MS",sans-serif;">roadblock as data retrieval engine in MySQL 3.x is quite primitive and thus </span><span style="font-family: "Trebuchet MS",sans-serif;">with larger set of data, retrieval would become even slower.</span><span style="font-family: "Trebuchet MS",sans-serif;"> </span></li>
<li><span style="font-family: "Trebuchet MS",sans-serif;">As current data model is not optimized and tuned, Analytical </span><span style="font-family: "Trebuchet MS",sans-serif;">reporting/Dashboard not possible with current database structure. Oracle </span><span style="font-family: "Trebuchet MS",sans-serif;">has many inbuilt features like Materialized views etc. to take care of </span><span style="font-family: "Trebuchet MS",sans-serif;">analytical needs of application.</span></li>
<li><span style="font-family: "Trebuchet MS",sans-serif;">In current application creation of data dump is not efficient and thus data </span><span style="font-family: "Trebuchet MS",sans-serif;">requirements of legal department are not easy to fulfill.</span><span style="font-family: "Trebuchet MS",sans-serif;"></span></li>
<li><span style="font-family: "Trebuchet MS",sans-serif;">User Interface design not intuitive; options are cluttered on screen, no </span><br style="font-family: "Trebuchet MS",sans-serif;" /><span style="font-family: "Trebuchet MS",sans-serif;">separate “tabs” to operate on logically grouped options.</span></li>
</ul>
<b><span style="font-size: large;"><span style="color: #274e13; font-family: "Trebuchet MS",sans-serif;">Successes</span></span></b><br />
<div style="font-family: "Trebuchet MS",sans-serif;">
<br /></div>
<span style="font-family: "Trebuchet MS",sans-serif;">Migration of OSS Database from MySQL 3.x to Oracle 10g. Sigma has extensive experience in managing large scale data migration projects for large enterprise customers. Sigma is well versed with MySQL as well as with Oracle and has resources having expertise in database related issues.</span><br />
<div style="color: #274e13; font-family: "Trebuchet MS",sans-serif;">
<span style="font-size: large;"><b><br /></b></span></div>
<span style="color: #274e13; font-size: large;"><b style="font-family: "Trebuchet MS",sans-serif;">Solution</b></span><br />
<span style="font-family: "Trebuchet MS",sans-serif;">Sigma Infosolutions’ development team successfully compiled the architecture </span><span style="font-family: "Trebuchet MS",sans-serif;">required for the project and followed waterfall model ensuring that the integration of </span><span style="font-family: "Trebuchet MS",sans-serif;">the system </span><br />
<span style="font-family: "Trebuchet MS",sans-serif;">proceeds along with user testing.</span><br />
<br />
<b><span style="font-family: "Trebuchet MS",sans-serif;">Key Modules Developed </span></b><br />
<span style="font-family: "Trebuchet MS",sans-serif;">o Mapping of complex relationships from disparate sources</span><br />
<span style="font-family: "Trebuchet MS",sans-serif;">o Faster retrieval of data from OSS</span><br />
<span style="font-family: "Trebuchet MS",sans-serif;">o Fast scale up and maintaining the application became easier as it is now compatible with latest version of Oracle</span><br />
<span style="font-family: "Trebuchet MS",sans-serif;">o Better and standard way of data retrieval architecture was applied </span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsJfh554-dVsXi5NJCL5bNm3zy0raNBHbZAdT2HiAHGPM1W59KEWt83f_W-as513XZWjwCAdH6qJ_nGuelF6T44KvGa1QhUsnUc9GSG2qnFPUq61PVQVxmxitVv7uUePyAwwPyDeh_uVQ/s1600/7.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsJfh554-dVsXi5NJCL5bNm3zy0raNBHbZAdT2HiAHGPM1W59KEWt83f_W-as513XZWjwCAdH6qJ_nGuelF6T44KvGa1QhUsnUc9GSG2qnFPUq61PVQVxmxitVv7uUePyAwwPyDeh_uVQ/s320/7.JPG" width="243" /></a></div>
<br />
<br />
<br />
<div style="font-family: "Trebuchet MS",sans-serif;">
<span style="color: #274e13; font-size: large;">Technology</span></div>
<br />
<ul style="font-family: "Trebuchet MS",sans-serif; text-align: left;">
<li>Oracle Database 10g</li>
<li>MySQL</li>
<li>J2EE</li>
</ul>
<span style="font-size: large;"><b style="color: #274e13;"><span style="font-family: "Trebuchet MS",sans-serif;">Business Benefits</span></b></span><span style="font-family: "Trebuchet MS",sans-serif;"> </span><br />
<ul style="text-align: left;">
<li><span style="font-family: "Trebuchet MS",sans-serif;">35% cost savings on functionality</span><span style="font-family: "Trebuchet MS",sans-serif;"> development</span><span style="font-family: "Trebuchet MS",sans-serif;"> </span></li>
<li><span style="font-family: "Trebuchet MS",sans-serif;">Complete set of data, functioning</span><span style="font-family: "Trebuchet MS",sans-serif;"> alarms in real-time</span><span style="font-family: "Trebuchet MS",sans-serif;"> </span></li>
<li><span style="font-family: "Trebuchet MS",sans-serif;">Ongoing operating costs at or better</span><span style="font-family: "Trebuchet MS",sans-serif;"> than budget</span><span style="font-family: "Trebuchet MS",sans-serif;"> </span></li>
<li><span style="font-family: "Trebuchet MS",sans-serif;">Low system overhead and lower</span><span style="font-family: "Trebuchet MS",sans-serif;"> support costs </span></li>
<li><span style="font-family: "Trebuchet MS",sans-serif;">Monthly technical availability is</span><span style="font-family: "Trebuchet MS",sans-serif;"> more than 99%</span></li>
</ul>
<span style="font-family: "Trebuchet MS",sans-serif;"></span><span style="color: #274e13; font-size: large;"><b><span style="font-family: "Trebuchet MS",sans-serif;">Next Phase </span></b></span><br />
<span style="font-family: "Trebuchet MS",sans-serif;">Oracle 10g offers many more new </span><span style="font-family: "Trebuchet MS",sans-serif;">features of the shelf and this reduces the </span><span style="font-family: "Trebuchet MS",sans-serif;">efforts needed to carry out </span><span style="font-family: "Trebuchet MS",sans-serif;">enhancements in the future. Many of </span><span style="font-family: "Trebuchet MS",sans-serif;">these have been proposed to Client in the </span><span style="font-family: "Trebuchet MS",sans-serif;">approach document from Sigma and can </span><span style="font-family: "Trebuchet MS",sans-serif;">be included in later phases. </span><br />
<br />
<div style="color: #274e13; text-align: center;">
<br /></div>
<div style="text-align: center;">
<span style="font-family: "Trebuchet MS",sans-serif; font-size: x-large;"><span style="color: #274e13;">Performance tuning in practice; a hands on approach </span></span></div>
</div>Sigmahttp://www.blogger.com/profile/03805283771675224528noreply@blogger.com0