Komatsu yellow machinery

Database migration that helps you be ‘better than the best’

Leentje Chavatte

Leentje Chavatte

Microsoft, Data & AI and Digital Transformation

Read Time, 2 min.

The Japanese term dantotsu is difficult to translate, but roughly means ‘better than the best’. Since its founding nearly 100 years ago, Japanese construction and mining equipment multinational, Komatsu, has striven to provide its customers with a service that achieves just that.

As part of this mission, Komatsu launched its Dantotsu Strategy in 2003, which included the creation of a line of ‘Dantotsu Products’, labelled as such due to their unrivalled design and performance. But today the company knows that achieving dantotsu means looking beyond the machines themselves – instead analysing the data they produce.

Komatsu and its quest for dantotsu

Construction is an extremely data-rich industry – in Australia alone, Komatsu has more than 30,000 machines in daily operation that stream data on productivity, machine condition, and other factors. This makes data modernization essential – and choosing the right database management system a key business decision.

“We have 1.5 terabytes of data and that number is growing fast,” explains Nipun Sharma, Analytics Architect, Business Technology & Systems at Komatsu Australia. “We currently process around a million records per day ­– and we determined Azure SQL Database Managed Instance was the best choice for us in terms of scalability, cost, and performance”.

Modernize your data platform

One of the key factors that influenced the Japanese company’s decision was Azure SQL Database Managed Instance’s near 100 percent compatibility with the latest on-premises SQL Servers, making migration quick and simple – not to mention, extremely cost-effective.

“We moved our entire database and the Discovery Hub analytics implementation to Azure SQL Database Managed Instance in less than two weeks, and since then we’ve seen a 49 percent cost reduction and 25 to 30 percent performance gains,” says Sharma.

But Komatsu’s performance gains and savings – while clearly worth shouting about – are in line with what was envisaged. Expected return on investment for migrating to Azure SQL Database Managed Instance is 212%, with post-migration payback predicted to be under six months. Coupled with performance benefits that allow you to scale your workloads in real-time, all in a secure cloud environment ­– migrating from an SQL Server is the logical choice for any company wanting to achieve dantotsu.

Industry

Manufacturing

Dossier

Customer Stories

Quickstart: Create an Azure SQL Database managed instance

This quickstart walks you through how to create an Azure SQL Database managed instance in the Azure portal

Discover more related articles per industry:

Education

  • Girl studying

    Secondary school Kirchdorf: Reimagining hybrid learning with Surface and Teams

    “What we really wanted to achieve was simplicity for both our students and our educators. Through our digitalization efforts, we’ve seen that using technology to complement traditional teaching and learning is an investment for the future, not just for children, but for everyone.” Martin Schnetzer, teacher and IT admin at Mittelschule Kirchdorf, Austria, reflects on […]

  • Unlock the potential of your students with Microsoft’s new Learning Accelerators

    Unlock the potential of your students with Microsoft’s new Learning Accelerators

    Personalized learning is a goal that educators everywhere have been trying to achieve for years. But the pandemic shone a light on the complexity of that challenge for teachers, who face a more diverse set of student needs than ever before.  Because delivering a truly personalized learning experience for every student has traditionally required lots […]

Finance & Insurance

Government

  • A man sitting at a table using a laptop

    Four common challenges governments face in a time of crisis

    This blog focuses on best practice and solutions for working from home, engaging with citizens, gaining situational awareness and staying secure.

  • Two people inside using Surface Go in office

    How technology is transforming the work of governments

    Governments have the ultimate responsibility to their citizens. People depend on the services they provide like no other institution. Whether in healthcare, education, business, roads, railways, water – it’s essential that government institutions are always at the forefront of social and digital trends. Cloud-powered technologies are playing a critical role in helping government agencies to […]

Healthcare

  • Two people working in Healthcare with a Windows device

    Medical device provider builds an Azure data estate for any future

    Danish med-tech company Coloplast makes innovative care products for people with intimate health challenges. To help maintain productive customer relationships and better understand the needs of patients, Coloplast migrated from an on-premises data warehouse and business intelligence (BI) solution to Microsoft Power BI, Azure SQL Data Warehouse, and other Azure services. The migration is part […]

  • a doctor wearing a white coat and smiling at the camera

    How technology is revolutionising care for patients with chronic conditions

    “I could never have imagined that the monitoring system I had developed for patients with chronic heart disease would one day play a role in the war against a global pandemic.” José Paulo Carvalho, Founding Partner of Portuguese telehealth company Hope Care, explains how technology he has been developing for more than six years – HCAlert […]

Manufacturing

  • Potato producers benefit from sensors (IoT) and AVR’s technological innovations

    Potato producers benefit from sensors (IoT) and AVR’s technological innovations

    In Roeslare (Roulers in French), better known by the name “Potato Valley,” potato producers have a particular fondness for AVR’s machines and technologies, which mean they can plant and harvest potatoes more efficiently. More and more of AVR’s machines are equipped with sensors that are connected to the internet (IoT This technology provides farmers with […]

  • Grundfos plant

    Smart moves help save water, money … and the planet

    Grundfos is a global leader in advanced pumping solutions and water technology. It contributes to global sustainability by pioneering technologies that improve the quality of life and health of people worldwide. As part of these efforts, Grundfos continues to increase the IQ of its smart pumping solutions with the Microsoft IoT Suite and Microsoft Dynamics […]

Retail

Discover more related articles per dossier:

Customer Stories

  • Male store associate helping female customer in tech shop

    Creating great experiences for employees and the customers they serve

    Retail is experiencing ongoing labor shortages in the aftermath of the pandemic. Many people have retired early, found new jobs, or have simply decided to leave the labor market. As competition for skilled and experienced staff has become fiercer, attracting talent and retaining staff is crucial for survival and success.  While increasing wages and benefits […]

Digital Transformation

  • a person standing in front of a truck

    Why leading Irish retailer Musgrave is ready for anything with cloud technology

    “When assessing the potential effects of major digital transformation projects on our business, we always think about three key constituents: colleagues, retailers, and consumers.” So says Paul Baguley, IT PMO for Musgrave Retail – Ireland’s leading food retail, wholesale and food service company. Together with its retail partners, who operate under leading brands including SuperValu […]

Security & Privacy

Tips

  • Person using gear to visualize a conversation

    From data to value: creating meaningful customer engagements

    It is hard to predict future trends, opportunities, or challenges. Keeping up with the increasing pace of change is both difficult and crucial for sustainable business. Whatever happens in the future, technology will be a key enabler of resilience and successful transformation.  This is particularly true in the retail sector, where being one step ahead […]