Case Study Archives - Database Performance Management - Remote Database Services

The Customer is the largest independent biotechnology company reaching millions of patients around the world, and developing a pipeline of medicines with breakaway potential. Facing major growth restraint as a result, they chose to move datacenter servers running Oracle databases onto their more dynamic and flexible Relational Database Service (RDS) for Oracle on the Cloud offered by Amazon Web Services.

The Customer is a leading global financial services corporation with the need to migrate database and data from their existing legacy DB2 mainframe platform to Oracle Exadata 12c to achieve better operational efficiencies and business outcomes. The Customer elected to migrate to Oracle Exadata for reliable database performance, scalability, and reliability.

The Customer is a transportation firm, operating nationwide. They were facing operational challenges in their database environment due to resources constraints in handling growing volumes of data. They were aware that a major upgrade of their existing IT infrastructure was required to handle the data growth and turned to mLogica for assistance.

TicketSocket, an Independent Software Vendor (ISV), is transforming the way companies use ticketing, with a white label software platform that any business can use to integrate into their website or application, enabling it to sell and redeem tickets, and as well as process registrations and credit card transactions with total control. Additionally, TicketSocket is providing their customers with AWS based data analytics and reporting. TicketSocket also provides their customers with the ability to perform deep, Artificial Intelligence-based, social analytics of their customers’ end users, business influencers and movers, and key social/business metrics for competitive intelligence to better enhance their business.

The Customer – a national vocational education and licensing company for the insurance and securities industry – was running an older, unsupported version of MySQL which could not be upgraded despite mounting performance problems. mLogica was brought in to assess and analyze their current MySQL environment, then suggest and implement performance and tuning recommendations.

The Customer is a global investment management firm. They were facing a number of operational and performance issues with their legacy SQL Server environment and had limited resources to support a complex environment of over 500 databases and replication servers that was error prone and slowing down business user performance. Additionally, documentation was missing; and processes and procedures were not established. mLogica was brought in to help remediate these issues and provide 24*7 operational database support.

The Customer is the world’s leading independent distributor and provider of supply chain management services to the global aerospace industry, The Customer was using a data warehousing solution running JD Edwards on an AS/400 DB2 platform and required assistance migrating data structures and data to an Oracle 12c Cloud based Data Mart so that they could perform advanced analytics and reporting.

The Customer maintains 350+ legacy Sybase/SAP servers to operate several of their mission critical applications. Over the years, as the Customer’s resource allocation to their system has grown, Sybase itself has seen its market share – and consequently, support for their product – decrease rapidly, putting at risk the Customer’s ability to manage their critical Sybase databases.

The Customer, one of the leading online retailers in North America, required mLogica’s assistance to identify and then implement the end-state architecture of their newly acquired Microsoft SQL Server database on their public cloud platform. This would allow them to understand, and fully utilize, the SQL Server’s advanced features such as high-availability, failover clustering, in-memory performance, advanced security, and in-database analytics.

The Customer’s legacy Sybase systems crashed over a weekend; their business ground to a halt and they were, in effect, out of business. They needed mLogica’s help with the triage and troubleshooting of their downed system and bringing it back online as quickly as possible; the mLogica technical team worked non-stop for 48 hours to bring the servers up.

The Customer, one of the largest private banks in the United States, decided to evaluate and re-platform their DB2 UDB (Universal Database) environment onto an Oracle Exadata to improve performance and reliability. Challenges with the Customer’s existing environment included availability, maintenance, and scalability of the legacy database platform which was leading to serious system performance issues in terms of data loads, aggregations and data “timeliness” across architectural tiers. In addition to this was the rising cost of DB2 resources and infrastructure amid decreasing DB2 market share.

The Customer is a prominent US state agency providing healthcare and human services within its state boundaries. It was using a data warehousing solution developed about two decades back built on Sybase IQ platform, which was rapidly reaching end-of-life and resulting in major operating challenges. Consequently, the Customer was looking to replace their hardware, upgrade or replace existing software, and migrate data for their Client Services Data Warehouse (CSDW).

Brabble Inc., the creator of the “All-In-One Social Media & E-Commerce App” was facing database and server issues with their application in terms of scalability and performance, Their mobile application was riddled with issues that was creating an unsatisfactory user experience. As a result, adoption was uneven and falling.

The Company decided to standardize not only the dev/ops but also all of their mission critical databases and migrate everything to AWS including their Oracle workload. They engaged mLogica to analyze the issues impacting Oracle/E-Business Suite performance, and help pinpoint the problems and root causes of the application slowdown.

mLogica was brought in to replace existing managed services support for the Customer’s SAP IQ database environment and to streamline its operation. The existing database architecture, in heavy use by their multiple-end customers, was proving increasingly inadequate and expensive; unable to keep pace with the Customer’s operational growth and usage. For example, the database was slow almost on a regular basis, its size in Terabytes growing substantially, rapidly and unsustainably.

The customer had become increasingly dissatisfied with a costly Teradata platform hindering their ability to meet reporting and business goals related to performance and scalability. There was a reluctance to migrate from Teradata as the environment had received significant customization investment and due to the cost, complexity and scale from previous project estimates, including time to market from five to seven years.

IBM has made public that they will be ending support for their legacy Netezza databases at the end of June, 2019 and, at this time, the only migration path which IBM is offering is to DB2. IBM’s future state roadmap for this technology is unclear. These factors understandably compelled this major Global Bank based in United States, to modernize their legacy Netezza environments.