Examining Cloud Storage Options
ii ) Managing Database Content
- http://yoursanjeev.blogspot.com/2016/11/examining-cloud-storage-options.htmlfocused on one major path to take for cloud storage, data objects.
The other primary type of data that is finding a home in the cloud is information stored in a database.
~ cloud data storage can handle structured data as well as unstructured blobs.
-There are two major strains of databases supported,
i) Relational Databases,
ii) Non-Relational Databases
-Relational Databases:
--Relational Databases are typically SQL databases and the Non-Relational ones use NoSQL which is short for not only SQL or No SQL.
~Google and HP focus on MySQL while others support a range of MySQL variations. ~Rackspace, for example, supports MySQL Percona Server and MariaDB.
~Some services such as AWS work with other Relational Databases including Oracle, SQL Server or PostgreSQL as well as MySQL.
~A few cloud data storage services have opted for the Proprietary route like Microsoft Azure with their SQL database offering.
- Cloud Relational Database Features :
~Many cloud data storage services take SQL Servers to the next level by replicating the databases across data centers, increasing data durability and decreasing latency.
~The cloud database servers scale very efficiently, spinning up new database instances or down as needed.
~Backups to multiple locations are often created automatically, allowing point-in-time recovery.
- Cloud Relational Database Access
Access to cloud-based databases is pretty broad overall but specific APIs for database management are limited on a service-by-service basis.
Generally speaking,
~ HTTP Requests supported across the board > All hosts support standard HTTP requests for accessing data but you'll have to heck each service to verify that an API for the language of your choice is available.
~ Specific APIs vary by service provider > And keep in mind that it is by no means a static situation.
~ New APIs routinely introduced > Many services add additional APIs on a continuing basis.
-Cloud Non-Relational Databases (NoSQL):
If your applications lend themselves to non-relational data with relatively straightforward queries, the most responsive database system capable of scaling to massive size is NoSQL.
--All the services that provide NoSQL alternatives, and not all do, provide their own framework, also Note: Both key/value and document-based NoSQL systems are available
like,
~Amazon DynamoDB, works with either key/value and document-based NoSQL systems
~Rackspace ObjectRocket
~Google Cloud Datastore - key/value-oriented
~Microsoft DocumentDB - document-focused
-Advantages and Uses :
~Appropriate for massive datasets > NoSQL's relatively simple structure opens the door to efficient processing of big data. A fact which a number of cloud data hosts are taking advantage of like AWS Redshift service or the recently introduced Google Cloud Bigtable.
~Platform Specific but robust > Management access to the NoSQL services are platform-specific but tend to be very robust. With most, you'll be able to programmatically create, update and delete tables as well as perform similar operations on table contents which may be called items or entities and their attributes as well.
-Cloud Database Security :
With both SQL and NoSQL solutions, data security is enhanced by automatic replication, often across geographic data centers. Replication can also be implemented via API calls. Numerous services allow you to optimize the degree of read consistency and right verification that your data requires. Cloud database storage is just as vigorous and vital as its sibling Object Storage. However, there is more diversity in the feature sets found on the various providers.
You'll need to research carefully to find the right fit for your organizational database needs.
Reference : https://www.lynda.com/Cloud-Platform-tutorials/Managing-database-content/383929/432096-4.html
Comments
Post a Comment