a yellow school bus driving down a dirt road

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

Paul Shanahan 

Paul Shanahan 

Intelligent Cloud Business Group Lead

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.

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

  • a person sitting at a desk in front of a computer

    Reimagining Uninterrupted Learning at Sacred Heart School in Tullamore

    As students and teachers once again find themselves away from the classroom environment and learning from home, schools are again adapting to different ways of learning to ensure quality education continues. For the Sacred Heart School in Tullamore, Co Offaly, the staff and student body were well prepared to deal with this upheaval and continued […]

Finance & Insurance

Government

  • 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 […]

  • a plane sitting on top of a grass covered field

    Fáilte Ireland Rapidly Adapted and Innovated with Microsoft Power Apps

    Fáilte Ireland Rapidly Adapted and Innovated with Microsoft Power Apps  When the Covid-19 pandemic closed offices globally and truly changed how every organisation functions, it created additional unanticipated challenges for many. Fáilte Ireland, the National Tourism Development Authority, was one such organisation which had migrated much of its work to the cloud. The tourism body, which employs 450 people, identified that […]

Healthcare

  • A woman undergoing a scan

    Predictive maintenance is improving quality of life for cancer patients

    With cancer affecting more than 17 million people annually, a figure set to rise dramatically in the coming years, efficient and cost-effective treatment is essential. Since deploying Microsoft Azure IoT, IBA Worldwide, a leading developer of medical equipment for cancer treatment, has been able to reduce the cost of maintenance and improve repair times for […]

  • 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 […]

Manufacturing

  • a man holding a paint spray

    What we can learn from AkzoNobel’s digital transformation

    Savvy businesses are always on the lookout for ways to improve what they do and differentiate themselves from the competition. From organisational restructure to the development of entirely new business models, the quest for continuous improvement takes many forms. But one common factor in almost all modern business leaders’ plans is an emphasis on technological […]

  • Uncovered: 4 Essential Field Service Trends For 2018

    Uncovered: 4 Essential Field Service Trends For 2018

    In a changing world of innovative new technology, connected devices, and shifting employee and customer needs, what trends are shaping the future for the Field Service industry and how can you embrace them? Trend #1: Putting the right tools into the right hands “It’s about empowering the field service engineer with more than just the […]

Retail

  • A man 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 […]

  • Big data boosts business for beverage company

    Big data boosts business for beverage company

    Contemplate, if you will, the multiple choices available every time you want something to drink. Water? Juice? Soft drink? Do you want a single-serve can or a six-pack? Or maybe you just grab a liter bottle. The fact is, we as consumers expect a lot of options and the global non-alcoholic beverage industry delivers. Arca […]

Discover more related articles per dossier:

Customer Stories

  • a man holding a gun

    Making the Schiphol Airport more sustainable into the future

    With over 71 million passengers a year, Schiphol is one of the biggest airports in Europe. Giving all of the passengers the most frictionless airport experience as possible, 17,000 assets need to be serviced and maintained 24 hours a day, 7 days a week. In order to deliver service excellence and optimize the maintenance, BAM […]

Digital Transformation

  • Blue and green circles

    How Leading Companies are Harnessing AI Technology

    “AI is the new electricity. Just as electricity transformed almost everything 100 years ago, today I have a hard time thinking of an industry that I don’t think AI will transform.” – Andrew Ng, AI Expert. Today, AI is embedded into our lives. We access it on a daily basis. Mobile banking, social networking; the […]

Press

  • Image of a man and woman smiling

    Microsoft and Connect at Catalyst Inc

    Microsoft and Connect at Catalyst Inc It’s an exciting time to be working in the technology sector in Northern Ireland. More than ever before we’re seeing increased numbers of entrepreneurs, start-up businesses, and indeed multinationals setting up in the North. Working together and learning from each other encourages a strong technology ecosystem and ultimately yields […]

Security & Privacy

Tips

  • Group of two female and one male office workers brainstorming in informal office setting. Both women are using laptops while the man is writing. Large screen shown in background.

    2019 Modern Selling Trends in 5 webinars

    The relationship between buyers and sellers grows more complicated each day. Every potential partnership requires finding the right buyer, fully understanding their business, tracking progress through the buying cycle, and engaging them with the right content—when and how they want it. These shifting dynamics underscore the artistry of modern selling. When the time is right, […]