Enqurious logo
Back to project

Relational Transaction Storage on Azure - 1

e-commerce
azure
azure-sql-db
python
azure-blob
azure-data-lake
Relational Transaction Storage on Azure - 1 project poster
This project includes
3 activities

Learning objective

  • Understand Various types of SQL Instances available on Azure
  • How to connect and work with Azure SQL
  • Integrate Azure SQL data and work with it

Overview

Overview of Relational Transactional Storage and how it works on Azure

Story

Global Mart is one of the leading e-Commerce giants with a presence in North America and Europe region. It has a presence across 120 markets and primarily deals with 3 lines of business : 

  • Technology,
  • Office Supplies
  • Furniture

 

With an increase in customers and expansion in geography, GlobalMart has developed tie-ups with several local vendors to help them deliver their products to the end customers. 

 

GlobalMart, an e-commerce company, currently stores its data on-premise, and they are facing multiple issues with its current setup. The on-premise data storage system has several limitations, such as limited scalability, insufficient redundancy, and increased risk of data loss in case of disasters. The data is not easily accessible, and the maintenance and management of the hardware are costly and time-consuming. They also face issues related to the backup and recovery process, which can be quite complex and time-consuming.

 

Furthermore, the on-premise database may not provide the required performance for a high-traffic e-commerce website. The slow speed of the database can result in a poor customer experience, leading to a loss in revenue and customer satisfaction. They may also have difficulty integrating with other applications and tools due to the inflexible nature of the on-premise database.

 

To address these challenges, GlobalMart is looking to migrate to a cloud-based relational database service on Azure that offers high scalability, availability, and disaster recovery capabilities

 

You are tasked with the responsibility in identifying right storage solution for the needs of GlobalMart