#Japan #Tokyo #Polaris Orbis #Insight SQL Testing #Amazon Aurora

Introduction

Polaris Orbis Holdings has effectively revitalized its core e-commerce site by upgrading its Amazon Aurora MySQL database to version 3, utilizing Insight SQL Testing to automate SQL testing processes. This initiative not only spurred rapid development but also guaranteed an accident-free transition, showcasing how innovative technology can enhance operational efficiency in the competitive e-commerce landscape.

Background of Insight SQL Testing Adoption

Polaris Orbis Holdings, which operates distinct e-commerce strategies for its various brands, pursues maximum customer experience. A significant portion of its core brand, Orbis, generates about 60% of its revenue through online sales. The e-commerce site, which manages approximately 1.8 billion records, is deemed essential for business operations. With the upcoming end of standard support for Amazon Aurora MySQL version 2 in October 2024, an urgent upgrade to version 3 was crucial.

Previously, a database upgrade for the Orbis review site, from Amazon RDS for MySQL 5.7 to 8.0, had unexpectedly degraded performance, which adversely affected user experience and consumed a considerable amount of time to resolve. The necessity to avoid similar performance declines in the primary e-commerce site intensified the urgency for a thorough version upgrade. Comprehensive testing, essential for a secure upgrade, seemed daunting due to the sheer volume of queries generated by the e-commerce platform, making manual testing unfeasible.

As the deadline approached, the team recognized that a highly efficient solution was imperative, prompting the decision to implement the "Insight SQL Testing" tool.

Advantages of Implementing Insight SQL Testing

"Insight SQL Testing" simplifies and accelerates database version upgrades by automatically collecting SQL generated by the applications in the production environment. This collected SQL is then tested and evaluated in the target test environment, which drastically reduces the workload involved in the transition.

Polaris Orbis identified several key benefits following the deployment of Insight SQL Testing:

• - A process that would typically demand over three months of manual unit testing was significantly expedited, allowing for the database upgrade to be completed within a limited time frame.
• - Comprehensive testing facilitated early identification and resolution of potential SQL execution errors and performance degradation, ensuring stable system operations post-migration.
• - The solution's AI-assisted correction suggestion feature made it easy to fix errors in SQL statements with minimal effort, simplifying retesting processes.
• - Unanticipated inefficient SQL executions were identified and improved through cache settings, thus enhancing overall performance.

Comments from Polaris Orbis Holdings

With the standard support deadline for the database rapidly approaching, it was paramount to execute a secure upgrade without the pitfalls of previous performance declines. The introduction of a tool like Insight SQL Testing provided the needed assurance.

Thanks to Insight SQL Testing, we achieved reliable verification within a short timeline, culminating in a zero-incident migration. Moving forward, we see potential for this solution not just during database migration but also for application renewals, thus supporting our strategy of both offense and defense," commented Yurika Yokouchi from Polaris Orbis Holdings’ Group Digital Solutions Center.

About Insight SQL Testing

Insight SQL Testing automates the assess of SQL applications required for database migration and upgrades, successfully reducing operational costs. Whether in the cloud or on-premises, it supports various databases by collecting SQL from the operational database and evaluating it on the target database.

For more information, visit the product page: Insight SQL Testing

Insight SQL Testing is also easily accessible via AWS Marketplace: AWS Marketplace.

About Insight Technology

Since its founding in 1995, Insight Technology has focused on database technology, providing professional services and products related to the data utilization infrastructure, Insight Infrastructure, aimed at empowering organizations to uncover valuable insights. To maximize the value of data in organizations, the company offers both offensive and defensive data governance solutions and organizes the "db tech showcase," an international conference that gathers data technology experts and engineers worldwide.

Company Website: Insight Technology
db tech showcase Website: db tech showcase

All company names, product names, and service names mentioned are trademarks or registered trademarks of their respective companies.