Suyati Technologies
  • Fluid Solutions
    • Buyer Rhythms Engine
    • Lead Prioritization
    • Customer LifeTime Value
    • Chatbot
    • Account Based Marketing
  • Platforms
    • CRM
      • Salesforce
      • Dynamics
    • CMS
      • Sitecore
      • Drupal
      • Episerver
      • Sitefinity
    • Ecom
      • Magento
      • Sitecore commerce
    • RPA
      • UiPath
    • Analytics
    • Martech
  • Services
    • CX Consulting
    • DSaaS
    • Product Engineering
  • Intel
    • Blog
    • eBooks
    • Webinars
    • Case Studies
  • About Us
    • Management Team
    • Advisory Board
    • Our Story
    • Testimonials
  • Careers
Suyati Technologies
  • Fluid Solutions
    • Buyer Rhythms Engine
    • Lead Prioritization
    • Customer LifeTime Value
    • Chatbot
    • Account Based Marketing
  • Platforms
    • CRM
      • Salesforce
      • Dynamics
    • CMS
      • Sitecore
      • Drupal
      • Episerver
      • Sitefinity
    • Ecom
      • Magento
      • Sitecore commerce
    • RPA
      • UiPath
    • Analytics
    • Martech
  • Services
    • CX Consulting
    • DSaaS
    • Product Engineering
  • Intel
    • Blog
    • eBooks
    • Webinars
    • Case Studies
  • About Us
    • Management Team
    • Advisory Board
    • Our Story
    • Testimonials
  • Careers
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

Outsourced Remote Resources Are Exceptionally Productive. How?

March 2, 2021

6 Effective Tips To Use Salesforce For Customer...

February 24, 2021

How CIOs Leverage Technology to Focus on Customer...

February 22, 2021

Identifying the Right Use Case for RPA in...

February 17, 2021

5 Tips to Future Proof Your Resource Pipeline

January 28, 2021

Best Practices to make the most out of...

January 27, 2021

How to Find the Right Offshore Development Team...

January 19, 2021

Most Viewed Blogs of 2020

January 13, 2021

Top 10 ETL Tools for Salesforce Data Migration...

January 4, 2021

How to Make the Most Out of Salesforce...

December 23, 2020

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

  • Outsourced Remote Resources Are Exceptionally Productive. How?

    March 2, 2021
  • 6 Effective Tips To Use Salesforce For Customer Retention

    February 24, 2021
  • How CIOs Leverage Technology to Focus on Customer Success

    February 22, 2021

Categories

  • Twitter
  • Linkedin
  • Facebook
  • Instagram
  • Fluid Solutions
    • Buyer Rhythms Engine
    • Lead Prioritization
    • Customer LifeTime Value
    • Chatbot
    • Account Based Marketing
  • Platforms
    • CRM
      • Salesforce
      • Dynamics
    • CMS
      • Sitecore
      • Drupal
      • Episerver
      • Sitefinity
    • Ecom
      • Magento
      • Sitecore commerce
    • RPA
      • UiPath
    • Analytics
    • Martech
  • Services
    • CX Consulting
    • DSaaS
    • Product Engineering
  • Intel
    • Blog
    • eBooks
    • Webinars
    • Case Studies
  • About Us
    • Management Team
    • Advisory Board
    • Our Story
    • Testimonials
  • Careers

© 2020 Suyati Technologies


Back To Top
Suyati Technologies

Popular Posts

  • 1

    What are the Top 3 risks for implementing a CX Program?

    August 30, 2019
  • 2

    What is Salesforce CRM and What Does it Do?

    February 19, 2014
  • 3

    Do you need a separate CX Team at your company?

    September 2, 2019
  • 4

    How to build Employee Advocacy for your Business?

    September 3, 2019
  • 5

    Tips to Reduce Salesforce Pricing

    February 17, 2015
© 2020 Suyati Technologies

Read alsox

Quality Assurance Strategy in the Age of Digital Transformation

September 16, 2016

The Seven Laws Of Open Source Leadership

October 10, 2017

Salesforce Shield – A New Level of Trust for Your...

April 29, 2016
Suyati Logo

Technology Insights. Delivered.

Know more about business technology platforms for your enterprise.

Thank you!

We're glad to have you as part of our community. Please feel free to contact us anytime with feedback or suggestions.

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