Suyati Technologies
  • Services
    • Custom Development
    • Salesforce
    • Analytics
    • Enablers
      • RPA
      • Cloud
      • Testing as a Service
  • Intel
    • Blog
    • eBooks
    • Webinars
    • Case Studies
  • About Us
    • Leadership Team
    • Our Story
    • Testimonials
  • Careers
  • Contact Us
Suyati Technologies
  • Services
    • Custom Development
    • Salesforce
    • Analytics
    • Enablers
      • RPA
      • Cloud
      • Testing as a Service
  • Intel
    • Blog
    • eBooks
    • Webinars
    • Case Studies
  • About Us
    • Leadership Team
    • Our Story
    • Testimonials
  • Careers
  • Contact Us
Suyati Technologies > Blog > A shift in Relational Data Storage Paradigms – Data storage on the Cloud?

A shift in Relational Data Storage Paradigms – Data storage on the Cloud?

by Karthikeyan S July 25, 2012
by Karthikeyan S July 25, 2012 0 comment

dataIn the last few years there has been a lot of hullabaloo on housing your RDBMS and mission critical business data on the Cloud or using a database which is driven by a database engine on the cloud. Although most of the business have desisted from making a major shift to any cloud based data architecture and storage, the prospect of this new technology garnering a sizeable share in the relational database usage is not a distant possibility.

These cloud based data services allows businesses to rapidly create, scale and extend applications into the cloud and relieve themselves from the expensive tasks of maintaining servers, infrastructure and other resources needed for their maintenance.

Today, we will talk about two popular cloud based data services which can be used to host SQL Server databases on the cloud and the pros and cons of these services with respect to each other.

1) Amazon Relational Data Service (Amazon RDS)

A recent entrant into the cloud based data services market, Amazon RDS, in a short frame of time has been able to generate considerable interest and establish itself as one of the major players in this segment. This service supports various RDBMS like ORACLE, MySQL and Microsoft SQL Server database engines on the cloud, allowing businesses to concentrate their focus on applications and core area.  Most of the full features and capabilities of a relational database are available on the cloud. Coupled with the option to migrate the existing applications and the tools to work with them, the Amazon RDS service offers a viable and cost effective proposal to the companies.

Pros

  • Provides full support of database features
  • Has inbuilt monitoring mechanisms for administration
  • Maximum database size is 1 TB
  • Supports database snap shots; database backup shelf size is 31 days

Cons

  • Databases are not replicated across multiple locations
  • Encrypted connections are not supported which is a security risk
  • Minimum database size supported is 20 GB

2) SQL Database (formerly known as Microsoft SQL Azure)

SQL Database, a cloud based database service from Microsoft was one of the first products introduced in the data services market. This product is tightly tied to Microsoft SQL Server RDBMS engine and the features supported by the stand-alone product are available on the cloud.

Pros

  • The administration interface is very simple to use
  • Supports very small databases without any minimum size restriction
  • Better security in the form of encrypted connections to and from the cloud
  • Allows keeping of multiple redundant database copies

Cons

  • Does not support the business to take any decision on the hardware used internally for storage
  • Maximum size allowed for a database in 150 GB
  • Not all features of standard a SQL server are offered and supported in the service
  • Restricted view of database information and limited monitoring.
  • Does not support use of Customized alerts

It will be interesting to see how these two services fare against each other in the future and what other alternatives become available for cloud data services, but if the initial indicators are anything to go by, Cloud data services are here to stay and change the way data is stored, retrieved and used for business!!

About the Author

S. Karthikeyan, or SK as he is better known, has 19 years of experience in designing, leading and delivering world-class software solutions. His specialties include Product Ideation, Innovation & Strategy, Enterprise & Solution Consulting, Data Science Solutions, and Digital Transformation. As Chief Innovation Officer, SK ensures that experimentation and innovation continues unfettered at Suyati Technologies. He leads the Mekanate team that is developing a Digital Transformation platform using AI, ML, IoT and Big Data technologies. He holds a Masters Degree in Computer Application, and Advanced Certificate in Information Technology Management from IIM, Kozhikode. The opportunity to build technically complex solutions is what runs through his mind all day, and probably keeps him awake at night! Connect with him on LinkedIn.

Data storage on the Cloudshift in Relational Data Storage Paradigms
0 comment
1
FacebookTwitterLinkedinTumblr
previous post
Multiple Record Insertions
next post
IDC Predicts phenomenal growth in IT Spending in India

You may also like

A Sneak Peek of the Salesforce Winter ’24...

September 13, 2023

Optimize Your Performance Using Performance Testing

September 13, 2023

Streamlining Sanity Testing with Playwright Automation

September 5, 2023

The sky’s the limit: top 5 Cloud Computing...

September 5, 2023

Accelerate your success with the power upgrade to...

August 8, 2023

Which Salesforce License Should You Opt for? ISVForce...

August 2, 2023

Boosting Efficiency with Power Automate Desktop

August 1, 2023

Stay ahead of the competition by keeping your...

July 26, 2023

Salesforce Increases Price After a Seven-year-long Hiatus: What...

July 25, 2023

Cloud migration is the future. With Salesforce, you...

July 18, 2023

Leave a Comment Cancel Reply

Save my name, email, and website in this browser for the next time I comment.

Keep in touch

Twitter Linkedin Facebook Pinterest

Recent Posts

  • A Sneak Peek of the Salesforce Winter ’24 Release Updates

    September 13, 2023
  • Optimize Your Performance Using Performance Testing

    September 13, 2023
  • Streamlining Sanity Testing with Playwright Automation

    September 5, 2023

Categories

  • Twitter
  • Linkedin
  • Facebook
  • Instagram
  • Services
    • Custom Development
    • Salesforce
    • Analytics
    • Enablers
      • RPA
      • Cloud
      • Testing as a Service
  • Intel
    • Blog
    • eBooks
    • Webinars
    • Case Studies
  • About Us
    • Leadership Team
    • Our Story
    • Testimonials
  • Careers
  • Contact Us

© 2023 Suyati Technologies


Back To Top
Suyati Technologies

Popular Posts

  • 1

    How IndianMoney.com Improved Efficiency and Conversions with Buyer Rhythms Engine

    September 24, 2020
  • 2

    How to Fully harvest Data Insights in your Organization

    March 29, 2021
  • 3

    Seven Key IT Outsourcing Trends to Expect in 2022

    December 14, 2021
  • 4

    Why Edge Computing is the Next Best Thing for Businesses

    September 14, 2022
  • 5

    How Do RPA Support Services in the USA Enhance Your Business?

    April 30, 2023
© 2023 Suyati Technologies

Read alsox

Apple has launched iOS 6.1, the latest version of its...

February 8, 2013

Facebook releases a Python package for GPU-accelerated machine learning networks

January 23, 2017

How Blockchain is contributing to Manufacturing 4.0

June 26, 2018
Suyati Logo

Leaving So Soon?

Know more about business technology platforms for your enterprise.

Thank you!

We're glad to have you as part of our community. You'll start receiving updates shortly. Please feel free to contact us anytime with feedback or suggestions.

By continuing to use this website you agree with our use of cookies. Read More Agree