How Pythian helped Nav Canada migrate their Oracle Database to a Microsoft Azure SQL Database

Posted in: Business Insights, Technical Track

A common concern for businesses is optimizing database speed and performance, without raising costs.

Nav Canada supports flight planning with aviation weather, aeronautical information, and online flight planning. To address a need for a more cost-efficient environment for their critical flight planning data, while optimizing performance they decided to migrate from an on-premises Oracle system to Microsoft Azure SQL Database. They turned to the database and cloud experts at Pythian to assist them.

“Pythian’s breadth of expertise spans both traditional on-premises and cloud environments, making Pythian the perfect partner as we migrated critical workloads to the cloud.”

Pascal Chamma, Manager, Nav Canada Database Technology Services.

Pythian was tasked with creating a Proof of Concept (PoC) on an Azure database, while simulating the central SQL database. The project team demonstrated that the same level of performance could be achieved within a more cost-effective cloud environment. The PoC proved that the new system could run a process (3000 lines of PL/SQL code) every 20 seconds, performing calculations on up to 3 minutes of collected data.

Nav Canada is currently implementing the system across a production environment, with Pythian advising them as needed.

Read the full case study to learn how Nav Canada was able to migrate to the cloud to reduce costs, without sacrificing performance.

email

About the Author

Lynda Partner is a self-professed data addict and experiences the power of data every day as Pythian’s Vice President of Analytics-as-a-Service. The author of Pythian’s Love Your Data mantra, Lynda understands very well how data can transform companies into competitive winners and she was the driving force in adding an analytics practice to Pythian’s database focus. Lynda works with companies around the world and across industries to turn data into insights, predictions and products, and is the co-author of Designing Data Lakes in the Cloud.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *